Bank Account Record ID
Bank
The bank where the bank account resides.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
Name
A unique name for the bank account.
Description
A description of the bank account.
Bank Account tab
Bank Account Number
The account number of the bank account.
Account Type
The type of bank account. Valid options are:
GL Batch
The GL batch for statement adjustment postings.
EFT table
Type
The type of EFT profile defined on the current row. Valid options are:
Note
Once you select a value in the Type column and tab off the detail line, the Type field becomes disabled. If you select the wrong type, leave the detail line, and then need to change it, you must delete the detail line and enter a new detail line with the correct type. This precaution prevents you from changing the type in error and losing set-up information.
AP
If marked, indicates the EFT profile is used for Accounts Payable EFT payments or for printing AP checks. AP can only be marked on one detail line. Both AP and PR can be marked on the same detail line; this is typical. This checkbox is only visible if the Accounts Payable package is installed.
PR
If marked, indicates the EFT profile is used for payroll direct deposits or for printing payroll checks. PR can only be marked on one detail line. Both PR and AP can be marked on the same detail line; this is typical. This checkbox is only visible if the Payroll package is installed.
Memo
Additional information about the EFT profile defined on the current row.
ACH fields
The following fields are visible when you select "ACH" in the Type field.
Information
ABA Routing Number
The bank's routing number. The routing number is used for automatic clearing of banking information. It contains routing and identifying information that allows any clearinghouse or financial institution in the United States to determine the correct bank. Currently, the ABA routing number is only used when the offsetting entry is included in the ACH file.
Last Detail Sequence Number
The starting number for detail records. This value is system-maintained after initial setup whenever a direct deposit file is created and the checks are marked as disbursed. The detail sequence number occupies positions 9-15 of the Trace Number in a direct deposit file.
Settlement Date Format
The characters to use to fill in the tens digit in settlement dates with months and/or days less than 10. Valid options are:
Create Offsetting Entry
If marked, this checkbox indicates the ACH file should include the offsetting entry for the transactions in the file. If your bank makes the offsetting entry, ensure the checkbox is cleared.
Service Class Code
The code that indicates the type(s) of transactions in the ACH file. Valid options are:
- 200. The file contains both credit and debit entries. If the Create Offsetting Entries? checkbox is marked, this option should be selected.
- 220. The file contains only credit entries.
Security Header
Include Security Header
If the checkbox is marked, indicates that ACH files should include security header information. Some banks require the security header.
Text
The security header information, provided by your bank, which will be included at the top of your ACH files. This field is enabled if the Include Security Header checkbox is marked.
Length
The length of the security header content in the Text field. Use this information to verify that the header length is correct.
Immediate Destination
Routing Number (with Prefix)
The routing number of the receiving point bank. Typically, the first position is blank, followed by the four-digit Federal Reserve routing symbol, the four-digit ABA institution ID, and the check digit. The routing number is part of the File Header record and is required.
Name
The name of the receiving point bank. The immediate destination name is part of the File Header record and is optional.
Company
ID (with Prefix)
The ID assigned to your company by the bank. The first character of the ID, the prefix, is one of the following values:
- 1. Indicates that the ID is the IRS Employer ID (EIN). (This is the prefix typically used.)
- 3. Indicates that the ID is the Data Universal Numbering System (DUNS) number.
- 9. Indicates that the ID is a number assigned by the bank.
Name
Your company name as it appears on the ACH contract with the bank. The company name is part of the Company/Batch Header record and is required.
Originating DFI ID
The originator's routing/transit number as assigned by the bank. This number is part of the Company/Batch Header record and the Company/Batch Control record and is required.
Immediate Origin
Routing Number (with Prefix)
The routing number of the sending point bank or the company tax ID (EIN/TIN). Typically, the first position is blank, followed by the four-digit Federal Reserve routing symbol, the four-digit ABA institution ID, and the check digit. The routing number is part of the File Header record and is required.
Name
The name of the sending point bank or company. The immediate origin name is part of the File Header record and is optional.
Canadian EFT fields
The following fields are visible when you select "Canadian" in the Type field.
Canadian
Last Detail Sequence Number
The starting number for detail records. After initial setup, this field is system-maintained.
User Number
The originator ID assigned to you by the bank.
User Name
The long form of your company name.
Abbreviated User Name
The short form of your company name. (This name may appear on your statements and may be assigned to you by the bank.)
Addressee
The five-digit destination data centre code.
Branch Number
The five-digit code that identifies the bank branch. (The last digit of the branch number typically indicates its geographical location.)
Bank Number
The three-digit code that identifies the financial institution.
Note
A leading zero followed by the bank number and then by the branch number constitute the routing number.
Currency Code
The three-character ISO currency code. This code must match the currency assigned in your service agreement. Valid options are:
- CAD. Canadian dollars.
- USD. US dollars.
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Reference
From the drop-down list, select the custom field to view references for. Reference custom fields have the following format: PackageName.EntityName.CustomFieldName.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Registers tab
The Check Registers pane shows the Check Registers HD view filtered to show all check registers for the selected bank account.
Double-click a row in the pane to drill down to its record in the Check Register window.
Transactions tab
The Bank Transactions pane shows the Bank Transactions HD view filtered to show all bank transactions for the selected bank account.
Double-click a row in the pane to drill down to its record in the Bank Transaction window.
Voided Forms tab
The Voided Forms pane shows the Voided Forms HD view filtered to show all voided forms for the selected bank account.
Double-click a row in the pane to drill down to its record in the Voided Form window.
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Attachments
The list box shows the files which are attached to the current record. Highlight a file name to preview the file in the adjacent pane. Double-click a file name to open the file in its native editor.
Preview pane
If a file name is highlighted in the Attachments list box, this pane shows a preview of the file contents. Some file types cannot be previewed but can be double-clicked to open in their native editor.
Change Logs tab
This tab is visible if the user has "Change Logs" access to the associated data folder resource.
The Change Logs pane shows the Change Logs HD view filtered to show all change logs for the selected entity record.
Double-click a row in the pane to drill down to its record in the Change Log window.
Other tab
Memo tab
To include additional information about this record not collected elsewhere, enter it in this text box. This area supports common keyboard shortcuts such as Ctrl+C to copy and Ctrl+V to paste.
Timestamps tab
This tab shows the user who created this record and the date and time of creation as well as the user, date, and time of the latest modification to the record.
Developer tab
This tab is visible only when developer features are enabled.
Automation subtab
This subtab shows field names and values for the current data record. Use the information in the subtab to assist when creating automation objects such as bots and import files. The field names and field values can be copied from the text box and pasted directly into your code or application. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Export (XML | JSON) subtab
This subtab shows the XML syntax for exporting the selected data record. The syntax can be copied from the text box as an exemplar for creating your own automation objects for bots, import files, ActivWebAPI, etc. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Import (XML | JSON) subtab
This subtab allows you to select a file for import and shows the XML syntax for importing data records. Use the subtab to explore the XML syntax for importing data records. In particular, you can investigate the syntax which results when using Data.Import and ActivWebAPI data POST and DELETE routes.
Change Log (XML | JSON) subtab
This subtab is visible only when the Enable Change Logs option is marked in System Options or Company Options (depending on whether the feature applies at the system or the company level). This is the default setting when developer features are enabled.
This subtab allows you to investigate changes to the current data record. The syntax can be copied for use in bots, dashboards, ActivWebAPI, and other automation. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Select Statement (SQL) subtab
This subtab allows you to investigate the SQL select statement used to retrieve the current data record. The syntax can be copied as an exemplar for data sources and other automation. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.