Bill

Bill Data Model

Bill - Main

The following data model illustrates the bill object.

Bill Data Model

Bill - Calculation Line

The following data model illustrates the bill calculation line and important references.

Bill Calculation Line 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 Table Names

Data Model Name

Table Name

Generated Keys

Referential Integrity Validation Batch Control

Key Assignment Batch Control

Insertion Batch Control

Bill

C1_​TAX_​BILL

Yes C1_​TAX_​BILL_​K

CTPVTBIV

CTPVTBIK

Has dependencies

CTPVTBII

Bill Calculation Line

C1_​TAX_​BILL_​CALC_​LN

No. The key is bill ID plus sequence number.

CTPVTBCV

CTPVTBCI

Bill Segment

C1_​TAX_​BILL_​SEG

Yes C1_​TAX_​BILL_​SEG_​K

CTPVTBSV

CTPVTBSK

Has dependencies

CTPVTBSI

Bill Value Detail

C1_​TAX_​BILL_​VAL_​DTL

No. The key is bill id and a sequence number.

CTPVTBDV

CTPVTBDI

Bill Characteristics

C1_​TAX_​BILL_​CHAR

No. The key is bill segment id, the char type, and a sequence number.

CTPVTBHV

CTPVTBHI

Bill Log

C1_​TAX_​BILL_​LOG

No. The key is bill id and a sequence number.

CTPVTBLV

CTPVTBLI

Bill Log Parameter

C1_​TAX_​BILL_​LOG_​PARM

No. The key is bill id, sequence number and a parm sequence number.

CTPVTBPV

CTPVTBPI

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

Bill Suggestions

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