Billable Charge Upload Staging Layout
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 routine, call ProgramCIPZKEYG 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 |
This is the external system id of the sender of the billable charge. See the description of the SA_EXT_REFT_ID field for how this field is used to determine the billable charge's SA_ID. |
SA_EXT_REF_ID |
36 |
N |
Varchar2 |
This field along with NT_XID_CD are used to uniquely identify the service agreement against which the billable charge will be stored. These two fields are used to identify a SA relationship record; the SA relationship record, in turn, has a sub SA and it is this SA that the billable charge will be linked to. Note well: these fields are only necessary if you do not know the billable charge SA ID. Refer to Maintaining SA Relationships for more information. |
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 |
254 |
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 a SA ID of a billable charge service agreement. You may leave this column blank if NT_XID_CD and SA_EXT_REF_ID are populated. |
BILLABLE_CHG_ID |
12 |
N |
Char |
Leave this column blank. It will be assigned by the system when it creates a billable charge record. |