Fields List - Recipe (Ingredients) Export

Recipe drop-down

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 Amount¹	Float	¹ Three 'Cost [X]' fields are used together. For example "5 pounds costs 2.75" - Amount: 2.75 \| Measure: Pound \| Quantity: 5
Cost Measure¹	Text
Cost Per Serving	Float
Cost Quantity¹	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
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 Weight²	Float	² Three 'Unit [X]' fields are used together. For example "5 pieces = 75 g" - Gram Weight: 75 \| Measure: Piece \| Quantity: 5
Unit Measure²	Text
Unit Quantity²	Float
User Code	Text
Volume Gram Weight³	Float	³ Three 'Volume [X]' fields are used together. For example "1.5 cup = 350 g" - Gram Weight: 350 \| Measure: Cup \| Quantity: 1.5
Volume Measure³	Text
Volume Quantity³	Float
Weight - Total	Float
Weight - Yield	Float

Items drop-down

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

Nutrients drop-down

Unrounded analysis value for each Item (“Ingredient”) per serving.

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

Allergens drop-down

Each exported Allergen is reflected as T/F

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

Attributes drop-down

Field	Type	Notes
Bioengineered	Yes/No/Unknown	Yes = Qualifies \| No = Does Not Qualify \| Unknown = Unknown