Coming Soon: Technical Guide - Data Exports Available Field List

Overview

The lists of available datasets and fields for the Data Export tool are quite expansive, so here we'll break down exactly which are available to avoid the guessing game.

What Can I Join?

Your primary dataset determines which other datasets you can add. Incompatible ones appear greyed out.

What you can add depends entirely on which relationships exist from your primary dataset. Charges History, for example, allows two additions, giving you up to three datasets in one export. 

Lenders and Lender History datasets include Vendors. There is a Lender/Vendor field available within the Lenders dataset to determine if the entity is a Lender or a Vendor, allowing you to filter them as needed.

History datasets (Loan, Charges, Lender, Funding) always export within a date range. If you don't set one, the export uses that dataset's default date field and returns the last year. Each export can cover up to one year at a time, and you can go back as far as three years. 

*Underlined date fields with an asterisk are the default.

Additional Notes

• Custom fields are included. Your organisation’s custom fields appear alongside the standard fields for Loans, Properties, and Lenders/Vendors.

• Sensitive values are masked. Tax identifiers and bank account numbers export showing only the last four characters, with the rest replaced by asterisks. This applies to every user and cannot be turned off.

Loans

• Account

• Sort Name

• By Last Name

• Full Name

• Salutation

• First Name

• MI

• Last Name

• Country

• Street

• City

• State

• Zip Code

• Phone (Home)

• Phone (Work)

• Phone (Cell)

• Phone (Fax)

• Tax ID Type

• Tax ID

• Original Balance

• Principal Balance

• Unearned Discount Balance

• Unearned Discount Accrual Method

• Note Rate

• Sold Rate

• Unpaid Late Charges

• Unpaid Interest

• Compound Interest Rate Type (Commercial)

• Compound Interest Rate Value (Commercial)

• Regular Payment - P&I

• Regular Payment - Reserve

• Regular Payment - Impound

• Closing Date

• First Payment Date

• Interest Paid To / Billed Through Date

• Next Payment Date

• Maturity Date

• Paid Off Date

• Purchase Date

• Booking Date

• Next Revision Date

• Priority

• Payment Frequency

• Payment Frequency - Day Due

• Loan Type

• Amortization Type

• Rate Type

• Section 32

• RESPA

• Article 7

• Section 4970

• Add Negative Amortization To Unpaid Interest

• Unpaid Interest - Include when Calculating Interest

• Unpaid Interest - Pay Automatically

• Periodic Interest Accrual Method

• Use Canadian Amortization

• Use 30-Day Month Basis

• Use 365 Day Year Basis

• Prepayment Penalty

• Prepayment Penalty - Other Method

• Prepayment Penalty - Expiration Date

• Prepayment Penalty - Distribute to Lenders

• Prepayment Penalty - Distribute to Orig. Vendor

• Late Charge - Method

• Late Charge - Grace Days

• Late Charge - Grace Days Method

• Late Charge - Minimum

• Late Charge - Percentage of

• Late Charge - Percentage

• Late Charge - Additional Daily Amount

• Late Charge - Distribute to Lenders

• Late Charge - Distribute to Orig. Vendor

• Loan Officer

• Loan Code

• Categories

• Originating Vendor

• Tax Reporting

• IRS 1098 Points Paid

• Send Late Notices

• Send Payment Receipts

• Send Payment Statements

• Email Address

• Email Format

• Delivery Options

• Hold

• DRE - Transaction Type

• DRE - Selling Price

• DRE - Appraisal, Credit, Escrow and Notary Fees

• DRE - Title and Recording Fees

• DRE - Origination, Points, Bonuses and Other Charges

• DRE - Commission Received

• DRE - Other Costs and Expenses

• DRE - Origination Costs Retained by Broker

• DRE - Note Purchase Price

• DRE - Note Selling Price

• DRE - Funds Advanced to Protect Security of the Note

• DRE - Non-Traditional Loan

• DRE - Loan to Refinance Loans Made by Broker

• DRE - Principal (Broker Funded) Loan Resale

• DRE - Person Who Holds the Original Note

• DRE - Language (Bilingual Disclosures)

• Loan Purpose

• Documentation (Other Loan Details)

• Escrow Analysis

