Data Structure
|
Field Track Main Help Top Previous Next |
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
|
|
|
|
|
|
|
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
|
|
|
|