--- title: What are the lender field mappings? description: Below is a detailed explaation of the available Lender Field Mappings and their respective acceptable values. --- [Skip to content](https://help.themortgageoffice.com/knowledge/what-are-the-lender-field-mappings#main-content) [![TMO-LO~1](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.png?width=200&height=65&name=TMO-LO~1.png)](https://www.themortgageoffice.com/) - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) Open main navigation Close main navigation - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) - [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new) [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.themortgageoffice.com/knowledge?hsLang=en) 2. [Loan Servicing](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en) 3. [Tasks & Reports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#tasks-reports) October 9, 2026 # What are the lender field mappings? ## Below is a detailed explaation of the available Lender Field Mappings and their respective acceptable values. Click **[here](https://help.themortgageoffice.com/knowledge/how-to-import-funding-from-an-excel-file-1?hsLang=en)** to how to import lenders from Excel using the field mappings below.  ### Lender field mappings: | **Field Name:** | **Description:** | | --- | --- | | **Account** | **Lender Account.** Enter a unique account number. (Maximum of 10 alpha-numeric characters including "-" and ".") | | **ACH\_AccountNumber** | **Bank Account Number.** Enter the number of the bank account from where the lender's payment is to be withdrawn. (Maximum of 17 characters) Click [here](https://help.themortgageoffice.com/knowledge/how-to-enter?hsLang=en) to learn more. | | **ACH\_AccountType** | **Account Type.** 0 = Checking, 1 = Savings | | **ACH\_IndividualId** | **Individual Id.** Enter the loan account number. (Maximum of 15 characters) | | **ACH\_IndividualName** | **Individual Name.** Enter the lender's name. (Maximum of 22 characters) | | **ACH\_RoutingNumber** | **Routing Number.** Enter the number of the bank or financial institution from where the lender’s payment should be withdrawn. (Maximum of 9 characters) Refer to the image below to locate the lender's bank routing number from a sample check.  ![](https://app.themortgageoffice.com/help/lib/Imagesach_check_info13.gif) | | **ACH\_ServiceStatus** | **Service Status.** Indicates the status of the lender's ACH settings. Select one of the following from the list:         0 = None         1 = Active         2 = Cancelled         3 = Hold | | **Birthday** | Birthdate. Enter the lender's birth date. | | **City** | **City.** Enter lender's city. (Maximum of 50 characters) | | **Code** | **Lender Code.** Enter a lender code. (Maximum of 50 characters) | | **Counselor** | **Counselor.** Enter the name of the investment counselor associated with this lender. (Maximum of 64 characters) | | **DeliveryOptions** | **Delivery Options.** The available options are: 0 = None 1 = Print 2 = E-mail 3 = Print & E-mail | | **EmailAddress** | Email Address. Enter lender's e-mail address. (Maximum of 255 characters) TIP: You may enter multiple e-mail addresses by separating each with a semi-colon. When sending documents via e-mail (such as statements), The Mortgage Office® will generate a separate e-mail with the appropriate attachment to each e-mail address in the field. | | **EmailFormat** | **Email Format.** Enter the e-mail delivery format. Available options are 0=Plain Text, 1=HTML. | | **FirstName** | **First Name.** Enter lender's first name. (Maximum of 30 characters) | | **FullName** | **Full Name.** Enter the lender's full name. (Maximum of 64 characters) | | **LastName** | **Last Name.** Enter lender's last name. (Maximum of 64 characters) | | **MI** | **Middle Initial.** Enter lender's middle initial. (Maximum of 1 character) | | **Payee** | **Payee.** Enter a payee name and address to use when printing checks, otherwise the system will use the lender's name and mailing address. | | **PhoneCell** | **Cell Phone Number.** Enter lender's phone number. (Maximum of 20 characters) | | **PhoneFax** | **Fax Phone Number.** Enter lender's phone number. (Maximum of 20 characters) | | **PhoneHome** | **Home Phone Number.** Enter lender's phone number. (Maximum of 20 characters) | | **PhoneMain** | **Primary Phone Number:** 0 = Home, 1 = Work, 2 = Cell and 3 = Fax. | | **PhoneWork** | **Work Phone Number.** Enter lender's phone number. (Maximum of 20 characters) | | **RolodexFlag** | **Rolodex Flag.** The options are:         0 = Never print rolodex cards.         1 = Print as needed.         2 = Data contained in the rolodex has changed.         3 = Print and data changed | | **Salutation** | **Borrower's Salutation.** Enter a salutation field. Maximum of 50 characters. | | **Send1099** | **Tax Reporting.** Enter 1 to print tax forms for this lender; otherwise enter 0. | | **SendDepositNotificationFlag** | **Send Deposit Notification.** The options are:         0 = None         2  = Print         4  = E-mail         6  = Print & E-mail | | **State** | **Borrower's State.** Enter lender's state. | | **Street** | **Borrower's Street.** Enter lender's mailing street address. (Maximum of 64 characters) | | **TIN** | **Borrower's TIN.** Enter lender's tax identification number. (Maximum of 11 characters) | | **TINType** | TIN Type. The options codes to identify the recipient type used for tax reporting: U.S.A.: 0 = Unknown. 1 = EIN. Employer identification number. 2 = SSN. Social security number. Canada: 1 = for an individual. 2 = for a joint account (two or more individuals). 3 = for a corporation. 4 = for an association, trust (RRSP trustee, fiduciary-trustee, nominee, or estate), club, or partnership. 5 = for a government, government enterprise, or international organization. | | **UsePayee** | **Enable Payee.** Enter 1 to print payee's name and address on check; otherwise enter 0. | | **WPC\_PIN** | **Web Publishing Central PIN.** (The PIN can be up to 10 alpha numeric characters) | | **WPC\_Publish** | **Web Publishing Central Publish.** Enter 1 to publish this lender; otherwise enter 0. | | **ZipCode** | **Borrower's Zip Code.** Enter lender's zip code. (Maximum of 10 characters) |   - [Getting Started](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#general) - [Basic Information](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#basic-information) - [New Company Setup](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#new-company-setup) - [User & Group Security](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#general) - [Users](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#users) - [Groups](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#groups) - [Single Sign-On (SSO)](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#single-sign-on-sso) - [Loan Origination](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#main-content) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#loan-files) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#smartviews) - [System Administration](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#system-administration) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lenders) - [Lightning Docs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lightning-docs) - [Integrations](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#integrations) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#borrowers) - [DossDocs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#dossdocs) - [Loan Servicing](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#general) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-files) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#borrowers) - [Terms](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#terms) - [Funding](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#funding) - [Properties](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#properties) - [History](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#history) - [Attachments](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#attachments) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lenders) - [Vendors](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#vendors) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#tasks-reports) - [Loan Charges](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-charges) - [Commercial Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#commercial-loans) - [Lines of Credit/HELOC](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lines-of-credit-heloc) - [Construction Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#construction-loans) - [Adjustable Rate Mortgages (ARM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#adjustable-rate-mortgages-arm) - [Graduated Terms Mortgages (GTM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#graduated-terms-mortgages-gtm) - [Escrow Administration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#escrow-administration) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#smartviews) - [Accounting System Integration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#accounting-system-integration) - [Custom Letters and Notices](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#custom-letters-and-notices) - [Loan Templates](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-templates) - [Data Exports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#data-exports) - [Trust Accounting](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#main-content) - [Trust Accounts](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#trust-accounts) - [Register](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#register) - [Clients](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#clients) - [Payees](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payees) - [Payers](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payers) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#tasks-reports) - [Collateralized Mortgage Obligations](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#main-content) - [Holders](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#holders) - [Mortgage Pool Servicing](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#main-content) - [Mortgage Pools](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#mortgage-pools) - [Partners](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#partners) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#tasks-reports) - [SmartViews](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#smartviews) - [ACH Express](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#general) - [Online Portals](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#general) - [Online Payments](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#online-payments) - [Borrowers](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#borrowers) - [Lenders](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#lenders) - [Partners](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#partners) - [Investment Offerings](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#investment-offerings) - [Messages](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#messages) - [Tax Forms Management & Printing](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#general) - [Tax Forms](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#tax-forms) - [Consumer Credit Reporting (Metro-2)](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#main-content) - [Metro-2 Fundamentals](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#metro-2-fundamentals) - [Custom Letters, Notices and Mailing Labels](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#main-content) - [Custom Letters](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-letters) - [Custom Notices](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-notices) - [Custom (User Defined) Fields](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#general) - [Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/options?hsLang=en#general) - [User Preferences Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#user-preferences-options) - [Loan Servicing Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#loan-servicing-options) - [Importing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#main-content) - [To Loan Servicing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#to-loan-servicing) - [From an Excel file](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#from-an-excel-file) - [Field Mappings](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#field-mappings) - [Online](https://help.themortgageoffice.com/knowledge/online?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online?hsLang=en#general) - [Text Messages](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#general) - [Pulse](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#general) - [Insurance Tracking](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#general) - [API Docs](https://help.themortgageoffice.com/knowledge/api-docs?hsLang=en) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes?hsLang=en) - [Desktop](https://help.themortgageoffice.com/knowledge/desktop?hsLang=en) - [Onboarding](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#main-content) - [Loan Origination](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#loan-origination) [![Chill listening crop-3](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.jpg?width=125&height=55&name=TMO-LO~1.jpg "Chill listening crop-3")](https://www.themortgageoffice.com/) 7755 Center Ave, Suite 800 Huntington Beach, CA 92647 [mailto:support@themortgagoffice.com](mailto:support@themortgagoffice.com) Copyright © 2025, The Mortgage Office®