The list below is not exhaustive, but includes only the most commonly used fields.
Source account information (from EFT Banks):
|
BankID |
The Bank Code from the Bank Setup screen. |
|
BankName |
The Bank Name from the Bank Setup screen. |
|
bsbno |
The BSB number from the Bank Setup screen. |
|
BankAccno |
The Account Number from the Bank Setup screen. |
|
BankAccname |
The Account Name from the Bank Setup screen. |
|
BankExtra1 to BankExtra10 |
An extra field which can be turned on for banks. Turn on by putting "BankExtra1=abc" in the formats.ini file |
|
Description |
File description |
|
Reference |
Reference option selected on EFT Bank |
Payment entry:
|
Firstcheque |
Payment cheque number |
|
EntryDate |
The entry date |
|
Amount |
The amount (eg $100.52 is 100.52) |
|
AmountInCents |
The amount in cents (eg $100.52 is 10052) |
|
Set to 1 to include void payments in Positive Pay files [Entry.Type] - returns “void” for void payment and blank for others |
|
| VOIDDATE | In most cases, the file format uses the original payment date as the Void Date. Some format requires the actual Void Date from the voided payment. |
Destination account information (from EFT
Customers, EFT Vendors or EFT EMPLOYEES):
|
DestId |
Vendor or Customer ID field from the EFT Customers or EFT Vendor screen |
|
DestShortName |
The A/P Vendor short name (APVEN.SHORTNAME) or A/R Customer short name (ARCUS.TEXTSNAM) |
|
DestBankName |
The bank name field from the EFT Customers or EFT Vendor screen |
|
DestBSB |
The BSB field from the EFT Customers or EFT Vendor screen |
|
DestAccount |
The account number field from the EFT Customers or EFT Vendor screen |
|
DestAccountName |
The account name field from the EFT Customers or EFT Vendor screen |
|
DestReference |
The reference field from the EFT Customers or EFT Vendor screen |
|
DestExtra1..50 |
Extra field on EFT Customers or EFT Vendors Setup screen. Extra field can be turn on in formats.ini by puting : VendorExtra1="abc" or CustomerExtra1="abc". “abc” is the field name to be displayed in the EFT Customer or EFT Vendor setup screen. From version 56, it can be up to 50 customised extra fields. |
|
DestName |
The A/R Customer Name or A/P Vendor Name |
|
DestAddress1..4 |
The A/R Customer Address lines 1 to 4 or A/P Vendor Address lines 1 to 4 |
|
DestCity |
The A/R Customer City or A/P Vendor City |
|
DestState |
The A/R Customer State or A/P Vendor State |
|
DestPostcode |
The A/R Customer Postcode or A/P Vendor Postcode |
|
DestCountry |
The A/R Customer Country or A/P Vendor Country |
|
DestPhone |
The A/R Customer Phone or A/P Vendor Phone |
|
DestFax |
The A/R Customer Fax or A/P Vendor Fax |
|
DestEmail |
The A/R Customer E-mail or A/P Vendor E-mail |
|
DestContact |
The A/R Customer Contact Name or A/P Vendor Contact Name |
|
DestContactPhone |
The A/R Customer Contact Phone or A/P Vendor Contact Phone |
|
DestContactFax |
The A/R Customer Contact Fax or A/P Vendor Contact Fax |
|
DestContactEmail |
The A/R Customer E-Mail or A/P Vendor Contact E-mail |
Applied Document Information:
|
InvoiceDate |
Applied Document Date |
|
InvoiceNumber |
Applied Document Number |
|
InvoiceDescription |
Applied Document Description |
|
InvoiceGrossAmount |
Applied Document Gross Amount (prior Discount) |
|
InvoiceDiscountAmount |
Applied Document Discount Amount |
|
InvoiceNetAmount |
Applied Document Net Amount (after discount / payable amount) |
|
FirstInvoiceNumber |
TThe first applied document number |
Miscellaneous:
|
Today |
The run date |
|
TransactionTotalInCents |
The total amount in cents (eg $100.52 is 10052) |
|
TransactionTotal |
The total amount (eg $100.52 is 100.52) |
|
NumberOfEntries |
Number of detail lines so far. This is counted from 1. |
|
RecordCount |
Number of lines so far. This is counted from 1. |
|
LF |
A line feed character |
|
CRLF |
A carriage return / line feed |
|
Blank |
A blank field. Useful for when there are large runs of spaces or 0. Set the pad length field to the size of the run. |
|
FieldIDModifier |
Alphabet from A to Z. To indicate a particular batch has been run for Create EFT file process for the number of time. The first run will have ‘A’ as indicator, subsequent run ‘B’, ‘C’ and so on. |
|
FILENAME |
The actual generated EFT File name |
Masking EFT File details
In the EFT File format, you can choose to mask the fields on the Orchid EFT tabs for Vendors, Customers and Employees.
Users will save the bank details as usual. After saving, they will see the first four, the last four or no digits at all, depending on the configuration.
Note: This applies only to the Orchid EFT tabs. When a user exports records or creates a custom view with the relevant EFT Fields, the fields are not masked.
For details, see Masking EFT details
