Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

 Recipe drop-down

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

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

 Label drop-down

Field

Type

Notes

Barcode Image Path

Text

Path to image location

Country

Text

Front of Package Image Path

Text

Path to image location

Nutrition Facts Image Path

Text

Path to image location

Serving Size Description (English)

Text

Serving Size Description (French)

Text

Serving Size Description (Spanish)

Text

Serving Size Weight 

Text

Servings Per Container (English)

Text

Servings Per Container (French)

Text

Servings Per Container (Spanish)

Text

 Allergens drop-down

Each exported Allergen is reflected as T/F

Field

Type

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

 Amt Per Serv (US) drop-down

Exported value rounded per regulations. Values are numbers, varying in decimal precision depending on rounding rules

Field

Type

Notes

18:0 - Stearic (g)

Float

Added Sugar (g)

Float

Biotin (mcg)

Float

Calcium (mg)

Float

Calories (kcal)

Float

Calories from Fat (kcal)

Float

Calories from SatFat (kcal)

Float

Carbohydrates (g)

Float

Chloride (mg)

Float

Cholesterol (mg)

Float

Choline (mg)

Float

Chromium (mcg)

Float

Copper (mg)

Float

Dietary Fiber (2016) (g)

Float

Fat (g)

Float

Fluoride (mg)

Float

Folate, DFE (mcg DFE)

Float

Insoluble Fiber (2016) (g)

Float

Iodine (mcg)

Float

Iron (mg)

Float

Magnesium (mg)

Float

Manganese (mg)

Float

Molybdenum (mcg)

Float

Mono Fat (g)

Float

Other Carbs (g)

Float

Pantothenic Acid (mg)

Float

Phosphorus (mg)

Float

Poly Fat (g)

Float

Potassium (mg)

Float

Protein (g)

Float

Saturated Fat (g)

Float

Selenium (mcg)

Float

Sodium (mg)

Float

Soluble Fiber (2016) (g)

Float

Sugar Alcohol (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

Vitamin A - RAE (mcg)

Float

Vitamin B1 - Thiamin (mg)

Float

Vitamin B12 (mcg)

Float

Vitamin B2 - Riboflavin (mg)

Float

Vitamin B3 - Niacin Equiv (mg)

Float

Vitamin B6 (mg)

Float

Vitamin C (mg)

Float

Vitamin D - mcg (mcg)

Float

Vitamin E - Alpha-Toco (mg)

Float

Vitamin K (mcg)

Float

Zinc (mg)

Float

 Amt Per Serv (Canada) drop-down

Exported value rounded per regulations. Values are numbers, varying in decimal precision depending on rounding rules

Field

Type

Notes

Calories (kcal)

Float

Calories from Fat (kcal)

Float

Calories from SatFat (kcal)

Float

Carbohydrates (g)

Float

Cholesterol (mg)

Float

Fat (g)

Float

Kilojoules (kJ)

Float

Mono Fat (g)

Float

Omega 3 Fatty Acid (g)

Float

Omega 6 Fatty Acid (g)

Float

Poly Fat (g)

Float

Potassium (mg)

Float

Protein (g)

Float

Saturated Fat (g)

Float

Sodium (mg)

Float

Starch (g)

Float

Sugar Alcohol (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

 Percent DV (US) drop-down

Exported value rounded per regulations. Values are numbers, varying in decimal precision depending on rounding rules

Field

Type

Notes

Added Sugar %DV

Float

Biotin %DV

Float

Calcium %DV

Float

Carbohydrates %DV

Float

Chloride %DV

Float

Cholesterol %DV

Float

Choline %DV

Float

Chromium %DV

Float

Copper %DV

Float

Dietary Fiber (2016) %DV

Float

Fat %DV

Float

Folate %DV

Float

Folate, DFE %DV

Float

Iodine %DV

Float

Iron %DV

Float

Magnesium %DV

Float

Manganese %DV

Float

Molybdenum %DV

Float

Pantothenic Acid %DV

Float

Phosphorus %DV

Float

Potassium %DV

Float

Protein %DV

Float

Saturated Fat %DV

Float

Selenium %DV

Float

Sodium %DV

Float

Total Dietary Fiber %DV

Float

Vitamin A - IU %DV

Float

Vitamin A - RAE %DV

Float

Vitamin B1 - Thiamin %DV

Float

Vitamin B12 %DV

Float

Vitamin B2 - Riboflavin %DV

Float

Vitamin B3 - Niacin %DV

Float

Vitamin B3 - Niacin Equiv %DV

Float

Vitamin B6 %DV

Float

Vitamin C %DV

Float

Vitamin D - IU %DV

Float

Vitamin D - mcg %DV

Float

Vitamin E - Alpha-Toco %DV

Float

Vitamin E - IU %DV

Float

Vitamin K %DV

Float

Zinc %DV

Float

 Percent DV (Canada) drop-down

Exported value rounded per regulations. Values are numbers, varying in decimal precision depending on rounding rules

Field

Type

Notes

Biotin %DV

Float

Calcium %DV

Float

Carbohydrates %DV

Float

Chloride %DV

Float

Cholesterol %DV

Float

Chromium %DV

Float

Copper %DV

Float

Fat %DV

Float

Folate %DV

Float

Iodine %DV

Float

Iron %DV

Float

Magnesium %DV

Float

Manganese %DV

Float

Molybdenum %DV

Float

Pantothenic Acid %DV

Float

Phosphorus %DV

Float

Potassium %DV

Float

Protein %DV

Float

Saturated Fat %DV

Float

Selenium %DV

Float

Sodium %DV

Float

Total Dietary Fiber %DV

Float

Trans Fatty Acid %DV

Float

Vitamin A - RE %DV

Float

Vitamin B1 - Thiamin %DV

Float

Vitamin B12 %DV

Float

Vitamin B2 - Riboflavin %DV

Float

Vitamin B3 - Niacin Equiv %DV

Float

Vitamin B6 %DV

Float

Vitamin C %DV

Float

Vitamin D - mcg %DV

Float

Vitamin E - mg %DV

Float

Vitamin K %DV

Float

Zinc %DV

Float

  • No labels