| |
AVAILABLE FIELDS |
TYPE |
|
| |
Audit |
Numeric |
|
| |
AuditText |
Text (50) |
|
| |
CertificateNumber |
Text (50) |
|
| |
CertificateType |
Numeric |
1=ACO,2=NASAA,3=DEMETER,4=OFC (Organic Food Chain),
5=Safe Food Queensland,6=Tasmanian Organis-Dynamic Producers (TOP),7=USDA Organics (US),
8=Soil Association Organic Standard (UK),9=Organic Farmers & Growers (UK),10=Certified Organic (NZ),
11=Certified Organic Agriquality (NZ),12=Organic Farming,13=Other |
| |
CertificateTypeText |
Text (50) |
|
| |
DateIssued |
Date |
|
| |
Details |
Text (2000) |
|
| |
EndDate |
Date |
|
| |
EvidenceReceived |
Text (1) |
Y/N |
| |
Id |
Numeric |
|
| |
IngredientStatus |
Numeric |
1=Approved,2=Declined,3=Pending,4=Waiting On Evidence |
| |
IngredientStatusText |
Text (50) |
|
| |
LabelStatus |
Numeric |
1=Approved,2=Declined,3=Pending,4=Waiting On Evidence |
| |
LabelStatusText |
Text (50) |
|
| |
Notes |
Text (2000) |
|
| |
ProcessingStatus |
Numeric |
1=Application Received,2=Under Review,3=No Progress,4=Declined,5=Approved |
| |
ProcessingStatusText |
Text (50) |
|
| |
Product |
Numeric |
Specific for each space |
| |
ProductText |
Text (50) |
|
| |
ProductStatus |
Numeric |
1=Approved,2=Declined,3=Pending,4=Waiting On Evidence |
| |
ProductStatusText |
Text (50) |
|
| |
Reference |
Text (50) |
|
| |
Sent |
Text (1) |
Y/N |
| |
SentDate |
Date |
|
| |
StartDate |
Date |
|
| |
Subscription |
Numeric |
|
| |
SubscriptionText |
Text (50) |
|
| |
SupplierContactBusiness |
Numeric |
|
| |
SupplierContactBusinessText |
Text (50) |
|
| |
SupplierNotified |
Text (1) |
Y/N |
| |
|
|
|
| |
* |
|
Indicates a default field |
| |
Audit Fields |
|
Click here for more information |