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