TransferOrderstransferOrderLines
TransferOrderstransferOrderLines
Columns
| Name | Type | Description |
| TransferOrdersHeaderId [KEY] | Long | TransferOrdersHeaderId of TransferOrderstransferOrderLines |
| LineId [KEY] | Long | LineId of TransferOrderstransferOrderLines |
| LineNumber | Int | LineNumber of TransferOrderstransferOrderLines |
| HeaderId | Long | HeaderId of TransferOrderstransferOrderLines |
| HeaderNumber | String | HeaderNumber of TransferOrderstransferOrderLines |
| InterfaceStatusLookup | String | InterfaceStatusLookup of TransferOrderstransferOrderLines |
| InterfaceStatus | String | InterfaceStatus of TransferOrderstransferOrderLines |
| FulfillmentStatusLookup | String | FulfillmentStatusLookup of TransferOrderstransferOrderLines |
| FulfillStatusMeaning | String | FulfillStatusMeaning of TransferOrderstransferOrderLines |
| SourceTypeLookup | String | SourceTypeLookup of TransferOrderstransferOrderLines |
| SourceOfTransferOrder | String | SourceOfTransferOrder of TransferOrderstransferOrderLines |
| SourceOrganizationId | Long | SourceOrganizationId of TransferOrderstransferOrderLines |
| SourceOrganizationCode | String | SourceOrganizationCode of TransferOrderstransferOrderLines |
| SourceOrganizationName | String | SourceOrganizationName of TransferOrderstransferOrderLines |
| SourceSubinventoryCode | String | SourceSubinventoryCode of TransferOrderstransferOrderLines |
| DestinationOrganizationId | Long | DestinationOrganizationId of TransferOrderstransferOrderLines |
| DestinationOrganizationCode | String | DestinationOrganizationCode of TransferOrderstransferOrderLines |
| DestinationOrganizationName | String | DestinationOrganizationName of TransferOrderstransferOrderLines |
| DestinationSubinventoryCode | String | DestinationSubinventoryCode of TransferOrderstransferOrderLines |
| DestinationTypeLookup | String | DestinationTypeLookup of TransferOrderstransferOrderLines |
| DestinationType | String | DestinationType of TransferOrderstransferOrderLines |
| DestinationLocationId | Long | DestinationLocationId of TransferOrderstransferOrderLines |
| DestinationLocationCode | String | DestinationLocationCode of TransferOrderstransferOrderLines |
| DestinationLocationName | String | DestinationLocationName of TransferOrderstransferOrderLines |
| DestinationAddressFirstLine | String | DestinationAddressFirstLine of TransferOrderstransferOrderLines |
| DestinationAddressSecondLine | String | DestinationAddressSecondLine of TransferOrderstransferOrderLines |
| DestinationAddressThirdLine | String | DestinationAddressThirdLine of TransferOrderstransferOrderLines |
| DestinationAddressFourthLine | String | DestinationAddressFourthLine of TransferOrderstransferOrderLines |
| DestinationCity | String | DestinationCity of TransferOrderstransferOrderLines |
| DestinationState | String | DestinationState of TransferOrderstransferOrderLines |
| DestinationPostalCode | String | DestinationPostalCode of TransferOrderstransferOrderLines |
| DestinationCountry | String | DestinationCountry of TransferOrderstransferOrderLines |
| MaterialReturnRequired | String | MaterialReturnRequired of TransferOrderstransferOrderLines |
| StatusLookup | String | StatusLookup of TransferOrderstransferOrderLines |
| TransferOrderLineStatus | String | TransferOrderLineStatus of TransferOrderstransferOrderLines |
| InventoryItemId | Long | InventoryItemId of TransferOrderstransferOrderLines |
| ItemNumber | String | ItemNumber of TransferOrderstransferOrderLines |
| ItemRevision | String | ItemRevision of TransferOrderstransferOrderLines |
| NeedByDate | Datetime | NeedByDate of TransferOrderstransferOrderLines |
| ScheduledShipDate | Datetime | ScheduledShipDate of TransferOrderstransferOrderLines |
| QuantityUOMCode | String | QuantityUOMCode of TransferOrderstransferOrderLines |
| QuantityUOMName | String | QuantityUOMName of TransferOrderstransferOrderLines |
| RequestedQuantity | Double | RequestedQuantity of TransferOrderstransferOrderLines |
| ShippedQuantity | Double | ShippedQuantity of TransferOrderstransferOrderLines |
| ReceivedQuantity | Double | ReceivedQuantity of TransferOrderstransferOrderLines |
| DeliveredQuantity | Double | DeliveredQuantity of TransferOrderstransferOrderLines |
| SecondaryQuantityUOMCode | String | SecondaryQuantityUOMCode of TransferOrderstransferOrderLines |
| SecondaryQuantityUOMName | String | SecondaryQuantityUOMName of TransferOrderstransferOrderLines |
| SecondaryRequestedQuantity | Double | SecondaryRequestedQuantity of TransferOrderstransferOrderLines |
| SecondaryShippedQuantity | Double | SecondaryShippedQuantity of TransferOrderstransferOrderLines |
| SecondaryReceivedQuantity | Double | SecondaryReceivedQuantity of TransferOrderstransferOrderLines |
| SecondaryDeliveredQuantity | Double | SecondaryDeliveredQuantity of TransferOrderstransferOrderLines |
| UnitPrice | Double | UnitPrice of TransferOrderstransferOrderLines |
| FreightCarrierId | Long | FreightCarrierId of TransferOrderstransferOrderLines |
| CarrierName | String | CarrierName of TransferOrderstransferOrderLines |
| ModeOfTransportLookup | String | ModeOfTransportLookup of TransferOrderstransferOrderLines |
| ModeOfTransport | String | ModeOfTransport of TransferOrderstransferOrderLines |
| ServiceLevelLookup | String | ServiceLevelLookup of TransferOrderstransferOrderLines |
| ServiceLevel | String | ServiceLevel of TransferOrderstransferOrderLines |
| ShipMethodDescription | String | ShipMethodDescription of TransferOrderstransferOrderLines |
| ShipmentPriorityLookup | String | ShipmentPriorityLookup of TransferOrderstransferOrderLines |
| ShipmentPriority | String | ShipmentPriority of TransferOrderstransferOrderLines |
| OriginalHeaderId | Long | OriginalHeaderId of TransferOrderstransferOrderLines |
| OriginalTransferOrder | String | OriginalTransferOrder of TransferOrderstransferOrderLines |
| OriginalLineId | Long | OriginalLineId of TransferOrderstransferOrderLines |
| OriginalTransferOrderLine | String | OriginalTransferOrderLine of TransferOrderstransferOrderLines |
| RequisitionId | Long | RequisitionId of TransferOrderstransferOrderLines |
| RequisitionNumber | String | RequisitionNumber of TransferOrderstransferOrderLines |
| RequisitionLineId | Long | RequisitionLineId of TransferOrderstransferOrderLines |
| RequisitionLineNumber | String | RequisitionLineNumber of TransferOrderstransferOrderLines |
| RequesterId | Long | RequesterId of TransferOrderstransferOrderLines |
| RequesterName | String | RequesterName of TransferOrderstransferOrderLines |
| InterfaceErrMsgCode | String | InterfaceErrMsgCode of TransferOrderstransferOrderLines |
| InterfaceErrMsgText | String | InterfaceErrMsgText of TransferOrderstransferOrderLines |
| PlannerId | Long | PlannerId of TransferOrderstransferOrderLines |
| PlannerName | String | PlannerName of TransferOrderstransferOrderLines |
| ChangeStatusLookup | String | ChangeStatusLookup of TransferOrderstransferOrderLines |
| ChangeStatus | String | ChangeStatus of TransferOrderstransferOrderLines |
| ChangeRequestedDate | Datetime | ChangeRequestedDate of TransferOrderstransferOrderLines |
| Comments | String | Comments of TransferOrderstransferOrderLines |
| SourceHeaderId | Long | SourceHeaderId of TransferOrderstransferOrderLines |
| SourceLineId | Long | SourceLineId of TransferOrderstransferOrderLines |
| InclNonrecoverableTax | Double | InclNonrecoverableTax of TransferOrderstransferOrderLines |
| InclRecoverableTax | Double | InclRecoverableTax of TransferOrderstransferOrderLines |
| NoninclNonrecoverableTax | Double | NoninclNonrecoverableTax of TransferOrderstransferOrderLines |
| NoninclRecoverableTax | Double | NoninclRecoverableTax of TransferOrderstransferOrderLines |
| CurrencyCode | String | CurrencyCode of TransferOrderstransferOrderLines |
| AgreementPtrId | Long | AgreementPtrId of TransferOrderstransferOrderLines |
| FirmPlanningScheduleLookup | String | FirmPlanningScheduleLookup of TransferOrderstransferOrderLines |
| FirmPlanningSchedule | String | FirmPlanningSchedule of TransferOrderstransferOrderLines |
| InterfaceSourceCode | String | InterfaceSourceCode of TransferOrderstransferOrderLines |
| BackToBack | String | BackToBack of TransferOrderstransferOrderLines |
| OriginalRequestLineId | Long | OriginalRequestLineId of TransferOrderstransferOrderLines |
| ActionSourceType | String | ActionSourceType of TransferOrderstransferOrderLines |
| NoteToReceiver | String | NoteToReceiver of TransferOrderstransferOrderLines |
| NoteToSupplier | String | NoteToSupplier of TransferOrderstransferOrderLines |
| Reprice | String | Reprice of TransferOrderstransferOrderLines |
| ChangePartyId | Long | ChangePartyId of TransferOrderstransferOrderLines |
| ChangeInitiatingPersonName | String | ChangeInitiatingPersonName of TransferOrderstransferOrderLines |
| Region | String | Region of TransferOrderstransferOrderLines |
| Action | String | Action of TransferOrderstransferOrderLines |
| AllowItemSubstitution | String | AllowItemSubstitution of TransferOrderstransferOrderLines |
| AllowItemSubstitutionMeaning | String | AllowItemSubstitutionMeaning of TransferOrderstransferOrderLines |
| ItemSubstituted | String | ItemSubstituted of TransferOrderstransferOrderLines |
| ItemSubstitutedMeaning | String | ItemSubstitutedMeaning of TransferOrderstransferOrderLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |
| PBatch | String | pBatch |
| PDestinationOrganization | String | pDestinationOrganization |
| PItemNumber | String | pItemNumber |
| PLineNumber | String | pLineNumber |
| PLineStatus | String | pLineStatus |
| PScheduledShipDate | Datetime | pScheduledShipDate |
| PSourceOrganization | String | pSourceOrganization |
| PTransactionOrigin | String | pTransactionOrigin |
| PTransferOrder | String | pTransferOrder |