|
|
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 BL120 BL122 BL130 BL140 BL20.1
BL20.3 BL21.2 BL21.5 BL240 BL241 BL243
BL29.1 BL29.2 BL31.1 BL31.2 BL31.3 BL31.5
BL31.7 BL32.3 BL32.4 BL340 BL41.1 BL48.1
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 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
Element: Company Identifies the AP company if the BL40.2 BL40.3
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OEB-LOCATION Alpha 5 BL141 BL40.1
Element: 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
Element: Base Name The user-defined name of a price base. BL40.2 BL40.3
OEB-CURRENCY-CODE Alpha 5 BL141 BL40.1
Element: 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
Element: 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
Element: Cur 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
Element: Unit of MeasurIf 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
Unit of Measure If the item is priced using multiple BL40.2 BL40.3
Multiplier 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
Element: Cur 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 18.5 Occurs 10 Times BL141 BL40.1
Element: Intl Cost 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
Element: Date A date indicating when the current BL240 BL241
price base became effective. BL340 BL40.1
BL40.2 BL40.3
OEB-CUR-MULT-SPR Numeric 1 BL140 BL141
Element: 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
Element: Unit of MeasurIf 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
Unit of Measure If an item is currently priced using BL240 BL241
Multiplier 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
Element: 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 18.5 Occurs 10 Times BL140 BL141
Element: Intl Cost Current base price for the item. BL240 BL241
BL340 BL40.1
BL40.2 BL40.3
OEB-NXT-EFF-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date The date from which the next price base BL130 BL141
will become effective. BL20.1 BL20.3
BL21.2 BL21.5
BL243 BL29.1
BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL40.1 BL40.2
BL40.3 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
...
OEB-NXT-MULT-SPR Numeric 1 BL141 BL40.1
Element: Cur 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
Element: Unit of MeasurIf 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
Unit of Measure If an item will be priced using BL40.2 BL40.3
Multiplier 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
Element: Cur 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 18.5 Occurs 10 Times BL141 BL40.1
Element: Intl Cost Next base price to be used by the BL40.2 BL40.3
system when pricing this item.
OEB-CUR-MULT-IND Derived
Element: Cur Mult Ind This field contains the current pricing
multiplier.
OEB-NXT-MULT-IND Derived
Element: Nxt Mult Ind This field contains the next pricing
multiplier.
OEB-CUR-PRICE-1 Derived
Element: Cur Price 1 This field is used only to facilitate
painting BL243 (Price Book Print).
OEB-PL1-PRICE Derived
Element: 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
Element: 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
Element: 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 BL120
LOCATION BL122 BL130
BASE-NAME BL140 BL141
CURRENCY-CODE BL20.1 BL20.3
ITEM BL21.2 BL21.5
BL240 BL241
BL243 BL29.1
BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL340 BL40.1
BL40.2 BL41.1
BL48.1 BL520
BL820 BL85.1
...
OEBSET2 COMPANY BL246 BL40.3
ITEM BL45.3 BL46.3
BASE-NAME BL47.3 OE13.5
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 OPB-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 OPB-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
|
