JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY] Long InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots
InventoryConsumptionAdvicesRevision [KEY] Long InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots
ConsumptionadvicelinesConsumptionLineId [KEY] Long ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots
LotNumber [KEY] String LotNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots
TransactionQuantity Double TransactionQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLots

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