JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

The Consumption Advice Lots And Serials resource gets the lot-serial details for items in the consumption advice line.

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY] Long InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
InventoryConsumptionAdvicesRevision [KEY] Long InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
ConsumptionadvicelinesConsumptionLineId [KEY] Long ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
ConsumptionadvicelotsLotNumber [KEY] String ConsumptionadvicelotsLotNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
SerialNumber [KEY] String SerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
ConsumptionHeaderId Long ConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
Finder String Finder of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
Revision Long Revision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060