ReceivingReceiptTransactionRequestslotSerialItemLots
ReceivingReceiptTransactionRequestslotSerialItemLots
Columns
| Name | Type | Description |
| ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestslotSerialItemLots |
| LotNumber [KEY] | String | Number that identifies the lot for the item corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| LotExpirationDate | Date | Date when the item of this lot corresponding to the receipt transaction request expires. This attribute is applicable when the warehouse places the item under lot and serial control. |
| ParentLotNumber | String | Number that identifies the parent lot of the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| VendorLotNumber | String | Number that identifies the supplier lot for the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| TransactionQuantity | Double | Transaction quantity of the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| PrimaryQuantity | Double | Transaction quantity for this lot in the primary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control. |
| SecondaryTransactionQuantity | Double | Transaction quantity for this lot in the secondary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control. |
| OriginationDate | Date | Date when this lot originated for the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| OriginationType | String | Type of origination for the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| HoldDate | Date | Date when the warehouse applied a hold on the lot corresponding to the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| ReasonId | Long | Value that uniquely identifies the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot and serial control. |
| ReasonName | String | Name of the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot and serial control. |
| MaturityDate | Date | Date when the lot matures for the receipt transaction request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| GradeCode | String | Abbreviation that identifies the grade. |
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 |