Lawson Insight Technical Documentation |
|
OEPLCLASS
OEPLCLASS FILE
Price List Sales Class
This file stores the price list sales class that, if used, identifies the
pricing and discounting parameters used to price all order or invoice lines
for items falling into the specified sales class. This level of pricing
overrides the prices on the price list level and is overridden by any item
level pricing parameters established.
REFERENCED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL243 BL245 BL246 BL247 BL29.1
BL29.2 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL520 BL820 BL85.1 BL85.2
BL90.1 BL92.1 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 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE283 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 WH20.2 WH20.7
UPDATED BY
BL45.1 BL45.2 BL46.1 BL46.2 BL47.1 BL47.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPC-COMPANY Numeric 4 BL45.2 BL46.2
Element: Company Identifies the AP company if the BL47.2
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OPC-CUSTOMER Alpha 9 (Right Justified) BL45.2 BL46.2
Element: Customer NumbeThis field contains the number that BL47.2
represents a customer.
OPC-LIST-NAME Alpha 14 BL45.2 BL46.2
Element: List Name Enter the identifier of the price list BL47.2
that is to have the price list sales
class record established.
OPC-PROMOTION Alpha 10 BL45.2 BL46.2
Element: Promotion Enter the name of the promotion that BL47.2
has a sales class price modifier
established.
OPC-SALES-MAJCL Alpha 4 BL45.2 BL46.2
Element: Major Class Sales major class code that indicates BL47.2
which items will be affected by this
price modifier.
OPC-SALES-MINCL Alpha 4 BL45.2 BL46.2
Element: Minor Class Sales minor class code that indicates BL47.2
which items will be affected by the
price modifier.
OPC-BEG-DATE Numeric 8 (yyyymmdd) BL45.2 BL46.1
Element: Beginning DateThis is the beginning date indicating BL46.2 BL47.1
when the promotion sales class price BL47.2
modifier will begin.
OPC-END-DATE Numeric 8 (yyyymmdd) BL45.2 BL46.1
Element: Ending Date This is the end date indicating when BL46.2 BL47.1
the promotion sales class price modifier BL47.2
will no longer be valid.
OPC-PROHIBIT-FL Alpha 1 BL45.2 BL46.2
Element: All Flag This flag indicates whether sales of BL47.2
the items within the sales major and
minor classes are prohibited - meaning
no sales of these items will be allowed
(unless there is an item level record
pricing the item, as that level
overrides the sales class records).
Y = Yes
N = No
OPC-CLASS-PRC-FL Alpha 1 BL45.2 BL46.2
Element: All Flag This class price flag indicates whether BL47.2
the items in the sales class should be
priced using amalgamation (group pricing
logic). Group pricing is explained in
detail in the Billing Procedures Manual.
N = No
Y = Yes
OPC-BRK-QTY Signed 9.0 Occurs 10 Times BL45.2 BL46.2
Element: Disc Qty If special pricing percentages should BL47.2
be applied for a specific sales class
based on item quantities ordered, the
lower item order quantity limit is
entered in this field. An order for an
item quantity surpassing this limit and
less than the next limit will be priced
using the override percentage specified
in the field to the right, overriding
the default pricing percentage specified
for the sales class.
OPC-BRK-PCT Percent 5.2 (Percent) Occurs 10 Times BL45.2 BL46.2
Element: Percent The override pricing percentage to be BL47.2
used for the item order quantity break
(specified in the Quantity Break field)
is entered in this field.
OPC-DISC-CODE Alpha 10 BL45.2 BL46.2
Element: Discount Code A discount code can be assigned at this BL47.2
level. If this has been done, the
entered discount will automatically be
applied to lines priced via this record.
OEPLCLASS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPCSET1 COMPANY BL120 BL122
CUSTOMER BL130 BL20.1
LIST-NAME BL20.3 BL21.2
PROMOTION BL21.5 BL243
SALES-MAJCL BL245 BL246
SALES-MINCL BL247 BL29.1
BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL45.1 BL45.2
BL46.2 BL47.1
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
...
OPCSET2 COMPANY Subset BL47.1 BL47.2
LIST-NAME Where PROMOTION != Spaces
PROMOTION
SALES-MAJCL
SALES-MINCL
OPCSET3 COMPANY Subset BL46.1 BL46.2
CUSTOMER Where PROMOTION = Spaces
LIST-NAME
SALES-MAJCL
SALES-MINCL
OPCSET4 COMPANY Subset BL46.2
CUSTOMER Where CUSTOMER != Spaces
SALES-MAJCL And PROMOTION = Spaces
SALES-MINCL
LIST-NAME
OPCSET5 COMPANY KeyChange, Subset BL120 BL122
CUSTOMER Where CUSTOMER > Spaces BL130 BL20.1
SALES-MAJCL BL20.3 BL21.2
SALES-MINCL BL21.5 BL243
END-DATE 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
...
OPCSET6 COMPANY KeyChange, Subset BL120 BL122
LIST-NAME Where PROMOTION != Spaces BL130 BL20.1
SALES-MAJCL BL20.3 BL21.2
SALES-MINCL BL21.5 BL243
END-DATE BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL47.1
BL47.2 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
OEPLCLASS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OPC-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
OPC-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
OPC-COMPANY -> ICC-COMPANY
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
OPC-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
When OPC-SALES-MINCL != Spaces
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
OPC-SALES-MAJCL -> MIN-MAJOR-CLASS
OPC-SALES-MINCL -> MIN-MINOR-CLASS
Oecompany OECOMPANY Required
OPC-COMPANY -> OEC-COMPANY
Oediscount OEDISCOUNT Required
When OPC-DISC-CODE != Spaces
OPC-COMPANY -> OED-COMPANY
OPC-DISC-CODE -> OED-DISC-CODE
Oeprclist OEPRCLIST Required
OPC-COMPANY -> OPL-COMPANY
OPC-CUSTOMER -> OPL-CUSTOMER
OPC-LIST-NAME -> OPL-LIST-NAME
OPC-PROMOTION -> OPL-PROMOTION
Price List OEPRCLIST Required
When OPC-PROMOTION != Spaces
OPC-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPC-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
|