ReceivingReceiptTransactionRequestsDFF
Handles descriptive flexfields for managing metadata related to receipt transactions.
Columns
Name | Type | Description |
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | Unique identifier for the transaction in the ReceivingReceiptTransactionRequestsDFF interface table. |
InterfaceTransactionId [KEY] | Long | Identifier for the transaction in the interface table of the ReceivingReceiptTransactionRequestsDFF schema. |
_FLEX_Context | String | Context name for descriptive flexfields related to receipt transaction requests, used to capture additional metadata. |
_FLEX_Context_DisplayValue | String | Human-readable display name of the context for descriptive flexfields associated with receipt transaction requests. |
DocumentNumber | String | Document number associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table. |
ExternalSystemTransactionReference | String | Reference identifier for the transaction originating from an external system, associated with the receipt transaction request. |
Finder | String | Reference to the finder or search term used to identify the receipt transaction requests in the system. |
FromDate | Datetime | Start date for the time period associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table. |
GroupId | Long | Identifier for the group to which the receipt transaction request belongs within the ReceivingReceiptTransactionRequestsDFF table. |
ItemId | String | Unique identifier for the item involved in the receipt transaction request. |
ItemNumber | String | Number or code identifying the item related to the receipt transaction request, often used for inventory tracking. |
OrganizationCode | String | Code representing the organization to which the receipt transaction request is associated in the system. |
OrganizationId | String | Unique identifier for the organization linked to the receipt transaction request in the database. |
POHeaderId | Long | Identifier for the purchase order header related to the receipt transaction request, linking it to procurement data. |
ProcessingStatusCode | String | Code indicating the current processing status of the receipt transaction request, used to track its progress. |
ReceiptAdviceHeaderId | Long | Unique identifier for the receipt advice header, which provides additional details for the receipt transaction request. |
RMANumber | String | Return merchandise authorization number associated with the receipt transaction request, often used for returned goods processing. |
ShipmentHeaderId | Long | Identifier for the shipment header associated with the receipt transaction request, linking it to logistics data. |
ShipmentNumber | String | Shipment number related to the receipt transaction request, used for tracking the movement of goods. |
SourceDocumentCode | String | Code that identifies the source document (for example, invoice, order) from which the receipt transaction request originated. |
ToDate | Datetime | End date for the time period associated with the receipt transaction request in the ReceivingReceiptTransactionRequestsDFF table. |
TransactionStatusCode | String | Code indicating the status of the transaction, such as pending, completed, or canceled. |
TransactionType | String | Type of transaction (for example, receipt, return, adjustment) associated with the receipt transaction request. |
TransferOrderHeaderId | Long | Identifier for the transfer order header related to the receipt transaction request, indicating the origin and destination of goods. |