JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

InventoryCompletedTransactions

The Completed Transactions in Inventory resource allows the warehouse manager to view inventory transactions that the application successfully processed.

Columns

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

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