Menu Path: System Administration Tools Bank Extract Format Maintenance
Set up and maintain bank extract formats.
Use Bank Extract Format Maintenance to create, edit, and delete bank extract formats, which are used to export direct deposit and direct debit information to banks. The formats you define should match the requirements provided by your bank. You can assign bank extract formats to banks in Bank Code Maintenance.
To create a bank extract format:
If your company uses consolidation ledgers, verify the ledger ID for which you want to create a bank extract format is entered in the Ledger ID field.
Click the New button in the ribbon.
If the bank extract format is for direct debits, select the Direct Debit radio button. Otherwise, leave the Direct Deposit radio button selected.
Selected whether data will be exported with a delimiter separating each field (Delimited) or with fixed-width columns (Positional). For delimited bank extract formats, specify the delimiter character, and optionally an enclosing character.
Select date and time formats for exported data.
Select the file format for exported data.
Select fields for the detail record of the bank extract format. You can select database fields from the Available Fields grid, or select the Static Value check box, and manually enter fields that are constant values (or blank spaces). Use the right-arrow button to select either type of field.
If the bank extract format will have header and/or summary records (in addition to detail records), select the appropriate record type, and select fields for the record as you did for the detail record in step 7.
Click the OK ribbon button. The bank extract format is created.
Button |
Description |
Exit |
Click this button to close the Bank Extract Format Maintenance window. |
New |
Click this button to create a new bank extract format. |
Update |
Click this button to update the selected bank extract format. |
Delete |
Click this button to delete the selected bank extract format. |
OK |
Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon. |
Cancel |
Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon. |
First |
Click this button to display the first bank extract format. |
Prev |
Click this button to display the previous bank extract format. |
Next |
Click this button to display the next bank extract format. |
Last |
Click this button to display the last bank extract format. |
Field or Button |
Description |
Enter a name for the bank extract format, or click the Lookup button to select a previously created bank extract format. |
|
Select whether the bank extract format is used to transmit direct deposit or direct debit information. The Direct Deposit radio button is selected by default. |
|
Enter a ledger ID for the bank extract format, or click the Lookup button to select a ledger ID. Note This field is only available if at least one consolidation ledger is set up. |
Field or Button |
Description |
Select whether data in the bank extract format is separated by a delimiter character or is in fixed-width columns. If you select Delimited, you must enter a delimiter character. If you select Positional, you must specify the length of each column. The Delimited radio button is selected by default. |
|
Click the Lookup button to select the date format for the bank extract format. |
|
Click the Lookup button to select the file format for the bank extract format. You can select one of the following file formats:
|
|
Click the Lookup button to select the time format for the bank extract format. |
|
Enter a delimiter character used to separate data for the bank extract format. This field is only available if the Delimited radio button is selected, and a file format other than Excel is selected for the Save As Type field. EXAMPLE If the bank requires commas between exported fields, enter a comma in this field. |
|
If you want to use single or double quotation marks around data exported for the bank extract format, enter ' or " in this field. This field is only available if the Delimited radio button is selected, and a file format other than Excel is selected for the Save As Type field. |
|
Select this check box to add database fields to the selected record type of the bank extract format, then use the Available Fields grid to specify the fields. |
|
Select this check box if you want to add a constant value to the selected record type of the bank extract format, then enter the value in the field to the right of the check box, and click the right-arrow button. NOTE You cannot include spaces at the end of static values. Do not include delimiter characters in static values. |
|
Click the Lookup button to select a record type (header, detail, or summary) for the bank extract format for which you want to specify or view fields. A bank extract format must have a detail record, but header and summary records are optional. This defaults to Detail. |
|
This grid displays field that you can add to the selected record type of the bank extract format. This grid is only enabled if the Field Value check box is selected. To add a field to the selected record type, double-click it, or select it, and click the right-arrow button. |
|
Click this button to add the selected field in the Available Fields grid or the entered field in the Static Value field to the Selected Fields grid (for the selected record type). |
|
Click this button to remove the selected field in the Selected Fields grid. |
|
This grid displays fields selected for the selected record type of the bank extract format. You can add information in the Description column to provide detailed information about the field. If the bank extract format is positional, you can also modify the Position and Max Length columns to specify the position and length of each field. For the Position column, enter 1 for the first field, 2 for the second field, etc. |
|
Click this button to move the selected field in the Selected Fields grid up one position in the bank extract format for the selected record type. This button is only enabled if the Delimited radio button is selected. |
|
Click this button to move the selected field in the Selected Fields grid down one position in the bank extract format for the selected record type. This button is only enabled if the Delimited radio button is selected. |