PurchaseAgreementslinespriceBreaks
Captures location- or quantity-based price adjustments for agreement lines, ensuring appropriate pricing for each scenario.
Columns
| Name | Type | Description |
| PurchaseAgreementsAgreementHeaderId [KEY] | Long | The unique identifier for the purchase agreement header, linking all price breaks and related information to the overall agreement. |
| LinesAgreementLineId [KEY] | Long | The unique identifier for the specific agreement line, used to distinguish individual items or terms within the purchase agreement related to price breaks. |
| PriceBreakId [KEY] | Long | The unique identifier for the price break record, allowing it to be differentiated and managed separately in the context of the agreement line. |
| PriceBreakNumber | Decimal | The number assigned to the price break on the agreement line, used to reference specific discounts or price reductions available under the agreement. |
| LineNumber | Decimal | The line number within the purchase agreement associated with the price break, used to track and organize price breaks on individual lines. |
| ShipToOrganizationId | Long | The unique identifier for the ship-to organization, ensuring that the price break is applied to the correct receiving organization for the goods. |
| ShipToOrganizationCode | String | The abbreviation identifying the ship-to organization, helping to manage multiple receiving organizations within a larger procurement framework. |
| ShipToOrganization | String | The name of the inventory organization that receives the goods or services, providing context for where the price break applies. |
| LocationId | Long | The unique identifier for the location where the goods or services covered by the price break will be shipped, helping with logistics and shipping management. |
| LocationCode | String | The abbreviation identifying the location where the supplier ships the items, allowing for efficient routing and inventory management. |
| Location | String | The name of the location where the supplier ships the goods, helping clarify the shipping destination and ensuring accurate delivery. |
| Quantity | Decimal | The minimum quantity of items required to trigger the price break, helping to manage discounts based on volume or bulk purchasing. |
| UOMCode | String | The unit of measure code for the price break, indicating how the quantity is measured (for example, 'EA' for each, 'KG' for kilogram). |
| UOM | String | The unit of measure for the price break, specifying how the quantity of items is quantified (for example, 'each,' 'kg,' 'box'). |
| Price | Decimal | The unit price for the item after applying the price break, representing the discounted price that will be charged per unit. |
| DiscountPercent | Decimal | The percentage discount applied to the original price of the item for the agreement line, reflecting the savings gained through the price break. |
| StartDate | Date | The date when the price break becomes effective, indicating the start date from which the discount will apply to the purchase agreement line. |
| EndDate | Date | The date after which the price break expires, indicating the end date for when the discount will no longer be available for purchase orders. |
| CurrencyCode | String | The currency code used to express the price and discount for the price break, ensuring that the financial terms are clear and standardized (for example, USD, EUR). |
| Currency | String | The name of the currency used for the price break, helping to clarify the financial terms (for example, 'US Dollar,' 'Euro'). |
| CreatedBy | String | The name of the person or system that created the price break record, ensuring accountability for the entry. |
| CreationDate | Datetime | The date and time when the price break record was created, providing a historical record of when the price break became active. |
| LastUpdatedBy | String | The name of the person or system that last updated the price break record, ensuring accountability for changes made. |
| LastUpdateDate | Datetime | The date and time when the price break record was last updated, providing a clear record of recent modifications. |
| AgreementHeaderId | Long | The unique identifier for the purchase agreement header, linking the price break to the specific purchase agreement. |
| Finder | String | The search function or query used to locate or filter price break records, helping to retrieve specific price break details based on defined criteria. |
| EffectiveDate | Date | The date used to retrieve price break records that are effective as of this date, ensuring that the correct version of the price break is applied based on the agreement's active period. |