| ColumnName |
Domain |
Datatype |
NULL |
Definition |
Code |
|
nvarchar(10) |
NO |
Bank code. |
| Account |
|
nvarchar(13) |
YES |
Account number associated with the bank code. |
| Org |
|
nvarchar(30) |
YES |
Organization associated with the bank code. |
| Description |
|
nvarchar(40) |
YES |
The bank code description. |
| AccountNumber |
|
nvarchar(20) |
YES |
Bank account number for the bank code. |
| AccountType |
|
varchar(1) |
YES |
Indicates whether the source account for the direct deposit is a checking or a savings account. |
| ImmediateDestination |
|
nvarchar(9) |
YES |
Identification number of the bank receiving the direct deposit file. |
| ImmediateDestinationName |
|
nvarchar(23) |
YES |
Name of the bank receiving the direct deposit file. |
| ImmediateOrigin |
|
nvarchar(9) |
YES |
The identification number assigned by the bank to the company sending the direct deposit file. |
| ImmediateOriginName |
|
nvarchar(23) |
YES |
The name of the company sending the direct deposit file. |
| CompanyName |
|
nvarchar(16) |
YES |
The name of the company sending the direct deposit file, as the name is to appear on statements. |
| FederalEIN |
|
nvarchar(10) |
YES |
The company's Federal Employer Identification Number. |
| RoutingNumber |
|
nvarchar(8) |
YES |
The ImmediateDestination's routing transit number. |
| EntryDescriptionPY |
|
nvarchar(10) |
YES |
Description of the purpose of the entry; for example, "Payroll" or "Regular Salary." |
| EntryDescriptionEX |
|
nvarchar(10) |
YES |
The description or purpose of the employee expense payment direct deposit entry, using up to ten characters. |
| FileFormat |
|
smallint |
NO |
Variable indicating the type of information in the direct deposit file. Valid options are 1-Credit only, 2-Debit and credit. |
| ICD |
|
varchar(1) |
NO |
A one-character variable indicating the type of identification code designator. |
| Byte4Char |
|
varchar(1) |
YES |
The first character in the file header record's space for immediate destination. |
| FilePadding |
|
varchar(1) |
NO |
Controls whether the total record count is forced to a multiple of ten. |
| SeparateBatches |
|
varchar(1) |
NO |
Indicates whether there are separate batches for credit and debit entries. |
| FileNamePY |
|
nvarchar(100) |
YES |
Filename and path location of the direct deposit file. |
| FileNameEX |
|
nvarchar(100) |
YES |
The path and filename for the employee expense payments direct deposit file. The default is DIRDEP.TXT in the current default directory. |
| Company |
|
nvarchar(14) |
NO |
The company owning the data entry file; that is, the company that is the active company when the file is created. |
| EntryDescriptionAP |
|
nvarchar(10) |
YES |
The description or purpose of the accounts payable entry. |
| FileNameAP |
|
nvarchar(100) |
YES |
The filename and file path of the accounts payable EFT file. |
| ExportTextFormat |
|
smallint |
NO |
The Export to Text Format. Valid options are 1 - Check and 2 - BACS. |
| Qualifier |
|
smallint |
NO |
The selected Text Qualifier, when ExportTextFormat is 2 - BACS. Valid options are 1 - None, 2 - ", and 3 - '. Each field of the output text file will be wrapped with the Qualifier selected. |
| UDFileType |
|
smallint |
NO |
The value in the File Type field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDUseFileCreationNumber |
|
varchar(1) |
NO |
Flag indicating whether the Use File Creation Number option is selected on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDLastFileCreationNumber |
|
int |
NO |
The value in the Last File Creation Number field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDPadLastBlock |
|
varchar(1) |
NO |
The value in the Pad Last Block field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDPadCharacter |
|
nvarchar(10) |
YES |
The value in the Pad Character field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDPadLinesMultiple |
|
int |
NO |
The value in the Pad Lines in Multiple of field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDHardReturns |
|
varchar(1) |
NO |
Flag indicating whether the Hard Returns option is selected on the User Defined File Format tab of Configuration, Accounting, Banks. |
| UDDateFormat |
|
nvarchar(100) |
YES |
The value in the Date Format field on the User Defined File Format tab of Configuration, Accounting, Banks. |
| IncludeICD |
|
varchar(1) |
NO |
Flag indicating whether the Include ICD in Immediate Origin Number option is selected on the NACHA File Format tab. |
| WireTransferFeeDebitAccount |
|
nvarchar(13) |
YES |
The default wire transfer fee debit account. |
| WireTransferFeeDebitWBS1 |
|
nvarchar(30) |
YES |
The default project to be charged for the wire transfer fee debit. |
| WireTransferFeeDebitWBS2 |
|
nvarchar(30) |
YES |
The default phase to be charged for the wire transfer fee debit. |
| WireTransferFeeDebitWBS3 |
|
nvarchar(30) |
YES |
The default task to be charged for the wire transfer fee debit. |
| UDLastFileCreationDate |
|
datetime |
YES |
The last File Creation Date of the UD output format. |
| UDClieOp |
|
varchar(1) |
NO |
Indicator of whether the ClieOP format is used. |
| UDResetLastFileNumberEach |
|
varchar(1) |
NO |
The frequency at which the Last File Number is reset. |
| EnableInProcessAccount |
|
varchar(1) |
NO |
Indicator of whether the in-process account method is enabled for the bank code. |
| InProcessAccount |
|
nvarchar(13) |
YES |
In-process account number. |
| UDSortByPaymentCurrency |
|
varchar(1) |
NO |
Indicator of whether to sort the record by payment currency for the UD output format. |
| UDSubtotalByPaymentCurrency |
|
varchar(1) |
NO |
Indicator of whether to subtotal by payment currency for the UD output format. |
| UDDecimalPlaces |
|
varchar(1) |
NO |
Indicator of whether to show the decimal place in the UD output format. |
| SEPAIBAN |
|
nvarchar(35) |
YES |
Firm IBAN number for the SEPA format. |
| SEPABIC |
|
nvarchar(35) |
YES |
Firm BIC number for the SEPA format. |
| SEPAAddress1 |
|
nvarchar(70) |
YES |
Firm Address Line 1 for the SEPA format. |
| SEPAAddress2 |
|
nvarchar(70) |
YES |
Firm Address Line 2 for the SEPA format. |
| SEPACountry |
|
nvarchar(2) |
YES |
Firm Country for the SEPA format. |
| SEPAFormat |
|
int |
NO |
SEPA format type. |
| DisplayEFTAsOneLine |
|
varchar(1) |
NO |
Display one line of Electronic Payments Runs in Bank ReconciliationAP Payment Terms Description |
| DisplayGLBalanceOnSummaryTab |
|
varchar(1) |
NO |
This field is not in use. |
| SEPAIncludeSchemaLocation |
|
varchar(1) |
NO |
|
| SEPAOIN |
|
nvarchar(20) |
YES |
|
| ImportEnabled |
|
varchar(1) |
NO |
|