Bill Suggestions
Most companies have found it impossible to load bill segment item, bill calculation 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 SPL CC&B would use to create them. This information is used to create the reversing GL entry when the bill segment is canceled.
Parent topic