Field | Type | Notes |
|---|
Name | Text | |
Gram Weight (g) | Float | |
Alternate Name (English) | Text | |
Alternate Name (French) | Text | |
Alternate Name (Spanish) | Text | |
BLANK (empty field) | | repeatable - used to provide blank column |
Common Name | 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 Quantity1 | Float | |
Creation Date | DateTime | |
ESHA Code | INT | |
Gov. Code | INT | |
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 | DateTime | |
Notes 1 | Text | |
Notes 2 | Text | |
Notes 3 | Text | |
Primary Key | INT | |
Product Code | INT | |
Product Name | Text | |
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 | |