| Database Table and Column | Description | Format |
|---|---|---|
| vendor_mst.EFT_bank_num | Vendor bank sort code | 99-99-99 |
| N/A | Separator | ',' |
| first 18 characters of vendor_mst.account_name if not null; else first 18 characters of vendaddr_mst.name | SyteLine vendor name, or vendor account name. This is reference information. | string, length 18 |
| N/A | Separator | ',' |
| Sum of all appmtd_mst.dom_amt_paid if the vendor's currency code = currparm_msts.curr_code for a payment; else sum of all apppmtd_mst.for_amt_paid for a payment | Payment amount | string of length 10, leading spaces converted to zeros and decimal point removed |
| N/A | Always set to 'EFT' | 'EFT' |
| appmt_mst.check-num | check number | integer, field as long as required for number |
| N/A | Always set to '99' | integer |
| N/A | Separator | '/' |
NOTES: There are no spaces except as specified and each EFT output file line corresponds to one payment record. Use '/' to delimit the end of each record.