LinesToInspect
LinesToInspect
Columns
Name | Type | Description |
ToOrganizationCode | String | ToOrganizationCode of LinesToInspect |
ToOrganizationId | Long | ToOrganizationId of LinesToInspect |
FromOrganizationName | String | FromOrganizationName of LinesToInspect |
FromOrganizationCode | String | FromOrganizationCode of LinesToInspect |
FromOrganizationId | Long | FromOrganizationId of LinesToInspect |
ItemNumber | String | ItemNumber of LinesToInspect |
ItemDescription | String | ItemDescription of LinesToInspect |
ItemId | Long | ItemId of LinesToInspect |
ItemRevision | String | ItemRevision of LinesToInspect |
ReceiptNumber | String | ReceiptNumber of LinesToInspect |
LineStatus | String | LineStatus of LinesToInspect |
DocumentType | String | DocumentType of LinesToInspect |
SourceDocumentCode | String | SourceDocumentCode of LinesToInspect |
DocumentNumber | String | DocumentNumber of LinesToInspect |
DocumentLineNumber | String | DocumentLineNumber of LinesToInspect |
DocumentScheduleNumber | String | DocumentScheduleNumber of LinesToInspect |
TransactionDate | Date | TransactionDate of LinesToInspect |
VendorName | String | VendorName of LinesToInspect |
VendorId | Long | VendorId of LinesToInspect |
VendorSiteCode | String | VendorSiteCode of LinesToInspect |
VendorSiteId | Long | VendorSiteId of LinesToInspect |
VendorItemNumber | String | VendorItemNumber of LinesToInspect |
TOShipmentNumber | String | TOShipmentNumber of LinesToInspect |
ASNType | String | ASNType of LinesToInspect |
ASNNumber | String | ASNNumber of LinesToInspect |
ASNLineNumber | Long | ASNLineNumber of LinesToInspect |
CustomerPartyName | String | CustomerPartyName of LinesToInspect |
CustomerId | Long | CustomerId of LinesToInspect |
AvailableQuantity | Double | AvailableQuantity of LinesToInspect |
UOMCode | String | UOMCode of LinesToInspect |
UnitOfMeasure | String | UnitOfMeasure of LinesToInspect |
SecondaryAvailableQuantity | Double | SecondaryAvailableQuantity of LinesToInspect |
SecondaryUOMCode | String | SecondaryUOMCode of LinesToInspect |
SecondaryUnitOfMeasure | String | SecondaryUnitOfMeasure of LinesToInspect |
DestinationType | String | DestinationType of LinesToInspect |
DestinationTypeCode | String | DestinationTypeCode of LinesToInspect |
Location | String | Location of LinesToInspect |
LocationId | Long | LocationId of LinesToInspect |
Routing | String | Routing of LinesToInspect |
RoutingHeaderId | Long | RoutingHeaderId of LinesToInspect |
POHeaderId | Long | POHeaderId of LinesToInspect |
POLineLocationId | Long | POLineLocationId of LinesToInspect |
POLineId | Long | POLineId of LinesToInspect |
PORevisionNumber | Long | PORevisionNumber of LinesToInspect |
ShipmentHeaderId | Long | ShipmentHeaderId of LinesToInspect |
ShipmentLineId | Long | ShipmentLineId of LinesToInspect |
TransferOrderHeaderId | Long | TransferOrderHeaderId of LinesToInspect |
TransferOrderLineId | Long | TransferOrderLineId of LinesToInspect |
TransferOrderDistId | Long | TransferOrderDistId of LinesToInspect |
ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId of LinesToInspect |
ReceiptAdviceLineId | Long | ReceiptAdviceLineId of LinesToInspect |
ReceiptSourceCode | String | ReceiptSourceCode of LinesToInspect |
ConsignedItems | String | ConsignedItems of LinesToInspect |
BackToBack | String | BackToBack of LinesToInspect |
CategoryName | String | CategoryName of LinesToInspect |
CategoryId | Long | CategoryId of LinesToInspect |
CurrencyCode | String | CurrencyCode of LinesToInspect |
CurrencyConversionRate | Double | CurrencyConversionRate of LinesToInspect |
CurrencyConversionDate | Date | CurrencyConversionDate of LinesToInspect |
CurrencyConversionType | String | CurrencyConversionType of LinesToInspect |
ParentTransactionType | String | ParentTransactionType of LinesToInspect |
ParentTransactionId [KEY] | Long | ParentTransactionId of LinesToInspect |
InspectionStatus | String | InspectionStatus of LinesToInspect |
InspectionStatusCode | String | InspectionStatusCode of LinesToInspect |
PrimaryUOMCode | String | PrimaryUOMCode of LinesToInspect |
Reason | String | Reason of LinesToInspect |
ReasonId | Long | ReasonId of LinesToInspect |
ReceiptException | String | ReceiptException of LinesToInspect |
EmployeeName | String | EmployeeName of LinesToInspect |
EmployeeId | Long | EmployeeId of LinesToInspect |
Comments | String | Comments of LinesToInspect |
Subinventory | String | Subinventory of LinesToInspect |
Locator | String | Locator of LinesToInspect |
LocatorId | Long | LocatorId of LinesToInspect |
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 |
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 |
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 |
BindToDate | Date | bindToDate |
BindTransferOrderHeaderId | Long | bindTransferOrderHeaderId |
BindTransferOrderLineId | Long | bindTransferOrderLineId |
Finder | String | finder |