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. |
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. |
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. |
CHAR_VAL_FK1 |
50 |
N |
Varchar2 |
A characteristic value foreign key must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |
CHAR_VAL_FK2 |
50 |
N |
Varchar2 |
A characteristic value foreign key must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |
CHAR_VAL_FK3 |
50 |
N |
Varchar2 |
A characteristic value foreign key must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |
CHAR_VAL_FK4 |
50 |
N |
Varchar2 |
A characteristic value foreign key must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |
CHAR_VAL_FK5 |
50 |
N |
Varchar2 |
A characteristic value foreign key must be supplied if the ad hoc switch on characteristic type is Y. Otherwise, it is not allowed. |