ReceivingReceiptRequestslineslotItemLotslotAttributesDFF
Supports descriptive flexfields for lot attributes linked to non-serial-controlled items, enabling customization.
Columns
Name | Type | Description |
ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the header interface in the Receiving Receipt Requests schema, representing the source or origin of the receiving receipt transaction. |
LinesInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction associated with the lines in the Receiving Receipt Requests schema, linking specific line items to the transaction. |
LotitemlotsLotNumber [KEY] | String | Alphanumeric code representing the lot number associated with item lots, used to track and manage inventory at the lot level. |
TransactionInterfaceId [KEY] | Long | Unique identifier for the transaction interface within the Receiving Receipt Requests schema, representing the specific transaction linked to the receipt request. |
LotNumber [KEY] | String | The lot number used to identify and track specific inventory lots within the receiving receipt request process. |
_FLEX_Context | String | The name of the descriptive flexfield context associated with lot attributes, which is relevant when items are managed under lot and serial control in a warehouse. |
_FLEX_Context_DisplayValue | String | The display value for the descriptive flexfield context, providing a user-friendly description for the lot attributes under lot and serial control in a warehouse. |
CustomerId | Long | Unique identifier for the customer associated with the receiving receipt request, representing the customer for whom the goods are being received. |
CustomerPartyName | String | The name of the customer or customer party involved in the receiving receipt request, typically the entity receiving the goods. |
DocumentNumber | String | The unique identifier for the document related to the receiving receipt request, used for reference and tracking in the system. |
ExternalSystemTransactionReference | String | Reference number from an external system associated with the transaction, used for cross-system tracking and reconciliation. |
Finder | String | Identifier used to find or query relevant records within the system, potentially used for locating related documents or transactions. |
FromDate | Datetime | The start date for the receiving receipt request transaction, indicating the beginning of the period during which the receipt is valid. |
FromOrganizationCode | String | The unique code representing the organization from which the goods or items are being received, indicating the source organization. |
FromOrganizationId | Long | Unique identifier for the organization from which the goods or items are being received, typically linking to the specific organizational entity in the database. |
GroupId | Long | Unique identifier for the group associated with the receiving receipt request, used for grouping related records or transactions. |
HeaderInterfaceId | Long | Unique identifier for the interface header in the receiving receipt request, serving as the primary reference for managing the receipt process. |
ItemId | Long | Unique identifier for the item in the receiving receipt request, linking to the specific product or inventory being received. |
ItemNumber | String | The number or code used to uniquely identify the item within the system, facilitating the tracking and management of inventory. |
OrganizationCode | String | The unique code representing the organization where the receiving receipt request is processed or where the goods are being received. |
OrganizationId | Long | Unique identifier for the organization where the receiving receipt request is being processed or where the goods are being received. |
POHeaderId | Long | Unique identifier for the purchase order header, linking the receiving receipt request to the associated purchase order. |
ProcessingStatusCode | String | The current processing status of the receiving receipt request, used to track the progress of the transaction through the receiving process. |
ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice header, indicating the document or record advising on the receipt of goods. |
RMANumber | String | Unique identifier for the return merchandise authorization (RMA), used to track and manage the return process for goods. |
ShipmentHeaderId | Long | Unique identifier for the shipment header, linking the receiving receipt request to a specific shipment of goods or materials. |
ShipmentNumber | String | The unique identifier or number for the shipment, used to track the shipment of goods from the vendor to the receiving organization. |
SourceDocumentCode | String | Code representing the source document for the receiving receipt request, providing a reference to the originating document (for example, purchase order, RMA). |
ToDate | Datetime | The end date for the receiving receipt request transaction, indicating the end of the period during which the receipt is valid. |
TransactionStatusCode | String | Code representing the current status of the transaction in the receiving receipt request, indicating whether the transaction is pending, completed, or otherwise. |
TransactionType | String | The type of transaction being performed in the receiving receipt request, such as receipt, return, or transfer, indicating the nature of the transaction. |
TransferOrderHeaderId | Long | Unique identifier for the transfer order header, linking the receiving receipt request to a specific transfer order if applicable. |
VendorId | Long | Unique identifier for the vendor providing the goods or services related to the receiving receipt request. |
VendorName | String | The name of the vendor supplying the goods or services for the receiving receipt request. |
VendorNumber | String | The number or code associated with the vendor, typically used for internal tracking and vendor identification. |