Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

InventoryStagedTransactions

InventoryStagedTransactions

Columns

Name Type Description
OrganizationId Long Value that uniquely identifies the organization.
OrganizationName String Name of the organization.
InventoryItemId Long Value that uniquely identifies the inventory item.
ItemNumber String Inventory item number.
ItemDescription String ItemDescription of InventoryStagedTransactions
Revision String Revision of the inventory item.
SubinventoryCode String Abbreviation that identifies the subinventory.
LocatorId Long Value that uniquely identifies the stock locator.
LocatorName String Description of the stock locators.
TransactionQuantity Double Transacted quantity of the item.
TransactionUOM String Abbreviation that identifies the unit of measure for the transaction.
TransactionUnitOfMeasure String Unit of measure for the transaction.
TransferOrganization Long Value that uniquely identifies the destination organization for transfer transactions.
TransferOrganizationName String Name of the transfer organization.
TransferSubinventory String Name of the destination subinventory for a transfer transaction.
TransferLocator Long Destination locator for a transfer transaction.
TransferLocatorName String Name of the destination locator for a transfer transaction.
TransactionHeaderId Long Value that uniquely identifies the transaction header.
TransactionInterfaceId [KEY] Long Value that uniquely identifies the transaction.
TrxSourceLineId Long Value that uniquely identifies the transaction source line.
TrxSourceDeliveryId Long Value that uniquely identifies the transaction source shipment.
TransactionDate Datetime Date when the transaction occurred.
SourceCode String Abbreviation that identifies the source.
SourceHeaderId Long Value that uniquely identifies the source header.
SourceLineId Long Value that uniquely identifies the source line.
TransactionSourceName String Name of the transaction source.
DemandSourceHeaderId Long Value that uniquely identifies the demand source header.
DemandSourceLine String Value that identifies the line in the demand document.
DemandSourceDelivery String Value that identifies the shipment in the demand document.
TransactionTypeName String Name of the transaction type.
TransactionTypeId Long Value that uniquely identifies the transaction type.
TransactionSourceTypeName String Name of the transaction source type.
TransactionSourceTypeId Long Value that uniquely identifies the transaction source type name.
TransactionActionName String Name of the transaction action.
TransactionActionId String Value that uniquely identifies the transaction action.
TransactionMode String Indicates the transaction mode.
LockStatus String Current status of the lock.
ProcessStatus String Current status of the process.
TransactionReference String Reference to the transaction.
ReasonId Long Value that uniquely identifies the inventory staged transaction reason.
ReasonName String Name of the inventory staged transaction reason.
ErrorCode String Abbreviation that identifies the error.
ErrorExplanation String Explanation of why the error occurred.
ShipmentNumber String Number that identifies the shipment.
FreightCarrierId Long Value that uniquely identifies the carrier.
Carrier String Name of the carrier.
ExternalSystemPackingUnit String Name of the packing unit in the external application.
WaybillAirbill String Number that identifies the waybill or airbill.
Containers Double Value that identifies the container to use when packing the unit.
TransferCost Double Cost incurred for the transfer.
TransportationCost Double Cost incurred for the transportation.
ExpectedArrivalDate Date Date when the item is expected to arrive.
OwningOrganizationId Long Value that uniquely identifies the owning organization.
OwningOrganizationName String Name of the owning organization.
OwningTpType String Type of owning trading partner.
TransferOwningOrganizationId Long Value that uniquely identifies the organization that owns the transfer.
TransferOwningOrganizationName String Name of the organization that owns the transfer.
TransferOwningTpType String Type of trading party owning the transfer.
ProcurementBusinessUnitName String Name of the business unit that procured the item.
VendorName String Name of the vendor.
VendorNumber String Number that identifies the vendor.
ConsignmentAgreementNumber String Number that identifies the consignment agreement.
DistributionAccountId Long Value that uniquely identifies the distribution account.
UseCurrentCostFlag Bool Contains one of the following values: true or false. If true, then use the current item cost. If false, then do not use the current item cost. This attribute does not have a default value. This attribute is mandatory.
PrimaryQuantity Double Transaction quantity in the primary unit of measure that the item uses.
TransactionBatchId Long Value that uniquely identifies the transaction batch.
TransactionBatchSequence Long Sequence number that identifies the transaction batch.
TransactionCost Double Cost incurred for the transaction.
TransactionGroupId Long Value that uniquely identifies the transaction group.
TransactionGroupSequence Double Sequence number that identifies the transaction group.
DefaultTaxationCountry String Abbreviation that identifies the default country for taxation.
DocumentSubType String Abbreviation that identifies the classification of the fiscal document.
TrxBusinessCategory String Name of the transaction business category.
UserDefinedFiscClass String Name of the fiscal classification.
TaxInvoiceNumber String Number of the tax invoice document.
TaxInvoiceDate Date Date and time of generation of the tax invoice document.
ProductCategory String Name of the product category of the transaction.
ProductType String Type of the product of the transaction.
AssessableValue Double Price that the tax authority uses to calculate tax for the item.
TaxClassificationCode String Abbreviation that identifies the tax classification.
ExemptCertificateNumber String Number that identifies the exempt certificate.
ExemptReasonCode String Abbreviation that identifies the reason for exemption.
IntendedUse String Value that identifies the classification for the intended use.
FirstPtyNumber String Number that identifies the first party of the transaction.
ThirdPtyNumber String Number that identifies the third party of the transaction.
FinalDischargeLocCode String Abbreviation that identifies the final discharge location.
CategoryName String Name of the category.
TransactionCostIdentifier String Value that uniquely identifies the transaction cost.
TransactionSourceId Long Value that uniquely identifies the transaction source.
ChartOfAccountsId Long Value that uniquely identifies the chart of accounts.
StructureInstanceNumber Long StructureInstanceNumber of InventoryStagedTransactions
SecondaryInventoryName String SecondaryInventoryName of InventoryStagedTransactions
SubinventoryId Long SubinventoryId of InventoryStagedTransactions
TransferSubInventoryId Long TransferSubInventoryId of InventoryStagedTransactions
TransferLocatorsSIN Long TransferLocatorsSIN of InventoryStagedTransactions
AccountCombination String Combination of the inventory transactions for a specified account combination.
AccountAliasCombination String Combination of the inventory transactions for an account alias.
TransferProjectId Long Value that uniquely identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in.
TransferTaskId Long Value that uniquely identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in.
TransferInvProject String Number that identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in.
TransferInvTask String Number that identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in.
LotTransactionGroupName String Name of the group of lot split, merge, and translate transactions data. This value is defined by the user.
SourceLotFlag Bool Contains one of the following values: true or false. If true, then the data belongs to the source lot of lot split, merge, and translate transaction types. If false, then the data belongs to the resultant lot of split, merge, and translate transaction types. This attribute does not have a default value.
RequesterId String Value that uniquely identifies the person who requested the material issued or received.
RequesterName String Name of the person who requested the material issued or received.
RequesterNumber String Number that uniquely identifies the person who requested the material issued or received. This value is defined by the user.
ExternalSystemTransactionReference String Value that refers to the corresponding transaction in external applications.
RepresentativeLotFlag Bool Contains one of the following values: true or false. If true, then the data belongs to the representative source lot for a lot merge transaction type. The lot attributes from the representative source lot will be copied to the resultant lot. If false, then the lot is not the representative source lot. This attribute does not have a default value.
SecondaryUOMCode String Abbreviation that identifies the secondary unit of measure that does not have a fixed conversion from the primary unit of measure. Also, this is part of the dual unit of measure record keeping that enables industries to maintain and use inventory in both quantity and weight units of measure, or volume and length units of measure.
SecondaryUnitOfMeasure String Secondary unit of measure in which an item can be transacted.
SecondaryTransactionQuantity Double Transaction quantity of an item in its secondary unit of measure.
LoadRequestId Long LoadRequestId of InventoryStagedTransactions
CreationDate Datetime CreationDate of InventoryStagedTransactions
CreatedBy String CreatedBy of InventoryStagedTransactions

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String finder

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