OEWKSHEET FILE
Pricing Worksheet
The Pricing Worksheet file controls the formal planning process of updating
price bases. The worksheet file indicates which item's bases to pull into
this worksheet. See the Billing Procedures Manual for a description of the
worksheet planning process.
REFERENCED BY
BL00.1 BL240
UPDATED BY
BL140 BL141 BL340 BL41.1 BL42.1 BL42.2
BL43.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OWK-COMPANY Numeric 4 BL41.1 BL42.1
Company The company number represents an BL43.1
established company and must be entered
on all form actions. This is the company
for which the worksheet will be
established.
OWK-WORK-NAME Alpha 10 BL41.1 BL42.1
Work Name User-defined name of the worksheet that BL43.1
has been or is being created.
OWK-SEL-BASE-LOC Alpha 5 BL140 BL141
Selected Base If the "Base Location Required" option BL240 BL340
Location has been selected for the company in the BL41.1
Billing system, the base list must be
further identified by location to
establish an acceptable worksheet that
will update the selected base. Selection
of this company level option indicates
that base list pricing can differ for
the same item, depending on the
inventory location of the item.
OWK-SEL-BASE Alpha 10 BL140 BL141
Selected Base If a base name is entered in this BL240 BL340
field, the current base price tied to BL41.1
this base will be multiplied by the
multiplier criteria established on
BL41.2 (Item Selection) to arrive at the
new base prices for all items specified.
In order for the bases to finally be
updated, BL141 (Base List Worksheet
Update) must be run.
Note: If vendor selection criteria has
been entered on BL41.2 (Item Selection),
a base name (in this field) can only be
entered as the price source to be
modified if company prices vary by
location. If so, the location field will
also be required when defining the
worksheet. The reason for this is that
the vendor is found on the Item Location
record but not the Item Master record. A
base that is not tied to a location will
not be able to be selected by vendor.
OWK-SEL-CURR Alpha 5 BL140 BL141
Sel Curr The worksheet feature allows users to BL240 BL340
select a price base that is defined BL41.1
using one currency and update or create
another price base in another currency.
This field identifies the currency of
the price base of the base selected to
be modified.
OWK-UPD-LOC Alpha 5 BL41.1 BL42.1
Upd Loc If the "Base Location Required" option
has been selected for the company in the
Billing system, the base name must be
further identified by location to
establish base price. Selection of this
company level option indicates that base
pricing can differ for the same item,
depending on the inventory location of
the item.
OWK-UPD-BASE Alpha 10 BL41.1 BL42.1
Update Base This field contains the base price name
that will either be updated by the
worksheet or created by the worksheet
when BL141 (Base List Worksheet Update)
is run.
OWK-UPD-CURR Alpha 5 BL41.1 BL42.1
Upd Curr The worksheet feature allows users to
select a price base that is defined
using one currency and update or create
another price base in another currency.
This field identifies the currency of
the price base that will be created or
updated.
OWK-PLAN-EFF-DATE Numeric 8 (yyyymmdd) BL41.1
Plan Effective Date This is the date the prices for the
updated base will take effect - provided
of course that this base has been
updated by BL141 (Base List Worksheet
Update). This date must be a future date
at the time it is entered.
OWK-SEL-LOCATION Alpha 5 BL41.1
Selected Location The price source to be modified by the
percentage indicated (on BL41.2) can be
specified as one of the two item costs
currently on file for the items at the
location entered in this field.
OWK-ISS-COST-PRI Numeric 1 BL41.1
Iss Cost Pri Entering a (1) or (2) in this field
will specify whether the item's cost
(updated when item was last issued)
should be used as the first or second
choice for the price source.
OWK-LAST-COST-PRI Numeric 1 BL41.1
Last Cost Pri Entering a (1) or (2) in this field
will indicate whether the item's last
received cost should be used as the
first or second choice for the price
source.
1
3
OWK-BEG-ITEM Alpha 32 Occurs 7 Times BL41.1
Beginning Item This field represents the first item in
the range of items that are to have
their price bases updated by the
multiplier identified to the right of
the range specified.
OWK-END-ITEM Alpha 32 Occurs 7 Times BL41.1
End Item This field represents the last item in
the range of items that are to have
their price bases updated by the
multiplier identified to the right of
the range specified.
OWK-ITEM-MULT Signed 5.4 Occurs 7 Times BL41.1
Item Mult This is the number that will be
multiplied by the price base for items
within the range identified to arrive at
the new price base for these items.
OWK-BEG-MAJ-SCLS Alpha 4 Occurs 14 Times BL41.1
Beg Maj Scls This field represents the first major
sales class in the range of sales
classes that are to have their items
base prices updated by the multiplier
identified to the right of the range
specified.
OWK-END-MAJ-SCLS Alpha 4 Occurs 14 Times BL41.1
End Maj Scls This field represents the ending major
sales class in the range of sales
classes that are to have their items
updated by the multiplier identified to
right of the range specified.
OWK-SCLASS-MULT Signed 5.4 Occurs 14 Times BL41.1
Sclass Mult This is the number that will be
multiplied by the price base for items
belonging to the major sales class range
identified to the left to arrive at the
new price base for these items.
OWK-SEL-VENDOR Alpha 9 (Right Justified) BL41.1
Selected Vendor If a vendor number is entered in this
field, the worksheet will update items
on a price base that are supplied only
by this vendor. This option can only be
selected if the company establishes
price bases for each location. If this
option is selected, then a location must
be selected on BL41.1 (Worksheet)
indicating what location the worksheet
should use when picking items to update.
OWK-VENDOR-MULT Signed 5.4 BL41.1
Vendor Multiplier If a multiplier is entered on this
field, it will be used in calculating
the updated price base for all items
supplied by the vendor entered above.
OWK-STATUS Numeric 1 BL140 BL141
Status This is the status of a given BL42.1 BL42.2
worksheet. BL43.1
0 = Edit
1 = Created
2 = Released
3 = Processed
OWK-SPRDSHEET-FL Alpha 1
Spreadsheet Flag If this flag is set to Yes, it
indicates that this worksheet cannot be
changed once it has been created. The
idea is that the worksheet will be
unloaded to a personal computer
spreadsheet format and be maintained
there instead of being maintained in the
Order Entry system.
Y = Yes
N = No
OWK-BEG-ITEM-1 Derived
Beginning Item 1 Array value of beginning item in range
of items to be updated.
OWK-BEG-ITEM-2 Derived
Beg Item 2 Array value of beginning item in second
range of items to be updated.
OWK-BEG-ITEM-3 Derived
Beg Item 3 Array value of beginning item in third
range of items to be updated.
OWK-BEG-ITEM-4 Derived
Beg Item 4 Array value of beginning item in fourth
range of items to be updated.
OWK-BEG-ITEM-5 Derived
Beg Item 5 Array value of beginning item in fifth
range of items to be updated.
OWK-BEG-ITEM-6 Derived
Beg Item 6 Array value of beginning item in sixth
range of items to be updated.
OWK-BEG-ITEM-7 Derived
Beg Item 7 Array value of beginning item in
seventh range of items to be updated.
OWK-END-ITEM-1 Derived
End Item 1 Array value of ending item in first
range of items to be updated.
OWK-END-ITEM-2 Derived
End Item 2 Array value of ending item in range of
items to be updated.
OWK-END-ITEM-3 Derived
End Item 3 Array value of ending item in third
range of items to be updated.
OWK-END-ITEM-4 Derived
End Item 4 Array value of ending item in fourth
range of items to be updated.
OWK-END-ITEM-5 Derived
End Item 5 Array value of ending item in fifth
range of items to be updated.
OWK-END-ITEM-6 Derived
End Item 6 Array value of ending item in sixth
range of items to be updated.
OWK-END-ITEM-7 Derived
End Item 7 Array value of ending item in seventh
range of items to be updated.
OEWKSHEET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OWKSET1 COMPANY BL00.1 BL140
WORK-NAME BL141 BL240
BL340 BL41.1
BL42.1 BL42.2
BL43.1
OWKSET2 WORK-NAME This index was created as a solution to BL140 BL141
COMPANY the Find Next/Prev Flag error. It is
only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
OEWKSHEET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When OWK-SEL-VENDOR != Spaces
OWK-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When OWK-SEL-VENDOR != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
OWK-SEL-VENDOR -> VEN-VENDOR
Iclocation ICLOCATION Required
When OWK-SEL-LOCATION != Spaces
OWK-COMPANY -> ICL-COMPANY
OWK-SEL-LOCATION -> ICL-LOCATION
Oecompany OECOMPANY Required
OWK-COMPANY -> OEC-COMPANY
Sel Curr CUCODES Required
When OWK-SEL-CURR != Spaces
OWK-SEL-CURR -> CUC-CURRENCY-CODE
Sel Location ICLOCATION Required
When OWK-SEL-BASE-LOC != Spaces
OWK-COMPANY -> ICL-COMPANY
OWK-SEL-BASE-LOC -> ICL-LOCATION
Upd Curr CUCODES Required
When OWK-UPD-CURR != Spaces
OWK-UPD-CURR -> CUC-CURRENCY-CODE
Upd Location ICLOCATION Required
When OWK-UPD-LOC != Spaces
OWK-COMPANY -> ICL-COMPANY
OWK-UPD-LOC -> ICL-LOCATION
OEWKSHEET FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemloc ITEMLOC Required
When OWK-SEL-BASE-LOC != Spaces
OWK-COMPANY -> ITL-COMPANY
OWK-SEL-LOCATION -> ITL-LOCATION
ITL-ITEM
Oeselbase OEBASE Required
When OWK-SEL-BASE != Spaces
OWK-COMPANY -> OEB-COMPANY
OWK-SEL-BASE-LOC -> OEB-LOCATION
OWK-SEL-BASE -> OEB-BASE-NAME
OEB-CURRENCY-CODE
OEB-ITEM
Oeupdbase OEBASE
OWK-COMPANY -> OEB-COMPANY
OWK-UPD-LOC -> OEB-LOCATION
OWK-UPD-BASE -> OEB-BASE-NAME
OEB-CURRENCY-CODE
OEB-ITEM
Oewkprice OEWKPRICE
OWK-COMPANY -> OWP-COMPANY
OWK-WORK-NAME -> OWP-WORK-NAME
OWP-ITEM
|
