JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions

The Consumption Advice Transactions resource gets the transaction details like transaction quantity and transaction type at the line level.

Columns

Name Type Description
InventoryConsumptionAdvicesConsumptionHeaderId String InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryConsumptionAdvicesRevision String InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionadvicelinesConsumptionLineId String ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionId String TransactionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Item String Item of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ItemDescription String ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryItemId String InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Revision String Revision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SubinventoryCode String SubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SubinventoryId String SubinventoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LocatorId String LocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Locator String Locator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionQuantity String TransactionQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionUOMCode String TransactionUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionUOM String TransactionUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionDate Datetime TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionTypeId String TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionType String TransactionType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceTypeId String TransactionSourceTypeId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceType String TransactionSourceType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SourceReference String SourceReference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Account String Account of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Reason String Reason of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Reference String Reference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ErrorExplanation String ErrorExplanation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrganization String TransferOrganization of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrganizationCode String TransferOrganizationCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrganizationId String TransferOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrgLocation String TransferOrgLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrgLocationId String TransferOrgLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferSubinventory String TransferSubinventory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferSubinventoryCode String TransferSubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferLocator String TransferLocator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferLocatorId String TransferLocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferBusinessUnit String TransferBusinessUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Quantity String Quantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
UOMName String UOMName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PrimaryUOMCode String PrimaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryQuantity String SecondaryQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryUOM String SecondaryUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryUOMCode String SecondaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Source String Source of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SourceLine String SourceLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionAction String TransactionAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionActionId String TransactionActionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSet String TransactionSet of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTransaction String TransferTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceivingTransaction String ReceivingTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Costed String Costed of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssetTrackingStatus String AssetTrackingStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AlmInterfaceStatus String AlmInterfaceStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PickSlip String PickSlip of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PackingUnit String PackingUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceiptRequiredAtExpenseDestination String ReceiptRequiredAtExpenseDestination of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ManualReceiptExpense String ManualReceiptExpense of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Location String Location of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipToLocationId String ShipToLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LocationType String LocationType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Shipment String Shipment of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Waybill String Waybill of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Carrier String Carrier of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
FreightCode String FreightCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
NumberOfContainers String NumberOfContainers of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyType String OwningPartyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningTpType String OwningTpType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOwningTpType String TransferOwningTpType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningParty String OwningParty of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartySite String OwningPartySite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOwningPartyType String TransferOwningPartyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOwningParty String TransferOwningParty of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOwningPartySite String TransferOwningPartySite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdvice String ConsumptionAdvice of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdviceLine String ConsumptionAdviceLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionLineId String ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrder String PurchaseOrder of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderHeaderId String PurchaseOrderHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderLineId String PurchaseOrderLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderLine String PurchaseOrderLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ParentTransaction String ParentTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Receipt String Receipt of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RcvShipmentHeaderId String RcvShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceiptLine String ReceiptLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RcvShipmentLineId String RcvShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdviceError String ConsumptionAdviceError of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdviceErrorAction String ConsumptionAdviceErrorAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssociatedOwnershipChangeTransaction String AssociatedOwnershipChangeTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxationCountry String TaxationCountry of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DefaultTaxationCountry String DefaultTaxationCountry of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionBusinessCategory String TransactionBusinessCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TrxBusinessCategory String TrxBusinessCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DocumentFiscalClassification String DocumentFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DocumentSubType String DocumentSubType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
UserDefinedFiscalClassification String UserDefinedFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
UserDefinedFiscClass String UserDefinedFiscClass of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProductFiscalClassification String ProductFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CategoryId String CategoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
IntendedUse String IntendedUse of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
IntendedUseClassifId String IntendedUseClassifId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LocationOfFinalDischarge String LocationOfFinalDischarge of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProductCategory String ProductCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProductCategoryCode String ProductCategoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxClassificationCode String TaxClassificationCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxClassification String TaxClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProductType String ProductType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProductTypeCode String ProductTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
FirstPartyTaxRegistrationNumber String FirstPartyTaxRegistrationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
FirstPtyRegId String FirstPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ThirdPartyTaxRegistrationNumber String ThirdPartyTaxRegistrationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ThirdPtyRegId String ThirdPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipFromSite String ShipFromSite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipFromLocationId String ShipFromLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxInvoiceNumber String TaxInvoiceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxInvoiceDate Date TaxInvoiceDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssessableValue String AssessableValue of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Currency String Currency of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxExemptionCertificateNumber String TaxExemptionCertificateNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxExemptReasonCode String TaxExemptReasonCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ExemptReasonCode String ExemptReasonCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationNumber String OperationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationSequenceNumber String OperationSequenceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationSequenceNumberId String OperationSequenceNumberId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationTransaction String OperationTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WIPSupplyType String WIPSupplyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WIPSupplyTypeCode String WIPSupplyTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WorkCenter String WorkCenter of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DepartmentCode String DepartmentCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DepartmentId String DepartmentId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssemblySerialNumber String AssemblySerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ElectronicSignature String ElectronicSignature of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Organization String Organization of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OrganizationName String OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OrganizationId String OrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyOrgName String OwningPartyOrgName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyLocation String OwningPartyLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyLocationId String OwningPartyLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LotTransactionGroupName String LotTransactionGroupName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SourceLotFlag Bool SourceLotFlag of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceName String TransactionSourceName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceId String TransactionSourceId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReasonId String ReasonId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsErrorTypeCode String ConsErrorTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsErrorActionCode String ConsErrorActionCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningOrganizationId String OwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
XfrOwningOrganizationId String XfrOwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
StructureInstanceNumber String StructureInstanceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CreationDate Datetime CreationDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CreatedBy String CreatedBy of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Category String Category of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Lot String Lot of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SerialNumber String SerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SupplierLot String SupplierLot of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ExternalSystemPackingUnit String ExternalSystemPackingUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DistributionAccountId String DistributionAccountId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
FinalDischargeLocationId String FinalDischargeLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProjectId String ProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaskId String TaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CountryOfOriginCode String CountryOfOriginCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProjectNumber String ProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaskNumber String TaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CountryOfOrigin String CountryOfOrigin of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferProjectId String TransferProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTaskId String TransferTaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferProjectNumber String TransferProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTaskNumber String TransferTaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RequesterId String RequesterId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RequesterName String RequesterName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ExternalSystemTransactionReference String ExternalSystemTransactionReference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
MovementRequestLineId String MovementRequestLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LoadRequestId String LoadRequestId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions

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