Texas Capital WarehouseNOW Sample eGuide

Spreadsheet Field Name

Manual Entry Field Name (not in screen order)

Data Description

Allowed Values

Notes

N product_code*

Product*

Client Eligible Loan Program

CONVARM Conventional ARM CONVFIX Conventional Fixed FHAARM FHA ARM FHAFIX FHA Fixed 203K FHA 203K HARP HARP 2.0 HOMEPATH FNMA HomePath JUMBO Jumbo Loan REVARM Reverse Adjustable Rate Mortgage REVERSE

Reverse Fixed Rate Mortgage

SEC184

HUD Section 184 USDA Rural Housing

USDA

VAARM VA ARM VAFIX VA Fixed

O lien_position

Lien*

1 2

1st Lien 2nd Lien

P address

Address*

Property House # and Street name per Note

Q address2

Address (2nd Line)*

Unit # if applicable per Note

R city

City*

City per Note State per Note

S state*

State*

T zip

Zip*

ZIP Code per Note County per Note Per current appraisal

U county

County*

V curr_appraised_value Appraised Value*

xxxxxx.xx

Do not use $

W property_type_code

Property Type*

CNDO COOP

Condo Co-op Duplex

DPLX FPLX MAN

Fourplex

Manufactured Single Family

SFR

TPLX

Triplex

* Required field ** Conditionally required field

81

10.01.2015 Version 4.0 – Client User Guide