MCP Server for Oracle Fusion Cloud SCM

Build 25.0.9440

ReceiptLots

Manages lot numbers associated with receipts, enabling precise tracking and validation.

Columns

Name Type Description
LotNumber [KEY] String The unique identifier for each lot in the ReceiptLots table, used to track specific lots of items received in the inventory system.
LotExpirationDate Date The expiration date associated with the lot, indicating when the items in the lot should no longer be used or sold.
ParentLotNumber String The identifier for the parent lot, if the current lot is a sub-lot or derived from another larger lot. This helps to link lots in a hierarchical structure.
BindItemId Long The identifier of the item associated with this lot, used to reference the specific product or material related to the receipt.
BindLotNumber String The identifier of the lot to which this receipt is bound, linking this lot to its corresponding receipt record.
BindOrganizationId Long The ID of the organization receiving the lot, representing the specific entity within the company that is handling the inventory.
BindTransactionTypeId Long The ID of the transaction type associated with the receipt of the lot, indicating the nature of the transaction (for example, purchase, transfer, etc.).
Finder String A reference code or identifier used for locating and searching the lot within the inventory system, which may include custom or external identifiers.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440