InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Provides transaction-level information, including quantity and transaction type, for consumption advice lines.
Columns
| Name | Type | Description |
| InventoryConsumptionAdvicesConsumptionHeaderId [KEY] | Long | A system-generated unique identifier linking this consumption transaction record to its corresponding consumption advice header. This identifier ensures traceability of inventory consumption transactions within the overall advice document. |
| InventoryConsumptionAdvicesRevision [KEY] | Long | The revision number of the associated consumption advice, indicating any updates or modifications made to the original consumption record for inventory movements. |
| ConsumptionadvicelinesConsumptionLineId [KEY] | Long | The unique identifier for the specific consumption advice line that this transaction record belongs to. This identifier ensures that inventory movements are accurately linked to the corresponding consumption transaction. |
| TransactionId [KEY] | Long | The unique identifier for the inventory transaction associated with the consumption advice. This identifier ensures traceability of stock movements and financial reconciliation. |
| Item | String | The item number associated with the inventory consumption transaction. This value establishes traceability between the inventory master record and consumed stock. |
| ItemDescription | String | The description of the inventory item consumed in the transaction, providing a user-friendly reference for stock management and financial reporting. |
| InventoryItemId | Long | The unique identifier for the inventory item referenced in the consumption transaction. This identifier ensures proper linkage to the inventory master record for stock tracking and valuation. |
| Revision | String | The revision number of the inventory consumption transaction, tracking modifications or updates made to the original transaction details. |
| SubinventoryCode | String | The unique code representing the subinventory from which the item was consumed. This code supports subinventory-level stock tracking and reconciliation. |
| SubinventoryId | Long | The unique identifier for the subinventory associated with the consumption transaction. This identifier ensures proper tracking of stock movements within designated storage locations. |
| LocatorId | Long | The unique identifier for the locator (specific storage location) within the subinventory from which the inventory was consumed. This identifier ensures accurate inventory tracking within warehouses. |
| Locator | String | The name or code of the locator (specific storage location) within the subinventory, ensuring visibility into where the inventory was stored before consumption. |
| TransactionQuantity | Decimal | The quantity of the inventory item consumed in the transaction. This quantity is essential for stock tracking, supplier replenishment, and financial reporting. |
| TransactionUOMCode | String | The unit of measure (UOM) code for the transaction quantity. This code ensures consistency in measurement standards across inventory transactions. |
| TransactionUOM | String | The full name of the UOM for the consumed inventory quantity. This name ensures accurate reporting and reconciliation. |
| TransactionDate | Datetime | The date and time when the inventory consumption transaction occurred. This timestamp ensures chronological accuracy in stock movement tracking and financial reconciliation. |
| TransactionTypeId | Long | The unique identifier for the type of transaction recorded in the consumption advice. This identifier ensures accurate classification of stock movements. |
| TransactionType | String | The name of the transaction type associated with the consumption advice (for example, 'Consumption', 'Transfer', or 'Return to Supplier'). This name ensures accurate classification of inventory usage. |
| TransactionSourceTypeId | Long | The unique identifier representing the source type of the inventory transaction. This identifier ensuresg accurate linkage to the original transaction source (for example, a purchase order, shipment, or inventory adjustment). |
| TransactionSourceType | String | The type of source associated with the inventory transaction (for example, 'Purchase Order', 'Shipment', or 'Adjustment'). This value ensures accurate tracking of stock movements. |
| SourceReference | String | The reference number associated with the original source of the transaction, providing traceability between inventory movements and the initiating document. |
| Account | String | The financial account associated with the inventory consumption transaction. This value ensures proper cost allocation and financial tracking of stock movements. |
| Reason | String | The justification for the inventory transaction (for example, 'Damaged', 'Expired', or 'Stock Adjustment'). This field is critical for audit trails and compliance reporting. |
| Reference | String | An additional reference or comment related to the inventory transaction, supporting better documentation of stock movements. |
| ErrorExplanation | String | A description of any errors encountered during the processing of the consumption transaction. This description assists in troubleshooting and ensuring data accuracy. |
| TransferOrganization | String | The name of the organization to which the inventory was transferred. This name supports inter-organizational stock transfers and financial tracking. |
| TransferOrganizationCode | String | The unique code representing the destination organization for the inventory transfer. This code ensures proper tracking of stock movements between business units. |
| TransferOrganizationId | Long | The unique identifier for the destination organization in an inventory transfer transaction. This identifier ensures financial accountability and accurate reporting for inter-org stock movements. |
| TransferOrgLocation | String | The name or description of the location within the destination organization where the inventory was transferred. This field ensures visibility into stock relocation. |
| TransferOrgLocationId | Decimal | The unique identifier for the location within the destination organization where the inventory was transferred. This identifier ensures accurate tracking of inter-organization stock movements. |
| TransferSubinventory | String | The name of the subinventory within the receiving organization where the inventory was transferred. This value supports inventory tracking at a detailed storage location level. |
| TransferSubinventoryCode | String | The unique code representing the subinventory at the destination organization where the inventory was transferred. This code ensures accurate stock location tracking. |
| TransferLocator | String | The name or identifier of the specific locator within the transfer subinventory. This identifier provides precise visibility into where the inventory is placed after transfer. |
| TransferLocatorId | Long | The unique identifier for the locator within the transfer subinventory. This identifier ensures accurate tracking of inventory placement at the storage location level. |
| TransferBusinessUnit | String | The name of the business unit receiving the transferred inventory. This name ensures accurate financial reporting and tracking of inter-business unit stock movements. |
| Quantity | Decimal | The quantity of inventory involved in the consumption transaction. This quantity ensures proper tracking of stock depletion, movement, and reconciliation. |
| UOMName | String | The full name of the UOM associated with the transaction quantity. This name ensures consistency in inventory reporting. |
| PrimaryUOMCode | String | The primary UOM code used for the consumed inventory item. This code helps standardize measurement across stock transactions. |
| SecondaryQuantity | Decimal | The quantity of the inventory item in an alternate UOM. This quantity is used when inventory is tracked in multiple units for reporting and conversion purposes. |
| SecondaryUOM | String | The name of the secondary UOM associated with the secondary quantity. This name ensures clear identification in stock conversion calculations. |
| SecondaryUOMCode | String | The UOM code for the secondary quantity. This code ensures standardization across multi-UOM transactions. |
| Source | String | The source system or document from which the inventory transaction originated. This information ensures traceability between inventory consumption and procurement or production records. |
| SourceLine | Long | The line number associated with the source document of the transaction, ensuring accurate reference to the originating record. |
| TransactionAction | String | The type of action taken in the transaction (for example, 'Issue', 'Transfer', or 'Adjustment'). This action type ensures proper classification of inventory movements. |
| TransactionActionId | Long | The unique identifier associated with the transaction action. This identifier ensures traceability and integration within the inventory system. |
| TransactionSet | Long | The unique identifier for the transaction set that groups multiple related inventory transactions. This identifier facilitates batch processing and reconciliation. |
| TransferTransaction | Long | The unique identifier for the inventory transfer transaction. This identifier ensures traceability of inter-organization stock movements. |
| ReceivingTransaction | Long | The unique identifier for the receiving transaction linked to the inventory transfer. This identifier ensures proper recording of received stock in the destination location. |
| Costed | String | A flag indicating whether the transaction has been costed in the financial system. This flag ensures proper valuation of inventory movements in accounting records. |
| AssetTrackingStatus | String | The tracking status of assets related to the inventory transaction. This status ensures visibility into asset-controlled inventory items. |
| AlmInterfaceStatus | String | The interface processing status of the inventory transaction in the Asset Lifecycle Management (ALM) system. This interface ensures seamless integration between inventory and asset tracking. |
| PickSlip | Long | The unique identifier for the pick slip associated with the inventory transaction. This identifierensures traceability between inventory picking and consumption records. |
| PackingUnit | String | The packing unit associated with the inventory transaction (for example, 'Box' or 'Pallet'). This field supports accurate handling and shipping documentation. |
| ReceiptRequiredAtExpenseDestination | String | A flag indicating whether a receipt is required at the expense destination for tracking purposes. This flag ensures compliance with procurement and financial policies. |
| ManualReceiptExpense | String | A flag indicating whether the expense receipt is manually recorded. This flag supports tracking of non-standard receipt processes. |
| Location | String | The name or description of the location where the inventory transaction took place. This information ensures accurate tracking of inventory movements. |
| ShipToLocationId | Long | The unique identifier for the ship-to location associated with the transaction. This identifier ensures proper tracking of goods movement and delivery. |
| LocationType | String | The type of location where the inventory transaction occurred (for example, 'Warehouse' or 'Dock'). This type ensures proper classification of stock movements. |
| Shipment | String | The shipment reference number associated with the inventory transaction. This reference number ensures traceability between inventory movements and logistics records. |
| Waybill | String | The waybill number associated with the shipment, ensuring accurate tracking of inventory in transit. |
| Carrier | String | The name of the carrier handling the shipment. This name ensures traceability of shipped inventory for logistics and compliance tracking. |
| FreightCode | String | The freight code associated with the inventory transaction. This code ensures accurate freight cost allocation and logistics management. |
| NumberOfContainers | Long | The total number of containers used in the shipment related to the transaction. This information ensures accurate tracking of packaging and logistics details. |
| OwningPartyType | String | The type of entity that owns the inventory involved in the transaction (for example, 'Supplier' or 'Business Unit'). This field ensures proper ownership tracking and financial reconciliation. |
| OwningTpType | Long | The type of ownership associated with the inventory transaction, defining whether the ownership is internal, supplier-managed, or consigned. This value ensures accurate financial tracking and compliance with inventory ownership policies. |
| TransferOwningTpType | Long | The type of ownership associated with the receiving party in a transfer transaction. This value ensures that ownership changes are accurately recorded when inventory moves between entities. |
| OwningParty | String | The name of the entity that owns the inventory involved in the transaction (for example, a business unit, supplier, or third party). This name ensures accurate financial reconciliation and stock accountability. |
| OwningPartySite | String | The specific site or location associated with the owning party. This field helps track inventory ownership at a detailed level for compliance and logistics. |
| TransferOwningPartyType | String | The type of entity receiving ownership of the inventory in the transfer. This value ensures that ownership changes are properly documented and tracked. |
| TransferOwningParty | String | The name of the receiving entity that will own the inventory after the transfer is complete. This name is essential for financial reporting and reconciliation of stock movements. |
| TransferOwningPartySite | String | The specific site or location associated with the receiving entity in a transfer transaction. This information ensures that inventory ownership updates align with physical stock locations. |
| ConsumptionAdvice | String | The consumption advice reference associated with the transaction, providing details on consumed inventory for supplier reconciliation and procurement planning. |
| ConsumptionAdviceLine | String | The specific line within the consumption advice document, ensuring traceability of each consumption entry for financial and inventory reconciliation. |
| ConsumptionLineId | Long | The unique identifier for the line item in the consumption advice document. This identifier ensures proper linkage between inventory transactions and consumption records. |
| PurchaseOrder | String | The purchase order reference linked to the consumption transaction, ensuring alignment between procurement, inventory usage, and supplier invoicing. |
| PurchaseOrderHeaderId | String | The unique identifier for the purchase order header, ensuring traceability between the overarching procurement agreement and individual consumption transactions. |
| PurchaseOrderLineId | String | The unique identifier for the purchase order line associated with the consumed inventory, ensuring financial alignment and procurement tracking. |
| PurchaseOrderLine | String | The specific purchase order line number linked to the consumption advice, supporting reconciliation of inventory movements against supplier contracts. |
| ParentTransaction | Long | The identifier for a related or previous transaction in a consumption advice sequence. This identifier ensures continuity in transaction tracking for audit and compliance. |
| Receipt | String | The receipt reference associated with the inventory consumption transaction. This receipt reference ensures traceability between received stock and consumed inventory. |
| RcvShipmentHeaderId | Long | The unique identifier for the shipment receipt document associated with the inventory transaction. This identifier ensures accurate tracking of inbound goods and consumption reporting. |
| ReceiptLine | String | The specific receipt line number corresponding to the inventory consumption transaction. This line number supports reconciliation between received and consumed stock. |
| RcvShipmentLineId | String | The unique identifier for the shipment line associated with the receipt and consumption advice. This identifier ensures proper tracking of received stock at a detailed level. |
| ConsumptionAdviceError | String | A description of any errors encountered in processing the consumption advice. This descriptions supports troubleshooting and ensures data accuracy in inventory transactions. |
| ConsumptionAdviceErrorAction | String | The corrective action taken to resolve errors in the consumption advice transaction. This action ensures accurate resolution of discrepancies in inventory tracking. |
| AssociatedOwnershipChangeTransaction | Long | The unique identifier for the ownership change transaction associated with the consumption advice. This identifier ensures traceability of stock transfers between different owners. |
| TaxationCountry | String | The country associated with the taxation rules applied to the inventory transaction. This value ensures compliance with local tax regulations. |
| DefaultTaxationCountry | String | The default taxation country used for financial calculations in the transaction. This value ensures consistency in tax reporting and compliance. |
| TransactionBusinessCategory | String | The business category assigned to the inventory transaction for financial and operational reporting. This classification supports analytics and compliance tracking. |
| TrxBusinessCategory | String | The transaction-level business category used to classify the nature of the inventory movement. This category ensures accurate reporting for financial and tax purposes. |
| DocumentFiscalClassification | String | The fiscal classification assigned to the transaction document for tax compliance and financial reporting. This classification ensures adherence to fiscal policies. |
| DocumentSubType | String | The subtype of the document used in the transaction, ensuring accurate classification of financial and tax records. |
| UserDefinedFiscalClassification | String | A custom-defined fiscal classification applied to the inventory transaction. This classification allows businesses to tailor tax reporting according to internal policies. |
| UserDefinedFiscClass | String | The user-defined fiscal class assigned to the transaction, supporting customized tax reporting and compliance. |
| ProductFiscalClassification | String | The fiscal classification assigned to the product involved in the transaction, ensuring accurate tax and compliance reporting. |
| CategoryId | Long | The unique identifier for the category of the inventory item, supporting classification in reporting, tax calculations, and procurement analysis. |
| IntendedUse | String | The intended purpose of the consumed inventory (for example, 'Manufacturing', 'Resale', or 'Internal Use'). This classification supports accurate tax and financial reporting. |
| IntendedUseClassifId | Long | The unique identifier for the classification of the intended use, ensuring compliance with tax regulations and inventory policies. |
| LocationOfFinalDischarge | String | The final location where the consumed inventory will be used or disposed of. This location ensures accurate inventory and tax reporting. |
| ProductCategory | String | The category assigned to the inventory item in the consumption transaction. This category ensures proper classification for inventory control, procurement, and financial reporting. |
| ProductCategoryCode | String | The unique code assigned to the product category, ensuring consistency in classification across inventory, procurement, and financial systems. |
| TaxClassificationCode | String | The code used to classify the inventory transaction for tax purposes. This code ensures proper tax calculation and reporting. |
| TaxClassification | String | The tax classification assigned to the inventory transaction, ensuring compliance with financial and regulatory requirements. |
| ProductType | String | The type of product involved in the inventory transaction (for example, 'Raw Material', 'Finished Good', or 'Service'). This field supports inventory categorization and financial analysis. |
| ProductTypeCode | String | The unique code assigned to the product type, ensuring accurate classification in inventory, procurement, and financial reporting. |
| FirstPartyTaxRegistrationNumber | String | The tax registration number of the first party involved in the transaction, typically the business unit or legal entity responsible for the inventory. This number ensures compliance with tax regulations and financial reporting. |
| FirstPtyRegId | Long | The unique identifier for the tax registration of the first party involved in the transaction. This identifier ensures compliance with tax reporting and financial reconciliation. |
| ThirdPartyTaxRegistrationNumber | String | The tax registration number of the third party involved in the transaction, such as a supplier or external entity. This field supports tax compliance and audit tracking. |
| ThirdPtyRegId | Long | The unique identifier for the tax registration of the third party. This identifier ensures proper financial and tax reporting in compliance with jurisdictional regulations. |
| ShipFromSite | String | The name or identifier of the shipping site from which the inventory was dispatched. This identifier ensures accurate tracking of inventory movement and logistics management. |
| ShipFromLocationId | Long | The unique identifier for the location from which the inventory shipment originated. This identifier supports traceability in outbound logistics and financial reporting. |
| TaxInvoiceNumber | String | The invoice number associated with the tax calculation for this transaction. This invoice number ensures proper tax documentation and compliance with financial regulations. |
| TaxInvoiceDate | Date | The date of issuance for the tax invoice associated with the transaction. This date supports accurate tax reporting and reconciliation. |
| AssessableValue | Decimal | The value of the inventory transaction that is subject to taxation. This value ensures correct tax calculations and financial reporting. |
| Currency | String | The currency used for the inventory transaction, ensuring consistency in financial reporting across multi-currency transactions. |
| TaxExemptionCertificateNumber | String | The certificate number granting tax exemption for the transaction. This number ensures compliance with tax regulations for exempt transactions. |
| TaxExemptReasonCode | String | The reason code for the tax exemption applied to the transaction. This code supports regulatory compliance and financial reporting. |
| ExemptReasonCode | String | The exemption reason code associated with the tax-exempt status of the transaction. This code ensures proper documentation for tax compliance. |
| OperationNumber | String | The identifier for the specific operation within the manufacturing or business process where the inventory transaction occurred. This identifier supports traceability in production workflows. |
| OperationSequenceNumber | Long | The sequence number representing the order of the operation in the manufacturing or business process. This sequence number ensures proper tracking of work-in-process (WIP) transactions. |
| OperationSequenceNumberId | Long | The unique identifier for the operation sequence number, supporting structured tracking of production activities. |
| OperationTransaction | Long | The unique identifier for the transaction associated with an operation in the work-in-process (WIP) system. This identifier ensures seamless tracking of inventory consumption in production. |
| WIPSupplyType | String | The type of supply used in work-in-process (WIP) inventory transactions, such as 'Push' or 'Pull'. This supports production planning and material consumption tracking. |
| WIPSupplyTypeCode | Decimal | The system code representing the WIP supply type. This code ensures standardized classification of inventory movements in production workflows. |
| WorkCenter | String | The name of the work center where the transaction took place. This name ensures accurate tracking of production-related inventory consumption. |
| DepartmentCode | String | The department code associated with the inventory transaction, ensuring accurate cost allocation and reporting. |
| DepartmentId | Long | The unique identifier for the department responsible for the inventory transaction. This identifier ensures proper cost assignment in financial reporting. |
| AssemblySerialNumber | String | The serial number assigned to the assembly associated with the inventory transaction. This serial number ensures traceability of serialized items in production. |
| ElectronicSignature | Long | The unique identifier for the electronic signature used to authenticate the transaction. This identifier ensures compliance with audit and security policies. |
| Organization | String | The name of the organization responsible for the inventory transaction. This name ensures correct financial and operational tracking. |
| OrganizationName | String | The full name of the organization managing the inventory transaction, ensuring proper assignment of transactions to business entities. |
| OrganizationId | Long | The unique identifier for the organization managing the inventory transaction. This identifier supports accurate financial reporting and compliance tracking. |
| OwningPartyOrgName | String | The name of the owning party organization associated with the transaction. This name ensures accurate inventory ownership tracking and cost allocation. |
| OwningPartyLocation | String | The location of the owning party organization. This location ensures traceability of inventory ownership changes. |
| OwningPartyLocationId | Long | The unique identifier for the location of the owning party organization. This identifier ensures accurate financial reporting for inter-organizational transactions. |
| LotTransactionGroupName | String | The name of the lot transaction group, used to group multiple lot-controlled inventory transactions together for reporting and processing. |
| SourceLotFlag | Bool | A flag indicating whether the transaction involves source lot tracking. This flag ensures proper traceability of lot-controlled inventory movements. |
| TransactionSourceName | String | The name of the source document or system that generated the inventory transaction. This name ensures proper integration between inventory and financial systems. |
| TransactionSourceId | Long | The unique identifier for the source transaction, linking the inventory movement to its originating document. |
| ReasonId | Long | The unique identifier for the reason associated with the transaction (for example, 'Damage', 'Return', or 'Stock Adjustment'). |
| ConsErrorTypeCode | String | The error type code associated with the consumption transaction. This code helps identify and resolve transaction errors. |
| ConsErrorActionCode | String | The action code representing the corrective measures taken for a consumption transaction error. This code supports troubleshooting and audit tracking. |
| OwningOrganizationId | Long | The unique identifier for the organization owning the inventory involved in the transaction. This identifier ensures accurate financial reporting and compliance. |
| XfrOwningOrganizationId | Long | The unique identifier for the organization receiving ownership of the transferred inventory. This identifier ensures traceability in ownership changes. |
| StructureInstanceNumber | Long | The unique identifier for the structure instance associated with the transaction. This identifier ensures proper tracking of structured inventory movements. |
| CreationDate | Datetime | The date and time when the inventory transaction was created. This timestamp supports audit tracking and financial reconciliation. |
| CreatedBy | String | The user or system entity that created the inventory transaction. This field ensures accountability and security in transaction processing. |
| Category | String | The category assigned to the inventory transaction (for example, 'Raw Material' or 'Finished Goods'). This categorization ensures accurate classification in reporting and analysis. |
| Lot | String | The lot number associated with the inventory transaction, ensuring traceability for lot-controlled items in compliance and quality tracking. |
| SerialNumber | String | The unique serial number assigned to the inventory item in this transaction. This serial number ensures traceability for serialized inventory, supporting warranty tracking, recall management, and compliance. |
| SupplierLot | String | The lot number assigned by the supplier for the inventory item. This field provides end-to-end traceability from the supplier to the consumption transaction, ensuring quality control and compliance. |
| ExternalSystemPackingUnit | String | The packing unit identifier used in an external system for inventory management. This identifier ensures consistency in packing information across integrated platforms. |
| DistributionAccountId | Long | The unique identifier for the financial distribution account associated with this inventory consumption transaction. This identifier ensures accurate financial allocation and reconciliation. |
| FinalDischargeLocationId | Long | The unique identifier for the final discharge location where the consumed inventory is used or disposed of. This identifier ensures accurate reporting of stock movement and usage. |
| ProjectId | Decimal | The unique identifier for the project associated with the consumed inventory. This identifier ensures accurate cost allocation and tracking of inventory usage within project-based accounting. |
| TaskId | Decimal | The unique identifier for the specific task within the project linked to this inventory consumption transaction. This identifier ensures that costs are properly assigned at the task level for financial and audit tracking. |
| CountryOfOriginCode | String | A standardized country code representing the country of origin for the inventory item. This country code ensures compliance with trade regulations and accurate documentation for international shipments. |
| ProjectNumber | String | A user-friendly project number associated with the inventory consumption transaction. This project number provides an easily identifiable reference for financial tracking and project cost allocation. |
| TaskNumber | String | The user-friendly task number associated with the inventory consumption transaction. This task number ensures precise tracking of task-level inventory consumption in project-based workflows. |
| CountryOfOrigin | String | The full name of the country where the inventory item was manufactured or sourced. This name supports compliance with import/export regulations and supplier documentation requirements. |
| TransferProjectId | Long | The unique identifier for the project receiving the transferred inventory. This identifier ensures that project-related inventory transfers are accurately recorded and tracked. |
| TransferTaskId | Long | The unique identifier for the task receiving the transferred inventory within the project. This identifier ensures proper cost allocation and inventory tracking at the task level. |
| TransferProjectNumber | String | The project number associated with the inventory transfer transaction. This project number provides a user-friendly reference for tracking project-specific inventory movements. |
| TransferTaskNumber | String | The task number associated with the inventory transfer transaction. This task number ensures accurate tracking of transferred inventory at the task level for financial reconciliation. |
| RequesterId | Long | The unique identifier of the individual or entity requesting the inventory transaction. This identifier ensures proper authorization and traceability of inventory consumption. |
| RequesterName | String | The name of the individual or entity requesting the inventory transaction. This name supports accountability and facilitates reporting on inventory requests. |
| ExternalSystemTransactionReference | String | The reference number from an external system associated with this inventory transaction. This reference number ensures seamless integration and traceability across connected platforms. |
| MovementRequestLineId | Long | The unique identifier for the movement request line associated with this inventory consumption transaction. This identifier ensures traceability of inventory transfers and consumption requests. |
| LoadRequestId | Long | The unique identifier for the load request associated with this inventory transaction. This identifier supports logistics planning and stock movement tracking. |
| ConsumptionHeaderId | Long | The unique identifier for the consumption advice document associated with this transaction. This identifier ensures proper linkage between consumption transactions and financial records. |
| Finder | String | The lookup reference used to retrieve and manage inventory consumption advice transaction records. This reference enables efficient searching, reporting, and system queries. |