Fields List - Ingredient Export

Name

Text

Gram Weight (g)

Float

Alternate Name (English)

Text

Alternate Name (French)

Text

Alternate Name (Spanish)

Text

BLANK (empty field)

repeatable - used to provide blank column

Common Name

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 Quantity¹

Float

Creation Date

DateTime

ESHA Code

INT

Gov. Code

INT

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

DateTime

Notes 1

Text

Notes 2

Text

Notes 3

Text

Primary Key

INT

Product Code

INT

Product Name

Text

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

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

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

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