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. |
|
||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| OEBSET1 |
COMPANY LOCATION BASE-NAME CURRENCY-CODE ITEM |
|
| ||||||||
| OEBSET2 |
COMPANY ITEM BASE-NAME LOCATION CURRENCY-CODE |
|
|||||||||
| OEBSET3 |
COMPANY BASE-NAME CURRENCY-CODE LOCATION ITEM |
|
|||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cucodes | CUCODES |
Required
| ||||||||||||
| Iccompany | ICCOMPANY |
Required
| ||||||||||||
| Iclocation | ICLOCATION |
Required
| ||||||||||||
| Itemmast | ITEMMAST |
Required
| ||||||||||||
| Minorcl | MINORCL |
Required
| ||||||||||||
| Oecompany | OECOMPANY |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.