Billable Charge Service Quantity Upload Staging Layout

You must create a billable charge service quantity upload record for each service quantity to be uploaded. The name of this table is CI_BCHG_UP_SQ. The following table describes each column on this table. Refer to "pass through" charges for more information about how this type of information is used.

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.
SEQ_NUM	3	Y	N	Sequence of the service quantity within the Billable Charge Upload
UOM_CD	30	N	Varchar	The unit of measure of the Billable Charge Upload SQ row. If specified, it must reference a valid value on CI_UOM. Note, at least one of the following fields should be specified: SQI_CD, TOU_CD, UOM_CD.
TOU_CD	30	N	Char	The time of use of the Billable Charge Upload SQ row. If specified, it must reference a valid value on CI_TOU. Note, at least one of the following fields should be specified: SQI_CD, TOU_CD, UOM_CD.
SQI_CD	30	N	Varchar	The service quantity identifier of the Billable Charge Upload SQ row. If specified, it must reference a valid value on CI_SQI. Note, at least one of the following fields should be specified: SQI_CD, TOU_CD, UOM_CD.
SVC_QTY	12.6	N	N	Quantity of the service used for the UOM / TOU / SQI combination