SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

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 [KEY] Long InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryConsumptionAdvicesRevision [KEY] Long InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionadvicelinesConsumptionLineId [KEY] Long ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionId [KEY] Long TransactionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Item String Item of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ItemDescription String ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryItemId Long InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Revision String Revision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SubinventoryCode String SubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SubinventoryId Long SubinventoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LocatorId Long LocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Locator String Locator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionQuantity Decimal TransactionQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionUOMCode String TransactionUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionUOM String TransactionUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionDate Datetime TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionTypeId Long TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionType String TransactionType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceTypeId Long 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 Long TransferOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrgLocation String TransferOrgLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOrgLocationId Decimal TransferOrgLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferSubinventory String TransferSubinventory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferSubinventoryCode String TransferSubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferLocator String TransferLocator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferLocatorId Long TransferLocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferBusinessUnit String TransferBusinessUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Quantity Decimal Quantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
UOMName String UOMName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PrimaryUOMCode String PrimaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryQuantity Decimal SecondaryQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryUOM String SecondaryUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SecondaryUOMCode String SecondaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Source String Source of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SourceLine Long SourceLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionAction String TransactionAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionActionId Long TransactionActionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSet Long TransactionSet of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTransaction Long TransferTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceivingTransaction Long ReceivingTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Costed String Costed of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssetTrackingStatus String AssetTrackingStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AlmInterfaceStatus String AlmInterfaceStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PickSlip Long PickSlip of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PackingUnit String PackingUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceiptRequiredAtExpenseDestination String ReceiptRequiredAtExpenseDestination of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ManualReceiptExpense String ManualReceiptExpense of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Location String Location of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipToLocationId Long 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 Long NumberOfContainers of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyType String OwningPartyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningTpType Long OwningTpType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferOwningTpType Long 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 Long ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrder String PurchaseOrder of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderHeaderId String PurchaseOrderHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderLineId String PurchaseOrderLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
PurchaseOrderLine String PurchaseOrderLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ParentTransaction Long ParentTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Receipt String Receipt of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RcvShipmentHeaderId Long RcvShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReceiptLine String ReceiptLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RcvShipmentLineId String RcvShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdviceError String ConsumptionAdviceError of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionAdviceErrorAction String ConsumptionAdviceErrorAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssociatedOwnershipChangeTransaction Long 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 Long CategoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
IntendedUse String IntendedUse of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
IntendedUseClassifId Long 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 Long FirstPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ThirdPartyTaxRegistrationNumber String ThirdPartyTaxRegistrationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ThirdPtyRegId Long ThirdPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipFromSite String ShipFromSite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ShipFromLocationId Long ShipFromLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxInvoiceNumber String TaxInvoiceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaxInvoiceDate Date TaxInvoiceDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssessableValue Decimal 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 Long OperationSequenceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationSequenceNumberId Long OperationSequenceNumberId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OperationTransaction Long OperationTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WIPSupplyType String WIPSupplyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WIPSupplyTypeCode Decimal WIPSupplyTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
WorkCenter String WorkCenter of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DepartmentCode String DepartmentCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
DepartmentId Long DepartmentId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
AssemblySerialNumber String AssemblySerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ElectronicSignature Long ElectronicSignature of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Organization String Organization of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OrganizationName String OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OrganizationId Long OrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyOrgName String OwningPartyOrgName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyLocation String OwningPartyLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningPartyLocationId Long OwningPartyLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LotTransactionGroupName String LotTransactionGroupName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
SourceLotFlag Bool SourceLotFlag of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceName String TransactionSourceName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransactionSourceId Long TransactionSourceId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ReasonId Long ReasonId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsErrorTypeCode String ConsErrorTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsErrorActionCode String ConsErrorActionCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
OwningOrganizationId Long OwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
XfrOwningOrganizationId Long XfrOwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
StructureInstanceNumber Long 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 Long DistributionAccountId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
FinalDischargeLocationId Long FinalDischargeLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProjectId Decimal ProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaskId Decimal TaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CountryOfOriginCode String CountryOfOriginCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ProjectNumber String ProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TaskNumber String TaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
CountryOfOrigin String CountryOfOrigin of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferProjectId Long TransferProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTaskId Long TransferTaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferProjectNumber String TransferProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
TransferTaskNumber String TransferTaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RequesterId Long RequesterId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
RequesterName String RequesterName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ExternalSystemTransactionReference String ExternalSystemTransactionReference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
MovementRequestLineId Long MovementRequestLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
LoadRequestId Long LoadRequestId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
ConsumptionHeaderId Long ConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Finder String Finder of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions

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