Data Structure

Field Track  Main Help  Top  Previous  Next

Field Track Database Structure

Here are the main database structures for the Field Track databases. This information is useful for PDA import/Export, as well as report writing. "Index" entries are for database fields that are indexed and thus far faster if used in searches (reports).

Field.dat (Field Records)

Field Name	Type	Size	Detail
Field Name	String	30
Season	String	9	Season record relates to
Field Number	String	25
OS Ref	String	40
Holding Farm	String	40
Map Size	Currency
Area	Currency
IACS Area	Currency
IACS	Boolean
Present Crop	String	25
Variety	String	25
Fert Costs	Currency		Total cost
Fert GM	Currency		Cost/field area
Chem Costs	Currency
Chem GM	Currency
Seed Costs	Currency
Seed GM	Currency
Misc Costs	Currency
Misc GM	Currency
Fixed Costs	Currency
Fixed GM	Currency
Main Income	Currency
Main Income GM	Currency
Main Income Percent	Currency
Second Income	Currency
Second Income GM	Currency
Misc Income	Currency
Misc Income GM	Currency
Yield/Area	Currency
GMArea	Currency		Gross margin/total area
GMTotal	Currency		Total gross margin
Total Yield	Currency
Price	Currency		Current product selling price
Notes	Memo				Permanent notes
Fert_Bud	Currency		Total cost budget
Chem_Bud	Currency
Seed_Bud	Currency
Fix_Bud	Currency
Misc_Bud	Currency
MainI_Bud	Currency
SecI_Bud	Currency
Miin_Bud	Currency
FertGM_Bud	Currency		Cost budget/field area
ChemGM_Bud	Currency
SeedGM_Bud	Currency
FixGM_Bud	Currency
MiscGM_Bud	Currency
MainIGM_Bud	Currency
SecIGM_Bud	Currency
MiinGM_Bud	Currency
Costs_Bud	Currency
GM_Bud	Currency		Total gross margin budget
GMArea_Bud	Currency		Gross margin/area budget
CostsArea_Bud	Currency
Analysis	Memo		Permanent analysis codes
Sale Crop	String	25
Notes2	Memo		Yearly notes
Company	String	30
Analysis2	Memo		Yearly analysis codes
Soil_Group	Memo
Soil_Series	Memo
Soil_Type	String	40
Soil_Grade	Memo
Date	Date		Soil related date
PH	Currency
P	Currency
K	Currency
Mg	Currency
Cu	Currency
Na	Currency
Mn	Currency
S	Currency
B	Currency
Ca	Currency
P-Index	Memo
K-Index	Memo
MG-Index	Memo
Adjust_Fixed	Currency
Adjust_FixedArea	Currency
Location	Memo		Not used
BufferZone	Memo
Field Code	AutoInc
Base Field	Integer		Link similar fields across seasons
Harvest Date	Date

Index (Field.dat)
Field Code
Base Field
PH
IACS
Season
Field Name
Sale Crop
Present Crop
Variety
Holding Farm
Company
Harvest Date

Records.dat (Application Records)

Field Name		Type	Size	Detail
Field Code		Integer
Seller		String	40
Product		String	25
Crop Type		String	25
Ingredients		Memo
Weather		Memo
Price/Unit		Currency
Rate/Area		Currency
Area		Currency
Cost/Area		Currency
Total Cost		Currency
Total Quantity		Currency