LinesToReceive
LinesToReceive
Columns
Name | Type | Description |
ToOrganizationCode | String | ToOrganizationCode of LinesToReceive |
ToOrganizationId | Long | ToOrganizationId of LinesToReceive |
FromOrganizationName | String | FromOrganizationName of LinesToReceive |
FromOrganizationCode | String | FromOrganizationCode of LinesToReceive |
FromOrganizationId | Long | FromOrganizationId of LinesToReceive |
ItemNumber | String | ItemNumber of LinesToReceive |
ItemDescription | String | ItemDescription of LinesToReceive |
ItemId | Long | ItemId of LinesToReceive |
ItemRevision | String | ItemRevision of LinesToReceive |
DocumentType | String | DocumentType of LinesToReceive |
SourceDocumentCode [KEY] | String | SourceDocumentCode of LinesToReceive |
DocumentNumber | String | DocumentNumber of LinesToReceive |
DocumentLineNumber | String | DocumentLineNumber of LinesToReceive |
DocumentScheduleNumber | String | DocumentScheduleNumber of LinesToReceive |
DocumentDistributionNumber | Long | DocumentDistributionNumber of LinesToReceive |
SoldtoLegalEntity | String | SoldtoLegalEntity of LinesToReceive |
SourceSystem | String | SourceSystem of LinesToReceive |
DocumentLineId [KEY] | Long | DocumentLineId of LinesToReceive |
DueDate | Date | DueDate of LinesToReceive |
VendorName | String | VendorName of LinesToReceive |
VendorSiteCode | String | VendorSiteCode of LinesToReceive |
VendorId | Long | VendorId of LinesToReceive |
VendorSiteId | Long | VendorSiteId of LinesToReceive |
VendorItemNumber | String | VendorItemNumber of LinesToReceive |
TOShipmentNumber | String | TOShipmentNumber of LinesToReceive |
ASNNumber | String | ASNNumber of LinesToReceive |
ASNLineNumber | Long | ASNLineNumber of LinesToReceive |
CustomerPartyName | String | CustomerPartyName of LinesToReceive |
CustomerId | Long | CustomerId of LinesToReceive |
AvailableQuantity | Double | AvailableQuantity of LinesToReceive |
UOMCode | String | UOMCode of LinesToReceive |
UnitOfMeasure | String | UnitOfMeasure of LinesToReceive |
SecondaryAvailableQuantity | Double | SecondaryAvailableQuantity of LinesToReceive |
SecondaryUOMCode | String | SecondaryUOMCode of LinesToReceive |
SecondaryUnitOfMeasure | String | SecondaryUnitOfMeasure of LinesToReceive |
DestinationType | String | DestinationType of LinesToReceive |
DestinationTypeCode | String | DestinationTypeCode of LinesToReceive |
ShipToLocation | String | ShipToLocation of LinesToReceive |
ShipToLocationId | Long | ShipToLocationId of LinesToReceive |
Routing | String | Routing of LinesToReceive |
RoutingHeaderId | Long | RoutingHeaderId of LinesToReceive |
OrderedQuantity | Double | OrderedQuantity of LinesToReceive |
OrderedUnitOfMeasure | String | OrderedUnitOfMeasure of LinesToReceive |
POHeaderId | Long | POHeaderId of LinesToReceive |
POLineLocationId | Long | POLineLocationId of LinesToReceive |
POLineId | Long | POLineId of LinesToReceive |
PODistributionId | Long | PODistributionId of LinesToReceive |
PORevisionNumber | Long | PORevisionNumber of LinesToReceive |
ShipmentHeaderId | Long | ShipmentHeaderId of LinesToReceive |
ShipmentLineId | Long | ShipmentLineId of LinesToReceive |
TransferOrderHeaderId | Long | TransferOrderHeaderId of LinesToReceive |
TransferOrderLineId | Long | TransferOrderLineId of LinesToReceive |
TransferOrderDistId | Long | TransferOrderDistId of LinesToReceive |
ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId of LinesToReceive |
ReceiptAdviceLineId | Long | ReceiptAdviceLineId of LinesToReceive |
ReceiptSourceCode | String | ReceiptSourceCode of LinesToReceive |
ConsignedItems | String | ConsignedItems of LinesToReceive |
BackToBack | String | BackToBack of LinesToReceive |
CategoryName | String | CategoryName of LinesToReceive |
CategoryId | Long | CategoryId of LinesToReceive |
CurrencyCode | String | CurrencyCode of LinesToReceive |
CurrencyConversionRate | Double | CurrencyConversionRate of LinesToReceive |
CurrencyConversionDate | Date | CurrencyConversionDate of LinesToReceive |
CurrencyConversionType | String | CurrencyConversionType of LinesToReceive |
InventoryTransactionTypeId | Long | InventoryTransactionTypeId of LinesToReceive |
POUnitPrice | Double | POUnitPrice of LinesToReceive |
MatchOption | String | MatchOption of LinesToReceive |
HeaderNoteToReceiver | String | HeaderNoteToReceiver of LinesToReceive |
ScheduleNoteToReceiver | String | ScheduleNoteToReceiver of LinesToReceive |
IntegrationStatus | String | IntegrationStatus of LinesToReceive |
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 |
BindASNLineNumber | Long | bindASNLineNumber |
BindASNNumber | String | bindASNNumber |
BindBackToBack | String | bindBackToBack |
BindConsigned | String | bindConsigned |
BindDocumentDistributionNumber | Long | bindDocumentDistributionNumber |
BindDocumentLineNumber | String | bindDocumentLineNumber |
BindDocumentNumber | String | bindDocumentNumber |
BindDocumentScheduleNumber | String | bindDocumentScheduleNumber |
BindDocumentType | String | bindDocumentType |
BindFromDate | Date | bindFromDate |
BindItemId | Long | bindItemId |
BindItemNumber | String | bindItemNumber |
BindOrganizationCode | String | bindOrganizationCode |
BindOrganizationId | Long | bindOrganizationId |
BindPODistributionId | Long | bindPODistributionId |
BindPOLineId | Long | bindPOLineId |
BindPOLineLocationId | Long | bindPOLineLocationId |
BindReceiptAdviceHeaderId | Long | bindReceiptAdviceHeaderId |
BindReceiptAdviceLineId | Long | bindReceiptAdviceLineId |
BindShipmentHeaderId | Long | bindShipmentHeaderId |
BindShipmentLineId | Long | bindShipmentLineId |
BindSourceDocumentCode | String | bindSourceDocumentCode |
BindToDate | Date | bindToDate |
BindTransferOrderDistId | Long | bindTransferOrderDistId |
BindTransferOrderHeaderId | Long | bindTransferOrderHeaderId |
BindTransferOrderLineId | Long | bindTransferOrderLineId |
Finder | String | finder |