ReceivingReceiptTransactionRequestsinventoryStripingDFF
Tracks inventory striping attributes such as project, task, and origin country via descriptive flexfields to enhance receipt and transaction tracking.
Columns
Name | Type | Description |
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] | Long | The unique identifier for a transaction in the receiving receipt transaction requests interface. It is used to track individual transaction entries in the system. |
InterfaceTransactionId [KEY] | Long | A unique identifier for each transaction, allowing system processes to track and differentiate each transaction. This value is tied to a specific feature that requires user consent to activate. |
ProjectId | Long | A unique identifier for a project, used to associate the transaction with a specific project in the system. This attribute is part of an optional feature. |
ProjectId_Display | String | The display number assigned to the project, serving as a user-friendly identifier. This is tied to an optional feature that requires user consent. |
TaskId | Long | A unique identifier for a task, associated with a specific project or transaction. This field is linked to a feature that is only accessible if the user opts in. |
TaskId_Display | String | The display number assigned to a task, providing an easily identifiable reference to the task within the system. This attribute is also part of an optional feature. |
CountryOfOriginCode | String | A code representing the country where the item was manufactured or produced. This attribute is linked to a feature that requires the user to opt in. |
CountryOfOriginCode_Display | String | The full name of the country of origin for the item. This field is related to an optional feature that requires user consent. |
_FLEX_Context | String | The context name for the descriptive flexfield, specifically used for inventory striping attributes. This attribute is part of a feature that requires opt-in from the user. |
_FLEX_Context_DisplayValue | String | The display value associated with the descriptive flexfield context for inventory striping attributes. It provides a user-friendly label for the context and is part of an optional feature. |
DocumentNumber | String | The document number assigned to the transaction in the ReceivingReceiptTransactionRequestsinventoryStripingDFF table, used for tracking purposes. |
ExternalSystemTransactionReference | String | A reference identifier from an external system, used to correlate transactions across systems. This value is essential for integration with external applications. |
Finder | String | A field used for locating and identifying specific records in the ReceivingReceiptTransactionRequestsinventoryStripingDFF table. It acts as a search key for users. |
FromDate | Datetime | The start date for the transaction, indicating when the transaction or relevant event began. This value is crucial for time-based queries and reports. |
GroupId | Long | An identifier for the group associated with the transaction, used for organizing related transactions or records within the system. |
ItemId | String | A unique identifier for the item involved in the transaction, used to track and reference the item across the system. |
ItemNumber | String | The item number associated with the transaction, providing a reference to a specific item in the inventory system. |
OrganizationCode | String | A code that identifies the organization related to the transaction, used to classify and manage transactions within different organizational contexts. |
OrganizationId | String | A unique identifier for the organization that initiated or received the transaction. This field is critical for transactions involving multiple organizations. |
POHeaderId | Long | The unique identifier for the purchase order header, used to link the transaction to a specific purchase order in the system. |
ProcessingStatusCode | String | A code indicating the current processing status of the transaction, providing insights into its progress within the system. |
ReceiptAdviceHeaderId | Long | The unique identifier for the receipt advice header, linking the transaction to the corresponding receipt advice document in the system. |
RMANumber | String | The Return Material Authorization (RMA) number assigned to the transaction, used to track the return of goods or materials. |
ShipmentHeaderId | Long | The unique identifier for the shipment header, connecting the transaction to a specific shipment record in the system. |
ShipmentNumber | String | The shipment number that identifies a specific shipment related to the transaction, used for logistics and tracking purposes. |
SourceDocumentCode | String | A code representing the source document for the transaction, providing a reference to the original document or record from which the transaction was initiated. |
ToDate | Datetime | The end date for the transaction, indicating when the transaction or relevant event concluded. It is used for time-based filtering and reporting. |
TransactionStatusCode | String | A code representing the current status of the transaction, used to track whether it is in progress, completed, or requires further action. |
TransactionType | String | The type of transaction being processed, such as receipt, return, or exchange, providing clarity on the nature of the transaction. |
TransferOrderHeaderId | Long | The unique identifier for the transfer order header, used to link the transaction to a specific transfer order in the system. |