GiftWrap check data mail merge file layout

GiftWrap Payment Data Mail Merge File Layout

The file created by Create Payment Data Mail Merge File is formatted for merging with a letter created in a word processor, such as Microsoft Word. The file is created under Payments > Advices/Files.

You can choose between two text formats for the file:

Comma and quote delimited (.csv): character values are enclosed in double quotes (e.g., "Joe Donor") and numbers, dollar amounts, and dates are not (e.g., 10/1/2005 or 120412). The fields included in the file and their order are shown below.
Fixed length text (.sdf): numbers and dollar amounts are right justified; character values and dates are left justified. The fields included in each record and their column positions are shown below.

Choose the file format most suited to the software that will be working with the data. File records are sorted by organization nickname, then organization ID, then check date, then last name of payee. The fields included in each record in the payment data mail merge file are as follows:

Field Name	Table.Field	Name in File	Position	Description
Organization Name	Org.Orgname	OrgName	1-50
		fmtDateToPrint	51-58	payment date in "mmmmm, dd yyyy" format
Salutation	tblPerson.Salutation	Salutation	59-88
Pay to the Order of	tblPersonGiftMap.Payto	Payto	89-138	Pay to order of name
Preferred Correspondence Address	tblAddress	fmtAdviceAddressLine1	139-208	First line of formatted address
Preferred Correspondence Address	tblAddress	fmtAdviceAddressLine2	209-278	Second line of formatted address
Preferred Correspondence Address	tblAddress	fmtAdviceAddressLine3	279-348	Third line of formatted address
Preferred Correspondence Address	tblAddress	fmtAdviceAddressLine4	349-418	Fourth line of formatted address
Net Amount	tblPaymentSnapshot.NetPaymentAmount	calNetAmountTotal	419-430	Net Payment
Federal Withheld	tblPaymentSnapshot.FederalWithheld	calFederalWithheldTotal	431-442	Federal Withheld
State Withheld	tblPaymentSnapshot.StateWithheld	calStateWithheldTotal	443-454	State Withheld
Gross Amount	tblPaymentSnapshot.NetPaymentAmount + tblPaymentSnapshot.FederalWithheld + tblPaymentSnapshot.StateWithheld	calPaymentAmountTotal	455-466	Gross Payment
Payment name		fmtPaymentName	467-516	Name in formatted address
Payment Address	tblAddress	fmtPaymentAddressLine1	517-586	First line of formatted address
Payment Address	tblAddress	fmtPaymentAddressLine2	587-656	Second line of formatted address
Payment Address	tblAddress	fmtPaymentAddressLine3	657-726	Third line of formatted address
Payment Address	tblAddress	fmtPaymentAddressLine4	727-796	Fourth line of formatted address
Bank Name	tblBank.BankName	BankName	797-846	Bank Name
Bank Account #	tblBank.BankAccount	BankAccount	847-863	Bank Account #
Bank Name and Account Number	tblBank.BankName + tblBank.BankAccount	fmtBankAndAccount	864-943	"c/o " + Bank name and account number concatenated and formatted
Person Key	tblPerson.PersonKey	PersonKey	944-954	Person Key
Address ID	tblAddress.AddressID	AddressID	955-965	Address Key