• Escrow Analysis - Next Computation Period

• Publish to Portals

• ACH - Bank Name

• ACH - Bank Address

• ACH - Routing Number

• ACH - Account Number

• ACH - Individual Name

• ACH - SEC Code

• ACH - Account Type

• ACH - Service Status

• ACH - Stop Date

• ACH - Debit Due Day

• ACH - Next Debit Date

• ACH - Debit Frequency

• ACH - Apply Debit As

• ACH - Use Manual Debit Amount

• ACH - Debit Amount

• ACH - SEC Code

• ARM - Index

• ARM - Index Rate

• ARM - Margin

• ARM - Ceiling

• ARM - Floor

• ARM - First Change Cap Minimum

• ARM - First Change Cap Maximum

• ARM - Periodic Cap Minimum

• ARM - Periodic Cap Maximum

• ARM - Rate Adjustment Frequency (Months)

• ARM - Next Rate Change

• ARM - Rounding Method

• ARM - Rounding Factor

• ARM - Send Rate/Payment Change Notice

• ARM - Notice Lead Days

• ARM - First Notice Sent Date

• ARM - Carryover

• ARM - Carryover Amount

• ARM - Look Back Days

• ARM - Payment Adjustment

• ARM - Payment Cap

• ARM - Payment Adjustment Frequency (Months)

• ARM - Next Payment Adjustment

• ARM - Neg Amort Cap

• ARM - Recast Payment

• ARM - Recast Frequency

• ARM - Recast Next Date

• ARM - Recast Stop Date

• ARM - Recast To Date

• ARM - Option ARM

• Draw Period (Line of Credit)

• Repayment Period (Line of Credit)

• Credit Limit (Line of Credit)

• Draw Minimum (Line of Credit)

• Draw Maximum (Line of Credit)

• Enforce Draw Maximum (Line of Credit)

• Funding/Draw Fee (Billables)

• Funding/Draw Fee - Percent of (Billables)

• Funding/Draw Fee - Plus Flat Amount (Billables)

• Funding/Draw Fee - Minimum Fee (Billables)

• Billing Frequency (Billables)

• Billing Cycle Start Day (Billables)

• Billing Cycle Calculation Method (Billables)

• Acct Maintenance Fee (Billables)

• Acct Maintenance Fee - Amount (Billables)

• Acct Maintenance Fee - Frequency (Billables)

• Acct Maintenance Fee - Next Charge Date (Billables)

• Acct Maintenance Fee - Assess Finance Charge (Billables)

• Int Charge Calc - Exclude Finance Charges (Billables)

• Int Charge Calc - Exclude Reserve Balances (Billables)

• Int Charge Calc - Exclude Impound Balances (Billables)

• Int Charge Calc - Exclude Late Charges (Billables)

• Pay Amount Calculation - Method (Billables)

• Pay Amount Calculation - Value (Billables)

• Early Closing Fee - Amount

• Early Closing Fee - Months

• Project Description (Construction)

• Project Sq. Ft. (Construction)

• Completion Date (Construction)

• Maximum Loan Amount (Construction)

• Contractor Account (Construction)

• Contractor License No. (Construction)

• Joint Checks (Construction)

• Revolving (Construction)

• Interest on Available Funds (Construction)

• Interest on Available Funds - Method (Construction)

• Interest on Available Funds - Rate (Construction)

• Default Interest - Enabled

• Default Interest - Default After Period

• Default Interest - Default After Value

• Default Interest - Effective Until

• Default Interest - Rate Method

• Default Interest - Rate Value

• Default Interest - Distribute to Lenders

• Default Interest - Distribute to Orig. Vendor

• Autopay from Reserve - Enabled (Billables)

• Autopay from Reserve - Percent of Amount Due (Billables)

• Autopay from Reserve - Plus Flat Amount (Billables)

• Autopay from Reserve - Insufficient Funds Method (Billables)

• Autopay from Reserve - Exclude Reserve (Billables)

• Autopay from Reserve - Exclude Impound (Billables)

• Autopay from Reserve - Exclude Other (Billables)

• CDFI - Included in TLR

• Last Updated

• Created By

• Date Created

• Disable Online Payments (Portals)

• Draw Requests Enabled (Portals)

