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.
Parent topic