Fields List - Recipe (Ingredients) 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 |
|---|---|---|
Item Alternate Name (English) | Text |
|
Item Alternate Name (French) | Text |
|
Item Alternate Name (Spanish) | Text |
|
Item Comments | Text |
|
Item Common Name | Text |
|
Item Document Type | ENUM | 1 = Ingredient | 2 = Recipe | 50 = Composite Ingredient |
Item ESHA Code | INT |
|
Item Gov. Code | INT |
|
Item Gram Weight (Gross) | Float |
|
Item Gram Weight (Net) | Float |
|
Item Ingredient Statement Key | INT |
|
Item Ingredient Stmt (English) | Text |
|
Item Ingredient Stmt (French) | Text |
|
Item Ingredient Stmt (Spanish) | Text |
|
Item Ingredient Stmts Are User Defined | Boolean | T / F |
Item Measure | Text |
|
Item Name | Text |
|
Item Notes 1 | Text |
|
Item Notes 2 | Text |
|
Item Notes 3 | Text |
|
Item Primary Key | INT |
|
Item Product | Text |
|
Item Product Code | INT |
|
Item Quantity | Float |
|
Item Supplier | Text |
|
Item Supplier Code | INT |
|
Item User Code | Text |
|
Item Yield Key | INT |
|
Unrounded analysis value for each Item (“Ingredient”) per serving.
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 |
|
Each exported Allergen is reflected as T/F
Field | Type | Notes |
|---|
Field | Type | Notes |
|---|---|---|
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 Attributes] | Yes/No/Unknown | Yes = Qualifies | No = Does Not Qualify | Unknown = Unknown |