CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceSerials

Tracks serial numbers for items within a consumption advice line to ensure detailed monitoring.

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY] Long A system-generated unique identifier linking this serialized inventory consumption record to its corresponding consumption advice header. This identifier ensures traceability of serialized 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 serialized inventory.
ConsumptionadvicelinesConsumptionLineId [KEY] Long The unique identifier for the specific consumption advice line that this serial record belongs to. This identifier ensures that serial-based inventory consumption is accurately linked to the corresponding consumption transaction.
SerialNumber [KEY] String The unique serial number assigned to the inventory item for this consumption transaction. This serial number enables precise tracking of serialized inventory movements, ensuring compliance with warranty validation, recall management, and audit requirements.
ConsumptionHeaderId Long The unique identifier for the consumption advice document. This identifier ensures that individual serial consumption records are properly linked to the overall consumption report for auditing and reconciliation.
Finder String The lookup reference used to retrieve and manage serial-based inventory consumption advice records. This reference facilitates efficient searching, reporting, and reconciliation of serial-tracked inventory usage.
Revision Long The version control identifier for the serialized inventory 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