Bill - Main
The following data model illustrates the bill object.
Bill - Calculation Line
The following data model illustrates the bill calculation line and important references.
Bill - FT
The following data model illustrates the FT that must be associated with a bill segment.
Data Model Name |
Table Name |
Generated Keys |
Referential Integrity Validation Batch Control |
Key Assignment Batch Control |
Insertion Batch Control |
Bill |
Yes C1_TAX_BILL_K |
CTPVTBIV |
CTPVTBIK |
CTPVTBII |
|
Bill Calculation Line |
No. The key is bill ID plus sequence number. |
CTPVTBCV |
CTPVTBCI |
||
Bill Segment |
CTPVTBSV |
CTPVTBSK |
CTPVTBSI |
||
Bill Value Detail |
No. The key is bill id and a sequence number. |
CTPVTBDV |
CTPVTBDI |
||
Bill Characteristics |
No. The key is bill segment id, the char type, and a sequence number. |
CTPVTBHV |
CTPVTBHI |
||
Bill Log |
No. The key is bill id and a sequence number. |
CTPVTBLV |
CTPVTBLI |
||
Bill Log Parameter |
No. The key is bill id, sequence number and a parm sequence number. |
CTPVTBPV |
CTPVTBPI |
||
FT (financial transaction) |
Yes CI_FT_K |
CIPVFTFV |
CIPVFTXK |
CIPVFTFI |
|
FT Characteristic |
No. The key is FT id, char type code and a sequence number |
CIPVFTCV |
CIPVFTCI |
||
FT GL (FT general ledger) |
No. The key is FT id and a GL sequence number |
CIPVFTGV |
CIPVFTGI |
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.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]