OEPLITEM – Price List Item

System: Billing (BL)
Prefix: OPI
Primary key: COMPANY, CUSTOMER, LIST-NAME, PROMOTION, ITEM
Fields: 25
Updated by: 0 programs
Referenced by: 0 programs

OEPLITEM is the Price List Item table in Lawson Billing (prefix OPI). It is indexed by COMPANY, CUSTOMER, LIST-NAME, PROMOTION, ITEM (OPISET1); alternate indexes: OPISET2, OPISET3, OPISET5 and OPISET6. It is related 1:1 to ARCOMP, ARCUSTOMER, CUSTDESC, ICCOMPANY, ITEMLOC, ITEMMAST, OECOMPANY, OEDISCOUNT and 1 more. The table has 25 fields, 5 indexes and 10 documented relations.

About OEPLITEM

This file contains pricing/discounting parameters for specific items. These parameters override those at the price list and price list sales class level.

Fields (25)

Column = COBOL field name without the OPI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OPI-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	—
`OPI-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	—
`OPI-LIST-NAME` PK LIST_NAME	Alpha 14	Enter the identifier of the price list that is to have the price list item record established.	—
`OPI-PROMOTION` PK PROMOTION	Alpha 10	Enter the name of the promotion that is to have an item level price modifier established.	—
`OPI-ITEM` PK ITEM	Alpha 32	The item identifier that is to be priced at the item price list level.	—
`OPI-BEG-DATE` BEG_DATE	Numeric 8 (yyyymmdd)	This is the beginning date indicating when the promotion item price modifier will begin.	—
`OPI-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	This is the end date indicating when the promotion item price modifier will no longer be valid.	—
`OPI-PROHIBIT-FL` PROHIBIT_FL	Alpha 1	Indicates whether sales of the item are prohibited, meaning that no sales of this item 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	—
`OPI-NO-CHARGE-FL` NO_CHARGE_FL	Alpha 1	No charge flag indicating that there will not be a charge for this item when it is priced using this record. `Y` Yes `N` No	—
`OPI-MULT-SPR-FL` MULT_SPR_FL	Alpha 1	Multiple sell price flag. The flag is set if the item has multiple pricing set in the Item Master file. If this flag is set, price break is maintained in the order line pricing UOM's file. `Y` Yes `N` No	—
`OPI-UOM-BRK-CD` UOM_BRK_CD	Alpha 1	The unit of measure break code determines how the price list item record will modify the price base for this item if it is priced using multiple units of measure. For example, if a (P) is used, the pricing parameters below will multiply the price base by a percentage defined below. If a (U) is used, the pricing parameters below will add the add-on charge amount defined to each unit of measure. `U` Unit Add-On `O` Override Price `P` Percentage	—
`OPI-UOM` UOM	Alpha 4 Occurs 10 Times ×10	This field contains the valid stock unit of measure for this item.	—
`OPI-SELL-PRICE-FL` SELL_PRICE_FL	Alpha 1 Occurs 10 Times ×10	This flag specifies if this alternate unit of measure is valid for the sell price in the Order Entry system. Valid values are: `Blank` Cannot be used `1` Valid, default on entry `2` Valid	—
`OPI-PCT` PCT	Percent 5.2 (Percent) Occurs 10 Times ×10	This price break percentage is the percentage that should be multiplied against the price base for the item if the quantity ordered exceeds the lower limit to the left and is less than the next limit.	—
`OPI-UNIT-PRICE` UNIT_PRICE	Signed 18.5 Occurs 10 Times ×10	The price break unit price amount that should be added to the unit price of the item if the quantity ordered exceeds the lower limit and is less than the next limit.	—
`OPI-ADD-UNIT-PRIC` ADD_UNIT_PRIC	Signed 18.5 Occurs 10 Times ×10	This is the Price Break Add-on Unit Price Amount field that should be added to each unit of the item if the quantity ordered exceeds the lower limit to the left and is less than the next limit.	—
`OPI-QTY-BRK-CD` QTY_BRK_CD	Alpha 1	The quantity pricing code determines how the price list item record will modify the price base. For example, if a (P) is used, the pricing parameters below will multiply the price base by a percentage defined below. If a (U) is used, the pricing parameters below will add the add-on charge amount defined to each unit of measure for the item ordered. `U` Unit Add-On `O` Override Price `P` Percentage	—
`OPI-BRK-QTY` BRK_QTY	Signed 9.0 Occurs 10 Times ×10	If special pricing percentages or amounts should be applied for a specific item depending on quantities ordered, the lower item order quantity limit is entered in this field. An order of an item quantity surpassing this limit and less than the next limit will be priced using the modifier found in the next series of fields.	—
`OPI-BRK-PCT` BRK_PCT	Percent 5.2 (Percent) Occurs 10 Times ×10	The percentage that should be multiplied against the price base for the item if the quantity ordered exceeds the lower limit and is less than the next limit.	—
`OPI-BRK-PRICE` BRK_PRICE	Signed 18.5 Occurs 10 Times ×10	This is the price break unit price amount field that should be added to the unit price of the item if the quantity ordered exceeds the lower limit and is less than the next limit.	—
`OPI-BRK-ADD-ON` BRK_ADD_ON	Signed 18.5 Occurs 10 Times ×10	The price break add-on unit price amount that should be added to each unit of the item if the quantity ordered exceeds the lower limit and is less than the next limit.	—
`OPI-DISC-CODE` DISC_CODE	Alpha 10	A discount code can be added at this level of the price list modifier. If you enter a discount code, the discount will automatically be applied to lines priced via this record.	—
`OPI-MULT-SPR-IND` MULT_SPR_IND	Derived	This is the multiple selling price indicator that tells the user that there are multiple pricing units of measure defined for this item.	—
`OPI-BRK-QTY-1` BRK_QTY_1	Derived	This is the first occurrence of the quantity breaks identified on the price list item modifier. This is used in creating BL90.1 (Pricing Inquiry).	—
`OPI-BRK-PRICE-1` BRK_PRICE_1	Derived	This is the first occurrence of the quantity price breaks identified on the price list item modifier. This is used in creating BL90.1 (Pricing Inquiry).	—

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OPISET1`	`COMPANY`, `CUSTOMER`, `LIST-NAME`, `PROMOTION`, `ITEM`	Primary		WH20.2, WH20.7
`OPISET2`	`COMPANY`, `LIST-NAME`, `PROMOTION`, `ITEM`	Subset	Where PROMOTION != Spaces And CUSTOMER = Spaces	—
`OPISET3`	`COMPANY`, `CUSTOMER`, `LIST-NAME`, `ITEM`	Subset	Where PROMOTION = Spaces And CUSTOMER != Spaces	—
`OPISET5`	`COMPANY`, `CUSTOMER`, `ITEM`, `END-DATE`	KeyChange, Subset	Where CUSTOMER != Spaces And PROMOTION = Spaces	WH20.2, WH20.7
`OPISET6`	`COMPANY`, `LIST-NAME`, `ITEM`, `END-DATE`	KeyChange, Subset	Where PROMOTION != Spaces And CUSTOMER = Spaces	WH20.2, WH20.7

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`OPI-COMPANY` → `ACO-COMPANY`
Arcustomer	ARCUSTOMER	Not Required		`OPI-COMPANY` → `ACM-COMPANY`, `OPI-CUSTOMER` → `ACM-CUSTOMER`
Custdesc	CUSTDESC	Required		`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `OPI-CUSTOMER` → `CUD-CUSTOMER`
Iccompany	ICCOMPANY	Required		`OPI-COMPANY` → `ICC-COMPANY`
Itemloc	ITEMLOC	Not Required		`OPI-COMPANY` → `ITL-COMPANY`, `Spaces` → `ITL-LOCATION`, `OPI-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `OPI-ITEM` → `ITE-ITEM`
Oecompany	OECOMPANY	Required		`OPI-COMPANY` → `OEC-COMPANY`
Oediscount	OEDISCOUNT	Required	When OPI-DISC-CODE != Spaces	`OPI-COMPANY` → `OED-COMPANY`, `OPI-DISC-CODE` → `OED-DISC-CODE`
Oeprclist	OEPRCLIST	Required		`OPI-COMPANY` → `OPL-COMPANY`, `OPI-CUSTOMER` → `OPL-CUSTOMER`, `OPI-LIST-NAME` → `OPL-LIST-NAME`, `OPI-PROMOTION` → `OPL-PROMOTION`
Price List	OEPRCLIST	Required	When OPI-PROMOTION != Spaces And OPI-CUSTOMER = Spaces	`OPI-COMPANY` → `OPL-COMPANY`, `Spaces` → `OPL-CUSTOMER`, `OPI-LIST-NAME` → `OPL-LIST-NAME`, `Spaces` → `OPL-PROMOTION`

Programs

No Lawson programs are documented as updating or referencing this table.