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.