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
WH20.2 WH20.7 AR08.1 AR10.1 AR501 AR550
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPL-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OPL-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
OPL-LIST-NAME Alpha 14
List Name User-defined name assigned to a price
list.
OPL-PROMOTION Alpha 10
Promotion User-defined name assigned to a
promotion that is associated with this
price list.
OPL-DESCRIPTION Alpha 30 (Lower Case)
Description The description of the price list.
OPL-BASE-NAME Alpha 10
Base Name User-defined name of the price base
that this price list modifies. Price
bases are defined on BL40.1 (Price
Base).
OPL-BEG-DATE Numeric 8 (yyyymmdd)
Beginning Date The beginning effective date for the
promotion or contract.
OPL-END-DATE Numeric 8 (yyyymmdd)
Ending Date The ending effective date for the
promotion or contract.
OPL-MISC Alpha 16
Misc You can add an add-on charge to the
price list that will always be assessed
when the price list is used.
OPL-PCT Percent 5.2 (Percent)
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 Alpha 10
Disc Code 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 Numeric 8 (yyyymmdd)
Contract Date Enter the date indicating when the
contract was added to the system.
OPL-CONTACT Alpha 20
Primary Contact The name of the customer that can be
contacted regarding this contract.
OPL-PHONE Alpha 15
Telephone Number Customer contact phone number.
OPL-PREV-CONTRACT Alpha 14
Previous Contract A previous number used to reference the
Number last contract can be entered in this
field.
OPL-CURRENCY-CODE Alpha 5
Currency Code 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 Signed 13.6
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
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
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
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
Order Discount Flag 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 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
Sc Count This field indicates the number of
price list sales class price modifiers
that have been established under this
price list.
OPL-ITEM-COUNT Numeric 6
Item Count 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 WH20.2 WH20.7
CUSTOMER
LIST-NAME
PROMOTION
OPLSET2 COMPANY Subset
LIST-NAME Where PROMOTION != Spaces
PROMOTION
OPLSET4 COMPANY Subset AR08.1 AR10.1
CUSTOMER Where PROMOTION = Spaces AR501 AR550
LIST-NAME
OPLSET5 COMPANY KeyChange, Subset WH20.2 WH20.7
CUSTOMER Where CUSTOMER > Spaces
END-DATE And PCT > Zeroes
OPLSET6 COMPANY KeyChange, Subset WH20.2 WH20.7
LIST-NAME Where PROMOTION > Spaces
END-DATE And PCT > Zeroes
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
|
