|
|
OEWKPRICE FILE
Pricing Worksheet Price
This file stores the individual item price bases for a specific pricing
worksheet. See the Billing Procedures Manual for a description of the
worksheet process.
REFERENCED BY
BL141 BL240 BL41.1
UPDATED BY
BL140 BL42.1 BL42.2 BL340
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OWP-COMPANY Numeric 4 BL140 BL42.1
Element: Company Identifies the AP company if the BL42.2
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OWP-WORK-NAME Alpha 10 BL140 BL42.1
Element: Base Name This field identifies the name of the BL42.2
worksheet.
OWP-ITEM Alpha 32 BL140 BL42.1
Element: Item This field contains the item identifier BL42.2
that will have the price updated by the
worksheet.
OWP-NXT-EFF-DATE Numeric 8 (yyyymmdd) BL140 BL42.1
Element: Date This will become the effective date for BL42.2
the next price on the updated base.
OWP-NXT-MULT-SPR Numeric 1 BL140
Element: Cur Mult Spr Next multiple sell price unit of
measure flag. If this is set, this item
has pricing based on unit of measure.
0 = Single price UOM
1 = Multiple price UOM
OWP-NXT-SPR-UOM Alpha 4 Occurs 10 Times BL140 BL42.1
Element: Uom This field contains the valid stock BL42.2
unit of measure for this item.
OWP-NXT-SPR-MULT Signed 13.7 Occurs 10 Times BL140 BL42.1
Element: Uom Mult If the item for which the price BL42.2
worksheet has been created is priced
using multiple sell price units of
measure, these fields indicate the
beginning date of the next price base.
OWP-NXT-PRICE Signed 18.5 Occurs 10 Times BL140 BL42.1
Element: Intl Cost This is the price base that will be BL42.2
updated beginning with the effective
date specified.
OWP-NXT-SPR-CD Alpha 1 Occurs 10 Times BL140 BL42.1
Element: Cur Spr Cd This field identifies the sell pricing BL42.2
unit of measure that will be used to
establish the next price base of the
item.
1 = Default sell price UOM
2 = Valid sell price UOM
" "
OEWKPRICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OWPSET1 COMPANY BL140 BL141
WORK-NAME BL240 BL340
ITEM BL41.1 BL42.1
BL42.2
OEWKPRICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
OWP-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
OWP-ITEM -> ITE-ITEM
Oebase OEBASE Required
When OWK-SEL-BASE != Spaces
OWP-COMPANY -> OEB-COMPANY
OWK-SEL-BASE-LOC -> OEB-LOCATION
OWK-SEL-BASE -> OEB-BASE-NAME
OWK-SEL-CURR -> OEB-CURRENCY-CODE
OWP-ITEM -> OEB-ITEM
Oebasews OEWKSHEET Required
OWP-COMPANY -> OWK-COMPANY
OWP-WORK-NAME -> OWK-WORK-NAME
Oecompany OECOMPANY Required
OWP-COMPANY -> OEC-COMPANY
Oewksheet OEWKSHEET Required
OWP-COMPANY -> OWK-COMPANY
OWP-WORK-NAME -> OWK-WORK-NAME
|
