Create a Format Map for ACH Export Files

Use Format Mapping Maintenance (XMAP) to map an export file that will be generated during the vendor payment process. Your PowerShift Support Representative can provide a sample format that you can adjust to meet the requirements of your financial institution.

The program displays:

Field Name	Displays
Format no	The order type
Description	The description of the format
Type	Mapping type: B: Banking C: Custom M: Manifest
Type	File type: O: Output (i.e., for export) I: Input (i.e., for import) D: Data import (CSV file)

Choose the appropriate options:

To	Do This
Add a format number	Click Add.
Delete the selected number	Click Delete. See Delete.
Copy the selected format	Click Copy. See Copy.
Display the selected format	Click Select or double click the line.
Print the format number listing	Click Print. See Print.
Exit the program	Click Exit.

Enter/review data in these fields:

Field Name	Type / Max Length	Action / Description
Description	Required 35 alphanumeric	Enter the description of the file.
Mapping type	Required 1 alpha	Select B for a bank mapping type.
Type	Conditional 1 alpha	Select O for an output mapping type.
Output file name	Required 8 alphanumeric maximum	Enter the output file name. The 8-character maximum includes the sequence number (the size of which you specify in the File seq size parameter). Example: If the Output file name is POSPAY and you set the file sequence to 2, the file created in the first payment register would be POSPAY00. The next run creates POSPAY01. If the 00 file is erased, the program reuses it before advancing to 02.
File type	Conditional 1 alpha	Typically, the positive pay file is output as a sequential file. Select D for a sequential file.
Record length	Optional 999 numeric	Enter the length of the record.
Key size	Conditional 999 numeric	If you selected K for the File type, enter a key size.
File seq size	Conditional 7 numeric maximum	Enter the number of digits to append to the specified Output file name as an incremental sequence number or leave blank. The combination of the Output file name and the File seq size cannot exceed 8 characters.
Delimiter	Optional 1 alphanumeric	Enter the field delimiter. It is not validated. Good delimiter choices are \| (pipe character) and ; (semicolon). You should not choose a character that is likely to appear in your data, such as these numeric symbols: [, (, ), -, %,], or these special characters: ), @, #.
Update program	Not applicable	Not applicable.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field and make changes. Click Apply to accept or click Cancel to abandon changes.
Delete a saved record	Click Delete. See Delete.
Enter file layout specification	Click Layout. See Enter Mapping File Layout.
Accept the data	Click OK. The program returns to the Format number field if this was a newly added format; it returns to the list of formats if you viewed or maintained an existing one.