JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ConsumptionHeaderId Long ConsumptionHeaderId
Revision Long Revision
Finder String finder

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