Cmdlets for Oracle Fusion Cloud SCM

Build 25.0.9434

InventoryCompletedTransactions

Enables warehouse managers to review and analyze successfully processed inventory transactions for reporting and auditing.

Columns

Name Type Description
TransactionId [KEY] Long A system-generated unique identifier for the completed inventory transaction. This identifier is essential for tracking, auditing, and managing all inventory movements within Oracle SCM, ensuring accurate reconciliation between physical and system-reported inventory.
Item String The item number or stock-keeping unit (SKU) of the product involved in the transaction. This value helps uniquely identify inventory items across warehouses and organizations.
ItemDescription String The detailed textual description of the item associated with the transaction. This description provides additional context to assist with product identification, reporting, and inventory reconciliation.
InventoryItemId Long A unique system-generated identifier assigned to the inventory item. This identifier ensures accurate integration between inventory transactions, stock records, and item master data.
Revision String The item revision number, if applicable, representing a specific version of the item. This value is used for tracking changes in engineering, design, or manufacturing specifications.
SubinventoryCode String The code representing the subinventory where the transaction was performed. This code enables precise tracking of inventory within specific storage locations, ensuring proper stock allocation and movement control.
SubinventoryId Long The unique identifier for the subinventory associated with the transaction. This field ensures accurate inventory location tracking and supports warehouse management operations.
LocatorId Long A system-generated identifier for the inventory locator, which specifies the exact bin, rack, or storage location where the transaction took place. This identifier ensures fine-grained inventory tracking within a warehouse or distribution center.
Locator String A human-readable locator code defining the physical storage location within a subinventory. This code enables users to quickly identify and retrieve inventory.
TransactionQuantity Decimal The quantity of items affected by the completed inventory transaction. This quantity is critical for inventory adjustments, transfers, issues, and receipts.
TransactionUOMCode String The code representing the unit of measure (UOM) used for the transaction. This code ensures consistency in quantity measurements across inventory and order management systems.
TransactionUOM String The full name of the UOM used for the transaction, providing a descriptive reference for inventory handling.
TransactionDate Datetime The date and time when the transaction was completed in the system. This value is crucial for inventory reconciliation, financial reporting, and audit compliance.
TransactionTypeId Long The unique identifier for the type of inventory transaction performed (for example, 'Receipt', 'Issue', 'Transfer', or 'Adjustment'). This value determines how the transaction impacts inventory and accounting.
TransactionType String The name or description of the transaction type, helping users and reports distinguish between different inventory movements (for example, 'Inventory Transfer', 'Miscellaneous Receipt').
TransactionSourceTypeId Long A system-generated identifier that defines the source type of the transaction. This identifier indicates whether it originated from a purchase order, sales order, work order, or another source.
TransactionSourceType String The name or description of the source type, providing context for how the inventory transaction was triggered within the supply chain.
SourceReference String A reference number or document identifier linking the transaction to its originating document (for example, a purchase order, work order, or transfer request), ensuring traceability and audit compliance.
Account String The general ledger account associated with the inventory transaction. This value ensures proper financial tracking of inventory movements and cost allocations within the accounting system.
Reason String A system-defined reason code or free-text explanation justifying why the inventory transaction was performed. This code is useful for audits and compliance reporting.
Reference String An additional reference field providing supplementary details about the completed inventory transaction, such as a tracking number or external document link.
ErrorExplanation String A detailed description of any processing errors encountered during the transaction, helping with troubleshooting and resolution in Oracle SCM.
TransferOrganization String The name of the organization to which the inventory was transferred in the transaction. This value is critical for tracking inter-organization stock movements and ensuring proper inventory alignment across business units.
TransferOrganizationCode String The short code representing the organization that received the transferred inventory. This code helps standardize organization identification in Oracle SCM.
TransferOrganizationId Long A system-generated unique identifier for the organization receiving the transferred inventory. This identifier ensures that inventory movements between organizations are accurately recorded and reconciled.
TransferOrgLocation String The name of the specific location within the receiving organization where the transferred inventory was delivered. This location helps pinpoint inventory placement after transfer.
TransferOrgLocationId Decimal A system-generated identifier for the receiving organization's location. This identifier enables detailed inventory tracking at the warehouse or facility level.
TransferSubinventory String The subinventory within the receiving organization where the transferred inventory was placed. This value ensures proper internal tracking of stock after inter-organization transfers.
TransferSubinventoryCode String The code representing the receiving subinventory, enabling structured inventory allocation and storage management.
TransferLocator String The specific storage locator within the receiving subinventory where the transferred inventory was stored. This locator is critical for warehouse operations and accurate inventory placement.
TransferLocatorId Long The unique identifier for the storage locator within the receiving subinventory, ensuring precise inventory tracking at the bin or shelf level.
TransferBusinessUnit String The business unit associated with the inventory transfer, ensuring financial and operational accountability for stock movements.
Quantity Decimal The total quantity of items involved in the completed inventory transaction. This quantity ensures accurate stock level tracking and inventory reconciliation.
UOMName String The descriptive name of the UOM used for the transaction, providing clarity in reporting and inventory management.
PrimaryUOMCode String The code representing the primary UOM used for the inventory transaction. This code ensures standardization and consistency in quantity measurements across inventory and order management systems.
SecondaryQuantity Decimal The quantity of the item in a secondary UOM, applicable when an item is tracked in dual units. This quantity supports accurate inventory tracking and reporting in cases where items have alternative measurement units.
SecondaryUOM String The name of the secondary UOM for the inventory transaction, providing a descriptive reference for dual-unit tracking.
SecondaryUOMCode String The code representing the secondary UOM used for the inventory transaction, ensuring accurate conversions between primary and secondary UOMs.
Source String The system-defined source of the inventory transaction, such as a purchase order, work order, or transfer order, providing traceability for inventory movements.
SourceLine Long The specific line number from the source document associated with the inventory transaction. This value ensures alignment between transaction records and their originating documents.
TransactionAction String The type of action performed in the inventory transaction (for example, 'Issue', 'Receipt', 'Transfer', or 'Adjustment'). This value defines the impact of the transaction on stock levels.
TransactionActionId Long A unique system-generated identifier representing the type of transaction action performed. This identifier ensures accurate tracking and classification of inventory movements.
TransactionSet Long The unique identifier for a group of related transactions processed together. This identifier enables batch processing and tracking of multiple transactions as part of a single operation.
TransferTransaction Long The unique identifier for the transaction related to an inventory transfer. This identifier ensures traceability when inventory is moved between organizations, locations, or subinventories.
ReceivingTransaction Long The identifier for the receiving transaction, used to track inbound inventory movements when receiving goods from suppliers, warehouses, or intercompany transfers.
Costed String Indicates whether the transaction has been costed in the financial system. 'Yes' means the transaction has been accounted for, while 'No' indicates pending cost processing.
AssetTrackingStatus String The status of asset tracking for the item involved in the transaction. This value helps monitor whether an asset is tracked, untracked, or pending tracking updates.
AlmInterfaceStatus String The status of the transaction's integration with the Asset Lifecycle Management (ALM) system. This status indicates whether the transaction has been successfully interfaced for asset tracking and management.
PickSlip Long The unique identifier for the pick slip document associated with the inventory transaction. This identifier is used in warehouse management to track picking and packing activities.
PackingUnit String The UOM used for packing the items in the transaction, such as 'Box', 'Pallet', or 'Carton'. This value supports shipping and handling processes.
ReceiptRequiredAtExpenseDestination String Indicates whether a receipt is required at the expense destination for this transaction. This value is relevant for transactions involving direct shipments to expense locations.
ManualReceiptExpense String Indicates whether the expense receipt for this transaction was manually processed instead of system-generated.
Location String The name or identifier of the physical or logical location associated with the transaction. This value is used for tracking inventory storage and movement.
ShipToLocationId Long The unique identifier for the destination location where the inventory is being shipped. This identifier ensures accurate tracking of shipments to their intended destinations.
LocationType String The type of location associated with the transaction, such as 'Warehouse', 'Retail Store', or 'Distribution Center'. This location helps classify different storage and shipment locations.
Shipment String The unique identifier for the shipment associated with the inventory transaction. This identifier is used to track and manage shipments throughout the supply chain.
Waybill String The waybill number associated with the shipment, serving as a tracking reference for logistics and transportation providers.
Carrier String The name of the carrier or shipping provider responsible for transporting the inventory. This name is used in logistics tracking and transportation management.
FreightCode String The code representing the freight terms or shipping method for the transaction (for example, 'FOB', 'CIF', or 'EXW'). This code is important for cost allocation and logistics planning.
NumberOfContainers Long The total number of containers used to ship the inventory in the transaction. This value is used for logistics tracking and shipment handling.
OwningPartyType String The type of party that owns the inventory involved in the transaction (for example,'Supplier', 'Customer', or 'Internal Business Unit'). This value helps classify ownership across transactions.
OwningTpType Long The unique identifier representing the type of owning party in the transaction. This identifier supports tracking and reporting on inventory ownership structures.
TransferOwningTpType Long The unique identifier for the type of owning party in the transfer transaction. This identifier ensures ownership tracking when inventory moves between entities.
OwningParty String The name of the entity that owns the inventory in the transaction. This value helps track and manage ownership responsibilities across the supply chain.
OwningPartySite String The specific site associated with the owning party, providing a more detailed location reference for ownership tracking.
TransferOwningPartyType String The type of party that owns the inventory after a transfer transaction. This value is critical for tracking changes in inventory ownership across business units.
TransferOwningParty String The name of the entity that takes ownership of the inventory after the transfer transaction. This value supports intercompany and interorganization transfers.
TransferOwningPartySite String The specific site of the entity that takes ownership after the transfer transaction, ensuring accurate tracking of inventory movements.
ConsumptionAdvice String Indicates whether consumption advice has been recorded for the transaction, typically used in consignment inventory scenarios where goods are consumed and then reported to the supplier for billing purposes.
ConsumptionAdviceLine String The line number associated with the consumption advice, used to track consumption details for consigned or vendor-managed inventory.
ConsumptionLineId Long The unique identifier for the consumption advice line, linking it to the associated transaction and ensuring accurate reconciliation of consumed inventory.
PurchaseOrder String The purchase order number associated with the inventory transaction, providing traceability for procurement-related movements.
PurchaseOrderHeaderId String A system-generated identifier for the purchase order header. This identifier groups multiple purchase order lines into a single document for financial and procurement tracking.
PurchaseOrderLineId String The unique identifier for the specific line item within the purchase order. This identifier ensures precise linkage between the inventory transaction and the ordered item.
PurchaseOrderLine String The line number of the purchase order associated with the transaction, providing additional context for matching goods received against purchase orders.
ParentTransaction Long The identifier for the parent transaction, used when an inventory transaction is part of a larger, related set of movements such as a split transaction or correction.
Receipt String The receipt document number associated with the inventory transaction. This document number links received goods to their purchase order and financial processing.
RcvShipmentHeaderId Long The unique identifier for the receiving shipment header. This identifier groups multiple receipt lines under a single inbound shipment.
ReceiptLine String The specific line number from the receipt document, used to track received inventory against procurement records.
RcvShipmentLineId String The unique identifier for the line within the receiving shipment. This identifier ensures proper reconciliation of goods received.
ConsumptionAdviceError String The error message or status associated with the consumption advice transaction. This error message or status is used for troubleshooting and resolving issues related to consigned inventory consumption.
ConsumptionAdviceErrorAction String The recommended corrective action or resolution for a consumption advice error, guiding users on how to address processing issues.
AssociatedOwnershipChangeTransaction Long The transaction identifier associated with an ownership change event. This identifier is used to track when inventory ownership is transferred between entities.
TaxationCountry String The country where the inventory transaction is subject to taxation. This value is essential for determining applicable tax rates and regulations.
DefaultTaxationCountry String The default country used for taxation purposes when a specific taxation country is not provided, ensuring compliance with financial regulations.
TransactionBusinessCategory String The business category assigned to the transaction. This category is used for reporting and financial classification purposes.
TrxBusinessCategory String The system-defined business category associated with the transaction. This category ensures proper classification for taxation and accounting.
DocumentFiscalClassification String The fiscal classification of the document associated with the transaction, determining how taxes and financial reporting are applied.
DocumentSubType String A subcategory of the document classification, further refining how the transaction is treated for tax and financial purposes.
UserDefinedFiscalClassification String A custom fiscal classification assigned by the user, allowing flexibility in tax and financial reporting.
UserDefinedFiscClass String An alternate representation of the user-defined fiscal classification, supporting customized tax reporting structures.
ProductFiscalClassification String The fiscal classification of the product in the transaction. This classification ensures accurate tax determination and compliance with regulations.
CategoryId Long The unique identifier for the product category associated with the inventory transaction. This identifier is used for classification in procurement, reporting, and tax calculations.
IntendedUse String The declared intended use of the item in the transaction, which can influence tax treatment and regulatory reporting requirements.
IntendedUseClassifId Long The unique identifier for the intended use classification. This identifier ensures proper application of tax and financial rules.
LocationOfFinalDischarge String The location where the goods will be ultimately used or consumed, which can impact tax calculations and regulatory compliance.
ProductCategory String The category assigned to the product in the inventory transaction, used for classification in financial reporting and taxation.
ProductCategoryCode String The code representing the product category. This code ensures standardization across tax reporting and inventory classification.
TaxClassificationCode String The tax classification code assigned to the transaction. This classification is used to determine applicable taxes based on regional or international regulations.
TaxClassification String The tax classification assigned to the inventory transaction. This classification determines the applicable tax rates and rules based on jurisdictional requirements.
ProductType String The classification of the product involved in the transaction (for example, 'Raw Material', 'Finished Good', or 'Service Item'). This classification is essential for inventory tracking and financial reporting.
ProductTypeCode String The code representing the product type, used for standardizing product classifications in inventory, tax, and financial reporting.
FirstPartyTaxRegistrationNumber String The tax registration number of the first party (company or entity executing the transaction). This number is required for tax reporting and compliance with regulatory requirements.
FirstPtyRegId Long The unique identifier for the first party’s tax registration. This identifier ensures proper linkage to tax compliance records.
ThirdPartyTaxRegistrationNumber String The tax registration number of the third party (supplier, customer, or external entity involved in the transaction), used for tax compliance and reporting.
ThirdPtyRegId Long The unique identifier for the third party’s tax registration. This identifier ensures accurate tracking of tax obligations and compliance.
ShipFromSite String The name of the site from which the goods are shipped in the transaction, providing traceability for outbound logistics and tax determination.
ShipFromLocationId Long The unique identifier for the ship-from location. This identifier ensures accurate tracking of inventory movements between facilities.
TaxInvoiceNumber String The invoice number assigned to the tax transaction. This number is used for tax reporting and audit purposes.
TaxInvoiceDate Date The date the tax invoice was issued, ensuring proper documentation for tax reporting and regulatory compliance.
AssessableValue Decimal The monetary value of the transaction used for tax calculation, ensuring accurate tax assessment based on applicable rates.
Currency String The currency in which the transaction was conducted. This value ensures accurate financial reporting and taxation in multi-currency environments.
TaxExemptionCertificateNumber String The certificate number indicating that the transaction is exempt from certain taxes, ensuring compliance with tax regulations.
TaxExemptReasonCode String The reason code indicating why the transaction qualifies for a tax exemption. This code supports accurate tax determination and compliance.
ExemptReasonCode String An alternate representation of the tax exemption reason code. This value ensures consistency in tax exemption tracking.
OperationNumber String The operation number within the manufacturing process associated with the transaction. This number is used for tracking work-in-process (WIP) activities.
OperationSequenceNumber Long The sequential number of the operation within the manufacturing process. This number ensures proper tracking of production workflows.
OperationSequenceNumberId Long The unique identifier for the operation sequence. This identifier provides traceability in manufacturing execution and transaction history.
OperationTransaction Long The identifier linking the transaction to a specific operation in the manufacturing process. This identifier supports work-in-process (WIP) tracking.
WIPSupplyType String The supply type used for work-in-process (WIP) inventory, such as 'Push', 'Pull', or 'Manual'. This value determines how materials are allocated to production.
WIPSupplyTypeCode Decimal A system-generated code representing the WIP supply type. This code ensures standardization in manufacturing operations.
WorkCenter String The name of the work center where the transaction occurred, providing visibility into manufacturing and production tracking.
DepartmentCode String The code representing the department responsible for the inventory transaction, ensuring proper financial and operational reporting.
DepartmentId Long The unique identifier for the department associated with the transaction. This identifier ensures accurate cost tracking and resource allocation.
AssemblySerialNumber String The serial number assigned to the assembly being processed in the transaction. This number ensures traceability of serialized manufacturing components.
ElectronicSignature Long The electronic signature captured for the transaction. This signature ensures compliance with security and regulatory requirements.
Organization String The name of the organization responsible for the transaction. This name ensures proper financial and operational classification.
OrganizationName String The full name of the organization executing the inventory transaction, providing clarity for reporting and reconciliation.
OrganizationId Long The unique identifier for the organization associated with the transaction. This identifier ensures accurate inventory and financial tracking.
OwningPartyOrgName String The name of the organization that owns the inventory, used to track ownership in intercompany and consignment transactions.
OwningPartyLocation String The location associated with the owning organization, providing visibility into inventory placement.
OwningPartyLocationId Long The unique identifier for the owning party’s location. This identifier ensures accurate tracking of inventory ownership.
LotTransactionGroupName String The name of the lot transaction group associated with the inventory transaction, used for grouping related lot-controlled transactions.
SourceLotFlag Bool Indicates whether the transaction originated from a lot-controlled source, ensuring proper tracking of lot-based inventory.
TransactionSourceName String The name of the source document or system that initiated the transaction. This name provides traceability for inventory movements.
TransactionSourceId Long The unique identifier for the transaction source. This identifier ensures accurate linkage to originating documents such as purchase orders, work orders, or sales orders.
ReasonId Long The unique identifier for the reason code associated with the transaction. This identifier is used for audit tracking and inventory adjustments.
ConsErrorTypeCode String The code representing the type of error encountered in a consignment-related transaction. This code is used for troubleshooting and resolution.
ConsErrorActionCode String The action code indicating the corrective action taken to resolve a consignment transaction error. This code ensures proper inventory reconciliation.
OwningOrganizationId Long A unique system-generated identifier for the organization that owns the inventory in this transaction. This identifier is essential for tracking inventory ownership across internal business units, ensuring proper financial control, cost allocation, and stock reconciliation in multi-entity environments.
XfrOwningOrganizationId Long The unique identifier for the organization receiving ownership of the transferred inventory. This identifier ensures proper ownership tracking when stock moves between organizations, helping maintain auditability in intercompany and intra-company transfers.
StructureInstanceNumber Long The unique instance number representing the structure associated with the transaction, such as a Bill of Materials (BOM) or work order structure. This value is crucial for tracking inventory usage within manufacturing and assembly processes.
CreationDate Datetime The date and time when the inventory transaction record was created in the system. This information is essential for audit tracking, transaction sequencing, and historical analysis of inventory movements.
CreatedBy String The name of the user or system process that initiated the inventory transaction. This information supports audit tracking, user accountability, and workflow validation.
Category String The classification category assigned to the transaction (for example, 'Material Issue', 'Receipt', or 'Transfer'). This categorization helps define the transaction’s impact on inventory, costing, and financial reporting.
Lot String The lot number associated with the inventory transaction, used for tracking and managing lot-controlled inventory. This value ensures compliance with traceability regulations and helps with recall management.
SerialNumber String The unique serial number of the item involved in the transaction. This serial number enables precise tracking of serialized inventory movements, ensuring regulatory compliance and asset control.
SupplierLot String The lot number assigned by the supplier, providing an additional layer of traceability for received goods. This number helps maintain visibility into supplier-provided inventory and ensures quality control.
ExternalSystemPackingUnit String The unit of packaging assigned to the transaction in an external system (for example, 'Pallet', 'Case', or 'Box'). This value supports seamless integration with third-party logistics, warehouse management, and shipping platforms.
DistributionAccountId Long The unique identifier for the distribution account linked to the inventory transaction. This identifier ensures accurate financial tracking and cost allocation, linking transactions to the general ledger.
FinalDischargeLocationId Long A system-generated identifier for the final destination of the inventory after movement. This identifier is critical for tracking inventory that moves through multiple locations before reaching its end-use location.
ProjectId Decimal The unique identifier for the project associated with the inventory transaction. This identifier enables project-based inventory management, ensuring that materials used in projects are properly tracked and costed.
TaskId Decimal The unique identifier for the task within the project that the transaction is linked to. This identifier helps allocate inventory costs accurately to specific tasks, improving project cost tracking and accountability.
CountryOfOriginCode String The standard country code representing the country where the item was manufactured or sourced. This code ensures compliance with trade regulations, customs reporting, and country-of-origin labeling requirements.
ProjectNumber String The project number associated with the inventory transaction. This field provides a user-friendly reference for tracking inventory that is assigned to a specific project.
TaskNumber String The task number within the project that the inventory transaction is linked to. This value ensures proper allocation of inventory resources within project-based costing structures.
CountryOfOrigin String The full name of the country where the item was manufactured or sourced. This value is essential for customs declarations, trade compliance, and government reporting requirements.
TransferProjectId Long The unique identifier for the project associated with an inventory transfer transaction. This identifier helps track inventory movement between projects and ensures accurate financial allocation.
TransferTaskId Long The unique identifier for the task associated with an inventory transfer transaction. This identifier ensures that transferred inventory is correctly assigned to a specific project task.
TransferProjectNumber String The project number associated with transferred inventory, providing traceability and ensuring proper allocation of project-related stock movements.
TransferTaskNumber String The task number linked to the transferred inventory, ensuring accurate project-level inventory tracking and cost distribution.
RequesterId Long The unique identifier of the individual or department that requested the inventory transaction. This identifier is critical for tracking approval workflows and ensuring accountability in inventory movements.
RequesterName String The name of the individual or department that requested the inventory transaction. This value provides visibility into request origins and supports inventory demand planning.
ExternalSystemTransactionReference String The transaction reference number from an external system, such as an ERP or third-party logistics system, ensuring seamless integration and cross-system reconciliation of inventory movements.
MovementRequestLineId Long A system-generated identifier for the specific line within a movement request. This identifier links the inventory transaction to internal stock movement requests, improving visibility into inventory allocation and movement.
LoadRequestId Long The unique identifier for the load request associated with the transaction. This identifier supports warehouse logistics by tracking shipments and load movements.
BindInventoryItemId Long The unique identifier for the inventory item referenced in a related transaction. This identifier helps establish linkages between transactions and supports reconciliation in multi-step inventory movements.
BindItem String The item number of the inventory being referenced in a binding transaction. This number ensures accurate linking of related inventory movements and cost allocations.
BindOrganization String The name of the organization associated with the binding transaction. This name ensures proper assignment of inventory movements across different business units or legal entities.
BindOrganizationId Long The unique identifier for the organization associated with the binding transaction. This identifier supports ownership tracking and financial reconciliation.
BindPJCProjectId String The unique identifier for the project referenced in a binding transaction. This identifier ensures alignment with project-based inventory tracking and costing.
BindPJCProjectNumber String The project number associated with the binding transaction, providing clarity on project-level inventory allocations.
BindPJCTaskId String The unique identifier for the task referenced in the binding transaction. This identifier ensures accurate tracking of inventory assigned to specific project tasks.
BindPJCTaskNumber String The task number associated with the binding transaction, improving visibility into task-level inventory consumption.
BindTransactionDate Datetime The date and time when the binding transaction occurred. This information ensures chronological accuracy in inventory tracking and reconciliation.
BindTransactionId Long The unique identifier of the binding transaction. This identifier establishes a reference for linking related inventory movements and transactions.
Finder String The system lookup reference used to identify and retrieve completed inventory transactions. This reference facilitates efficient searching, tracking, and reconciliation of inventory records.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434