Fields List - Recipe Import (Create)

Name*

Text(1000)

* Required for Import

Additional Allergen Stmt (English)

Text (Max)

Additional Allergen Stmt (French)

Text (Max)

Additional Allergen Stmt (Spanish)

Text (Max)

Additional Allergen Stmts Are User Generated

Boolean

T / F

Allergen Statement (English)

Text (Max)

Allergen Statement (French)

Text (Max)

Allergen Statement (Spanish)

Text (Max)

Allergen Stmts Are User Generated

Boolean

T / F

Alternate Name (English)

Text(1000)

Alternate Name (French)

Text(1000)

Alternate Name (Spanish)

Text(1000)

Barcode Checksum

Number

Recommended left blank. If blank (NULL), checksum will be calculated.
If supplied, checksum recorded as an override

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(1000)

Cooking Method

Text (30)

Cooking Temperature

Text (15)

Cooking Time

Text (15)

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¹

Exact Text or ENUM

See Document:
Available Measures (Import)

Cost Per Serving

Float

Cost Quantity¹

Float

Creation Date

Date

Ingredient Statement Key

INT

Ingredient Stmt (English)

Text (MAX)

Ingredient Stmt (French)

Text (MAX)

Ingredient Stmt (Spanish)

Text (MAX)

Ingredient Stmts Are User Generated

Boolean

T / F

Is Fat

Boolean

Is Sugar

Boolean

Is Sweetener

Boolean

Modified Date

Date

Notes 1

Text (MAX)

Notes 2

Text (MAX)

Notes 3

Text (MAX)

Pan Size

Text (45)

Preparation Instructions

Text (3800)

Preparation Time

Text (15)

Primary Key

INT

Product Code

INT

Product Name

Text (75)

Serving Size is by Wgt

Boolean

T / F

Serving Size Measure

Exact Text or ENUM

See Document:
Available Measures (Import)

Serving Size Quantity

Float

Supplier Code

INT

Supplier Name

Text (255)

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²

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)

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³

Exact Text or ENUM

See Document:
Available Measures (Import)

Volume Quantity³

Float

Barcode Image Path

Ignored

Country

Text

Front of Package Image Path

Ignored

Nutrition Facts Image Path

Ignored

Serving Size Description (English)

Text (100)

Serving Size Description (French)

Text (100)

Serving Size Description (Spanish)

Text (100)

Serving Size Weight 

Text

Defined or calculated serving size, rounded per regulations

Servings Per Container (English)

Text (100)

Servings Per Container (French)

Text (100)

Servings Per Container (Spanish)

Text (100)

Item Alternate Name (English)

Text (1000)

Item Alternate Name (French)

Text (1000)

Item Alternate Name (Spanish)

Text (1000)

Item Comments

Text (2000)

Item Common Name

Text (1000)

Item Document Type

ENUM

1 = Ingredient | 2 = Recipe | 50 = Composite Ingredient
if Blank (NULL), Ingredient (1) is default

Item ESHA Code*⁵

INT

* Required for Import
⁵ In addition to (1) Recipe Name, (2) Item Name, (3) Item Quantity, (4) Item Measure, (5) Item User Code and/or Item ESHA Code is required

Item Gov. Code

INT

Item Gram Weight (Gross)

Float

Item Gram Weight (Net)

Float

Item Ingredient Statement Key

INT

Item Ingredient Stmt (English)

Text (MAX)

Item Ingredient Stmt (French)

Text (MAX)

Item Ingredient Stmt (Spanish)

Text (MAX)

Item Ingredient Stmts Are User Defined

Boolean

T / F ;
True sets override to use static text as Ingredient Statement instead of Program Generated 

Item Measure*

Exact Text or ENUM

* Required for Import
See Document:
Available Measures (Import)

Item Name*

Text (1000)

* Required for Import

Item Notes 1

Text (MAX)

Item Notes 2

Text (MAX)

Item Notes 3

Text (MAX)

Item Primary Key

INT

Item Product

Text (75)

Item Product Code

INT

Item Quantity*

Float

* Required for Import

Item Supplier

Text (255)

Item Supplier Code

INT

Item User Code*⁵

Text (400)

* Required for Import
⁵ In addition to (1) Recipe Name, (2) Item Name, (3) Item Quantity, (4) Item Measure, (5) Item User Code and/or Item ESHA Code is required

Item Yield Key

INT

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

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