Bill

Bill Data Model

Contents

Bill - Main

The following data model illustrates the bill object.

Bill Data Model

Bill - FT

The following data model illustrates the FT that must be associated with a bill segment.

Bill Segment FT Data Model

Bill Characteristics

The following data model illustrates Bill Characteristics.

Bill Characteristics Data Model

Bill Messages and Routing

The following data model illustrates Bill Messages and Bill Routing.

Bill Messages and Bill Routing

Bill Table Names

*Data Model Name*	*Table Name*	*Generated Keys*	*Referential Integrity Validation Batch Control*	*Key Assignment Batch Control*	*Insertion Batch Control*
Bill	CI_BILL	Yes CI_BILL_K	CIPVBLLV	CIPVBILK Has dependencies	CIPVBLLI
Obligation Balance Snapshot	CI_BILL_SA	No. The key is bill ID plus obligation ID.	CIPVBSAV		CIPVBSAI
Bill Segment	CI_BSEG	Yes CI_BSEG_K	CIPVSEGV	CIPVBSGK Has dependencies	CIPVSEGI
Calc Header	CI_BSEG_CALC	No. The key is bill segment id and a sequence number	CIPVBSCV		CIPVBSCI
Calc Lines	CI_BSEG_CALC_LN	No. The key is bill segment id, the header sequence number, and a sequence number	CIPVBSLV		CIPVBSLI
Read Detail	CI_BSEG_READ	No. The key is bill segment id and a sequence number.	CIPVSRRV		CIPVSRRI
Asset Detail	CI_BSEG_ITEM	No. The key is bill segment id and a sequence number	CIPVBSIV		CIPVBSII
Rate Quantity	CI_BSEG_SQ	No. The key is bill segment id, uom code, tou code and RQI code	CIPVSQTV		CIPVSQTI
FT (financial transaction)	CI_FT	Yes CI_FT_K	CIPVFTFV	CIPVFTXK Has dependencies	CIPVFTFI
FT Characteristic	CI_FT_CHAR	No. The key is FT id, char type code and a sequence number	CIPVFTCV		CIPVFTCI
FT GL (FT general ledger)	CI_FT_GL	No. The key is FT id and a GL sequence number	CIPVFTGV		CIPVFTGI
Characteristics	CI_BILL_CHAR	No. The key is bill id, char type code and a sequence number	CIPVBCHV		CIPVBCHI
Bill Messages	CI_BILL_MSGS	No. The key is bill id and bill message code.	CIPVBLMV		CIPVBLMI
Bill Routing	CI_BILL_ROUTING	No. The key is bill id and a sequence number	CIPVBLRV		CIPVBLRI

Bill Suggestions

Most companies have found it impossible to load bill segment item, bill calc header and lines with sufficient information and therefore these tables are not populated. See the comments in the above ERD's for more information.

Please populate the columns on the FT that's associated with the bill segment as follows:

CUR_AMT should be set equal to the bill segment amount
PAY_AMT should be set equal to the bill segment amount
CRE_DTTM should be set equal to the bill segment end date / time
FREEZE_SW should be "Y"
FREEZE_DTTM should be set equal to the bill segment end date / time
ARS_DT should be set equal to the bill segment end date
CORRECTION_SW should be "N"
REDUNDANT_SW should be "N"
NEW_DEBIT_SW should be "N"
NOT_IN_ARS_SW should be set to "N"
SHOW_ON_BILL_SW should be set to "N"
ACCOUNTING_DT should be set to the current date
SCHED_DISTRIB_DT should be left blank
CURRENCY_CD should be the currency on the installation record
BAL_CTL_GRP_ID should be left blank
XFERRED_OUT_SW should be set to "Y"
PARENT_ID should be set to the bill ID
SIBLING_ID should be set to the bill segment ID
Do NOT create any GL details for the FT. If GL details are converted, ensure they are populated with the EXACT information the system would use to create them. This information is used to create the reversing GL entry when the bill segment is canceled.