PurchaseOrderslines
Lists line-level details within a purchase order, specifying items, quantities, unit prices, and related buying terms.
Columns
| Name | Type | SupportedFinders | 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 | PrimaryKey, findByIntent | 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 | FindByIntent | The intent behind the purchase order line, clarifying whether the item is being purchased for immediate use, stock, or other specific purposes. |
| SysEffectiveDate | String | FindByIntent | 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. |