ShoppingCatalogItemDetailsagreementLinePriceBreaks
Agreement price breaks are reductions in the price of an item based on certain conditions, such as purchasing in bulk or ordering from a specific location.
Columns
| Name | Type | Description |
| ShoppingCatalogItemDetailsSearchObjectId [KEY] | Long | Value that uniquely identifies the search object referenced by the catalog item. |
| 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. |
| Finder | String | Finder criteria used to filter shopping catalog item details agreement line price breaks based on specific search parameters and conditions. |
| GuidedBuyingEnabledFlag | String | A finder used to filter data using Finder column. Contains one of the following values: true or false. If true, then it returns the master item document for an item that's on a blanket purchase agreement. If false, then it doesn't return the master item document for an item that's on blanket purchase agreement. This is used for the feature Procure Goods from Preferred Sources During Catalog Shopping. |
| IgnoreAgreementFlag | String | A finder used to filter data using Finder column. Contains one of the following values: Y or N. If Y, then the application ignores the agreement on the requisition line and retrieves the master item information in the destination organization from Oracle Product Information Management. If N, then it returns the information from the agreement line present on the requisition line. |
| RequisitionLineId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the requisition line for which the information is queried. |
| SearchObjectId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the search object referenced by the catalog item. |
| UserPreferenceId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the user preference referenced by the catalog item. |