Outbound Customer Extracts To Payment Agencies Batch

17.3.10 Outbound Customer Extracts To Payment Agencies Batch

An outbound customer extract file can be generated and sent to multiple payment vendors like Money gram, Quick Collect, Speed Pay from Western Union, Lockbox etc. Sharing this extract enables various outlets of these payment agencies to verify account’s existence in FI and proceed with payment processing.

After receiving the payment extract file, the vendor validates customer details and sends a notification confirmation of Payment in NACHA format.

In case of Master and its associated accounts, the Output File Definition for Customer Payment File Extract (CUST_PAYMENT_EXTRACT) has a consolidation of all account dues at Master account level based on system parameter OCP_CUST_PMT_PREF (MASTER ACCOUNT ROLLUP FOR PMT EXTRACT FILE).

The Column Definitions for Customer Payment File Extract has predefined columns to populate individual account dues and consolidated master account dues. However, for accounts having no Master account, consolidation is not done and system does not display rolled-up dues in Master column fields.

The basis of dues consolidation at Master account level is controlled based on the following:

Consolidation preference defined at Contract setup for individual account

Any of the following values defined for system parameter OCP_CUST_PMT_PREF (MASTER ACCOUNT ROLLUP FOR PMT EXTRACT FILE).

Table 17-26 Dues consolidation at Master account level

Parameter Value (if selected)	Action
Master and All Associated Accounts of Same Currency and Company	Customer Payment File Extract displays rolledup dues for Master and its associated accounts of same currency and company.
Master and All Associated accounts of Same Currency, Company and Statement Consolidation	Customer Payment File Extract displays rolledup dues for Master and its associated accounts of same currency, company and having Statement Consolidation = Y
Master and All Associated account of Same Product type, Currency and Company	Customer Payment File Extract displays rolledup dues for Master and its associated account of same currency, company and Product Type.
Master and All Associated account of Same Product type, Currency, Company and Statement Consolidation	Customer Payment File Extract displays rolledup dues for Master and its associated account of same currency, company, Product Type and having Statement Consolidation = Y

Processing

The system generates customer extract of customers from which payment is expected, everyday. This process is configured as Outbound Customer Extracts To Payment Agencies Batch batch job OCPPRC_BJ_100_01 defined in SET-ODD2 Batch Job Set which is run daily. The batch generated an extract in text format containing all Accounts relevant details.

Accounts with payment mode ACH or Lockbox can be excluded. The system facilitates setting-up options to pick up payment modes that needs to be included in extract generation.

This file is stored in a configurable shared path from which it is shared to required outlets as discussed earlier.

Parent topic: Payments