Column Name | Length | Req'd | Data Type | Comments |
MR_STAGE_UP_ID | 12 | Y | A/N | This must correspond with the prime key of the related CI_MR_STAGE_UP record. |
CHAR_TYPE_CD | 8 | Y | A/N | This must correspond with a characteristic type that is defined as valid for meter read upload staging. Refer to Setting Up Characteristic Types & Their Values for more information |
SEQ_NUM | 3 | Y | N | This should be set to 1 unless you have multiple values for a given meter read upload staging and characteristic type. |
ADHOC_CHAR_VAL | 254 | N | A/N | Populate this field if your characteristic type is ad-hoc or file location. |
CHAR_VAL | 16 | N | A/N | Populate this field if your characteristic type is predefined |
CHAR_VAL_FK1 - CHAR_VAL_FK5 | 50 (each) | N | A/N | Populate these fields if your characteristic type is a foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys. |