Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots

Details lot-specific information, such as lot number and transaction quantity, within consumption advice lines.

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY] Long A system-generated unique identifier linking this lot-level consumption record to its corresponding consumption advice header. This identifier ensures traceability of lot-tracked inventory consumption within the overall advice document.
InventoryConsumptionAdvicesRevision [KEY] Long The revision number of the associated consumption advice, indicating any updates or modifications made to the original consumption record for lot-controlled inventory.
ConsumptionadvicelinesConsumptionLineId [KEY] Long The unique identifier for the specific consumption advice line that this lot record belongs to. This identifier ensures that lot-based inventory consumption is accurately linked to the corresponding consumption transaction.
LotNumber [KEY] String The unique lot number associated with the inventory item in this consumption transaction. This value ensures precise tracking of lot-controlled inventory for compliance, quality control, and supplier reconciliation.
TransactionQuantity Decimal The quantity of the lot-controlled inventory item that was consumed in this transaction. This quantity is essential for tracking stock depletion, ensuring accurate financial reporting, and maintaining inventory accuracy.
ConsumptionHeaderId Long The unique identifier for the consumption advice document. This identifier ensures that individual lot consumption records are properly linked to the overall consumption report for auditing and reconciliation.
Finder String The lookup reference used to retrieve and manage lot-based inventory consumption advice records. This reference facilitates efficient searching, reporting, and reconciliation of lot-tracked inventory usage.
Revision Long The version control identifier for the lot-level consumption advice record. This identifier ensures proper tracking of modifications and updates to the consumption history.

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