OEBASE – Base Price
- System
- Billing (BL)
- Prefix
OEB- Primary key
COMPANY,LOCATION,BASE-NAME,CURRENCY-CODE,ITEM- Fields
- 30
- Updated by
- 0 programs
- Referenced by
- 0 programs
OEBASE is the Base Price table in Lawson Billing (prefix OEB). It is indexed by COMPANY, LOCATION, BASE-NAME, CURRENCY-CODE, ITEM (OEBSET1); alternate indexes: OEBSET2 and OEBSET3. It is related 1:1 to CUCODES, ICCOMPANY, ICLOCATION, ITEMMAST, MINORCL and OECOMPANY. The table has 30 fields, 3 indexes and 6 documented relations.
About OEBASE
This file stores the price bases established for items that are to be sold through the Lawson Order Entry system. All items must have a record in this file if they are to be ordered and priced by the Lawson Order Entry system. This is simply the price base for the item and this can be modified up or down with any one of the three price modifiers (price list, promotion, or contract).
Fields (30)
Column = COBOL field name without the OEB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OEB-COMPANY PKCOMPANY | 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. | — |
OEB-LOCATION PKLOCATION | Alpha 5 | If the base location required option has been selected for the company, the base list can be further identified by location to establish base price. This will indicate that item pricing may differ, depending on the location where the item is stored. For example, base name BASE1 could appear on this form several times, with a different price for each different inventory location. Note: Inventory locations are established in the Inventory Control system. | — |
OEB-BASE-NAME PKBASE_NAME | Alpha 10 | The user-defined name of a price base. | — |
OEB-CURRENCY-CODE PKCURRENCY_CODE | Alpha 5 | The currency code indicating which currency the system will use when creating the price base for the order. | — |
OEB-ITEM PKITEM | Alpha 32 | The identifier of the item to which the price base will be or has been assigned. | — |
OEB-LAST-MULT-SPRLAST_MULT_SPR | Numeric 1 | This field indicates whether an item can be priced using one or multiple units of measure. If multiple units of measure are defined for this item, the user must establish a price for each unit of measure when defining the base price for this item. Applies only to old or "last" pricing unit of measure table of price base.
| — |
OEB-LAST-SPR-UOMLAST_SPR_UOM | Alpha 4 Occurs 10 Times ×10 | If an item is priced in multiple units of measure, this field holds up to six different units of measure that can be used to price the item. | — |
OEB-LAST-SPR-MULTLAST_SPR_MULT | Signed 13.7 Occurs 10 Times ×10 | If the item is priced using multiple units of measure, this field holds up to six conversion factors used to convert quantities from those pricing units of measure to stock units of measure. | — |
OEB-LAST-SPR-CDLAST_SPR_CD | Alpha 1 Occurs 10 Times ×10 | Code indicating whether each pricing unit of measure is the default pricing unit of measure or a valid pricing unit of measure or an invalid unit of measure to be used for pricing.
| — |
OEB-LAST-PRICELAST_PRICE | Signed 18.5 Occurs 10 Times ×10 | Last base price used before the use of the current base price. | — |
OEB-CUR-EFF-DATECUR_EFF_DATE | Numeric 8 (yyyymmdd) | A date indicating when the current price base became effective. | — |
OEB-CUR-MULT-SPRCUR_MULT_SPR | Numeric 1 | Current multiple sell price unit of measure flag. If an item is priced in multiple units of measure, this field holds up to six different units of measure that can be used to price the item.
| — |
OEB-CUR-SPR-UOMCUR_SPR_UOM | Alpha 4 Occurs 10 Times ×10 | If this item is priced in multiple units of measure, this field holds up to six different units of measure that can be used to price the item. | — |
OEB-CUR-SPR-MULTCUR_SPR_MULT | Signed 13.7 Occurs 10 Times ×10 | If an item is currently priced using multiple units of measure, this field holds up to six conversion factors used to convert quantities from pricing units of measure to stock units of measure. | — |
OEB-CUR-SPR-CDCUR_SPR_CD | Alpha 1 Occurs 10 Times ×10 | Code indicating whether each pricing unit of measure is the default pricing unit of measure or a valid pricing unit of measure or an invalid unit of measure to be used for pricing.
| — |
OEB-CUR-PRICECUR_PRICE | Signed 18.5 Occurs 10 Times ×10 | Current base price for the item. | — |
OEB-NXT-EFF-DATENXT_EFF_DATE | Numeric 8 (yyyymmdd) | The date from which the next price base will become effective. | WH20.2, WH20.7 |
OEB-NXT-MULT-SPRNXT_MULT_SPR | Numeric 1 | Next multiple sell price unit of measure flag. If an item will be priced in multiple units of measure, this field holds up to six different units of measure that can be used to price the item.
| — |
OEB-NXT-SPR-UOMNXT_SPR_UOM | Alpha 4 Occurs 10 Times ×10 | If this item will be priced in multiple units of measure, this field holds up to six different units of measure that can be used to price the item. | — |
OEB-NXT-SPR-MULTNXT_SPR_MULT | Signed 13.7 Occurs 10 Times ×10 | If an item will be priced using multiple units of measure, this field holds up to six conversion factors used to convert quantities from pricing units of measure to stock units of measure. | — |
OEB-NEXT-SPR-CDNEXT_SPR_CD | Alpha 1 Occurs 10 Times ×10 | Code indicating whether each pricing unit of measure that will be used is the default pricing unit of measure or a valid pricing unit of measure or an invalid unit of measure to be used for pricing. | — |
OEB-NXT-PRICENXT_PRICE | Signed 18.5 Occurs 10 Times ×10 | Next base price to be used by the system when pricing this item. | — |
OEB-CUR-MULT-INDCUR_MULT_IND | Derived | This field contains the current pricing multiplier. | — |
OEB-NXT-MULT-INDNXT_MULT_IND | Derived | This field contains the next pricing multiplier. | — |
OEB-CUR-PRICE-1CUR_PRICE_1 | Derived | This field is used only to facilitate painting BL243 (Price Book Print). | — |
OEB-PL1-PRICEPL1_PRICE | Derived | This field is used only to facilitate painting BL243 (Price Book Print). Price book will print up to three different price lists that have been added to the system. | — |
OEB-PL2-PRICEPL2_PRICE | Derived | This field is used only to facilitate painting BL243 (Price Book Print). The price book will print up to three different price lists that have been added to the system. | — |
OEB-PL3-PRICEPL3_PRICE | Derived | This field is used only to facilitate painting BL243 (Price Book Print). The price book will print up to three different price lists that have been added to the system. | — |
OEB-CURR-NO-CHARGECURR_NO_CHARGE | Alpha 1 | This field indicates the item's price is zero. This defaults to (N)o. If (Y)es, this field prevents the system from pricing the item. No charge invoices are not be passed to the Lawson Accounts Receivable system for collection. | — |
OEB-NEXT-NO-CHARGENEXT_NO_CHARGE | Alpha 1 | This field indicates the item's price is zero. This defaults to (N)o. If (Y)es, this field prevents the system from pricing the item. No charge invoices are not be passed to the Lawson Accounts Receivable system for collection. | — |
Indexes (3)
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 |
|---|---|---|---|---|
OEBSET1 | COMPANY, LOCATION, BASE-NAME, CURRENCY-CODE, ITEM | Primary | WH20.2, WH20.7 | |
OEBSET2 | COMPANY, ITEM, BASE-NAME, LOCATION, CURRENCY-CODE | — | ||
OEBSET3 | COMPANY, BASE-NAME, CURRENCY-CODE, LOCATION, ITEM | — |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cucodes | CUCODES | Required | OEB-CURRENCY-CODE → CUC-CURRENCY-CODE (CUCSET1) | |
| Iccompany | ICCOMPANY | Required | OEB-COMPANY → ICC-COMPANY | |
| Iclocation | ICLOCATION | Required | When OEB-LOCATION != Spaces | OEB-COMPANY → ICL-COMPANY, OEB-LOCATION → ICL-LOCATION |
| Itemmast | ITEMMAST | Required | ICC-ITEM-GROUP → ITE-ITEM-GROUP, OEB-ITEM → ITE-ITEM | |
| Minorcl | MINORCL | Required | ICC-ITEM-GROUP → MIN-ITEM-GROUP, "S" → MIN-CLASS-TYPE, ITE-SALES-MAJCL → MIN-MAJOR-CLASS, ITE-SALES-MINCL → MIN-MINOR-CLASS | |
| Oecompany | OECOMPANY | Required | OEB-COMPANY → OEC-COMPANY |
Programs
No Lawson programs are documented as updating or referencing this table.