ReceivingReceiptRequestslineslotSerialItemLotslotAttributesDFF
Manages descriptive flexfields for lot attributes linked to items controlled by both lots and serials.
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | The unique identifier for the receiving receipt request header, used for tracking the receipt requests in the system. This identifier links to the related records in the ReceivingReceiptRequestslineslotSerialItemLotslotAttributesDFF table. |
| LinesInterfaceTransactionId [KEY] | Long | A unique identifier for the transaction associated with a line in the receiving receipt request. This ID helps in tracking the transaction details within the ReceivingReceiptRequestslineslotSerialItemLotslotAttributesDFF table. |
| LotserialitemlotsLotNumber [KEY] | String | The identifier for the lot number associated with the serialized item. This value is used to track the specific lot in inventory management and traceability systems within the ReceivingReceiptRequestslineslotSerialItemLotslotAttributesDFF table. |
| TransactionInterfaceId [KEY] | Long | The identifier for the interface transaction linked to the receipt, enabling the system to track the transaction across various interfaces and systems. |
| LotNumber [KEY] | String | The unique lot number assigned to an item for tracking purposes, ensuring accurate traceability of items during receiving and inventory processing. |
| _FLEX_Context | String | The context for the Descriptive Flexfield (DFF), which allows for custom attributes related to lot and serial-controlled items in a warehouse. This is used to capture additional, flexible data specific to warehouse management. |
| _FLEX_Context_DisplayValue | String | The display value for the Descriptive Flexfield context, which provides a human-readable version of the context name. This is used when the system displays the DFF context in user interfaces. |
| CustomerId | Long | The unique identifier of the customer associated with the receiving transaction. This helps link the receipt to the specific customer in the system. |
| CustomerPartyName | String | The name of the customer party associated with the receiving transaction. This is used for identification and reporting purposes. |
| DocumentNumber | String | The document number associated with the transaction. This value is used to link and identify specific documents like purchase orders or invoices related to the receipt. |
| ExternalSystemTransactionReference | String | A reference identifier from an external system that links the transaction to external records. This helps in tracking and reconciling transactions across different systems. |
| Finder | String | The identifier used for finding specific records in the system. This value helps in querying and locating items related to the receiving receipt request. |
| FromDate | Datetime | The start date of the receiving receipt transaction, indicating the beginning of the transaction's effective period. |
| FromOrganizationCode | String | The code identifying the organization from which the items are being received. This is useful for tracking inter-organization transfers and transactions. |
| FromOrganizationId | Long | The unique identifier of the organization from which the items are being received. This helps link the transaction to a specific organization. |
| GroupId | Long | The unique identifier for the group of receiving transactions. This helps track and manage related transactions grouped together in the system. |
| HeaderInterfaceId | Long | The identifier for the header interface transaction, linking the receiving receipt request to the header-level interface records in the system. |
| ItemId | Long | The unique identifier for the item being received. This is essential for inventory and item management, ensuring that the correct item is being processed. |
| ItemNumber | String | The unique item number associated with the received item. This number is used to track and manage the item in the inventory system. |
| OrganizationCode | String | The code for the organization receiving the items. This helps link the receipt request to the appropriate receiving organization. |
| OrganizationId | Long | The identifier for the organization receiving the items. This is used for organization-level tracking and reporting of receiving transactions. |
| POHeaderId | Long | The unique identifier for the Purchase Order (PO) header associated with the receiving receipt request. This ID helps link the receipt request to the corresponding purchase order. |
| ProcessingStatusCode | String | The status of the processing for the receiving receipt request, indicating whether it is pending, in progress, or completed. |
| ReceiptAdviceHeaderId | Long | The identifier for the receipt advice header, which provides detailed information regarding the receipt of goods and serves as a record for internal and external communications. |
| RMANumber | String | The Return Merchandise Authorization (RMA) number associated with the receiving transaction, used when items are being returned to the vendor. |
| ShipmentHeaderId | Long | The identifier for the shipment header linked to the receiving receipt request. This helps connect the receipt request with the shipment details, including the shipment's origin and destination. |
| ShipmentNumber | String | The shipment number associated with the receipt request. This value is used to track the shipment during the receiving process. |
| SourceDocumentCode | String | The code identifying the source document for the transaction, such as a sales order, purchase order, or return authorization. This helps link the receipt to the originating document. |
| ToDate | Datetime | The end date of the receiving receipt transaction, marking the expiration or completion of the transaction's effective period. |
| TransactionStatusCode | String | The current status of the transaction, indicating whether the transaction has been successfully processed, is pending, or has failed. |
| TransactionType | String | The type of transaction associated with the receiving receipt request, such as a purchase, return, or transfer, which helps classify and manage different types of receipt requests. |
| TransferOrderHeaderId | Long | The identifier for the transfer order header, used when items are being transferred between organizations or warehouses. |
| VendorId | Long | The unique identifier for the vendor supplying the goods. This is crucial for tracking and managing vendor relationships. |
| VendorName | String | The name of the vendor supplying the goods, used for identification and reporting purposes. |
| VendorNumber | String | The vendor number associated with the receiving transaction, helping to link the transaction to a specific vendor in the system. |