|
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 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL243 BL245 BL246 BL29.1
BL29.2 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL32.1 BL32.2 BL48.1 BL520
BL820 BL85.1 BL85.2 BL90.1 BL92.1 WH20.2
WH20.7 BL247 AR08.1 AR10.1 AR120 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
Element: Company Identifies the AP company if the BL47.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OPL-CUSTOMER Alpha 9 (Right Justified) BL45.1 BL46.1
Element: Customer This field contains the number that BL47.1
represents a customer.
OPL-LIST-NAME Alpha 14 BL45.1 BL46.1
Element: List Name User-defined name assigned to a price BL47.1
list.
OPL-PROMOTION Alpha 10 BL45.1 BL46.1
Element: 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
Element: Description The description of the price list. BL47.1 BL48.1
OPL-BASE-NAME Alpha 10 BL45.1 BL46.1
Element: 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
Element: Beg Date The beginning effective date for the
promotion or contract.
OPL-END-DATE Numeric 8 (yyyymmdd) BL46.1 BL47.1
Element: End Date The ending effective date for the
promotion or contract.
OPL-MISC Alpha 16 BL45.1 BL46.1
Element: 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
Element: Pct 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
Element: Discount 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
Element: Contract Date Enter the date indicating when the
contract was added to the system.
OPL-CONTACT Alpha 20 BL46.1
Element: Contact The name of the customer that can be
contacted regarding this contract.
OPL-PHONE Alpha 15 BL46.1
Element: Phone Customer contact phone number.
OPL-PREV-CONTRACT Alpha 14 BL46.1
Element: List Name A previous number used to reference the
last contract can be entered in this
field.
OPL-CURRENCY-CODE Alpha 5 BL45.1 BL46.1
Element: 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 14.7 BL46.1
Element: Curr 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
Element: Contact A customer reference number, or any
information that the user wants to carry
on the contract. Purely informational.
OPL-MIN-CONT-AMT Signed 18.2 BL46.1
Element: Intl Amt 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 Signed 18.2 BL46.1
Element: Intl Amt 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 Alpha 1 BL45.1 BL46.1
Element: Ord Disc Fl 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 18.2
Element: Intl Amt 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 18.2
Element: Intl Amt 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
Element: 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
Element: 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 BL120
CUSTOMER BL122 BL130
LIST-NAME BL20.1 BL20.3
PROMOTION BL21.2 BL21.5
BL243 BL245
BL246 BL29.1
BL29.2 BL31.1
BL31.2 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
...
OPLSET2 COMPANY Subset BL247 BL47.1
LIST-NAME Where PROMOTION != Spaces BL47.2 BL47.3
PROMOTION
OPLSET4 COMPANY Subset AR08.1 AR10.1
CUSTOMER Where PROMOTION = Spaces AR120 AR501
LIST-NAME AR550 BL02.1
BL130 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 BL120 BL122
CUSTOMER Where CUSTOMER > Spaces BL130 BL20.1
END-DATE And PCT > Zeroes BL20.3 BL21.2
BL21.5 BL243
BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL46.1
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
WH20.2 WH20.7
OPLSET6 COMPANY KeyChange, Subset BL120 BL122
LIST-NAME Where PROMOTION > Spaces BL130 BL20.1
END-DATE And PCT > Zeroes BL20.3 BL21.2
BL21.5 BL243
BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL47.1
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
WH20.2 WH20.7
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
|