|
Ordinal
|
Description
|
Data
Type
|
Data
Length
|
Required
|
Check
Constraints
|
Comments
|
|
1
|
Category ID
|
string
|
30
|
Y
|
|
XREF
lookup is used to determine the row to update other a new row is created.
|
|
2
|
Category Name
|
string
|
30
|
|
|
|
|
3
|
Parent Category
|
string
|
30
|
|
|
Optionally,
a category can reference a parent category in the same table in order to
build a hierarchy
|
|
4
|
Category Group Code
|
string
|
10
|
|
|
Optionally,
a category can be grouped by a code which can be used for certain price
matrix types
|
|
5
|
Price Adj Basis Code
|
string
|
30
|
|
|
As
part of the pricing system, the price basis for calculation can be redirected
to use the item category basis as opposed to the local basis code stored with
the price adjustment (matrix) records. See KS_PRICE_ADJS export
specification.
|
|
6
|
Override Basis Code
|
string
|
30
|
|
|
Used
in conjunction with the field above. The pricing system uses the local basis
code to lookup by item category the price adjustment basis code and use the
corresponding override basis code. (Eclipse)
|