• Legal Structure

• Shared Appreciation - Enabled

• Shared Appreciation - Lender % Share

• <List Custom Fields>

Loan History

• Pay Method

• Reference

• Date Received

• Date Due

• Paid To

• Applied to Interest

• Applied to Principal

• Applied to Reserve

• Applied to Impound

• Applied to Late Charges

• Charges Principal

• Charges Interest

• Prepayment Penalty

• Unpaid Interest 


• Unearned Discount/Fees

• Fees Paid to Broker

• Fees Paid to Lenders

• Other Payments

• Other Taxable

• Other Tax Free

• Amount to Previous Bill

• Amount to Current Bill

• Shared Appreciation

• Late Charge Added

• Principal Balance

• Notes

• Payment Code

• Source

• Transmission Date (ACH)

• File Number (ACH)

• Batch Number (ACH)

• Trace Number (ACH)

• Created By

• Date Created

Properties

• Loan Account

• Description

• Street

• City

• State

• Country

• Zip Code

• County

• Property Type

• Occupancy

• LTV

• Appraised Value

• Appraised Date

• APN

• Zoning

• Primary Property

• Legal Description

• Pledged Equity

• Priority

• Flood Zone

• Purchase Price

• Real Estate Owned (REO)

• Last Updated

• Created By

• Date Created

• <List Custom Fields>

Charges

• Loan Account

• Advanced By

• On Behalf Of

• Date of Charge

• Reference

• Original Amount

• Amount Owed (Advanced By)

• Amount Owed (On Behalf Of)

• Interest Rate

• Interest From

• Description

• Notes

• Deferred

• Assess Finance Charges

• Charge Type

• Last Updated

• Created By

• Date Created 

Charges History

• Loan Account

• Paid By

• Transaction Type

• Transaction Date

• Reference

• Pay Amount (Advanced By)

• Apply to Interest (Advanced By)

• Pay Amount (On Behalf Of)

• Apply to Interest (On Behalf Of)

• Created By

• Date Created

Lenders

• Account

• Sort Name

• By Last Name

• Full Name

• Salutation

• First Name

• MI

• Last Name

• Street

• City

• State

• ZipCode

• Phone (Home)

• Phone (Work)

• Phone (Mobile)

• Phone (Fax)

• Tax ID Type

• Tax ID

• Tax Reporting

• Send Check to Payee

• Payee Details

• Lender/Vendor Code

• Investment Counselor

• DOB

• Lender/Vendor

• Categories

• Email Address

• Email Format

• Delivery Options

• Send Notification of Deposit

• ACH - Bank Name

• ACH - Bank Address

• ACH - Routing Number

• ACH - Account Number

• ACH - Individual Name

• ACH - Account Type

• ACH - Service Status

• ACH - SEC Code

• Publish to Portals

• Institutional Lender (CA RE 881)

• Institutional Lender (CA RE 881) - Fixed

• Institutional Lender (CA RE 881) - Adjustable

• Accounting System Integration - Methodology

• Last Updated

• Created By

• Date Created

• IRS 1099-NEC

• <List Custom Fields>

Lender History

• Lender Account

• Loan Account

• Payment Code

• Payment Date Received

• Payment Date Due

• Check Date

• Check Number

• Check Memo

• Applied To Interest

• Applied To Principal

• Service Fees

• GST

• Applied To Late Charges

• Charges Principal

• Charges Interest

• Applied to Prepay Fee

• Applied to Trust

• Other Payments

• Other Taxable

• Other Non-Taxable

• Shared Appreciation

• Notes

• Print Note on Check

• Source

• Transmission Date (ACH)

• File Number (ACH)

• Batch Number (ACH)

• Trace Number (ACH)

• Last Updated

• Created By

• Date Created 

Lender Portfolio

• Lender

• Loan Account

• Borrower Name

• Note Rate

• Lender Rate

• Regular Payment

• Principal Balance

• Next Payment

• Maturity Date

• Term Left

• Days Late

• Pct Owned

• Property Address

• First Funding

• Last Funding

Funding History

• Loan Account

• Lender Account

• Draw Type

• Transaction Date

• Reference

• Amount

• Funding Fee

• Notes

• Last Updated

• Created By

• Date Created