SupplyRequestssupplyOrderLinesbuySupply
SupplyRequestssupplyOrderLinesbuySupply
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyorderlinesSupplyLineId [KEY] | Long | SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyTrackingLineId [KEY] | Long | SupplyTrackingLineId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyLineId | Long | SupplyLineId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyParentTrackingLineId | Long | SupplyParentTrackingLineId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyTrackingLineNumber | Long | SupplyTrackingLineNumber of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyTrackingLineStatus | String | SupplyTrackingLineStatus of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyType | String | SupplyType of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyOrderReferenceLineId | Long | SupplyOrderReferenceLineId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyOrderReferenceLineNumber | String | SupplyOrderReferenceLineNumber of SupplyRequestssupplyOrderLinesbuySupply |
| ItemId | Long | ItemId of SupplyRequestssupplyOrderLinesbuySupply |
| ItemRevision | String | ItemRevision of SupplyRequestssupplyOrderLinesbuySupply |
| UOMCode | String | UOMCode of SupplyRequestssupplyOrderLinesbuySupply |
| Quantity | Double | Quantity of SupplyRequestssupplyOrderLinesbuySupply |
| DestinationOrganizationId | Long | DestinationOrganizationId of SupplyRequestssupplyOrderLinesbuySupply |
| DestinationOrganizationCode | String | DestinationOrganizationCode of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyFulfilledQuantity | Double | SupplyFulfilledQuantity of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyChangePendingFlag | Bool | SupplyChangePendingFlag of SupplyRequestssupplyOrderLinesbuySupply |
| SupplyExceptionFlag | Bool | SupplyExceptionFlag of SupplyRequestssupplyOrderLinesbuySupply |
| BuyerId | Long | BuyerId of SupplyRequestssupplyOrderLinesbuySupply |
| PreparerId | Long | PreparerId of SupplyRequestssupplyOrderLinesbuySupply |
| CategoryId | Long | CategoryId of SupplyRequestssupplyOrderLinesbuySupply |
| ScheduledShipDate | Datetime | ScheduledShipDate of SupplyRequestssupplyOrderLinesbuySupply |
| RequestedShipDate | Datetime | RequestedShipDate of SupplyRequestssupplyOrderLinesbuySupply |
| DeliverToLocationId | Long | DeliverToLocationId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplierId | Long | SupplierId of SupplyRequestssupplyOrderLinesbuySupply |
| SupplierSiteId | Long | SupplierSiteId of SupplyRequestssupplyOrderLinesbuySupply |
| DeliverToRequesterId | Long | DeliverToRequesterId of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderHeaderId | String | PurchaseOrderHeaderId of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderNumber | String | PurchaseOrderNumber of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderLineId | String | PurchaseOrderLineId of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderLineNumber | String | PurchaseOrderLineNumber of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderScheduleId | Long | PurchaseOrderScheduleId of SupplyRequestssupplyOrderLinesbuySupply |
| CarrierId | Long | CarrierId of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitioningBUId | Long | RequisitioningBUId of SupplyRequestssupplyOrderLinesbuySupply |
| PurchaseOrderScheduleNumber | String | PurchaseOrderScheduleNumber of SupplyRequestssupplyOrderLinesbuySupply |
| BackToBackFlag | Bool | BackToBackFlag of SupplyRequestssupplyOrderLinesbuySupply |
| SupplierSiteName | String | SupplierSiteName of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitionLineNumber | String | RequisitionLineNumber of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitionNumber | String | RequisitionNumber of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitionId | String | RequisitionId of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitionLineId | String | RequisitionLineId of SupplyRequestssupplyOrderLinesbuySupply |
| ItemNumber | String | ItemNumber of SupplyRequestssupplyOrderLinesbuySupply |
| ItemDescription | String | ItemDescription of SupplyRequestssupplyOrderLinesbuySupply |
| UOMName | String | UOMName of SupplyRequestssupplyOrderLinesbuySupply |
| DestinationOrganizationName | String | DestinationOrganizationName of SupplyRequestssupplyOrderLinesbuySupply |
| DeliverToRequesterName | String | DeliverToRequesterName of SupplyRequestssupplyOrderLinesbuySupply |
| DeliverToRequesterEmail | String | DeliverToRequesterEmail of SupplyRequestssupplyOrderLinesbuySupply |
| PreparerEmail | String | PreparerEmail of SupplyRequestssupplyOrderLinesbuySupply |
| PreparerName | String | PreparerName of SupplyRequestssupplyOrderLinesbuySupply |
| CarrierCode | String | CarrierCode of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitioningBUCode | String | RequisitioningBUCode of SupplyRequestssupplyOrderLinesbuySupply |
| RequisitioningBUName | String | RequisitioningBUName of SupplyRequestssupplyOrderLinesbuySupply |
| CategoryName | String | CategoryName of SupplyRequestssupplyOrderLinesbuySupply |
| BuyerName | String | BuyerName of SupplyRequestssupplyOrderLinesbuySupply |
| DeliverToLocationName | String | DeliverToLocationName of SupplyRequestssupplyOrderLinesbuySupply |
| SupplierName | String | SupplierName of SupplyRequestssupplyOrderLinesbuySupply |
| SupplierNumber | String | SupplierNumber of SupplyRequestssupplyOrderLinesbuySupply |
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 |