SupplyRequestssupplyOrderLinesmakeSupply
SupplyRequestssupplyOrderLinesmakeSupply
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyorderlinesSupplyLineId [KEY] | Long | SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyTrackingLineId [KEY] | Long | SupplyTrackingLineId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyLineId | Long | SupplyLineId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyParentTrackingLineId | Long | SupplyParentTrackingLineId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyTrackingLineNumber | Long | SupplyTrackingLineNumber of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyTrackingLineStatus | String | SupplyTrackingLineStatus of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyType | String | SupplyType of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyOrderReferenceLineId | Long | SupplyOrderReferenceLineId of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyOrderReferenceLineNumber | String | SupplyOrderReferenceLineNumber of SupplyRequestssupplyOrderLinesmakeSupply |
| ItemId | Long | ItemId of SupplyRequestssupplyOrderLinesmakeSupply |
| ItemNumber | String | ItemNumber of SupplyRequestssupplyOrderLinesmakeSupply |
| ItemDescription | String | ItemDescription of SupplyRequestssupplyOrderLinesmakeSupply |
| ItemRevision | String | ItemRevision of SupplyRequestssupplyOrderLinesmakeSupply |
| UOMCode | String | UOMCode of SupplyRequestssupplyOrderLinesmakeSupply |
| UOMName | String | UOMName of SupplyRequestssupplyOrderLinesmakeSupply |
| Quantity | Double | Quantity of SupplyRequestssupplyOrderLinesmakeSupply |
| DestinationOrganizationId | Long | DestinationOrganizationId of SupplyRequestssupplyOrderLinesmakeSupply |
| DestinationOrganizationCode | String | DestinationOrganizationCode of SupplyRequestssupplyOrderLinesmakeSupply |
| DestinationOrganizationName | String | DestinationOrganizationName of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyFulfilledQuantity | Double | SupplyFulfilledQuantity of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyChangePendingFlag | Bool | SupplyChangePendingFlag of SupplyRequestssupplyOrderLinesmakeSupply |
| SupplyExceptionFlag | Bool | SupplyExceptionFlag of SupplyRequestssupplyOrderLinesmakeSupply |
| BackToBackFlag | Bool | BackToBackFlag of SupplyRequestssupplyOrderLinesmakeSupply |
| DeliverToSubinventory | String | DeliverToSubinventory of SupplyRequestssupplyOrderLinesmakeSupply |
| FirmPlannedFlag | Bool | FirmPlannedFlag of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderId | String | WorkOrderId of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderNumber | String | WorkOrderNumber of SupplyRequestssupplyOrderLinesmakeSupply |
| AllowExplosionFlag | Bool | AllowExplosionFlag of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderStatusId | Long | WorkOrderStatusId of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkDefinitionName | String | WorkDefinitionName of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkDefinitionAsOfDate | Datetime | WorkDefinitionAsOfDate of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderSubType | String | WorkOrderSubType of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkDefinitionId | Long | WorkDefinitionId of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkMethodCode | String | WorkMethodCode of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderType | String | WorkOrderType of SupplyRequestssupplyOrderLinesmakeSupply |
| SourceSystemId | String | SourceSystemId of SupplyRequestssupplyOrderLinesmakeSupply |
| SourceSystemType | String | SourceSystemType of SupplyRequestssupplyOrderLinesmakeSupply |
| SchedulingMethod | String | SchedulingMethod of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderCompletionDate | Datetime | WorkOrderCompletionDate of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderStartDate | Datetime | WorkOrderStartDate of SupplyRequestssupplyOrderLinesmakeSupply |
| WorkOrderDescription | String | WorkOrderDescription of SupplyRequestssupplyOrderLinesmakeSupply |
| WIPQuantity | Double | WIPQuantity of SupplyRequestssupplyOrderLinesmakeSupply |
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 |