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