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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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 |