ReceivingReceiptTransactionRequestsserialItemSerials
ReceivingReceiptTransactionRequestsserialItemSerials
Columns
Name | Type | Description |
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestsserialItemSerials |
FromSerialNumber [KEY] | String | Starting serial number in a range of serial numbers of the receipt transaction 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 receipt transaction 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 receipt transaction 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 |
DocumentNumber | String | DocumentNumber |
ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
FromDate | Datetime | FromDate |
GroupId | Long | GroupId |
InterfaceTransactionId | Long | InterfaceTransactionId |
ItemId | String | ItemId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
OrganizationId | String | 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 |
Finder | String | finder |