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