Page Comparison

Versions Compared

Old Version 8

changes.mady.by.user Patrick Murphy

Saved on Dec 22, 2020

compared with

New Version Current

changes.mady.by.user Patrick Murphy

Saved on Jun 13, 2023

Key

This line was added.
This line was removed.
Formatting was changed.

Expand

title	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)

^ Listed here for reference, but found under ‘Nutrients’ drop-down within ESHA Port
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


Ing Stmt Name (English)	Text(1000)
Ing Stmt Name (French)	Text(1000)
Ing Stmt Name (Spanish)	Text(1000)
Ingredient Statement (English)	Text (MAX)
Ingredient

Stmt

Statement (French)	Text (MAX)
Ingredient

Stmt

Statement (Spanish)	Text (MAX)
Ingredient Statement Key	INT
Is Fat	Boolean
Is Sugar	Boolean
Is Sweetener	Boolean
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

Volume 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

Volume Measure

Exact Text or ENUM

See Document:
Available Measures (Import)

Unit

Volume Quantity

Float

Expand

title	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
Allulose	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
CBD (mg)	Float
Chloride (mg)	Float
Cholesterol (mg)	Float
Choline (mg)	Float
Chromium (mcg)	Float
Citric Acid (g)	Float
Copper (mg)	Float
Cost		Export Field only 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
Gram Weight (g)* ^	Float	Required for Import ^ Listed here for reference, but found under ‘Nutrients’ drop-down within ESHA Port
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
Maltitol (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
Polydextrose (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
Sulfites (mg)	Float
Sulfites (ppm)	Float
Tagatose (g)	Float
Taurine (g)	Float
THC (mg)	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

Expand

title	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

Expand

title	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"