JDBC Driver for Oracle SCM

Build 22.0.8462

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 String InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryConsumptionAdvicesRevision String InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionLineId String ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionAdviceLine String ConsumptionAdviceLine of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumptionHeaderId String ConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
PurchaseAgreementLine String PurchaseAgreementLine of InventoryConsumptionAdvicesconsumptionAdviceLines
PurchaseAgreementLineId String PurchaseAgreementLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantity String ConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantityUOMCode String ConsumedQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines
ConsumedQuantityUnitOfMeasure String ConsumedQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryItemId String InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLines
ItemNumber String ItemNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ItemDescription String ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryOrganizationId String InventoryOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLines
OrganizationName String OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLines
OrganizationCode String OrganizationCode of InventoryConsumptionAdvicesconsumptionAdviceLines
POHeaderId String POHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
PONumber String PONumber of InventoryConsumptionAdvicesconsumptionAdviceLines
POLineId String POLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
POLineNumber String POLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
POScheduleId String POScheduleId of InventoryConsumptionAdvicesconsumptionAdviceLines
POScheduleNumber String POScheduleNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryConsumedQuantity String SecondaryConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryQuantityUOMCode String SecondaryQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines
SecondaryQuantityUnitOfMeasure String SecondaryQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionDate Date TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionTypeId String TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLines
TransactionTypeName String TransactionTypeName of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentReceiptNumber String ShipmentReceiptNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentHeaderId String ShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines
ReceiptLineNumber String ReceiptLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines
ShipmentLineId String ShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLines
CurrencyCode String CurrencyCode of InventoryConsumptionAdvicesconsumptionAdviceLines
UnitPrice String UnitPrice of InventoryConsumptionAdvicesconsumptionAdviceLines
ExtendedPrice String ExtendedPrice of InventoryConsumptionAdvicesconsumptionAdviceLines
RevisionNumber String RevisionNumber of InventoryConsumptionAdvicesconsumptionAdviceLines

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462