PurchaseAgreementslines
Defines the line items (goods/services) under a purchase agreement, detailing negotiated prices and quantities.
Columns
| Name | Type | Description |
| PurchaseAgreementsAgreementHeaderId [KEY] | Long | The unique identifier for the purchase agreement header, linking all the purchase agreement lines to the overall agreement. |
| AgreementLineId [KEY] | Long | The unique identifier for the specific purchase agreement line, used to distinguish individual items or terms within the agreement. |
| LineNumber | Decimal | The line number within the purchase agreement, used to organize and reference individual items or services in the agreement. |
| AgreementHeaderId | Long | The unique identifier for the purchase agreement header, linking the agreement line to the overall purchase agreement. |
| AgreementNumber | String | The number assigned to the purchase agreement, uniquely identifying it within the sold-to legal entity, for easy reference and tracking. |
| ProcurementBUId | Long | The unique identifier for the business unit responsible for managing and owning the purchase agreement, ensuring proper handling and compliance. |
| ProcurementBU | String | The name of the business unit responsible for managing and overseeing the purchase agreement. |
| SupplierId | Long | The unique identifier for the supplier fulfilling the purchase agreement line, ensuring proper supplier identification and tracking. |
| Supplier | String | The name of the supplier who provides the goods or services specified in the purchase agreement line. |
| SupplierSiteId | Long | The unique identifier for the supplier site where goods or services are delivered, ensuring accuracy in shipping and logistics. |
| SupplierSite | String | The name or identifier of the supplier site where the goods or services will be delivered or fulfilled. |
| LineTypeId | Long | The unique identifier for the line type in the purchase agreement, used to categorize the line as either goods, services, or other types. |
| LineType | String | The type of line item in the purchase agreement (for example, goods, services, or labor), which classifies the nature of the procurement. |
| ItemId | Long | The unique identifier for the item specified in the purchase agreement line, allowing easy identification and tracking of the item. |
| Item | String | The abbreviated name or identifier for the item specified in the purchase agreement line. |
| ItemRevision | String | The revision number of the item, used to track and manage different versions or updates of the item. |
| Description | String | A detailed description of the item or service specified in the purchase agreement line, providing additional context and specifications. |
| SupplierItem | String | The unique item number assigned by the supplier, used to track the product or service as identified by the supplier. |
| CategoryId | Long | The unique identifier for the purchasing category associated with the item, used for classification and reporting purposes. |
| CategoryCode | String | The abbreviation for the category under which the item is classified, helping to organize procurement categories. |
| Category | String | The name or description of the purchasing category associated with the item in the agreement line. |
| StatusCode | String | The code representing the status of the agreement line, indicating whether the line is active, pending, or closed. |
| Status | String | The human-readable status of the agreement line, reflecting its current stage in the procurement lifecycle (for example, 'Active,' 'Closed'). |
| UOMCode | String | The unit of measure code used for the item in the agreement line, providing standardization for quantity measurement (for example, 'EA' for each, 'KG' for kilograms). |
| UOM | String | The unit of measure for the item on the purchase agreement line, indicating how quantities are measured (for example, 'each,' 'kg'). |
| Price | Decimal | The unit price for the item specified in the agreement line, representing the agreed cost per unit of the item or service. |
| Amount | Decimal | The total amount for the purchase agreement line, typically calculated as the price multiplied by the quantity of items ordered. |
| CurrencyCode | String | The currency code representing the currency used for the price and amount in the agreement line (for example, USD, EUR). |
| Currency | String | The name of the currency used for the price and amount in the agreement line, helping to clarify the financial terms (for example, 'US Dollar,' 'Euro'). |
| ConsignmentLineFlag | Bool | Indicates whether the agreement line involves consignment stock. 'True' means the line involves consignment, 'False' means it does not. |
| NoteToSupplier | String | A note to the supplier, providing additional instructions or clarifications related to the purchase agreement line. |
| AllowItemDescriptionUpdateFlag | Bool | Indicates whether the item description can be updated on the agreement line. 'True' means updates are allowed, 'False' means they are not. |
| PriceLimit | Decimal | The maximum price allowed for the item on the agreement line, ensuring that releases do not exceed the predefined limit. |
| AllowPriceOverrideFlag | Bool | Indicates whether the price for the item can be overridden during release or invoicing. 'True' allows overrides, 'False' prevents them. |
| NegotiatedFlag | Bool | Indicates whether the price for the agreement line has been negotiated with the supplier. 'True' means it was negotiated, 'False' means it was not. |
| ExpirationDate | Date | The date after which the agreement line expires and is no longer valid for placing orders or making releases against it. |
| MinimumReleaseAmount | Decimal | The minimum amount that can be released against a blanket or planned purchase order for the agreement line. |
| AgreementAmount | Decimal | The total amount agreed upon for the purchase agreement line, representing the monetary value agreed between the buyer and supplier. |
| AgreementQuantity | Decimal | The total quantity agreed upon for the item or service in the agreement line, specifying the amount to be procured. |
| ReleasedAmount | Decimal | The amount already released or invoiced against the agreement line, representing the sum of all approved purchase order amounts. |
| PriceBreakTypeCode | String | The code representing the pricing scheme applied to the agreement line for price breaks, such as volume discounts or tiered pricing. |
| SupplierItemAuxiliaryIdentifier | String | An additional identifier provided by the supplier for the item, used to reference specific details or versions of the item. |
| ParentItemId | Long | The unique identifier for the parent item, used for tracking items in bundles or configurations that are sold together. |
| SupplierParentItem | String | The supplier's identifier for the parent item associated with the current item in the purchase agreement line. |
| TopModelId | Long | The unique identifier for the top model associated with the item or product, often used in product families or configurations. |
| SupplierTopModel | String | The supplier's identifier for the top model associated with the item, used to track and reference the model for complex items or configurations. |
| UnNumberId | Long | The unique identifier for the UN number, used to identify hazardous materials as per United Nations regulations. |
| UnNumber | String | The UN number associated with hazardous materials, used to ensure proper handling and transportation of hazardous items. |
| UNNumberDescription | String | The description of the UN number, providing additional details about the hazardous material classification. |
| HazardClassId | Long | The unique identifier for the hazard class of the item, used to classify items based on their level of risk. |
| HazardClassCode | String | The code for the hazard class, representing the level of danger posed by the item, such as 'flammable' or 'corrosive'. |
| HazardClass | String | The name or description of the hazard class, providing context for handling and transport safety. |
| AgingPeriodDays | Int | The maximum number of days the consigned material can remain in inventory before it is considered aged and must be returned or disposed of. |
| CreatedBy | String | The name of the user or system that created the purchase agreement line, providing accountability for the data entry. |
| CreationDate | Datetime | The date and time when the purchase agreement line was created, providing historical context for tracking and auditing. |
| LastUpdatedBy | String | The name of the user or system that last updated the purchase agreement line, ensuring accountability for any changes made. |
| LastUpdateDate | Datetime | The date and time when the purchase agreement line was last updated, ensuring that the most recent changes are available for reference. |
| Finder | String | The search function used to retrieve specific purchase agreement lines based on criteria such as status, supplier, or item. |
| EffectiveDate | Date | The date used to retrieve purchase agreement lines that are effective as of this specified date, ensuring accurate data retrieval based on the agreement's active period. |