FTP_SALES File Layout
FIELD NAME |
DESCRIPTION |
TYPE |
PARCEL_ID |
18 digit account number - common link to all data files and parcel shapefiles |
VARCHAR(25) |
SALE_ID |
Number used to make sale per parcel unique |
INT |
LN_NUM |
Number used to put sales in order |
INT |
SALEDT |
Date of the sale |
DATE/TIME |
PRICE |
Sale Price |
INT |
BOOK |
Official Record Book Number |
VARCHAR(8) |
PAGE |
Official Record Page Number |
VARCHAR(8) |
SALETYPE |
Vacant/Improved |
CHAR(1) |
TRNS_CD |
Transaction Code |
VARCHAR(16) |
TRNS_DSCR |
Transaction Code Description |
VARCHAR(50) |
INSTRTYP |
Instrument Type (Reason) Code |
VARCHAR(2) |
INSTRTYP_DSCR |
Instrument Type (Reason) Code Description |
VARCHAR(50) |
GRANTOR |
Seller |
VARCHAR(100) |
GRANTEE |
Buyer |
VARCHAR(100) |
FORECLOSURE |
Current or Past Foreclosure blank if not a foreclosure |
CHAR(1) |