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 |