You must create an upload staging record for each billable charge. The name of this table is CI_BCHG_UP. The following table describes each column on this table.
|
Column Name |
Length |
Req'd |
Data Type |
Comments |
|
BCHG_UP_ID |
30 |
Y |
Char |
This is the unique identifier of the record. This value does NOT have to be a random number, but it does need to be unique. If your process that inserts records on this table is capable of calling a COBOL routine, call CIPCKEYG and it will supply a 12 digit random number for you. |
|
BCHG_UP_STAT_FLG |
2 |
Y |
Char |
This must be set to P for Pending. |
|
NT_XID_CD |
30 |
N |
Char |
Leave this column blank. |
|
SA_EXT_REF_ID |
36 |
N |
Varchar2 |
Leave this column blank. |
|
BCHG_EXT_REF_ID |
50 |
N |
Varchar2 |
This is the identifier of the billable charge in the sender's system. |
|
CRE_DTTM |
26 |
N |
Date/Time |
The date and time the upload staging row was inserted (this can be used for audit purposes). |
|
START_DT |
10 |
Y |
Date |
The start date of the period encompassed by the billable charge. |
|
END_DT |
10 |
Y |
Date |
The end date of the billable charge period. |
|
DESCR_ON_BILL |
80 |
Y |
Varchar2 |
This is the description that should prefix the charges on the printed bill. |
|
SA_ID |
10 |
See note |
Char |
This must correspond with an obligation ID of a billable charge obligation. |
|
BILLABLE_CHG_ID |
12 |
N |
Char |
Leave this column blank. It will be assigned by the system when it creates a billable charge record. |
Copyright © 2007, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 8.3.2015 14:40:38 [T1_1438638038000]