You must create a billable charge read details upload record for each calculation detail to be uploaded. The name of this table is CI_BCHG_UP_READ. 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. |
|
SP_ID |
10 |
Y |
Char |
Leave this column blank. It is not used. |
|
SEQNO |
5 |
Y |
Number |
This should be a value greater than zero. |
|
END_READ_DTTM |
26 |
Y |
DateTime |
This is the date and time of the end quantity |
|
END_REG_READ_ID |
12 |
N |
Char |
Leave this column blank. It is not used. |
|
END_REG_READING |
9.6 |
Y |
Number |
This is the end quantity. |
|
FINAL_REG_QTY |
12.6 |
Y |
Number |
This is the final quantity |
|
FINAL_SQI |
8 |
N |
Char |
The rate quantity identifier of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_SQI. Note, at least one of the following fields should be specified: FINAL_SQI, FINAL_UOM_CD. |
|
FINAL_TOU_CD |
8 |
N |
Char |
The time-of-use code of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_TOU. |
|
FINAL_UOM_CD |
4 |
N |
Char |
The unit of measure of the FINAL_REG_QTY. If specified, it must reference a valid value on CI_UOM. Note, at least one of the following fields should be specified: FINAL_SQI, FINAL_UOM_CD. |
|
HOW_TO_USE_FLG |
2 |
Y |
Char |
See the field description in the data dictionary for the valid values ( CI_BCHG_UP_READ). |
|
MSR_PEAK_QTY_SW |
1 |
Y |
Char |
Y or N |
|
MSR_QTY |
12.6 |
Y |
Number |
Quantity. This is the difference between end quantity and start quantity. |
|
REG_CONST |
6.6 |
Y |
Number |
This is the constant value used to adjust the quantity. Set this to a value of 1 if it is not known. |
|
SQI_CD |
8 |
N |
The rate quantity identifier of end quantity and start quantity. 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. |
|
|
START_READ_DTTM |
26 |
Y |
DateTime |
This is the date and time of the start quantity. |
|
START_REG_READ_ID |
12 |
Y |
Char |
Leave this column blank. It is not used. |
|
START_REG_READING |
9.6 |
Y |
Number |
This is the start quantity |
|
TOU_CD |
8 |
N |
Char |
The time-of-use code of end quantity and start quantity. If specified, it must reference a valid value on CI_TOU. |
|
UOM_CD |
4 |
Y |
Char |
The unit of measure of end quantity and start quantity. |
|
USAGE_FLG |
2 |
Y |
Char |
Leave this column blank. It is not used. |
|
USE_PCT |
3 |
Y |
Number |
This is the percentage of the quantity that was billed (this will typically be 100). |
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.