BBMEFT EFT Output Format
This topic describes BBMEFT EFT output format.
| Database Table and Column | Description | Format |
|---|---|---|
| vendor.EFT_bank_num | Vendor bank sort code | 99-99-99 |
| N/A | Separator | ',' |
| first 18 characters of vendor.account_name if not null; else first 18 characters of vendaddr.name | Service Management vendor name, or vendor account name. This is reference information. | string, length 18 |
| N/A | Separator | ',' |
| Sum of all appmtd.dom_amt_paid if the vendor's currency code = currparms.curr_code for a payment; else sum of all apppmtd.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.check-num | check number | integer, field as long as required for number |
| N/A | Always set to '99' | integer |
| N/A | Separator | '/' |
Note: 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.
Sample
11-22-33,Bicycle Parts Comp,10020032,0000001500,EFT7,99/
11-22-33,Bicycle Parts Comp,01234568,0000002000,EFT82,99/