User Defined File Format Tab of Bank Codes
The file format information that you enter on the User Defined File Format tab is used to create a text (.txt) file that contains payment information that is processed by a third-party software application.
On this tab you match (map) Vision fields and information with your bank's text file requirements. You can set up user-defined file formats for electronic funds transfer (EFT) requirements of many international banks, including BACS (Bankers Automated Clearing System) files used in the United Kingdom. The text files are created in Vision when you select the Export to Text option for:
-
Accounts payable payments
-
Employee expense payments
This tab is available only if you select User Defined in the Export to Text Format field on the Bank Codes tab.
Contents
Pad Blocks
File Creation Date
Employee Grid
After you select a line type in the Line Type field, use the Employee grid rows to enter each piece of information for that line type that your bank requires for an employee expense payment.
Vendor Grid
After you select a line type in the Line Type field, use the Vendor grid rows to enter each piece of information for that line type that your bank requires for a vendor payment.
Field | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Vendor Drop-down |
Click the drop-down arrow on a grid header to complete any of the following actions:
Not all options are available on all grids. |
||||||||||||
Insert | Click this option to add a row to the grid. | ||||||||||||
Top Up Down Bottom |
Use these options to move rows in the grid. Select a row (click anywhere in the row), and then click one of the toolbar options to move a row in the grid. The order of the rows in the grid determines the order of the fields in the text files for both CSV and fixed length file types. |
||||||||||||
Delete | To delete a row in the grid, select the row and click this option. | ||||||||||||
Field Number |
Enter a number to identify this field. Both CSV and fixed length file types use the field number to identify fields that are used in calculations. When you select Calculation in the Data Mapping column of this grid, you must enter a field number in the Field No column. |
||||||||||||
Length | Enter the number of characters that your bank requires for this field. This field is enabled only if you select Fixed Length in the File Type field. | ||||||||||||
Start |
Enter the number of the starting position of this field in the text file. This is based on the number of characters to the right of the first character in the file. Some file formats define an end position. Vision will calculate the end position based on the starting position and the length. This field is enabled only if you select Fixed Length in the File Type field. |
||||||||||||
Description | Enter a description to help identify the contents of this field. This description is not used in the text file itself. It is for informational purposes only. | ||||||||||||
Data Mapping |
Click in this field to enable the drop-down list, and from the list, select the type of information that is contained in the field that is entered in the row. The options are:
|
||||||||||||
Mapping Value |
Based on the type of information that you selected in the Data Mapping field, enter the specific contents of the text file field in the Mapping Value field.
|
||||||||||||
Calculation |
You can use calculations for control total information, such as entry or addenda counts, entry hash totals, total debit entry dollar amount, total credit entry dollar amount, and batch number. Click the Calculation field and then click the to open the Calculation Details dialog box. In the dialog box, enter the information for the calculation in this field. This field is enabled only if you select Calculation in the Data Mapping field. |
||||||||||||
Pad Character |
Enter the character to use to fill (pad) blank spaces that remain in this field when the field is left or right justified. For example, if a field contains the Vision Vendor Name and a vendor's name takes up only 12 of the 30 spaces that are allotted for the name, the remaining 18 spaces are filled with a character that you choose as the pad character. When you leave this field blank, Vision pads with spaces. This field is enabled only when you select Fixed Length in the File Type field. |
||||||||||||
Justify | Select the justification for the contents of the field: Left or Right. This field is enabled only when you select Fixed Length in the File Type field. |