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 |