Adjustment Staging Control Characteristic
You must create an adjustment staging control characteristic record for each characteristic that you would like to link to the adjustment staging control. The name of this table is CI_ADJ_STG_CTL_CHAR. The following describes each column on this table.
|
Column Name |
Length |
Req'd |
Data Type |
Comments |
|
ADJ_STG_CTL_ID |
12 |
Y |
N |
This must correspond with the prime key of the related CI_ADJ_STG_CTL record. |
|
CHAR_TYPE_CD |
8 |
Y |
A/N |
This must correspond with a characteristic type that is defined as valid for adjustment staging control. 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 staging control 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. |