The following fields are available for inclusion in the formats.
Note: References to Refund or RF is included in some format definition. However, it is not applicable to Sage Intacct.
Batch information
This applies to the
From the batch header:
|
BatchNumber |
Batch Number |
| BatchDesc | Batch Description |
| BatchCurrency | Currency code selected in batch header |
|
BatchDate |
The batch date, or the system date, whichever is later. |
|
BatchDateJulian |
The batch date as a julian number. Use for most Canadian banks. |
|
TrueBatchDate |
The real batch date |
From the batch entry:
|
EntryNumber |
Entry number. |
|
EntryDate |
Payment date |
|
EntryDateJulian |
Payment date in Julian Format |
|
Amount |
Payment amount in bank's currency (eg $100.52 is 100.52) |
|
AmountInCents |
Payment amount in bank's currency in cents (eg $100.52 is 10052) |
| sourceamount |
Payment amount in vendor's/customer's currency |
| sourceamountincents |
Payment amount in vendor's/customer's currency in cents |
| entry.desc |
Batch Entry Number |
| ereference |
Entry Reference |
Source account information
From EFT Banks:
|
BankID |
The Bank Code from the Bank Setup screen. |
|
BankName |
The Bank Name from the Bank Setup screen. |
|
BankBSB |
The BSB / Branch / Routing number from the Bank Setup screen. |
|
BankAccount |
The Account Number from the Bank Setup screen. |
|
BankAccountName |
The Account Name from the Bank Setup screen. |
|
BankReference |
A/P Payment Reference from the EFT Bank screen for A/P Payments batches or A/R Receipt Reference from the Bank Setup screen if an AR batch is being exported |
|
BankExtra1 |
An extra field which can be turned on for banks. If enabled, you will see a line: "Extra1=abc" in the formats.ini file will be the field label on the EFT Bank screen. |
|
BankExtra2 to BankExtra10 |
The same method applies to the other nine extra fields. |
From Sage 300 Common Services > Bank Services > Bank
|
bank.ccy |
The statement currency of the bank code |
|
bank.transit |
Transit Number |
|
bank.address1 bank.address2 bank.address3 bank.address4 bank.city bank.state bank.zip bank.country |
Bank Address details |
From Sage 300 Common Services > Company Profile
The field names are self-explanatory:
Company.name
Company.taxnumber
company.brn
Company.address1, Company.address2, Company.address3, Company.address4
Company.city
Company.state
Company.zip
Company.country
Company.phone
Company.fax
Company.contactname
Company.branch
Destination account information
From EFT Customers or EFT Vendors:
|
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 |
Extra field on EFT Customers or EFT Vendors Setup screen. If enabled, there is a line in the formats.ini: VendorExtra1="abc" or CustomerExtra1="abc" “abc” is the field name to be displayed in the EFT Customer or EFT Vendor setup screen. If writing a custom format, include the lines in the userformats.ini file. |
|
DestExtra2 to DestExtra50 |
Same as above |
Destination account From A/P Vendor or A/R Customer
|
DestName |
The A/R Customer Name or A/P Vendor Name |
|
DestAddress1 to DestAddress4 |
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 |
| Dest.ccy | A/P Vendor or A/R Customer currency code |
Destination account information (from Vendor Remit To on the batch entry):
|
DestRemitName |
The A/P Vendor Remit-To Name |
|
DestRemitAddress1to DestRemitAddress4 |
The A/P Vendor Remit-To Address lines 1 to 4 |
|
DestRemitCity |
The A/P Vendor Remit-To City |
|
DestRemitState |
The A/P Vendor Remit-To State |
|
DestRemitPostcode |
The A/P Vendor Remit-To Postcode |
|
DestRemitCountry |
The A/P Vendor Remit-To Country |
|
DestRemitPhone |
The A/P Vendor Remit-To Phone |
|
DestRemitFax |
The A/P Vendor Remit-To Fax |
|
DestRemitEmail |
The A/P Vendor Remit-To E-mail |
|
DestRemitContact |
The A/P Vendor Remit-To Contact Name |
|
DestRemitContactPhone |
The A/P Vendor Remit-To Contact's phone |
|
DestRemitContactFax |
The A/P Vendor Remit-To Contact's fax |
|
DestRemitContactEmail |
The A/P Vendor Remit-To Contact's e-mail |
Applied Document Information:
|
InvoiceDate |
Applied Document Date |
| InvoiceDateDue | Applied Document Invoice Due 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 |
The first applied document number |
Miscellaneous:
|
Today |
The run date |
|
Reference |
The reference field from Create EFT File screen |
|
Description |
The description field from Create EFT File screen |
|
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. |
|
CR |
The A/P Vendor Remit-To Fax |
|
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. |
|
Today |
The run date |
|
+xD or -xD |
To add or minus number of days to the date field. Example: [Today+3D] [BatchDate-1D] |
|
Reference |
Reference field from the screen |
|
Description |
Description field from the screen |
|
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. |
|
CR |
A carriage return |
|
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. |
|
BCRLF |
A carriage return / line feed will only be inserted if there is already a record /value in the file. For formats without a footer row and where the last record must not have a carriage return, use BCRLF at the beginning of each detail row instead of placing CRLF at the end of the row. |
|
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. |
|
InitRecord1Count.. InitRecord5Count |
To reset record counter to zero. There are 5 record counters available. |
|
IncRecord1Count . IncRecord5Count |
To include a record count. When a [IncRecordxCount] field is placed on a row, it will increment by one. |
|
GetRecord1Count.. GetRecord5Count |
To print the record count number. |
|
InitAmount1 .. InitAmount5 |
To reset amount summary field to zero. There are 5 amount summary fields available. |
|
AddAmount1 to AddAmount5 |
Use to add the amount to a summary field. In order to do the summary, the Amountxfield has to be defined. Example:
Amount1="[BankAmount]" DetailAP="[AddAmount1],[BankAccountNumber],[BatchCurrency], [Amount],[EntryDate:YYYYMMDD],[DestBankName:%-35C], [DestAccountNumber], [DestAccountName:%-35C] [CRLF]” |
|
GetAmount1 to GetAmount5 |
To display or print the Amount summary. Eg: Example: Footer="99,[NumberofEntries],[GetAmount1:%D0.2][CRLF]" |
|
AddAmountY=X Eg: [AddAmount2=1]
|
To add amount of a “Y” field to the summary of “X”. Eg. A requirement to add Payor / Account Number with the beneficiary Account Number and display it at the footer as the check digit for the transfer file. In the format, declare field Y as an amount field, add it to the summary and display at the footer. Amount1="[DestAccount:%010D]" Amount2="[BankAccountNumber:%010D]" Detail1="[AddAmount1][AddAmount2=1]01[AmountInCents:%012D] [BankAccountNumber:%010D][DestAccount:%010D][ CRLF]" Footer1="99[TransactionTotalInCents:%018D][GetAmount1:%R10C][CRLF]" |
|
EffectiveDate
|
This date field can be used as active payment date. When the EffectiveDate field is used in the format, it will display a date field on Create EFT screen.
|
|
SessionDate
|
Sage 300 sign on date. |
|
FILENAME |
The actual generated EFT File name |
