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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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