Fields List - Recipe (Label) Export

Owned by Patrick Murphy
Last updated: Dec 22, 2020
5 min read

Field

Type

Notes

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

Is Fat

Boolean

 

Is Sugar

Boolean

 

Is Sweetener

Boolean

 

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

 

Field

Type

Notes

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

 

Each exported Allergen is reflected as T/F

Field

Type

Notes

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

 

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

Field

Type

Notes

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

 

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

Field

Type

Notes

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

Â