ReceivingReceiptRequestslinesserialItemSerials
ReceivingReceiptRequestslinesserialItemSerials
Columns
Name | Type | Description |
ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslinesserialItemSerials |
LinesInterfaceTransactionId [KEY] | Long | LinesInterfaceTransactionId of ReceivingReceiptRequestslinesserialItemSerials |
FromSerialNumber [KEY] | String | Starting serial number in a range of serial numbers of the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under serial control. |
ToSerialNumber | String | Ending serial number in a range of serial numbers of the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under serial control. |
VendorSerialNumber | String | Supplier serial number for the serial range of the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under serial control. |
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 |
CustomerId | Long | CustomerId |
CustomerPartyName | String | CustomerPartyName |
DocumentNumber | String | DocumentNumber |
ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
FromDate | Datetime | FromDate |
FromOrganizationCode | String | FromOrganizationCode |
FromOrganizationId | Long | FromOrganizationId |
GroupId | Long | GroupId |
HeaderInterfaceId | Long | HeaderInterfaceId |
ItemId | Long | ItemId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
OrganizationId | Long | OrganizationId |
POHeaderId | Long | POHeaderId |
ProcessingStatusCode | String | ProcessingStatusCode |
RMANumber | String | RMANumber |
ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId |
ShipmentHeaderId | Long | ShipmentHeaderId |
ShipmentNumber | String | ShipmentNumber |
SourceDocumentCode | String | SourceDocumentCode |
ToDate | Datetime | ToDate |
TransactionStatusCode | String | TransactionStatusCode |
TransactionType | String | TransactionType |
TransferOrderHeaderId | Long | TransferOrderHeaderId |
VendorId | Long | VendorId |
VendorName | String | VendorName |
VendorNumber | String | VendorNumber |
Finder | String | finder |