Individual Transaction Upload

Perform a mass import of client account registration information and account transaction postings.

Avatar CFMS > Banking Reports > Individual Transaction Upload

This form has the capability of compiling a flat text file and placing that information in either the Account Registration table (SYSTEM.cf_acct_registration) or the Account Transaction table (SYSTEM.cf_acct_transaction_detail). There are two record types that can be imported through this form:

• ACC Record format - This is the Account Registration flat file. This file contains all of the information that would be entered through the Account Registration form.
• TRN Record format - This is the Account Transaction flat file. This file contains all of the information that would be entered through the Individual Transaction Posting form.

1. Create a tab delimited or positional transaction file.

• Use any Windows-based word processing program. Save the document as a text (.txt) file.
• Follow each column with a carriage return (ASCII character 13), and a line feed (ASCII character 10).

2. Open the Individual Transaction Upload form.
3. Type the path and file name in the File Name field.
4. Click Submit.