BBMEFT EFT Output Format

This table shows the output format:

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	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	'/'

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.

11-22-33,Bicycle Parts Comp,10020032,0000001500,EFT7,99/ 
11-22-33,Bicycle Parts Comp,01234568,0000002000,EFT82,99/