OEPRCLIST FILE
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
BL00.1 BL243 BL245 BL246 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.3 BL32.4 BL32.1
BL32.2 BL48.1 BL85.1 BL85.2 BL90.1 BL247
AR08.1 AR501 AR550 BL02.1 BL30.1 BL30.2
BL30.3 BL30.5 BL546 BL802
UPDATED BY
BL45.1 BL45.2 BL45.3 BL46.1 BL46.2 BL46.3
BL47.1 BL47.2 BL47.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPL-COMPANY Numeric 4 BL45.1 BL46.1
Company The company number represents an BL47.1
established company and is entered on
all function codes.
OPL-CUSTOMER Alpha 9 (Right Justified) BL45.1 BL46.1
Customer Number This field contains the number that BL47.1
represents a customer.
OPL-LIST-NAME Alpha 14 BL45.1 BL46.1
List Name User-defined name assigned to a price BL47.1
list.
OPL-PROMOTION Alpha 10 BL45.1 BL46.1
Promotion User-defined name assigned to a BL47.1
promotion that is associated with this
price list.
OPL-DESCRIPTION Alpha 30 (Lower Case) BL45.1 BL46.1
Description The description of the price list. BL47.1 BL48.1
OPL-BASE-NAME Alpha 10 BL45.1 BL46.1
Base Name User-defined name of the price base BL47.1
that this price list modifies. Price
bases are defined on BL40.1 (Price
Base).
OPL-BEG-DATE Numeric 8 (yyyymmdd) BL46.1 BL47.1
Beginning Date The beginning effective date for the
promotion or contract.
OPL-END-DATE Numeric 8 (yyyymmdd) BL46.1 BL47.1
Ending Date The ending effective date for the
promotion or contract.
OPL-MISC Alpha 16 BL45.1 BL46.1
Misc You can add an add-on charge to the BL47.1
price list that will always be assessed
when the price list is used.
OPL-PCT Percent 5.2 (Percent) BL45.1 BL46.1
Percent This default percentage (enter 90% as BL47.1
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 Alpha 10 BL45.1 BL46.1
Disc Code A discount code, entered using BL44.1 BL47.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 Numeric 8 (yyyymmdd) BL46.1
Contract Date Enter the date indicating when the
contract was added to the system.
OPL-CONTACT Alpha 20 BL46.1
Primary Contact The name of the customer that can be
contacted regarding this contract.
OPL-PHONE Alpha 15 BL46.1
Telephone Number Customer contact phone number.
OPL-PREV-CONTRACT Alpha 14 BL46.1
Previous Contract A previous number used to reference the
Number last contract can be entered in this
field.
OPL-CURRENCY-CODE Alpha 5 BL45.1 BL46.1
Currency Code The currency this price list is meant BL47.1
to use. If blank, orders in any currency
can be priced via this price list.
OPL-CURR-RATE Signed 13.6 BL46.1
Currency Rate 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 Alpha 20 BL46.1
Cust Referenc A customer reference number, or any
information that the user wants to carry
on the contract. Purely informational.
OPL-MIN-CONT-AMT Signed 15.2 BL46.1
Minimum Enter a minimum contract amount for the
Contribution Amount contract. This minimum will print on a
report that lists the actual contract
sales.
OPL-MAX-CONT-AMT Signed 15.2 BL46.1
Maximum A maximum contract amount can be
Contribution Amount 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 Alpha 1 BL45.1 BL46.1
Order Discount Flag This order discount flag is used only BL47.1
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 Signed 15.2
Minimum Order Amount 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 Signed 15.2
Maximum Order Amount 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 Numeric 4 BL45.2 BL46.2
Sc Count This field indicates the number of BL47.2
price list sales class price modifiers
that have been established under this
price list.
OPL-ITEM-COUNT Numeric 6 BL45.3 BL46.3
Item Count This field indicates the number of BL47.3
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 BL00.1 BL243
CUSTOMER BL245 BL246
LIST-NAME BL31.1 BL31.2
PROMOTION BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL45.1
BL45.2 BL45.3
BL46.1 BL46.2
BL46.3 BL47.1
BL47.2 BL47.3
BL48.1 BL85.1
BL85.2 BL90.1
OPLSET2 COMPANY Subset BL247 BL47.1
LIST-NAME Where PROMOTION != Spaces BL47.2 BL47.3
PROMOTION
OPLSET4 COMPANY Subset AR08.1 AR501
CUSTOMER Where PROMOTION = Spaces AR550 BL02.1
LIST-NAME BL245 BL30.1
BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL45.1 BL45.2
BL45.3 BL46.1
BL46.3 BL546
BL802
OPLSET5 COMPANY KeyChange, Subset BL243 BL31.1
CUSTOMER Where CUSTOMER > Spaces BL31.2 BL31.3
END-DATE And PCT > Zeroes BL31.5 BL31.7
BL32.3 BL32.4
BL46.1 BL85.1
BL85.2 BL90.1
OPLSET6 COMPANY KeyChange, Subset BL243 BL31.1
LIST-NAME Where PROMOTION > Spaces BL31.2 BL31.3
END-DATE And PCT > Zeroes BL31.5 BL31.7
BL32.3 BL32.4
BL47.1 BL85.1
BL85.2 BL90.1
OEPRCLIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And OPL-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 RELATED
NAME 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
And OPL-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
And OPL-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
And OPL-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
And OPL-PROMOTION > Spaces
OPL-COMPANY -> OPI-COMPANY
OPL-LIST-NAME -> OPI-LIST-NAME
OPL-PROMOTION -> OPI-PROMOTION
OPI-ITEM
|
