PurchaseOrderslines
Lists line-level details within a purchase order, specifying items, quantities, unit prices, and related buying terms.
Columns
| Name | Type | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the purchase order header, linking the purchase order lines to the associated purchase order header. |
| POLineId [KEY] | Long | The unique identifier for the purchase order line, used to track specific items or services within a purchase order. |
| POHeaderId | Long | The unique identifier for the purchase order header, used to group and associate the purchase order line with the overall order. |
| LineNumber | Decimal | The line number associated with the purchase order line, used for sorting and referencing specific items or services in the purchase order. |
| OrderNumber | String | The unique order number associated with the purchase order, used for tracking the order in procurement and fulfillment processes. |
| LineTypeId | Long | The unique identifier for the line type, indicating the category of items or services represented by the purchase order line. |
| LineType | String | The descriptive name of the line type, such as 'Goods,' 'Services,' or 'Maintenance,' indicating the nature of the item or service. |
| ItemId | Long | The unique identifier for the item associated with the purchase order line, ensuring accurate product identification and tracking. |
| Item | String | The name or code of the item associated with the purchase order line, used to identify the product or service ordered. |
| ConsignmentLineFlag | Bool | Indicates whether the purchase order line is for consignment goods, determining the payment structure based on goods consumption. |
| ItemRevision | String | The revision number or identifier for the item, used to track updates or changes to the item specification. |
| Description | String | A detailed description of the item or service on the purchase order line, providing context for the procurement. |
| SupplierItem | String | The identifier assigned by the supplier for the item, allowing for easy matching between the buyer's order and the supplier's catalog. |
| SupplierConfigurationId | String | The identifier for the configuration set by the supplier, used to specify customized or configurable items. |
| CategoryId | Long | The unique identifier for the category to which the item belongs, helping with classification for inventory and procurement. |
| CategoryCode | String | The code representing the purchasing category for the item, used for reporting and classification within procurement systems. |
| Category | String | The name of the purchasing category for the item, providing a more human-readable classification for procurement management. |
| StatusCode | String | The code representing the current status of the purchase order line, such as 'Open,' 'Completed,' or 'Cancelled.' |
| Status | String | The descriptive status of the purchase order line, indicating its current state in the procurement process. |
| UOMCode | String | The unit of measure code used for the item, ensuring consistent tracking of quantities ordered and received. |
| UOM | String | The abbreviation for the unit of measure for the item, ensuring consistency in how quantities are measured (for example, 'EA' for each, 'KG' for kilograms). |
| Quantity | Decimal | The quantity of the item ordered on the purchase order line, used for inventory tracking and order fulfillment. |
| BasePrice | Decimal | The base price of the item on the purchase order line, used for calculating the cost before any discounts or adjustments. |
| DiscountType | String | The type of discount applied to the purchase order line, such as 'Percentage' or 'Amount,' indicating how the discount is calculated. |
| Discount | Decimal | The value of the discount applied to the purchase order line, reducing the base price of the item. |
| DiscountReason | String | The reason for applying the discount, providing context for why the item received a discount (for example, 'Promotional' or 'Negotiated Price'). |
| Price | Decimal | The total price of the item on the purchase order line, including any discounts or adjustments applied to the base price. |
| NegotiatedFlag | Bool | Indicates whether the price on the purchase order line was negotiated between the buyer and the supplier. |
| CurrencyCode | String | The currency code used for the purchase order line, ensuring the correct currency is applied to the price and amounts. |
| Currency | String | The currency associated with the purchase order line, indicating the financial currency used for the transaction. |
| WorkOrderProduct | String | The identifier for the product or service linked to a work order, used in maintenance or project-based procurement. |
| NoteToSupplier | String | Any special instructions or notes provided to the supplier regarding the purchase order line, helping with the fulfillment process. |
| UNNumberId | Long | The unique identifier for the UN (United Nations) number associated with hazardous materials on the purchase order line. |
| UNNumber | String | The UN number assigned to hazardous materials, used for safety, shipping, and regulatory compliance. |
| UNNumberDescription | String | A description of the UN number, providing further details on the type and classification of hazardous material. |
| HazardClassCode | String | The code representing the hazard class of the material on the purchase order line, used for compliance and safety regulations. |
| HazardClassId | Long | The unique identifier for the hazard class of the material, ensuring proper classification for hazardous materials. |
| HazardClass | String | The descriptive name of the hazard class, such as 'Flammable,' 'Toxic,' or 'Corrosive,' used for regulatory and safety purposes. |
| Ordered | Decimal | The quantity of items ordered in the purchase order line, used for tracking order progress and fulfillment. |
| TotalTax | Decimal | The total amount of tax applied to the purchase order line, helping with financial reporting and compliance. |
| Total | Decimal | The total value of the purchase order line, including the cost of items and any applied tax or fees. |
| SourceAgreementId | Long | The unique identifier for the source agreement associated with the purchase order line, linking it to a negotiated contract or framework agreement. |
| SourceAgreementNumber | String | The number of the source agreement, providing a reference to the contract under which the items are being purchased. |
| SourceAgreementLineId | Long | The unique identifier for the line item within the source agreement, specifying the terms for that particular item. |
| SourceAgreementLine | Decimal | The line number or identifier within the source agreement, used to specify which agreement line corresponds to the purchase order line. |
| SourceAgreementTypeCode | String | The code representing the type of source agreement, such as 'Framework,' 'Spot Purchase,' or 'Contract.' |
| SourceAgreementType | String | The descriptive name of the source agreement type, clarifying whether the agreement is a contract, framework, or other type of agreement. |
| SourceAgreementProcurementBUId | Long | The unique identifier for the procurement business unit associated with the source agreement, ensuring alignment with the correct department. |
| SourceAgreementProcurementBU | String | The name of the procurement business unit associated with the source agreement, helping identify the responsible department. |
| MaximumRetainageAmount | Decimal | The maximum amount of retainage that can be withheld for the purchase order line, typically used in contracts requiring performance completion. |
| Manufacturer | String | The name of the manufacturer of the item, helping to identify the source of production and support traceability. |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer for the item, helping with identification and compatibility. |
| CreationDate | Datetime | The date and time when the purchase order line was created, providing a timestamp for record-keeping and process tracking. |
| CreatedBy | String | The user who created the purchase order line, ensuring accountability and traceability. |
| LastUpdateDate | Datetime | The date and time when the purchase order line was last updated, reflecting the most recent change or adjustment. |
| LastUpdatedBy | String | The user who last updated the purchase order line, ensuring proper documentation of modifications. |
| PricingUOM | String | The unit of measure for pricing, determining how the price of the item is calculated per unit. |
| PricingUOMCode | String | The code for the unit of measure used for pricing the item, ensuring clarity in financial calculations. |
| SecondaryUOM | String | The secondary unit of measure for the item, used when a different measurement unit is required for the item (for example, kilograms instead of pieces). |
| SecondaryUOMCode | String | The code for the secondary unit of measure, ensuring consistent tracking and conversion between measurement units. |
| SecondaryQuantity | String | The quantity of the item in the secondary unit of measure, used for reporting and conversion purposes. |
| NegotiationId | Long | The unique identifier for the negotiation associated with the purchase order line, linking it to the negotiation process. |
| Negotiation | String | The name or identifier of the negotiation associated with the purchase order line, providing context for pricing or contract terms. |
| NegotiationLine | Decimal | The line number associated with the negotiation, helping to identify specific terms or offers within the negotiation. |
| CreditFlag | Bool | Indicates whether the purchase order line is associated with a credit, such as returns or adjustments, affecting the financial records. |
| Finder | String | The search function or query used to locate or filter specific purchase order lines based on defined criteria. |
| Intent | String | The intent behind the purchase order line, clarifying whether the item is being purchased for immediate use, stock, or other specific purposes. |
| SysEffectiveDate | String | The system effective date used to determine the active version of the data, ensuring correct data retrieval based on the effective period. |
| EffectiveDate | Date | The date from which the purchase order line is valid, marking when the descriptive attributes of the purchase order line are in effect. |