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, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]