Adjustment Characteristic Upload Staging
You must create an adjustment characteristic upload staging record for each characteristic that you would like to link to the adjustment upload staging. The name of this table is CI_​ADJ_​STG_​UP_​CHAR. The following describes each column on this table.
Column Name
Length
Req'd
Data Type
Comments
ADJ_​STG_​UP_​ID
12
Y
N
This must correspond with the prime key of the related CI_​ADJ_​STG_​UP record.
CHAR_​TYPE_​CD
8
Y
A/N
This must correspond with a characteristic type that is defined as valid for adjustment Refer to Setting Up Characteristic Types & Their Values for more information.
SEQ_​NUM
3
Y
N
This should be set to 10 unless you have multiple values for a given adjustment upload staging and characteristic type.
CHAR_​VAL
16
N
A/N
Populate this field if your characteristic type is predefined.
ADHOC_​CHAR_​VAL
254
N
A/N
Populate this field if your characteristic type is ad-hoc or file location.
CHAR_​VAL_​FK1 - CHAR_​VAL_​FK5
50 each
N
A/N
Populate these fields if your characteristic type is foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys.