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.