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
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OPLSET1 |
COMPANY CUSTOMER LIST-NAME PROMOTION |
|
| ||||||||||||||||||||
OPLSET2 |
COMPANY LIST-NAME PROMOTION |
|
|||||||||||||||||||||
OPLSET4 |
COMPANY CUSTOMER LIST-NAME |
|
|||||||||||||||||||||
OPLSET5 |
COMPANY CUSTOMER END-DATE |
|
| ||||||||||||||||||||
OPLSET6 |
COMPANY LIST-NAME END-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| ||||||||||||||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||||||||||||||
Cucodes | CUCODES |
Required
| ||||||||||||||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||||||||||||||
Oediscount | OEDISCOUNT |
Required
| ||||||||||||||||||||||||
Oemisc | OEMISC |
Required
| ||||||||||||||||||||||||
Oeprclist | OEPRCLIST |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cont Classes | OEPLCLASS |
| ||||||||||||||||||||||||||||||
Cont Items | OEPLITEM |
| ||||||||||||||||||||||||||||||
List Classes | OEPLCLASS |
| ||||||||||||||||||||||||||||||
List Items | OEPLITEM |
| ||||||||||||||||||||||||||||||
Oeplclass | OEPLCLASS |
Delete Cascades
| ||||||||||||||||||||||||||||||
Oeplitem | OEPLITEM |
Delete Cascades
| ||||||||||||||||||||||||||||||
Promo Classes | OEPLCLASS |
| ||||||||||||||||||||||||||||||
Promo Items | OEPLITEM |
|
All trademarks and registered trademarks are the property of their
respective owners.