SupplyRequestssupplyOrderLinestransferSupply
SupplyRequestssupplyOrderLinestransferSupply
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyorderlinesSupplyLineId [KEY] | Long | SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyTrackingLineStatus | String | SupplyTrackingLineStatus of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyTrackingLineId [KEY] | Long | SupplyTrackingLineId of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyTrackingLineNumber | Long | SupplyTrackingLineNumber of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyLineId | Long | SupplyLineId of SupplyRequestssupplyOrderLinestransferSupply |
| SplitFromTlineId | Long | SplitFromTlineId of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyType | String | SupplyType of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyOrderReferenceLineId | Long | SupplyOrderReferenceLineId of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyOrderReferenceLineNumber | String | SupplyOrderReferenceLineNumber of SupplyRequestssupplyOrderLinestransferSupply |
| ItemId | Long | ItemId of SupplyRequestssupplyOrderLinestransferSupply |
| ItemRevision | String | ItemRevision of SupplyRequestssupplyOrderLinestransferSupply |
| UOMCode | String | UOMCode of SupplyRequestssupplyOrderLinestransferSupply |
| Quantity | Double | Quantity of SupplyRequestssupplyOrderLinestransferSupply |
| NeedByDate | Datetime | NeedByDate of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationOrganizationId | Long | DestinationOrganizationId of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationOrganizationCode | String | DestinationOrganizationCode of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyExceptionFlag | Bool | SupplyExceptionFlag of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyChangePendingFlag | Bool | SupplyChangePendingFlag of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyFulfilledQuantity | Double | SupplyFulfilledQuantity of SupplyRequestssupplyOrderLinestransferSupply |
| TransferOrderHeaderId | String | TransferOrderHeaderId of SupplyRequestssupplyOrderLinestransferSupply |
| TransferOrderHeaderNumber | String | TransferOrderHeaderNumber of SupplyRequestssupplyOrderLinestransferSupply |
| TransferOrderLineId | String | TransferOrderLineId of SupplyRequestssupplyOrderLinestransferSupply |
| TransferOrderLineNumber | String | TransferOrderLineNumber of SupplyRequestssupplyOrderLinestransferSupply |
| TransferPrice | Double | TransferPrice of SupplyRequestssupplyOrderLinestransferSupply |
| TransferPriceCurrencyCode | String | TransferPriceCurrencyCode of SupplyRequestssupplyOrderLinestransferSupply |
| SourceOrganizationId | Long | SourceOrganizationId of SupplyRequestssupplyOrderLinestransferSupply |
| SourceSubinventoryCode | String | SourceSubinventoryCode of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationLocationId | Long | DestinationLocationId of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationTypeCode | String | DestinationTypeCode of SupplyRequestssupplyOrderLinestransferSupply |
| DeliverToRequesterId | Long | DeliverToRequesterId of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationSubinventoryCode | String | DestinationSubinventoryCode of SupplyRequestssupplyOrderLinestransferSupply |
| PreparerId | Long | PreparerId of SupplyRequestssupplyOrderLinestransferSupply |
| CarrierId | Long | CarrierId of SupplyRequestssupplyOrderLinestransferSupply |
| ShipClassOfService | String | ShipClassOfService of SupplyRequestssupplyOrderLinestransferSupply |
| ShipModeOfTransport | String | ShipModeOfTransport of SupplyRequestssupplyOrderLinestransferSupply |
| DooShipmentFlag | Bool | DooShipmentFlag of SupplyRequestssupplyOrderLinestransferSupply |
| SupplyParentTrackingLineId | Long | SupplyParentTrackingLineId of SupplyRequestssupplyOrderLinestransferSupply |
| Comments | String | Comments of SupplyRequestssupplyOrderLinestransferSupply |
| NoteToReceiver | String | NoteToReceiver of SupplyRequestssupplyOrderLinestransferSupply |
| NoteToSupplier | String | NoteToSupplier of SupplyRequestssupplyOrderLinestransferSupply |
| BackToBackFlag | Bool | BackToBackFlag of SupplyRequestssupplyOrderLinestransferSupply |
| TransferSupplyDetailsId | Long | TransferSupplyDetailsId of SupplyRequestssupplyOrderLinestransferSupply |
| ItemNumber | String | ItemNumber of SupplyRequestssupplyOrderLinestransferSupply |
| ItemDescription | String | ItemDescription of SupplyRequestssupplyOrderLinestransferSupply |
| UOMName | String | UOMName of SupplyRequestssupplyOrderLinestransferSupply |
| SourceOrganizationCode | String | SourceOrganizationCode of SupplyRequestssupplyOrderLinestransferSupply |
| SourceOrganizationName | String | SourceOrganizationName of SupplyRequestssupplyOrderLinestransferSupply |
| SourceSubinventoryName | String | SourceSubinventoryName of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationOrganizationName | String | DestinationOrganizationName of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationSubinventoryName | String | DestinationSubinventoryName of SupplyRequestssupplyOrderLinestransferSupply |
| DestinationLocation | String | DestinationLocation of SupplyRequestssupplyOrderLinestransferSupply |
| DeliverToRequesterName | String | DeliverToRequesterName of SupplyRequestssupplyOrderLinestransferSupply |
| DeliverToRequesterEmail | String | DeliverToRequesterEmail of SupplyRequestssupplyOrderLinestransferSupply |
| PreparerEmail | String | PreparerEmail of SupplyRequestssupplyOrderLinestransferSupply |
| PreparerName | String | PreparerName of SupplyRequestssupplyOrderLinestransferSupply |
| CarrierCode | String | CarrierCode of SupplyRequestssupplyOrderLinestransferSupply |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SupplyOrderReferenceNumber | String | SupplyOrderReferenceNumber |
| BindDestOrganizationCode | String | bindDestOrganizationCode |
| BindDocumentNumber | String | bindDocumentNumber |
| BindItemNumber | String | bindItemNumber |
| BindNeedByDate | Datetime | bindNeedByDate |
| BindSupplyOrderNumber | String | bindSupplyOrderNumber |
| BindSupplyOrderReferenceNumber | String | bindSupplyOrderReferenceNumber |
| BindSupplyOrderSource | String | bindSupplyOrderSource |
| BindSupplyRequestDate | Datetime | bindSupplyRequestDate |
| BindSupplyStatus | String | bindSupplyStatus |
| BindSupplyType | String | bindSupplyType |
| Finder | String | finder |