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





Notes

Memo





Units

String
10




StockDate

DateTime

Date & time combination to calculate stock



Date

Date





Start Time

Time





Finish Time

Time





Operator

String
25




Growth_Stage

String
45




Problem

String
35




Soil_Cond

Memo

Soil condition



Invoice

Memo





Water_Vol

Memo

Water volume



PType

String
35
Product type (pesticide, etc)



Manu

Memo

Manufacturer



HGroup

Memo

Hazard group



Precaution

Memo





Maff

Memo





Comment

Memo





Disposal

Memo





ProType

Memo

Ingredient type (liquid, etc)



Batch

Currency

Batch number



HInterval

Memo

Old unused harvest interval



EndDate

Date





HIntervalDate

Date

Date of harvest based on harvest interval



HIntervalDays

Currency

Harvert interval days count



Buffer

Memo





AppMix

Integer

Application mix number



AssessDate

Date





Dose

Memo





Assessor

String
25




Watercourse

Memo





Star

Memo





Category

Memo





BufferZone

Memo





Season

String
9
Season cost related to



N

Currency





P

Currency





K

Currency





S

Currency





B

Currency





Ca

Currency





Mg

Currency





Mn

Currency





N1

Currency

User defined nutrient values



N2

Currency





N3

Currency





N4

Currency





Dressing

Memo





Seeds/SqM

Memo





Plants/SqM

Memo





Establish

Memo





Ears/SqM

Memo





Cost Type

String
10
Main cost type (chemical, fertiliser, etc



Variety

String
25




Stock Code

Integer





Spread

Integer

Number of years of spread



Machine

String
30




CType

String
30
Cost type sub category



Record Number

AutoInc





FieldArea

Currency

Used to calculate the true cost/area



   
Planner records match 'records.dat', however the field's name and owner are also included.
            

Index (Field.dat)
Record Number
Field Code
Season
Cost Type
Date
Start Time
Stock Code
AppMix
Batch
StockDate
Problem
PType
CType