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. |