Price Book Lines (tdpcg0131m000)
Use this session to view, enter, and maintain price book lines.
You can also enter and maintain price books if this session is started from the following sessions:
- Sales Contract Lines (tdsls3501m000)
- Sales Contract Prices (tdsls3103m000)
- Purchase Contract Prices (tdpur3103m000)
- RFQ Responses (tdpur1506m000)
This session appears as a tab in the Price Book (tdpcg0611m000) session.
Field Information
- Price Book
- Type
-
Displays whether the price book is a sales price book or a purchase price book.
Default value
This field is defaulted from the Type field in the Price Books (tdpcg0111m000) session.
- Line
-
The price book line number.
Note:- The value in this field cannot be modified.
- This value is used as reference to generate retro-billing advice and to store the relation between the price book line and the Using Documents.
- The price book line number for existing records will be populated only if the Pricing parameter Log Using Documents check box is selected.
- Item
-
The item for which the price book line is created.
- Manufacturer Part Number
-
The manufacturer part number (MPN) linked to the price book line. You can maintain the price for a combination of the MPN and the manufacturer. You can specify an MPN that is linked to the specified Item, in the Manufacturer Part Numbers (tdipu0145m000) session.
Note:- This field is displayed only if the Pricing by MPN check box is selected in the Procurement Parameters (tdpur0100m000) session.
- This field is enabled only if:
- The Type of the related Price Book is set to a value other than Sales in the Price Books (tdpcg0111m000) session.
- The Item is specified and Multiple Manufacturer Item Check check box is selected for this item in the Items - Purchase (tdipu0101m000) session.
- Description
-
The description or name of the code.
- Manufacturer
-
The code of the manufacturer linked to the price book line. You can maintain the price for a combination of the MPN and the manufacturer.
Note:- This field is displayed only if the Pricing by MPN check box is selected in the Procurement Parameters (tdpur0100m000) session.
- This field is enabled and you must specify the value if:
- The Type of the related Price Book is set to a value other than Sales in the Price Books (tdpcg0111m000) session.
- The Manufacturer Part Number is specified.
- Description
-
The description or name of the code.
- Price Type
-
The price type for which the purchase price book line is applicable.
Allowed values
The price book line can include prices for the following types (purchase scenarios):
-
Buying
Used for all nonsubcontracting purchasing scenarios -
Item Subcontracting
Used for item subcontracting -
Operation Subcontracting
Used for operation subcontracting -
Service Subcontracting
Used for service subcontracting
Default value
Buying
Note: If the Type field is Sales, this Price Type field is set to Not Applicable. -
- Effective Date
-
The date and time from which the price book is valid.
Default value
If this session is started and the price book is entered from the:
-
Sales Contract Lines (tdsls3501m000) session
The effective date is defaulted from the Effective Date in the Sales Contract Lines (tdsls3501m000) session. -
Sales Contract Prices (tdsls3103m000)
The effective date is defaulted from the Effective Date in the Sales Contract Prices (tdsls3103m000) session. -
Purchase Contract Prices (tdpur3103m000) session
The effective date is defaulted from the Effective Date in the Purchase Contract Prices (tdpur3103m000) session. -
RFQ Responses (tdpur1506m000) session
The effective date is defaulted from the Receipt Period in the RFQ Responses (tdpur1506m000) session.
-
- Expiry Date
-
The expiry date and time of the current price book. If this field is not filled, the price book is infinitely valid.
Default value
If this session is started and the price book is entered from the:
-
Sales Contract Lines (tdsls3501m000) session
The expiry date is defaulted from the Expiry Date in the Sales Contract Lines (tdsls3501m000) session. -
Sales Contract Prices (tdsls3103m000)
The expiry date is defaulted from the Expiry Date in the Sales Contract Lines (tdsls3501m000) session. -
Purchase Contract Prices (tdpur3103m000) session
The expiry date is defaulted from the Expiry Date in the Purchase Contract Lines (tdpur3101m000) session. -
RFQ Responses (tdpur1506m000) session
The expiry date is defaulted from the Receipt Period End Date in the RFQ Responses (tdpur1506m000) session.
-
- Entry Date
-
The entry date of the current price book line.
- Reference
- Source
-
The LN component in which the price is created, or the means by which the price is created.
This field can have the following values:
-
Manual
The price is manually specified. -
Item data
The price is imported from item data with the Import Prices from Item Data to Price Book (tdpcg0231m200) session. -
RFQ
The price is copied from an RFQ with the Convert RFQs (tdpur1202m000) session. The number, position number and sequence number are displayed. -
Price book
The price is copied from a price book with the Copy Price Book (tdpcg0231m100) session. The price book identification is displayed.
-
- Used for Quotations
-
If this check box is selected, the price book line is allocated to quotations.
- Break Type
-
Allowed values
- Minimum
-
Select this break type if pricing and discount agreements in your company are based on a minimum order quantity or amount, or if freight rates are based on minimum distances.
- Up To
-
Select this break type if pricing and discount agreements in your company are based on a maximum order quantity or amount, or if freight rates are based on maximum distances.
- Break Quantity/Value
-
The minimum or maximum order quantity or value, in inventory units, to which the price book applies.
- Quantity Unit
-
The unit in which the item's quantity is expressed.
- Price / Percentage
-
Define, for a cost or service item, whether you can enter a price or a percentage.
The Additional Cost Type field in the Sales Additional Cost Set Lines (tdsls0528m000) session determines whether a price or a percentage must be retrieved from the price book.
Note: This field is disabled if the Used for Contracts check box or the Used for RFQs check box is selected for the price book header in the Price Books (tdpcg0111m000) session. - Price
-
The item's price.
Note: If the Material Pricing in Procurement and/or the Material Pricing in Sales check box is selected in the Material Price Parameters (tcmpr0100m000) session, this price can include material base prices. - Currency
-
The price book currency is the currency in which the base price is stored.
- Price Unit
-
The price unit in which the price is stored.
- Base Price
-
If this check box is selected, the default sales or purchase price book from the Pricing Parameters (tdpcg0100m000) session is used to store the item's prices and discounts.
Note: When you enter a record in the Items - Purchase (tdipu0101m000) session or the Items - Sales (tdisa0501m000) session, and the Update Default Price Book or Update Supplier Price Book check boxes are selected in the Pricing Parameters (tdpcg0100m000) session, LN automatically inserts a line in this session with the Base Price check box selected. - Material Price
-
The total material base price for the item on the price book line.
Note: This field is visible only if the Material Pricing in Procurement and/or the Material Pricing in Sales check box is selected in the Material Price Parameters (tcmpr0100m000) session. - Price Stage
-
- Update Order Lines with Price Unit from Price Book
-
If this check box is selected, and an order line is entered, the price unit on the order line is similar to the price book's Price Unit.
If this check box is cleared, and an order line is entered, the price unit on the order line is similar to the price unit in, for example, Item Purchase Data or Item Sales Data . As a result, the price on the order line is converted to a price for the price unit in Item Purchase Data or Item Sales Data .
Example:
Origin Price Unit Price Book box Item Sales/Purchase Data pieces If the Update Order Lines with Price Unit from Price Book is selected, the price unit on the order line is boxes. If the Update Order Lines with Price Unit from Price Book is cleared, the price unit on the order line is converted to pieces.
Note: This field is disabled if the Used for Contracts check box or the Used for RFQs check box is selected for the price book header in the Price Books (tdpcg0111m000) session. - Percentage
-
The additional cost item's percentage, based on which an additional cost amount is calculated.
The additional cost amount is calculated as follows:
Shipment based costs Order based costs Shipment dependent costs Item dependent costs - percentage* total net amount of a shipment's shipment lines percentage * net amount of a specific shipment line percentage* total net amount of an order's order lines Note: A percentage is only retrieved from a price book if the Additional Cost Type field is set to Percentage in the Sales Additional Cost Set Lines (tdsls0528m000) session. - Discount Schedule
-
Note: This field is disabled if the Used for Contracts check box or the Used for RFQs check box is selected for the price book header in the Price Books (tdpcg0111m000) session.
- Buy-from Business Partner
-
Note: You can only define the Buy-from Business Partner if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session.
- Ship-from Business Partner
-
Note: You can only define the Ship-from Business Partner if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session.
- High Priority
-
If this check box is selected, the price of the buy-from business partner/ship-from business partner/item combination has priority over the prices stored under the normal matrix priority structure.
If this check box is cleared, the price of the buy-from business partner/ship-from business partner/item combination is subordinate to the prices stored under the normal matrix priority structure.
Note: You can only maintain the High Priority check box if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session.As a result, the search sequence for pricing information is as follows:
- From valid special contracts.
- From valid normal contracts.
- From the supplier price book, for combinations that have the High Priority check box selected in the Price Book Lines (tdpcg0131m000) session. This search step is only applicable when retrieving purchase prices, not sales prices.
- From valid price matrices, selected from the price matrices for which a matrix priority is defined. If more than one valid price matrix exists, price retrieval is controlled by the Price Control (Sales) or Price Control (Purchase) fields in the Pricing Parameters (tdpcg0100m000) session.
- For sales prices, from the Default Sales Price Book. For purchase prices, from the Supplier Price Book for combinations that have the High Priority check box cleared in the Price Book Lines (tdpcg0131m000) session.
- From Item Sales Data , or from Item Purchase Data .
Performance aspects
The setting of this field could affect system performance and database growth. For more information, refer to High priority supplier price book.
- Picture
-
The item's picture, which is defaulted from the Picture field in the Items (tcibd0501m000) session.