LinesToCorrect
LinesToCorrect
Columns
Name | Type | Description |
ToOrganizationCode | String | ToOrganizationCode of LinesToCorrect |
ToOrganizationId | Long | ToOrganizationId of LinesToCorrect |
FromOrganizationCode | String | FromOrganizationCode of LinesToCorrect |
FromOrganizationId | Long | FromOrganizationId of LinesToCorrect |
ItemNumber | String | ItemNumber of LinesToCorrect |
ItemId | Long | ItemId of LinesToCorrect |
ItemDescription | String | ItemDescription of LinesToCorrect |
ItemRevision | String | ItemRevision of LinesToCorrect |
ReceiptNumber | String | ReceiptNumber of LinesToCorrect |
LineStatus | String | LineStatus of LinesToCorrect |
DocumentType | String | DocumentType of LinesToCorrect |
SourceDocumentCode | String | SourceDocumentCode of LinesToCorrect |
DocumentNumber | String | DocumentNumber of LinesToCorrect |
DocumentLineNumber | String | DocumentLineNumber of LinesToCorrect |
DocumentScheduleNumber | String | DocumentScheduleNumber of LinesToCorrect |
DocumentDistributionNumber | Double | DocumentDistributionNumber of LinesToCorrect |
TransactionDate | Date | TransactionDate of LinesToCorrect |
VendorName | String | VendorName of LinesToCorrect |
VendorId | Long | VendorId of LinesToCorrect |
VendorSiteCode | String | VendorSiteCode of LinesToCorrect |
VendorSiteId | Long | VendorSiteId of LinesToCorrect |
VendorItemNumber | String | VendorItemNumber of LinesToCorrect |
TOShipmentNumber | String | TOShipmentNumber of LinesToCorrect |
ASNNumber | String | ASNNumber of LinesToCorrect |
ASNLineNumber | Double | ASNLineNumber of LinesToCorrect |
CustomerPartyName | String | CustomerPartyName of LinesToCorrect |
CustomerId | Long | CustomerId of LinesToCorrect |
AvailableQuantity | Double | AvailableQuantity of LinesToCorrect |
UOMCode | String | UOMCode of LinesToCorrect |
UnitOfMeasure | String | UnitOfMeasure of LinesToCorrect |
SecondaryAvailableQuantity | Double | SecondaryAvailableQuantity of LinesToCorrect |
SecondaryUOMCode | String | SecondaryUOMCode of LinesToCorrect |
SecondaryUnitOfMeasure | String | SecondaryUnitOfMeasure of LinesToCorrect |
DestinationType | String | DestinationType of LinesToCorrect |
DestinationTypeCode | String | DestinationTypeCode of LinesToCorrect |
Location | String | Location of LinesToCorrect |
LocationId | Long | LocationId of LinesToCorrect |
Routing | String | Routing of LinesToCorrect |
RoutingHeaderId | Long | RoutingHeaderId of LinesToCorrect |
POHeaderId | Long | POHeaderId of LinesToCorrect |
POLineLocationId | Long | POLineLocationId of LinesToCorrect |
POLineId | Long | POLineId of LinesToCorrect |
PODistributionId | Long | PODistributionId of LinesToCorrect |
ShipmentHeaderId | Long | ShipmentHeaderId of LinesToCorrect |
ShipmentLineId | Long | ShipmentLineId of LinesToCorrect |
TransferOrderHeaderId | Long | TransferOrderHeaderId of LinesToCorrect |
TransferOrderLineId | Long | TransferOrderLineId of LinesToCorrect |
TransferOrderDistId | Long | TransferOrderDistId of LinesToCorrect |
ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId of LinesToCorrect |
ReceiptAdviceLineId | Long | ReceiptAdviceLineId of LinesToCorrect |
ReceiptSourceCode | String | ReceiptSourceCode of LinesToCorrect |
ConsignedItems | String | ConsignedItems of LinesToCorrect |
BackToBack | String | BackToBack of LinesToCorrect |
CategoryName | String | CategoryName of LinesToCorrect |
CategoryId | Long | CategoryId of LinesToCorrect |
CurrencyCode | String | CurrencyCode of LinesToCorrect |
CurrencyConversionRate | Double | CurrencyConversionRate of LinesToCorrect |
CurrencyConversionDate | Date | CurrencyConversionDate of LinesToCorrect |
CurrencyConversionType | String | CurrencyConversionType of LinesToCorrect |
InventoryTransactionTypeId | Long | InventoryTransactionTypeId of LinesToCorrect |
ParentTransactionType | String | ParentTransactionType of LinesToCorrect |
ParentTransactionId [KEY] | Long | ParentTransactionId of LinesToCorrect |
GrandParentTransactionId | Long | GrandParentTransactionId of LinesToCorrect |
Reason | String | Reason of LinesToCorrect |
ReasonId | Long | ReasonId of LinesToCorrect |
ReceiptException | String | ReceiptException of LinesToCorrect |
EmployeeName | String | EmployeeName of LinesToCorrect |
EmployeeId | Long | EmployeeId of LinesToCorrect |
Subinventory | String | Subinventory of LinesToCorrect |
Locator | String | Locator of LinesToCorrect |
LocatorId | Long | LocatorId of LinesToCorrect |
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 |
BindPOHeaderId | Long | bindPOHeaderId |
BindPOLineId | Long | bindPOLineId |
BindPOLineLocationId | Long | bindPOLineLocationId |
BindParentTransactionId | Long | bindParentTransactionId |
BindReceiptAdviceHeaderId | Long | bindReceiptAdviceHeaderId |
BindReceiptAdviceLineId | Long | bindReceiptAdviceLineId |
BindReceiptNumber | String | bindReceiptNumber |
BindShipmentHeaderId | Long | bindShipmentHeaderId |
BindShipmentLineId | Long | bindShipmentLineId |
BindSourceDocumentCode | String | bindSourceDocumentCode |
BindTOShipment | String | bindTOShipment |
BindToDate | Date | bindToDate |
BindTransferOrderDistId | Long | bindTransferOrderDistId |
BindTransferOrderHeaderId | Long | bindTransferOrderHeaderId |
BindTransferOrderLineId | Long | bindTransferOrderLineId |
Finder | String | finder |