We have a vendor that we need to provide sales data to in a nightly report csv file. We need to produce a csv file of all Deals created for the day within certain criteria. As in: "Form Type = wexham" and "Deal Disposition = Approved" for the date of "Today".

This would be easy enough with a standard report; however, I need to have the Column Header names to be different text than what my current field names are. For example.
Their report column "Customer_First_Name" would be our report "First Name" and their "Comment_Text" will be our "Package Total".

I have a copy of their template file with 149 column headers. We need to fill in about 18 fields from our Deals module and another 23 will be static/constant data. The rest will remain empty, but they still need to be there so they can import the file.