Price List

This file contains three types of records: price lists, contracts, and promotions. The difference between the records is how they are accessed. The following shows the access methods for each: Price List Contract Promotion Company Yes Yes Yes Customer No Yes No Price List Name Yes Yes, Contract ID Yes Promotion Name No No Yes

REFERENCED BY

AR08.1

AR10.1

AR501

AR550

UPDATED BY

WH20.2

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OPL-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
OPL-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.
OPL-LIST-NAME Element: List Name	Alpha 14 User-defined name assigned to a price list.
OPL-PROMOTION Element: Promotion	Alpha 10 User-defined name assigned to a promotion that is associated with this price list.
OPL-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description of the price list.
OPL-BASE-NAME Element: Base Name	Alpha 10 User-defined name of the price base that this price list modifies. Price bases are defined on BL40.1 (Price Base).
OPL-BEG-DATE Element: Beg Date	Numeric 8 (yyyymmdd) The beginning effective date for the promotion or contract.
OPL-END-DATE Element: End Date	Numeric 8 (yyyymmdd) The ending effective date for the promotion or contract.
OPL-MISC Element: Misc	Alpha 16 You can add an add-on charge to the price list that will always be assessed when the price list is used.
OPL-PCT Element: Pct	Percent 5.2 (Percent) This default percentage (enter 90% as 90.0) will be multiplied by the base price specified for an item to arrive at an item's price. Price list percentages, assigned to sales classes or individual items will override the default pricing percentage entered here.
OPL-DISC-CODE Element: Discount Code	Alpha 10 A discount code, entered using BL44.1 (Discount Code), can optionally be assigned at this level. If this has been done, the entered discount will automatically be applied when calculating the item price for items using this price list. Note: If price lists have been assigned to sales classes or to individual items, the discount (if any) assigned at these levels will be used instead.
OPL-CONTRACT-DATE Element: Contract Date	Numeric 8 (yyyymmdd) Enter the date indicating when the contract was added to the system.
OPL-CONTACT Element: Contact	Alpha 20 The name of the customer that can be contacted regarding this contract.
OPL-PHONE Element: Phone	Alpha 15 Customer contact phone number.
OPL-PREV-CONTRACT Element: List Name	Alpha 14 A previous number used to reference the last contract can be entered in this field.
OPL-CURRENCY-CODE Element: Currency Code	Alpha 5 The currency this price list is meant to use. If blank, orders in any currency can be priced via this price list.
OPL-CURR-RATE Element: Curr Rate	Signed 14.7 The currency rate that is in effect for this contract. If blank, the system will use the rate tied to the currency code in the currency tables at the time of invoicing.
OPL-CUST-REFERENC Element: Contact	Alpha 20 A customer reference number, or any information that the user wants to carry on the contract. Purely informational.
OPL-MIN-CONT-AMT Element: Intl Amt	Signed 18.2 Enter a minimum contract amount for the contract. This minimum will print on a report that lists the actual contract sales.
OPL-MAX-CONT-AMT Element: Intl Amt	Signed 18.2 A maximum contract amount can be specified for the contract in this field. This maximum will print on OE293 (Contract Status Report), a report that lists the actual contract sales.
OPL-ORD-DISC-FL Element: Ord Disc Fl	Alpha 1 This order discount flag is used only by contracts and promotions. If this flag is set to No, this indicates that any line priced with this promotion or contract will not be included in the order total when calculating the order-level discount. N = No Y = Yes
OPL-MIN-ORD-AMT Element: Intl Amt	Signed 18.2 This is a minimum contract amount that can be specified for the contract in this field. This minimum will print on OE293 (Contract Status Report), a report that lists the actual contract sales. This is informational only.
OPL-MAX-ORD-AMT Element: Intl Amt	Signed 18.2 A maximum contract amount can be specified for a contract only in this field. This maximum will print on OE293 (Contract Status Report), a report that lists the actual contract sales.
OPL-SC-COUNT Element: Sc Count	Numeric 4 This field indicates the number of price list sales class price modifiers that have been established under this price list.
OPL-ITEM-COUNT Element: Item Count	Numeric 6 This field indicates the number of price list item modifiers that have been established under this price list.

OEPRCLIST FILE INDEX

OEPRCLIST FILE RELATIONS

ONE TO ONE RELATIONS

OEPRCLIST FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.