Deposit Account Extract

This data will be used for purposes of funds transfer pricing. Funds credit and charge rates are calculated at the customer account level.

Please generate this extract as soon as possible after the quarter ends. Many customers send this data in two files: One for demand accounts, one for time deposits.

Here is the field list we need. As always, please call us if you have questions.

Field Name	Required/ Not Required	Notes
Account Number	Required
Current Balance	Required
Average Balance	Required	Sometimes called the average ledger balance.
Type/Plan/Class Code	Required
IRA Code	Required	A code indicating if the account is an IRA. Sometimes the type code indicates this.
Branch Number/GL Cost Center	Required	Sometimes these are two different values. We need both if they're different.
Open Date	Required	Also called the origination date.
Last Rollover Date	Required	Possibly called "last renew date".
Maturity Date	Required
Current Interest Rate	Required
Account Name	Not Required
Date Closed	Not Required	Please exclude closed accounts from the file, but if not possible, include close date.
Available Balance	Not Required	Sometimes called the collected balance.
Term	Not Required	The term of the account, hopefully in a consistent unit, like months, etc.
Term Code	Not Required	What unit the term value is in: "M" for months, "D" for days. Supply a list if necessary.
Officer code	Not Required
Rollover Frequency	Not Required
Customer ID Number	Not Required	Do not send a Social Security number.