Back to Technical Support
Document Index
Farm File Layout (database structure)
4x 5x W
C FP
Tech Support Addendum #0100c
The "farm" files are standard dBASE III Plus compatible
files. Below is a listing of the file structure incorporated in
the data files used by the program. As of 7/15/96 every farm will
contain at least the following 45 fields.
Type definitions
| C = character | N = numeric | D = date |
L = logical |
|
#
| Field Name
|
Type
|
Length
|
Dec
|
#
| Field Name |
Type
|
Length
|
Dec
|
|
1
| APN |
C
|
20
|
0
|
23
| GARAGE |
C
|
1
|
0
|
|
2
| ONR_NAME |
C
|
20
|
0
|
24
| PHONE |
C
|
10
|
0
|
|
3
| FIRST |
C
|
30
|
0
|
25
| TFR_DATE |
D
|
8
|
0
|
|
4
| SALUTATION |
C
|
10
|
0
|
26
| TFR_VAL |
N
|
9
|
0
|
|
5
| SITE_ADD |
C
|
30
|
0
|
27
| F_P |
C
|
1
|
0
|
|
6
| SITE_CITY |
C
|
24
|
0
|
28
| LENDER |
C
|
20
|
0
|
|
7
| SITE_ZIP |
C
|
10
|
0
|
29
| FIRST_TD |
N
|
9
|
0
|
|
8
| MAIL_ADD |
C
|
30
|
0
|
30
| TYPE_LOAN |
C
|
3
|
0
|
|
9
| MAIL_CITY |
C
|
24
|
0
|
31
| RATE_TYPE |
C
|
3
|
0
|
|
10
| MAIL_ZIP |
C
|
10
|
0
|
32
| SECOND_TD |
N
|
9
|
0
|
|
11
| ASSD_VAL |
N
|
9
|
0
|
33
| TRACT_NUM |
C
|
11
|
0
|
|
12
| PCNT_IMP |
N
|
2
|
0
|
34
| LOT |
C
|
5
|
0
|
|
13
| USE_CODE |
C
|
16
|
0
|
35
| ROUTE |
C
|
6
|
0
|
|
14
| ZONING |
C
|
15
|
0
|
36
| TICKLER |
D
|
8
|
0
|
|
15
| YR_BUILT |
N
|
4
|
0
|
37
| FLAG |
L
|
1
|
0
|
|
16
| BLDG_SQFT |
N
|
8
|
0
|
38
| NOTES |
M
|
10
|
0
|
|
17
| NUM_UNITS |
N
|
4
|
0
|
39
| NUMSTORIES |
N
|
2
|
0
|
|
18
| ROOMS |
N
|
2
|
0
|
40
| LAND_VAL |
N
|
9
|
0
|
|
19
| BEDROOMS |
N
|
2
|
0
|
41
| THOM_BRO |
C
|
10
|
0
|
|
20
| BATHROOMS |
N
|
6
|
2
|
42
| LAST_CONT |
D
|
8
|
0
|
|
21
| LOT_SIZE |
N
|
9
|
0
|
43
| SELLER |
C
|
20
|
0
|
|
22
| POOL |
C
|
1
|
0
|
44
| TRAN_TYPE |
C
|
1
|
0
|
|
23
| GARAGE |
C
|
1
|
0
|
45
| MAIL_ROUTE |
C
|
6
|
0
|
NOTE:
Older farms may have any of the following differences
- TRAN_TYPE field may be missing.
- MAIL_ROUTE field may be missing.
- BEDROOMS may be N 6 2 instead of N 6 1
small office, home office, soho, soho software, real
estate agent software, realtor software, mortgage broker software, real
estate broker, real estate tax data software, tax roll data software,
property data software, real estate property software, real estate database
management software, real estate listing software, real estate software, real
estate management, lending software, lender software, mortgage software,
contact management, listing management, cma sofware, cma report software,
closing management, escrow management, escrow software, closing software,
closing manager, escrow manager, campaign manager, financial calculator,
financial software, refinance software, refinancing software, loan
qualification software, amortization software, scheduler software, scheduling
software, real estate spreadsheet, settlement sheets, bulk mailing, client
management, telemarketing software, real estate database software, mls
software, multiple listing service software, scheduler, spreadsheet,
settlement sheets, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant impact
gold, Information Products, salesimpact, sales impact, the lenders edge,
lenders edge, lender's edge, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant
impact gold, Information Products, salesimpact, sales impact, the lenders
edge, lenders edge, lender's edge