Billable Charge Line Characteristic Upload Staging Layout
If you want to upload characteristics on your billable charge lines, you must create a billable charge line characteristic upload record for each characteristic on each line. The name of this table is CI_B_LN_UP_CHAR . The following table describes each column on this table.
| Column Name | Length | Req'd | Data Type | Comments |
|---|---|---|---|---|
| BCHG_UP_ID | 30 | Y | Char | This is the foreign key to the billable charge upload staging record. |
| LINE_SEQ | 3 | Y | N | This is the foreign key to the billable charge line upload staging record |
| CHAR_TYPE_CD | 8 | Y | Char | This is the unique identifier of the billable charge line characteristics. This value must be unique within the billable charge line characteristics. |
| CHAR_VAL | 16 | N | Char | A characteristic value must be supplied if the ad hoc switch on characteristic type is N. Otherwise, it is not allowed. |
| ADHOC_CHAR_VAL | 30 | N | Varchar2 | An ad hoc characteristic value must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |