OEBASE FILE
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
BL00.1 BL140 BL240 BL241 BL243 BL31.1
BL31.2 BL31.3 BL31.5 BL31.7 BL32.3 BL32.4
BL340 BL41.1 BL48.1 BL85.1 BL85.2 BL90.1
BL246 BL45.3 BL46.3 BL46.1 BL47.3 BL47.1
BL248
UPDATED BY
BL141 BL40.1 BL40.2 BL40.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEB-COMPANY Numeric 4 BL141 BL40.1
Company The company number represents an BL40.2 BL40.3
established company and is entered on
all function codes.
OEB-LOCATION Alpha 5 BL141 BL40.1
Location Code If the base location required option BL40.2 BL40.3
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 Alpha 10 BL141 BL40.1
Base Name The user-defined name of a price base. BL40.2 BL40.3
OEB-CURRENCY-CODE Alpha 5 BL141 BL40.1
Currency Code The currency code indicating which BL40.2 BL40.3
currency the system will use when
creating the price base for the order.
OEB-ITEM Alpha 32 BL141 BL40.1
Item Number The identifier of the item to which the BL40.2 BL40.3
price base will be or has been assigned.
OEB-LAST-MULT-SPR Numeric 1 BL141 BL40.1
Last Mult Spr This field indicates whether an item BL40.2 BL40.3
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 Alpha 4 Occurs 10 Times BL141 BL40.1
Last Spr Uom If an item is priced in multiple units BL40.2 BL40.3
of measure, this field holds up to six
different units of measure that can be
used to price the item.
OEB-LAST-SPR-MULT Signed 13.7 Occurs 10 Times BL141 BL40.1
Last Spr Mult If the item is priced using multiple BL40.2 BL40.3
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 Alpha 1 Occurs 10 Times BL141 BL40.1
Last Spr Cd Code indicating whether each pricing BL40.2 BL40.3
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 Signed 13.5 Occurs 10 Times BL141 BL40.1
Last Price Last base price used before the use of BL40.2 BL40.3
the current base price.
OEB-CUR-EFF-DATE Numeric 8 (yyyymmdd) BL140 BL141
Current Effective A date indicating when the current BL240 BL241
Date price base became effective. BL340 BL40.1
BL40.2 BL40.3
OEB-CUR-MULT-SPR Numeric 1 BL140 BL141
Cur Mult Spr Current multiple sell price unit of BL240 BL241
measure flag. If an item is priced in BL340 BL40.1
multiple units of measure, this field BL40.2 BL40.3
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 Alpha 4 Occurs 10 Times BL140 BL141
Cur Spr Uom If this item is priced in multiple BL240 BL241
units of measure, this field holds up to BL340 BL40.1
six different units of measure that can BL40.2 BL40.3
be used to price the item.
OEB-CUR-SPR-MULT Signed 13.7 Occurs 10 Times BL140 BL141
Cur Spr Mult If an item is currently priced using BL240 BL241
multiple units of measure, this field BL340 BL40.1
holds up to six conversion factors used BL40.2 BL40.3
to convert quantities from pricing units
of measure to stock units of measure.
OEB-CUR-SPR-CD Alpha 1 Occurs 10 Times BL140 BL141
Cur Spr Cd Code indicating whether each pricing BL240 BL241
unit of measure is the default pricing BL340 BL40.1
unit of measure or a valid pricing unit BL40.2 BL40.3
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 Signed 13.5 Occurs 10 Times BL140 BL141
Current Price Current base price for the item. BL240 BL241
BL340 BL40.1
BL40.2 BL40.3
OEB-NXT-EFF-DATE Numeric 8 (yyyymmdd) BL141 BL243
Next Price The date from which the next price base BL31.1 BL31.2
Effective Date will become effective. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL40.1
BL40.2 BL40.3
BL85.1 BL85.2
BL90.1
OEB-NXT-MULT-SPR Numeric 1 BL141 BL40.1
Nxt Mult Spr Next multiple sell price unit of BL40.2 BL40.3
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 Alpha 4 Occurs 10 Times BL141 BL40.1
Nxt Spr Uom If this item will be priced in multiple BL40.2 BL40.3
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 Signed 13.7 Occurs 10 Times BL141 BL40.1
Nxt Spr Mult If an item will be priced using BL40.2 BL40.3
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 Alpha 1 Occurs 10 Times BL141 BL40.1
Next Spr Cd Code indicating whether each pricing BL40.2 BL40.3
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.
1 = Default Sell Price UOM
2 = Valid Sell Price UOM
OEB-NXT-PRICE Signed 13.5 Occurs 10 Times BL141 BL40.1
Next Price Next base price to be used by the BL40.2 BL40.3
system when pricing this item.
OEB-CUR-MULT-IND Derived
Cur Mult Ind This field contains the current pricing
multiplier.
OEB-NXT-MULT-IND Derived
Nxt Mult Ind This field contains the next pricing
multiplier.
OEB-CUR-PRICE-1 Derived
Cur Price 1 This field is used only to facilitate
painting BL243 (Price Book Print).
OEB-PL1-PRICE Derived
Pl1 Price 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 Derived
Pl2 Price 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 Derived
Pl3 Price 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.
OEBASE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEBSET1 COMPANY BL00.1 BL140
LOCATION BL141 BL240
BASE-NAME BL241 BL243
CURRENCY-CODE BL31.1 BL31.2
ITEM BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL340
BL40.1 BL40.2
BL41.1 BL48.1
BL85.1 BL85.2
BL90.1
OEBSET2 COMPANY BL246 BL40.3
ITEM BL45.3 BL46.3
BASE-NAME BL47.3
LOCATION
CURRENCY-CODE
OEBSET3 COMPANY BL248 BL46.1
BASE-NAME BL47.1
CURRENCY-CODE
LOCATION
ITEM
OEBASE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cucodes CUCODES Required
OEB-CURRENCY-CODE -> CUC-CURRENCY-CODE
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
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
PBC-MAJOR-SCLASS -> MAJ-CLASS-TYPE
PBC-MINOR-SCLASS -> MAJ-MAJOR-CLASS
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
Oepbclass OEPBCLASS Not Required
OEB-COMPANY -> PBC-COMPANY
OPB-BOOK-NAME -> PBC-BOOK-NAME
ITE-SALES-MAJCL -> PBC-MAJOR-SCLASS
ITE-SALES-MINCL -> PBC-MINOR-SCLASS
Oepbitem OEPBITEM Not Required
OEB-COMPANY -> PBI-COMPANY
OPB-BOOK-NAME -> PBI-BOOK-NAME
OEB-ITEM -> PBI-ITEM
Oeprcbook OEPRCBOOK Not Required
OEB-COMPANY -> OPB-COMPANY
OEB-BASE-NAME -> OPB-BASE-NAME
Spaces -> OPB-BOOK-NAME
Price List1 OEPRCLIST Required
OEB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-1 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Price List2 OEPRCLIST Required
When OEB-PRICE-LIST-2 != Spaces
OEB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-2 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Price List3 OEPRCLIST Required
When OEB-PRICE-LIST-3 != Spaces
OEB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-3 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
OEBASE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oebpaudit OEBPAUDIT
OEB-COMPANY -> OBA-COMPANY
OEB-LOCATION -> OBA-LOCATION
OEB-BASE-NAME -> OBA-BASE-NAME
OEB-CURRENCY-CODE -> OBA-CURRENCY-CODE
OEB-ITEM -> OBA-ITEM
OBA-UPDATE-DATE
OBA-UPDATE-TIME
|
