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 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL243 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 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE283 OE293 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810 OE830 OE920 OE950 SA254 SA255 WH20.2 WH20.7 BL247 AR08.1 AR10.1 AR501 AR550 BL02.1 BL245 BL30.1 BL30.2 BL30.3 BL30.5 BL546 BL802 BL902 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 OE293 promotion or contract. OPL-END-DATE Numeric 8 (yyyymmdd) BL46.1 BL47.1 Ending Date The ending effective date for the OE293 promotion or contract. OPL-MISC Alpha 16 BL45.1 BL46.1 Miscellaneous 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 OE293 Contract Date Enter the date indicating when the contract was added to the system. OPL-CONTACT Alpha 20 BL46.1 OE293 Primary Contact The name of the customer that can be contacted regarding this contract. OPL-PHONE Alpha 15 BL46.1 OE293 Telephone Number Customer contact phone number. OPL-PREV-CONTRACT Alpha 14 BL46.1 OE293 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 OE293 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 OE293 Cust Reference 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 SA254 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 SA254 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 OE293 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 OE293 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 BL120 CUSTOMER BL130 BL20.1 LIST-NAME BL20.3 BL21.2 PROMOTION BL21.5 BL243 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 BL520 BL820 ... OPLSET2 COMPANY Subset BL247 BL47.1 LIST-NAME Where PROMOTION != Spaces BL47.2 BL47.3 PROMOTION SA255 OPLSET4 COMPANY Subset AR08.1 AR10.1 CUSTOMER Where PROMOTION = Spaces AR501 AR550 LIST-NAME 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 BL902 OPLSET5 COMPANY KeyChange, Subset BL120 BL130 CUSTOMER Where CUSTOMER > Spaces BL20.1 BL20.3 END-DATE And PCT > Zeroes 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 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... OPLSET6 COMPANY KeyChange, Subset BL120 BL130 LIST-NAME Where PROMOTION > Spaces BL20.1 BL20.3 END-DATE And PCT > Zeroes 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 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... 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 |