ALLEFT EFT Output Format
This table shows the ALLEFT EFT output format:
| 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 | 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 |
Note: There are no spaces except
as specified and each EFT output file line corresponds to one payment
record.
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).
11-22-33100200320Bicycle Parts Comp 10.00 1
11-22-33100200320Bicycle Parts Comp 20.00 2