JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

InventoryConsumptionAdvicesconsumptionAdviceLines

The Consumption Advice Lines resource gets the line level details like item, organization, and purchase order details for a consumption advice.

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY] Long InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryConsumptionAdvicesRevision [KEY] Long InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionLineId [KEY] Long ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionAdviceLine Decimal ConsumptionAdviceLine of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionHeaderId Long ConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
PurchaseAgreementLine Decimal PurchaseAgreementLine of InventoryConsumptionAdvicesconsumptionAdviceLines
PurchaseAgreementLineId Long PurchaseAgreementLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantity Decimal ConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantityUOMCode String ConsumedQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantityUnitOfMeasure String ConsumedQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryItemId Long InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLines
ItemNumber String ItemNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ItemDescription String ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryOrganizationId Long InventoryOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLines
OrganizationName String OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLines
OrganizationCode String OrganizationCode of InventoryConsumptionAdvicesconsumptionAdviceLines
POHeaderId Long POHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
PONumber String PONumber of InventoryConsumptionAdvicesconsumptionAdviceLines
POLineId Long POLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
POLineNumber Decimal POLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
POScheduleId Long POScheduleId of InventoryConsumptionAdvicesconsumptionAdviceLines
POScheduleNumber Decimal POScheduleNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryConsumedQuantity Decimal SecondaryConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryQuantityUOMCode String SecondaryQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryQuantityUnitOfMeasure String SecondaryQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionDate Date TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionTypeId Long TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionTypeName String TransactionTypeName of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentReceiptNumber String ShipmentReceiptNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentHeaderId Long ShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
ReceiptLineNumber Long ReceiptLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentLineId Long ShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
CurrencyCode String CurrencyCode of InventoryConsumptionAdvicesconsumptionAdviceLines
UnitPrice Decimal UnitPrice of InventoryConsumptionAdvicesconsumptionAdviceLines
ExtendedPrice Decimal ExtendedPrice of InventoryConsumptionAdvicesconsumptionAdviceLines
RevisionNumber Long RevisionNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
Finder String Finder of InventoryConsumptionAdvicesconsumptionAdviceLines
Revision Long Revision of InventoryConsumptionAdvicesconsumptionAdviceLines

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