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 | CIPVBLLI |
SA Balance Snapshot | CI_BILL_SA | No. The key is bill ID plus SA ID. | CIPVBSAV | CIPVBSAI | |
Bill Segment | CI_BSEG | Yes (CI_BSEG_K) | CIPVSEGV | CIPVBSGK | 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, SP ID and a sequence number | CIPVSRRV | CIPVSRRI | |
Item Detail | CI_BSEG_ITEM | No. The key is bill segment id and a sequence number | CIPVBSIV | CIPVBSII | |
Service Quantity | CI_BSEG_SQ | No. The key is bill segment ID, uom code, tou code and SQI code | CIPVSQTV | CIPVSQTI | |
FT (financial transaction) | CI_FT | Yes (CI_FT_K) | CIPVFTFV | CIPVFTXK | CIPVFTFI |
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 Review Schedule | CI_BILL_RVW_SCH | No. The key is bill ID, bill review date and batch code. | CIPVBRVV | CIPVBRVI |