OEBASE

Base Price

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).

REFERENCED BY
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEB-COMPANY
Element: 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.
OEB-LOCATION
Element: Location
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
Element: Base Name
Alpha 10
The user-defined name of a price base.
OEB-CURRENCY-CODE
Element: Currency Code
Alpha 5
The currency code indicating which currency the system will use when creating the price base for the order.
OEB-ITEM
Element: Item
Alpha 32
The identifier of the item to which the price base will be or has been assigned.
OEB-LAST-MULT-SPR
Element: Cur 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.
0 = Single Pricing UOM
1 = Multiple Pricing UOM
OEB-LAST-SPR-UOM
Element: Uom
Alpha 4 Occurs 10 Times
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-MULT
Element: Uom Mult
Signed 13.7 Occurs 10 Times
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-CD
Element: Cur Spr Cd
Alpha 1 Occurs 10 Times
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.
1 = Default Sell Price UOM
2 = Valid Sell Price UOM
OEB-LAST-PRICE
Element: Intl Cost
Signed 18.5 Occurs 10 Times
Last base price used before the use of the current base price.
OEB-CUR-EFF-DATE
Element: Date
Numeric 8 (yyyymmdd)
A date indicating when the current price base became effective.
OEB-CUR-MULT-SPR
Element: Cur 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.
0 = Single Pricing UOM
1 = Multiple Pricing UOM
OEB-CUR-SPR-UOM
Element: Uom
Alpha 4 Occurs 10 Times
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-MULT
Element: Uom Mult
Signed 13.7 Occurs 10 Times
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-CD
Element: Cur Spr Cd
Alpha 1 Occurs 10 Times
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.
1 = Default Sell Price UOM
2 = Valid Sell Price UOM
OEB-CUR-PRICE
Element: Intl Cost
Signed 18.5 Occurs 10 Times
Current base price for the item.
OEB-NXT-EFF-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date from which the next price base will become effective.
WH20.2 WH20.7
OEB-NXT-MULT-SPR
Element: Cur 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.
0 = Single Pricing UOM
1 = Multiple Pricing UOM
OEB-NXT-SPR-UOM
Element: Uom
Alpha 4 Occurs 10 Times
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-MULT
Element: Uom Mult
Signed 13.7 Occurs 10 Times
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-CD
Element: Cur Spr Cd
Alpha 1 Occurs 10 Times
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-PRICE
Element: Intl Cost
Signed 18.5 Occurs 10 Times
Next base price to be used by the system when pricing this item.
OEB-CUR-MULT-IND
Element: Cur Mult Ind
Derived
This field contains the current pricing multiplier.
OEB-NXT-MULT-IND
Element: Nxt Mult Ind
Derived
This field contains the next pricing multiplier.
OEB-CUR-PRICE-1
Element: Cur Price 1
Derived
This field is used only to facilitate painting BL243 (Price Book Print).
OEB-PL1-PRICE
Element: Pl1 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-PRICE
Element: Pl2 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-PRICE
Element: Pl3 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-CHARGE
Element: No Charge Fl
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-CHARGE
Element: No Charge Fl
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.


OEBASE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEBSET1 COMPANY
LOCATION
BASE-NAME
CURRENCY-CODE
ITEM
WH20.2 WH20.7
OEBSET2 COMPANY
ITEM
BASE-NAME
LOCATION
CURRENCY-CODE
OEBSET3 COMPANY
BASE-NAME
CURRENCY-CODE
LOCATION
ITEM


OEBASE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:09:29 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.