Payment Suggestions
We recommend that you use the system to create a single deposit control and link to it a single tender control using the PRODUCTION tables. The tender control should reference a tender source of "conversion". Use the prime key of the tender control as the foreign key on the tenders that you insert into the STAGING tables. This means you will have an invalid foreign key relationship on CI_​PAY_​TNDR (it will reference a tender control that doesn't exist).
After converting the payments:
• Re-access the tender control in production and enter the appropriate amounts (per tender type) to balance the tender control.
• Re-access the deposit control in production and enter the appropriate amounts to balance the deposit control.
Please populate the columns on the FT that's associated with the payment segment as follows:
• CUR_​AMT should be set equal to the payment segment amount
• PAY_​AMT should be set equal to the payment segment amount
• CRE_​DTTM should be set equal to the payment segment date / time
• FREEZE_​SW should be "Y"
• FREEZE_​DTTM should be set equal to the payment segment date / time
• ARS_​DT should be set equal to the payment segment 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" on all payments other than payments that have been received since the last bill. For recent payments that you want to show on the next bill, this switch must be "Y"
• 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 payment ID
• SIBLING_​ID should be set to the payment 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 payment segment is canceled.