You must create a billable charge rate quantity upload record for each rate 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 rate quantity within the Billable Charge Upload |
|
UOM_CD |
4 |
N |
Char |
The unit of measure of the Billable Charge Upload RQ 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 |
8 |
N |
Char |
The time of use of the Billable Charge Upload RQ 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 |
8 |
N |
Char |
The rate quantity identifier of the Billable Charge Upload RQ 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 rate used for the UOM / TOU / RQI combination |
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.