SupplyRequestssupplyOrderLinesatpSupply
SupplyRequestssupplyOrderLinesatpSupply
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyorderlinesSupplyLineId [KEY] | Long | SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyTrackingLineId [KEY] | Long | SupplyTrackingLineId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyLineId | Long | SupplyLineId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyParentTrackingLineId | Long | SupplyParentTrackingLineId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyTrackingLineNumber | Long | SupplyTrackingLineNumber of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyTrackingLineStatus | String | SupplyTrackingLineStatus of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyType | String | SupplyType of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyOrderReferenceLineId | Long | SupplyOrderReferenceLineId of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyOrderReferenceLineNumber | String | SupplyOrderReferenceLineNumber of SupplyRequestssupplyOrderLinesatpSupply |
| ItemId | Long | ItemId of SupplyRequestssupplyOrderLinesatpSupply |
| ItemRevision | String | ItemRevision of SupplyRequestssupplyOrderLinesatpSupply |
| ItemNumber | String | ItemNumber of SupplyRequestssupplyOrderLinesatpSupply |
| ItemDescription | String | ItemDescription of SupplyRequestssupplyOrderLinesatpSupply |
| UOMCode | String | UOMCode of SupplyRequestssupplyOrderLinesatpSupply |
| UOMName | String | UOMName of SupplyRequestssupplyOrderLinesatpSupply |
| Quantity | Double | Quantity of SupplyRequestssupplyOrderLinesatpSupply |
| DestinationOrganizationId | Long | DestinationOrganizationId of SupplyRequestssupplyOrderLinesatpSupply |
| DestinationOrganizationCode | String | DestinationOrganizationCode of SupplyRequestssupplyOrderLinesatpSupply |
| DestinationOrganizationName | String | DestinationOrganizationName of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyFulfilledQuantity | Double | SupplyFulfilledQuantity of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyChangePendingFlag | Bool | SupplyChangePendingFlag of SupplyRequestssupplyOrderLinesatpSupply |
| SupplyExceptionFlag | Bool | SupplyExceptionFlag of SupplyRequestssupplyOrderLinesatpSupply |
| BackToBackFlag | Bool | BackToBackFlag of SupplyRequestssupplyOrderLinesatpSupply |
| ReservationNumber | String | ReservationNumber of SupplyRequestssupplyOrderLinesatpSupply |
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 |