Fields List - Ingredient Import (Create)

Ingredient drop-down

Field	Type	IMPORT notes
Name*^	Text(1000)	* Required for Import ^ On Import - Create: Value will be written (INSERT). ^ On Import - Update, used as 3rd of 3 Key fields (PrimaryKey, UserCode, Name)
Gram Weight (g)*	Float	* Required for Import
Alternate Name (English)	Text(1000)
Alternate Name (French)	Text(1000)
Alternate Name (Spanish)	Text(1000)
BLANK (empty field)		repeatable - used to provide blank column
Common Name	Text(1000)
Cost Amount¹	Float	¹ All three 'Cost [X]' fields are used together. For example "5 pounds costs 2.75" - Amount: 2.75 \| Measure: Pound \| Quantity: 5
Cost Measure¹	Exact Text or ENUM	See Document: Available Measures (Import)
Cost Quantity¹	Float
Creation Date	DateTime
ESHA Code⁺		⁺Do Not Include during Import. If included, import will error (user-created cannot have an ESHA Code value)
Gov. Code	INT
Ingredient Statement Key	INT
Ingredient Stmt (English)	Text (MAX)
Ingredient Stmt (French)	Text (MAX)
Ingredient Stmt (Spanish)	Text (MAX)
Modified Date	DateTime
Notes 1	Text (MAX)
Notes 2	Text (MAX)
Notes 3	Text (MAX)
Primary Key^{^}	INT	^{^}On Import - Create: leave BLANK (NULL) to auto-generate. ^ On Import - Update, used as 1st of 3 Key fields (PrimaryKey, UserCode, Name)
Product Code	INT
Product Name	Text (75)
Supplier Code	INT
Supplier Name	Text (255)
Unit Gram Weight²	Float	² All three 'Unit [X]' fields are used together. For example "5 pieces = 75 g" - Gram Weight: 75 \| Measure: Piece \| Quantity: 5
Unit Measure²	Exact Text or ENUM	See Document: Available Measures (Import)
Unit Quantity²	Float
User Code	Text(400)	^{^}On Import - Create: Value will be written (INSERT). ^{^}On Import - Update, used as 2nd of 3 Key fields (PrimaryKey, UserCode, Name)
Unit Gram Weight²	Float	³ All three 'Volume [X]' fields are used together. For example "1.5 cup = 350 g" - Gram Weight: 350 \| Measure: Cup \| Quantity: 1.5
Unit Measure²	Exact Text or ENUM	See Document: Available Measures (Import)
Unit Quantity²	Float

Nutrients drop-down

Field	Type	IMPORT 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)		Ignored: Calculated from Total Fat
Calories from SatFat (kcal)		Ignored: Calculated from SaturatedFat
Calories from TransFat (kcal)		Ignored: Calculated from Trans Fat
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		Ignored: Calculated as Cost per defined Gram Weight
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)		Ignored: Calculated
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

Allowed values are T/F or 1/0 (1 = True).
Blank/NULL is considered False

Field	Type	IMPORT 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	IMPORT notes
Bioengineered	Yes/No/Unknown	Allowed text is "Yes" (Qualifies), "No" (Does Not Qualify) "Unknown" (Unknown). Blank/NULL is considered "Unknown"
[User-Added Attributes]	Yes/No/Unknown	Allowed text is "Yes" (Qualifies), "No" (Does Not Qualify) "Unknown" (Unknown). Blank/NULL is considered "Unknown"