PurchaseAgreementLines
Describes goods or services in a purchase agreement, excluding delivery or fulfillment specifics, to outline negotiated items.
Columns
| Name | Type | Description |
| AgreementLineId [KEY] | Long | The unique identifier for the agreement line within the purchase agreement, linking it to specific terms and conditions. |
| LineNumber | Decimal | The unique line number within the purchase agreement, used to track and organize line items for the agreement. |
| AgreementHeaderId | Long | The unique identifier for the purchase agreement header, linking all lines to the overall agreement. |
| AgreementNumber | String | The unique identifier (number) for the purchase agreement, used for reference and tracking across systems. |
| ProcurementBUId | Long | The unique identifier for the procurement business unit responsible for the purchase agreement, linking it to the managing business unit. |
| ProcurementBU | String | The name of the procurement business unit that owns and manages the purchase agreement. |
| SupplierId | Long | The unique identifier for the supplier associated with the purchase agreement line, allowing easy identification of the supplying company. |
| Supplier | String | The name of the supplier providing the goods or services on the purchase agreement. |
| SupplierSiteId | Long | The unique identifier for the supplier site from where the goods or services are fulfilled, ensuring accurate delivery and inventory management. |
| SupplierSite | String | The name or identifier of the location where the supplier fulfills the purchase agreement. |
| LineTypeId | Long | The unique identifier for the line type in the purchase agreement, distinguishing between product, service, or other item categories. |
| LineType | String | The type of line item in the purchase agreement, such as goods, services, or labor, used to classify the line. |
| ItemId | Long | The unique identifier for the item being purchased in the agreement line, linking it to inventory and catalog data. |
| Item | String | The name or code of the item being purchased on the agreement line, often used for identification and ordering. |
| ItemRevision | String | The revision or version number of the item, used to track changes or updates to the product being purchased. |
| Description | String | A description of the purchase agreement line item, providing additional context about the item or service being procured. |
| SupplierItem | String | The unique item identifier assigned by the supplier to the product being purchased, used for tracking and cataloging. |
| CategoryId | Long | The unique identifier for the category to which the item belongs, helping with item organization and reporting. |
| CategoryCode | String | The code for the category under which the item is classified, aiding in cataloging and reporting within the purchasing system. |
| Category | String | The name of the category for the item, helping to group similar items together in the procurement system. |
| StatusCode | String | The status code for the purchase agreement line, indicating its current status (for example, active, pending, or canceled). |
| Status | String | The human-readable status of the purchase agreement line, such as 'Active,' 'Closed,' or 'Pending,' providing clarity on the agreement line's lifecycle. |
| UOMCode | String | The unit of measure code for the item on the purchase agreement line, defining the measurement unit (for example, 'EA' for each, 'KG' for kilogram). |
| UOM | String | The unit of measure for the item on the purchase agreement line, indicating how the item is measured (for example, 'each,' 'box,' 'kilogram'). |
| Price | Decimal | The unit price for the item or service on the purchase agreement line, representing the agreed cost per unit. |
| Amount | Decimal | The total amount for the purchase agreement line, typically calculated as price times quantity. |
| CurrencyCode | String | The currency code for the purchase agreement line, representing the currency in which the price is stated (for example, USD, EUR). |
| Currency | String | The name of the currency for the purchase agreement line, providing clarity on the pricing currency. |
| ConsignmentLineFlag | Bool | Indicates whether the agreement line involves consignment. 'True' means the line is for consignment, 'False' means it is not. |
| NoteToSupplier | String | A note to the supplier, providing additional instructions or information related to the purchase agreement line. |
| AllowItemDescriptionUpdateFlag | Bool | Indicates whether item descriptions can be updated on the agreement line. 'True' allows updates, 'False' prevents them. |
| PriceLimit | Decimal | The maximum price allowed for the agreement line, ensuring that purchases do not exceed the agreed limit. |
| AllowPriceOverrideFlag | Bool | Indicates whether the price for the agreement line can be overridden. 'True' allows overrides, 'False' does not. |
| 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 purchase agreement line is no longer valid, marking its expiration. |
| 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 agreement line, representing the full cost or value of the line item. |
| AgreementQuantity | Decimal | The total quantity agreed upon for the item or service on the agreement line, specifying how many units are to be purchased. |
| ReleasedAmount | Decimal | The total amount released or invoiced against the agreement line, representing how much has been fulfilled or billed. |
| PriceBreakTypeCode | String | The code representing the type of price break applied to the agreement line, specifying how price reductions are structured. |
| SupplierItemAuxiliaryIdentifier | String | An additional identifier used by the supplier for the item, often representing a subpart or additional categorization. |
| ParentItemId | Long | The unique identifier for the parent item or product that the current line item is part of, often used for bundled or configurable items. |
| SupplierParentItem | String | The supplier’s identifier for the parent item or product associated with the current line item. |
| TopModelId | Long | The unique identifier for the top model of the item, typically used in product families or configurable items to group related products. |
| SupplierTopModel | String | The supplier’s identifier for the top model associated with the item on the purchase agreement line. |
| UnNumberId | Long | The unique identifier for the UN number (hazard classification) of the item, providing a standardized identifier for hazardous materials. |
| UnNumber | String | The UN number for the item, used for identifying hazardous materials during shipping and handling. |
| UNNumberDescription | String | A description of the UN number, providing more context on the classification of hazardous materials. |
| HazardClassId | Long | The unique identifier for the hazard class of the item, indicating its potential risks and classification for safety and shipping purposes. |
| HazardClassCode | String | The code representing the hazard class for the item, used to categorize the material for transportation and safety requirements. |
| HazardClass | String | The name or description of the hazard class for the item, providing details on the item's potential risks and necessary precautions. |
| AgingPeriodDays | Int | The maximum number of days the material may be stored or consigned before it is considered aged and requires action. |
| CreatedBy | String | The name of the person or system that created the purchase agreement line, helping to trace the origin of the agreement. |
| CreationDate | Datetime | The date and time when the purchase agreement line was created, used for historical tracking and auditing purposes. |
| LastUpdatedBy | String | The name of the person or system that last updated the purchase agreement line, providing accountability for changes. |
| LastUpdateDate | Datetime | The date and time when the purchase agreement line was last updated, ensuring that the most recent data is available. |
| Finder | String | The search function or query mechanism used to locate specific purchase agreement lines based on criteria like supplier, item, or status. |