Fields List - Recipe (Analysis) Export
- Patrick Murphy
Field | Type | Notes |
---|
Field | Type | Notes |
---|---|---|
Name | Text | Â |
Additional Allergen Stmt (English) | Text | Â |
Additional Allergen Stmt (French) | Text | Â |
Additional Allergen Stmt (Spanish) | Text | Â |
Additional Allergen Stmts Are User Generated | Boolean | T / F |
Allergen Statement (English) | Text | Â |
Allergen Statement (French) | Text | Â |
Allergen Statement (Spanish) | Text | Â |
Allergen Stmts Are User Generated | Boolean | T / F |
Alternate Name (English) | Text | Â |
Alternate Name (French) | Text | Â |
Alternate Name (Spanish) | Text | Â |
Barcode Checksum | Number | 1 digit number |
Barcode Manufacturer Code | Number | 5 digit number |
Barcode Product Code | Number | 5 digit number |
Barcode Product Type | Number | 1 digit number |
BLANK (empty field) | Â | repeatable - used to provide blank column |
Common Name | Text | Â |
Cooking Method | Text | Â |
Cooking Temperature | Text | Â |
Cooking Time | Text | Â |
Cost Amount1 | Float | 1 Three 'Cost [X]' fields are used together. For example "5 pounds costs 2.75" - Amount: 2.75 | Measure: Pound | Quantity: 5 |
Cost Measure1 | Text | Â |
Cost Per Serving | Float | Â |
Cost Quantity1 | Float | Â |
Creation Date | Date | Â |
ESHA Code | Number | Â |
Gov. Code | Number | Â |
Ingredient Statement Key | INT | Â |
Ingredient Stmt (English) | Text | Â |
Ingredient Stmt (French) | Text | Â |
Ingredient Stmt (Spanish) | Text | Â |
Ingredient Stmts Are User Generated | Boolean | T / F |
Is Fat | Boolean | Â |
Is Sugar | Boolean | Â |
Is Sweetener | Boolean | Â |
Modified Date | Date | Â |
Notes 1 | Text | Â |
Notes 2 | Text | Â |
Notes 3 | Text | Â |
Nutrient Content (English) | Text | Â |
Nutrient Content (French) | Text | Â |
Nutrient Content (Spanish) | Text | Â |
Pan Size | Text | Â |
Preparation Instructions | Text | Â |
Preparation Time | Text | Â |
Primary Key | INT | Â |
Product Code | INT | Â |
Product Name | Text | Â |
Serving Size is by Wgt | Boolean | T / F |
Serving Size Measure | Text | Â |
Serving Size Quantity | Float | Â |
Supplier Code | INT | Â |
Supplier Name | Text | Â |
Unit Gram Weight2 | Float | 2 Three 'Unit [X]' fields are used together. For example "5 pieces = 75 g" - Gram Weight: 75 | Measure: Piece | Quantity: 5 |
Unit Measure2 | Text | Â |
Unit Quantity2 | Float | Â |
User Code | Text | Â |
Volume Gram Weight3 | Float | 3 Three 'Volume [X]' fields are used together. For example "1.5 cup = 350 g" - Gram Weight: 350 | Measure: Cup | Quantity: 1.5 |
Volume Measure3 | Text | Â |
Volume Quantity3 | Float | Â |
Weight - Total | Float | Â |
Weight - Yield | Float | Â |
Field | Type | Notes |
---|
Field | Type | Notes |
---|---|---|
10:0 - Capric (g) | Float | Â |
12:0 - Lauric (g) | Float | Â |
14:0 - Myristic (g) | Float | Â |
14:1 - Myristol (g) | Float | Â |
15:0 - Pentadec (g) | Float | Â |
15:1 - Pentadecenoic (g) | Float | Â |
16:0 - Palmitic (g) | Float | Â |
16:1 - Palmitol (g) | Float | Â |
17:0 - Heptadec (g) | Float | Â |
17:1 - Heptadecenoic (g) | Float | Â |
18:0 - Stearic (g) | Float | Â |
18:1 - Oleic (g) | Float | Â |
18:2 - Linoleic (g) | Float | Â |
18:3 - Linolenic (g) | Float | Â |
18:4 - Stearidon (g) | Float | Â |
20:0 - Arachidic (g) | Float | Â |
20:1 - Eicosen (g) | Float | Â |
20:3 - Eicosatrienoic (g) | Float | Â |
20:4 - Arachidon (g) | Float | Â |
20:5 - EPA (g) | Float | Â |
22:0 - Behenate (g) | Float | Â |
22:1 - Erucic (g) | Float | Â |
22:5 - DPA (g) | Float | Â |
22:6 - DHA (g) | Float | Â |
24:0 - Tetracos (g) | Float | Â |
24:1 - Nervonic (g) | Float | Â |
4:0 - Butyric (g) | Float | Â |
6:0 - Caprioc (g) | Float | Â |
8:0 - Caprylic (g) | Float | Â |
Acetic Acid (g) | Float | Â |
Added Sugar (g) | Float | Â |
Alanine (g) | Float | Â |
Alcohol (g) | Float | Â |
Alpha-Carotene (mcg) | Float | Â |
Arginine (g) | Float | Â |
Artificial Sweetener (mg) | Float | Â |
Ash (g) | Float | Â |
Aspartame (mg) | Float | Â |
Aspartic Acid (g) | Float | Â |
Beta-Carotene (mcg) | Float | Â |
Beta-Carotene Equiv (mcg) | Float | Â |
Biotin (mcg) | Float | Â |
Boron (mcg) | Float | Â |
Caffeine (mg) | Float | Â |
Calcium (mg) | Float | Â |
Calories (kcal) | Float | Â |
Calories from Fat (kcal) | Float | Â |
Calories from SatFat (kcal) | Float | Â |
Calories from TransFat (kcal) | Float | Â |
Carbohydrate (Available) (g) | Float | Â |
Carbohydrates (g) | Float | Â |
Carotenoid RE (mcg) | Float | Â |
Chloride (mg) | Float | Â |
Cholesterol (mg) | Float | Â |
Choline (mg) | Float | Â |
Chromium (mcg) | Float | Â |
Citric Acid (g) | Float | Â |
Copper (mg) | Float | Â |
Cost | Float | Â |
Cryptoxanthin (mcg) | Float | Â |
Cystine (g) | Float | Â |
Dietary Fiber (2016) (g) | Float | Â |
Disaccharides (g) | Float | Â |
Erythritol (g) | Float | Â |
Exchange - Alcohol | Float | Â |
Exchange - Fat | Float | Â |
Exchange - Fruit | Float | Â |
Exchange - Lean Meat | Float | Â |
Exchange - NonFat Milk | Float | Â |
Exchange - Other Carbs | Float | Â |
Exchange - Starch | Float | Â |
Exchange - Vegetables | Float | Â |
Fat (g) | Float | Â |
Fluoride (mg) | Float | Â |
Folate (mcg) | Float | Â |
Folate, DFE (mcg DFE) | Float | Â |
Folate, food (mcg) | Float | Â |
Folic Acid (mcg) | Float | Â |
Fructose (g) | Float | Â |
Galactose (g) | Float | Â |
Glucose (g) | Float | Â |
Glutamic Acid (g) | Float | Â |
Glycemic Index | Float | Â |
Glycemic Load | Float | Â |
Glycerol (g) | Float | Â |
Glycine (g) | Float | Â |
Histidine (g) | Float | Â |
Inositol (g) | Float | Â |
Insoluble Fiber (2016) (g) | Float | Â |
Insoluble Non-digestible Carbohydrate (g) | Float | Â |
Iodine (mcg) | Float | Â |
Iron (mg) | Float | Â |
Isoleucine (g) | Float | Â |
Kilojoules (kJ) | Float | Â |
Lactic Acid (g) | Float | Â |
Lactitol (g) | Float | Â |
Lactose (g) | Float | Â |
Leucine (g) | Float | Â |
Lutein & Zeaxanthin (mcg) | Float | Â |
Lycopene (mcg) | Float | Â |
Lysine (g) | Float | Â |
Magnesium (mg) | Float | Â |
Malic Acid (g) | Float | Â |
Maltose (g) | Float | Â |
Manganese (mg) | Float | Â |
Mannitol (g) | Float | Â |
Methionine (g) | Float | Â |
Molybdenum (mcg) | Float | Â |
Mono Fat (g) | Float | Â |
Monosaccharides (g) | Float | Â |
MyPlate - Dairy (c) | Float | Â |
MyPlate - Fruit (c) | Float | Â |
MyPlate - Grain Total (oz-eq) | Float | Â |
MyPlate - Protein Total (oz-eq) | Float | Â |
MyPlate - Vegetable Total (c) | Float | Â |
Net Carbs (g) | Float | Â |
Non-digestible Carbohydrate (g) | Float | Â |
Omega 3 Fatty Acid (g) | Float | Â |
Omega 6 Fatty Acid (g) | Float | Â |
Organic Acids (g) | Float | Â |
Other Carbs (g) | Float | Â |
Pantothenic Acid (mg) | Float | Â |
Phenylalanine (g) | Float | Â |
Phosphorus (mg) | Float | Â |
Poly Fat (g) | Float | Â |
Potassium (mg) | Float | Â |
Proline (g) | Float | Â |
Protein (g) | Float | Â |
Retinol RE (mcg) | Float | Â |
Saccharin (mg) | Float | Â |
Salatrims (g) | Float | Â |
Salt (g) | Float | Â |
Saturated Fat (g) | Float | Â |
Selenium (mcg) | Float | Â |
Serine (g) | Float | Â |
Sodium (mg) | Float | Â |
Soluble Fiber (2016) (g) | Float | Â |
Soluble Non-digestible Carbohydrate (g) | Float | Â |
Sorbitol (g) | Float | Â |
Starch (g) | Float | Â |
Sucrose (g) | Float | Â |
Sugar Alcohol (g) | Float | Â |
Taurine (g) | Float | Â |
Threonine (g) | Float | Â |
Total Dietary Fiber (g) | Float | Â |
Total Insoluble Fiber (g) | Float | Â |
Total Soluble Fiber (g) | Float | Â |
Total Sugars (g) | Float | Â |
Trans Fatty Acid (g) | Float | Â |
Tryptophan (g) | Float | Â |
Tyrosine (g) | Float | Â |
Valine (g) | Float | Â |
Vitamin A - IU (IU) | Float | Â |
Vitamin A - RAE (mcg) | Float | Â |
Vitamin A - RE (mcg) | Float | Â |
Vitamin B1 - Thiamin (mg) | Float | Â |
Vitamin B12 (mcg) | Float | Â |
Vitamin B2 - Riboflavin (mg) | Float | Â |
Vitamin B3 - Niacin (mg) | Float | Â |
Vitamin B3 - Niacin Equiv (mg) | Float | Â |
Vitamin B6 (mg) | Float | Â |
Vitamin C (mg) | Float | Â |
Vitamin D - IU (IU) | Float | Â |
Vitamin D - mcg (mcg) | Float | Â |
Vitamin E - Alpha-Toco (mg) | Float | Â |
Vitamin E - Alpha-Toco Equiv (mg) | Float | Â |
Vitamin E - IU (IU) | Float | Â |
Vitamin E - mg (mg) | Float | Â |
Vitamin K (mcg) | Float | Â |
Water (g) | Float | Â |
Xylitol (g) | Float | Â |
Zinc (mg) | Float | Â |
Field | Type | Notes |
---|
Field | Type | Notes |
---|---|---|
 |  | Each exported Allergen is reflected as T/F |
Allergen Celery | Boolean | Â |
Allergen Crustaceans | Boolean | Â |
Allergen Egg | Boolean | Â |
Allergen Fish | Boolean | Â |
Allergen Gluten | Boolean | Â |
Allergen Lupin | Boolean | Â |
Allergen Milk | Boolean | Â |
Allergen Molluscs | Boolean | Â |
Allergen Mustard | Boolean | Â |
Allergen Peanut | Boolean | Â |
Allergen Sesame Seeds | Boolean | Â |
Allergen Shellfish | Boolean | Â |
Allergen Soy | Boolean | Â |
Allergen Sulphites | Boolean | Â |
Allergen Tree Nuts | Boolean | Â |
Allergen Wheat | Boolean | Â |
Field | Type | Notes |
---|
Field | Type | Notes |
---|---|---|
Bioengineered | Yes/No/Unknown | Yes = Qualifies | No = Does Not Qualify | Unknown = Unknown |
[User-Added Attribute Fields] | Yes/No/Unknown | Yes = Qualifies | No = Does Not Qualify | Unknown = Unknown |