PurchaseAgreementslinespriceBreaks
Agreement price breaks are reductions in the price of an item depending on certain conditions such as purchasing in bulk or from a certain location. For example, for a laptop, price will be reduced by 100 dollars if your order exceeds 20 quantity or 30 dollars if you order for a specific location.
Columns
Name | Type | Description |
PurchaseAgreementsAgreementHeaderId [KEY] | Long | Value that uniquely identifies the purchase agreement. |
LinesAgreementLineId [KEY] | Long | Value that uniquely identifies the agreement line. |
PriceBreakId [KEY] | Long | Value that uniquely identifies the price break referenced by this line. |
PriceBreakNumber | Decimal | Number that uniquely identifies the price break on the purchase agreement line. |
LineNumber | Decimal | Value that uniquely identifies the purchase order or agreement line. |
ShipToOrganizationId | Long | Value that uniquely identifies the ship-to organization. |
ShipToOrganizationCode | String | Abbreviation that identifies the ship-to organization. |
ShipToOrganization | String | Name of the inventory organization that receives the item. |
LocationId | Long | Value that uniquely identifies the location where the supplier ships the shipment item. |
LocationCode | String | Abbreviation that identifies the location where the supplier ships the item. |
Location | String | Name of the location where the supplier ships the item. |
Quantity | Decimal | Value that identifies the price break quantity, when the price break is effective for blanket purchase orders. |
UOMCode | String | Code that identifies the unit of measure. |
UOM | String | Abbreviation that identifies the unit of measure on the agreement line price break. |
Price | Decimal | Unit price for the line. |
DiscountPercent | Decimal | Value that identifies the discount percentage for the price break. |
StartDate | Date | Date on which the agreement becomes effective. |
EndDate | Date | Date after which the purchase agreement is no longer valid. |
CurrencyCode | String | Code that identifies the currency on the agreement line price break. |
Currency | String | Currency on the agreement line price break. |
CreatedBy | String | User who created the price breaks for a purchase agreement line. |
CreationDate | Datetime | Date and time when the buyer or application created the price breaks for a purchase agreement line. |
LastUpdatedBy | String | User who last updated the price breaks on a purchase agreement line. |
LastUpdateDate | Datetime | Date when the price break was last updated. |
AgreementHeaderId | Long | agreementheaderid |
Finder | String | finder |
EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. |