ReceivingReceiptRequestslineslotSerialItemLotslotNumbersDFF
Supports descriptive flexfields for lot numbers associated with lot and serial-controlled items.
Columns
Name | Type | Description |
ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | Unique identifier for the header interface record in the Receiving Receipt Request system. This is used to track the receipt request at the header level. |
LinesInterfaceTransactionId [KEY] | Long | Identifier for the transaction associated with a specific line in the Receiving Receipt Request system. This ID is used to trace individual transactions linked to each receipt request line. |
LotserialitemlotsLotNumber [KEY] | String | Represents the lot number associated with a serial-controlled item in the Receiving Receipt Request system. It helps identify the specific lot for inventory tracking. |
TransactionInterfaceId [KEY] | Long | Unique identifier for the transaction in the Receiving Receipt Request system, used to track the transaction details associated with a receipt request. |
LotNumber [KEY] | String | Identifies the lot number for an item in the inventory. This number is used for tracking the specific batch or group of items within the system. |
_FLEX_Context | String | Context name for a descriptive flexfield used when an item is controlled by lot and serial numbers in the warehouse. This field provides additional contextual information for managing lot-specific details. |
_FLEX_Context_DisplayValue | String | Display value associated with the descriptive flexfield context for lots. It provides a user-friendly label or description of the context applied to the item. |
CustomerId | Long | Identifier for the customer associated with the receipt request. This ID helps in identifying which customer is requesting the receipt or inventory update. |
CustomerPartyName | String | Name of the customer party related to the receipt request. This provides a human-readable reference to the customer involved in the transaction. |
DocumentNumber | String | Document number associated with the receipt request or transaction. This number is used to link the request to a specific document for reference and tracking. |
ExternalSystemTransactionReference | String | Reference identifier from an external system for the transaction. This is used to connect the transaction in OracleSCM with external systems' data for integration purposes. |
Finder | String | A search identifier used within the Receiving Receipt Request system. It helps in locating or referencing specific transactions or items within the system. |
FromDate | Datetime | The start date for the period during which the receipt request is valid. This date marks the beginning of the time range for processing or tracking the request. |
FromOrganizationCode | String | Code representing the organization from which the goods or items are being received. This helps in identifying the origin of the receipt. |
FromOrganizationId | Long | Identifier for the organization that is sending or transferring the items to the receiving organization. This ID helps track the source of the receipt request. |
GroupId | Long | Identifier for the group associated with the receipt request. This ID is used to categorize and track related receipt requests within the system. |
HeaderInterfaceId | Long | Identifier for the header-level interface record, linking the receiving receipt request to its corresponding header record in the system. |
ItemId | Long | Unique identifier for the item being received. This ID helps identify the specific product or material associated with the receipt request. |
ItemNumber | String | Unique number or identifier for the item. This number is used to track and reference the item in the receiving process. |
OrganizationCode | String | Code representing the organization receiving the items. This helps identify the location or department involved in the receipt of goods. |
OrganizationId | Long | Identifier for the organization receiving the goods or materials. This ID helps distinguish different organizations or units within the system. |
POHeaderId | Long | Purchase order header identifier for the items being received. This ID links the receipt request to a specific purchase order for validation and processing. |
ProcessingStatusCode | String | Code representing the current status of the receipt request. It helps indicate whether the request is pending, processed, or has encountered issues. |
ReceiptAdviceHeaderId | Long | Identifier for the receipt advice header, used to track receipt advice related to a purchase or transaction. This helps in validating and confirming receipt information. |
RMANumber | String | Return merchandise authorization (RMA) number, used for tracking the return of items. This number is tied to the receipt of goods being returned. |
ShipmentHeaderId | Long | Identifier for the shipment associated with the receipt request. This ID helps link the receipt to a specific shipment for tracking and processing. |
ShipmentNumber | String | Shipment number associated with the transaction, used for tracking the movement and receipt of goods during the shipment process. |
SourceDocumentCode | String | Code representing the original source document, such as an invoice or purchase order, linked to the receipt request. This helps track the origin of the receipt. |
ToDate | Datetime | The end date for the period during which the receipt request is valid. This date marks the end of the time range for processing or tracking the request. |
TransactionStatusCode | String | Code representing the current status of the transaction, indicating whether it is pending, completed, or has encountered errors. |
TransactionType | String | Type of transaction associated with the receipt request, such as purchase, return, or transfer. This helps classify the nature of the transaction. |
TransferOrderHeaderId | Long | Identifier for the transfer order header, used to track inter-organization transfers. This ID links the receipt request to a specific transfer order. |
VendorId | Long | Identifier for the vendor supplying the items being received. This ID is used to track which vendor the goods are coming from. |
VendorName | String | Name of the vendor supplying the items. This provides a human-readable reference to the vendor in the receipt request. |
VendorNumber | String | Vendor number used to uniquely identify the vendor in the system. This number is used for tracking and managing vendor-related transactions. |