Fields List - Recipe (Analysis) Export

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