InventoryConsumptionAdvicesconsumptionAdviceLines
Offers line-level information on items, organizations, and purchase orders within consumption advice records.
Columns
| Name | Type | Description |
| InventoryConsumptionAdvicesConsumptionHeaderId [KEY] | Long | A system-generated unique identifier linking this consumption advice line to its corresponding consumption advice header. This identifier ensures traceability of inventory consumption records at the document level. |
| InventoryConsumptionAdvicesRevision [KEY] | Long | The revision number of the associated consumption advice, indicating any modifications or updates to the original advice record. |
| ConsumptionLineId [KEY] | Long | The unique identifier for a specific line within the consumption advice document. This identifier is used for tracking individual consumption records for inventory reconciliation and supplier invoicing. |
| ConsumptionAdviceLine | Decimal | The line number associated with the consumption advice entry, providing a sequential reference for tracking consumed inventory items. |
| ConsumptionHeaderId | Long | The unique identifier for the consumption advice document. This identifier ensures linkage between individual consumption lines and the overall consumption record. |
| PurchaseAgreementLine | Decimal | The line number from the purchase agreement that corresponds to this consumption advice line, ensuring that consumption is properly aligned with contractual agreements. |
| PurchaseAgreementLineId | Long | The unique identifier for the purchase agreement line associated with the consumed inventory. This identifier ensures compliance with procurement contracts and supplier agreements. |
| ConsumedQuantity | Decimal | The total quantity of the inventory item consumed during the reporting period. This quantity is critical for tracking stock usage, supplier replenishment, and financial reporting. |
| ConsumedQuantityUOMCode | String | The unit of measure (UOM) code for the consumed quantity. This code ensures consistency in quantity tracking and conversion across different measurement standards. |
| ConsumedQuantityUnitOfMeasure | String | The full name of the UOM for the consumed inventory quantity, providing clarity in inventory reports and supplier communications. |
| InventoryItemId | Long | The unique identifier for the inventory item referenced in the consumption advice line. This identifier ensures proper linkage to the inventory master record for stock tracking and valuation. |
| ItemNumber | String | The item number associated with the consumed inventory. This number ensures traceability and accurate reconciliation of stock movements. |
| ItemDescription | String | The description of the inventory item consumed, providing a user-friendly reference for stock management and supplier reporting. |
| InventoryOrganizationId | Long | The unique identifier for the inventory organization responsible for the consumed stock. This identifier ensures accurate tracking of stock movements within multi-organization environments. |
| OrganizationName | String | The name of the organization managing the inventory consumption, ensuring proper assignment of transactions to business entities. |
| OrganizationCode | String | The unique code representing the inventory organization managing the consumption transaction. This code supports multi-organization financial reporting. |
| POHeaderId | Long | The unique identifier for the purchase order (PO) associated with the consumption advice line. This identifier ensures traceability between consumption and procurement records. |
| PONumber | String | The purchase order number linked to the consumption advice line, providing a reference for reconciling inventory consumption with supplier invoicing. |
| POLineId | Long | The unique identifier for the purchase order line associated with the consumed inventory. This identifier ensures accurate financial and contractual tracking. |
| POLineNumber | Decimal | The line number within the purchase order that corresponds to this consumption advice line, ensuring consistency between procurement and inventory records. |
| POScheduleId | Long | The unique identifier for the PO schedule associated with the inventory consumption advice. This identifier ensures proper tracking of scheduled stock deliveries. |
| POScheduleNumber | Decimal | The schedule number from the purchase order that aligns with the consumption advice, ensuring consistency between scheduled procurement and actual usage. |
| SecondaryConsumedQuantity | Decimal | The quantity of the inventory item consumed in an alternate UOM. This quantity is used when inventory items have multiple UOMs for tracking and reporting. |
| SecondaryQuantityUOMCode | String | The UOM code for the secondary consumed quantity, ensuring consistency in measurement standards across inventory transactions. |
| SecondaryQuantityUnitOfMeasure | String | The full name of the secondary UOM for the consumed inventory quantity, ensuring accurate stock conversion and reporting. |
| TransactionDate | Date | The date on which the inventory consumption transaction occurred. This date is critical for inventory reconciliation, supplier invoicing, and financial reporting. |
| TransactionTypeId | Long | The unique identifier for the type of transaction recorded in the consumption advice. This identifier ensures accurate classification of stock movements. |
| TransactionTypeName | String | The name of the transaction type associated with the consumption advice (for example, 'Consumption' or 'Return to Supplier'). This name ensures accurate classification of inventory usage. |
| ShipmentReceiptNumber | String | The receipt number of the shipment associated with the consumption advice line. This receipt number ensures traceability of received goods linked to consumption transactions. |
| ShipmentHeaderId | Long | The unique identifier for the shipment header associated with the consumption advice. This identifier provides a reference for inbound logistics tracking. |
| ReceiptLineNumber | Long | The line number within the receipt document that corresponds to the consumption advice, ensuring consistency between inventory receipts and usage records. |
| ShipmentLineId | Long | The unique identifier for the shipment line linked to the consumption advice. This identifier ensures accurate reconciliation of received goods with inventory consumption. |
| CurrencyCode | String | The currency code used for the unit price and extended price calculations. This code ensures accurate financial reporting across multi-currency transactions. |
| UnitPrice | Decimal | The price per unit of the consumed inventory item, ensuring proper financial valuation of stock consumption. |
| ExtendedPrice | Decimal | The total financial value of the consumed inventory item, calculated as the unit price multiplied by the consumed quantity. This field is essential for financial reporting and supplier invoicing. |
| RevisionNumber | Long | The revision number of the consumption advice line, indicating modifications or updates to the consumption record. |
| Finder | String | The lookup reference used to retrieve and manage inventory consumption advice lines. This reference facilitates efficient searching, reporting, and reconciliation of inventory usage. |
| Revision | Long | The version control identifier for the consumption advice line. This identifier ensures proper tracking of updates and modifications to the consumption record. |