OEPRCLIST

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPLSET1 COMPANY
CUSTOMER
LIST-NAME
PROMOTION
WH20.2 WH20.7
OPLSET2 COMPANY
LIST-NAME
PROMOTION
Subset
WherePROMOTION !=Spaces
OPLSET4 COMPANY
CUSTOMER
LIST-NAME
Subset
WherePROMOTION =Spaces
AR08.1 AR10.1
AR501 AR550
OPLSET5 COMPANY
CUSTOMER
END-DATE
KeyChange, Subset
WhereCUSTOMER >Spaces
AndPCT >Zeroes
WH20.2 WH20.7
OPLSET6 COMPANY
LIST-NAME
END-DATE
KeyChange, Subset
WherePROMOTION >Spaces
AndPCT >Zeroes
WH20.2 WH20.7


OEPRCLIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OPL-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
When OPL-CUSTOMER >Spaces
OPL-COMPANY->ACM-COMPANY
OPL-CUSTOMER->ACM-CUSTOMER
Cucodes CUCODES Required
When OPL-CURRENCY-CODE !=Spaces
OPL-CURRENCY-CODE->CUC-CURRENCY-CODE
Custdesc CUSTDESC Required
When OPL-CUSTOMER >Spaces
ACO-CUST-GROUP->CUD-CUST-GROUP
OPL-CUSTOMER->CUD-CUSTOMER
Oecompany OECOMPANY Required
OPL-COMPANY->OEC-COMPANY
Oediscount OEDISCOUNT Required
When OPL-DISC-CODE !=Spaces
OPL-COMPANY->OED-COMPANY
OPL-DISC-CODE->OED-DISC-CODE
Oemisc OEMISC Required
When OPL-MISC !=Spaces
OPL-COMPANY->OEM-COMPANY
OPL-MISC->OEM-MISC
OPL-CURRENCY-CODE->OEM-CURRENCY-CODE
Oeprclist OEPRCLIST Required
When OPL-CUSTOMER =Spaces
AndOPL-PROMOTION >Spaces
OPL-COMPANY->OPL-COMPANY
Spaces->OPL-CUSTOMER
OPL-LIST-NAME->OPL-LIST-NAME
Spaces->OPL-PROMOTION


OEPRCLIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cont Classes OEPLCLASS
Valid When OPL-CUSTOMER >Spaces
OPL-COMPANY->OPC-COMPANY
OPL-CUSTOMER->OPC-CUSTOMER
OPL-LIST-NAME->OPC-LIST-NAME
  OPC-SALES-MAJCL
  OPC-SALES-MINCL
Cont Items OEPLITEM
Valid When OPL-CUSTOMER >Spaces
OPL-COMPANY->OPI-COMPANY
OPL-CUSTOMER->OPI-CUSTOMER
OPL-LIST-NAME->OPI-LIST-NAME
  OPI-ITEM
List Classes OEPLCLASS
Valid When OPL-CUSTOMER =Spaces
AndOPL-PROMOTION =Spaces
OPL-COMPANY->OPC-COMPANY
OPL-CUSTOMER->OPC-CUSTOMER
OPL-LIST-NAME->OPC-LIST-NAME
OPL-PROMOTION->OPC-PROMOTION
Spaces->OPC-SALES-MAJCL
  OPC-SALES-MINCL
List Items OEPLITEM
Valid When OPL-CUSTOMER =Spaces
AndOPL-PROMOTION =Spaces
OPL-COMPANY->OPI-COMPANY
Spaces->OPI-CUSTOMER
OPL-LIST-NAME->OPI-LIST-NAME
Spaces->OPI-PROMOTION
  OPI-ITEM
Oeplclass OEPLCLASS Delete Cascades
OPL-COMPANY->OPC-COMPANY
OPL-CUSTOMER->OPC-CUSTOMER
OPL-LIST-NAME->OPC-LIST-NAME
OPL-PROMOTION->OPC-PROMOTION
  OPC-SALES-MAJCL
  OPC-SALES-MINCL
Oeplitem OEPLITEM Delete Cascades
OPL-COMPANY->OPI-COMPANY
OPL-CUSTOMER->OPI-CUSTOMER
OPL-LIST-NAME->OPI-LIST-NAME
OPL-PROMOTION->OPI-PROMOTION
  OPI-ITEM
Promo Classes OEPLCLASS
Valid When OPL-CUSTOMER =Spaces
AndOPL-PROMOTION >Spaces
OPL-COMPANY->OPC-COMPANY
OPL-LIST-NAME->OPC-LIST-NAME
OPL-PROMOTION->OPC-PROMOTION
  OPC-SALES-MAJCL
  OPC-SALES-MINCL
Promo Items OEPLITEM
Valid When OPL-CUSTOMER =Spaces
AndOPL-PROMOTION >Spaces
OPL-COMPANY->OPI-COMPANY
OPL-LIST-NAME->OPI-LIST-NAME
OPL-PROMOTION->OPI-PROMOTION
  OPI-ITEM


File created: Thu Jun 09 11:09:40 2016

Home
Contact Us



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