| Database Table and Column | Description | Format |
|---|---|---|
| vendor_mst.EFT_bank_num | Vendor bank sort code | 99-99-99 |
| vendor_mst.account | EFT bank account number | 99999999 |
| N/A | Always set to zero | 9 |
| 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 of length 18 |
| Sum of all appmtd_mst.dom_amt_paid if the vendor's currency code = currparms_mst.curr_code for a payment; else sum of all apppmtd_mst.for_amt_paid for a payment | Payment amount | decimal, length 8, padded on left with blanks, always 2 digits after the decimal point (maximum 99999.99) |
| appmt_mst.check-num | Check number | string of length 7, padded on left with blanks |
If the payment amount is greater than 99999.99, then ?????.?? is written to the output file, and a line displaying the error is written to an error file (generated in the same directory as the output file).