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.