Entity Definition

Logical Name : StockItemConsumerProductLabel
Physical Name : AS_LB_STK_ITM_PDT

Identifies and describes the stock item for presentation on a label designed to inform or warn consumers about the product.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
ServingSizeUnitOfMeasureCode The unit of measure assigned to the item for serving size counts. LU_UOM_SRV_SZ Quantity DECIMAL(9,3)
ConsumerLabelTypeCode Defines the type of information to be carried on the label. Examples include nutritional information, hazard warnings, OSHA warnings, handling warnings, laundering instructions, etc. TY_LB_CNS Code2 char(2)
ServingSizeUnitOfMeasureCount The count or number of serving unit of measures in a serving. QU_UOM_SRV_SZ Quantity DECIMAL(9,3)
ServingsInRetailSaleUnitCount Number of servings in a retail sale unit for the item. QU_UN_RT_SRV Quantity DECIMAL(9,3)
CaloriesCount A count of the number of calories in the serving unit. QU_CLRS Quantity DECIMAL(9,3)
CaloriesFromFatCount The number of calories derived from fat for the serving unit of the item QU_CLRS_FRM_FAT Quantity DECIMAL(9,3)
TotalFatGramsQuantity Total fat weight in grams for the serving of the item. QU_FAT_GM_TOT Quantity DECIMAL(9,3)
TotalFatDailyIntakePercent The input percentage of fat based on the total-fat-grams amount. PE_INTK_DLY_FAT_TOT Percent decimal(7,4)
SaturatedFatGramsQuantity Total saturated fat weight in grams for the serving of the item. QW_FAT_STRT_GM Quantity DECIMAL(9,3)
SaturatedFatPercent The input percentage of saturated fat based on the total-fat-grams amount. PE_FAT_STRT Percent decimal(7,4)
CholesterolMilligramsCount The weight (in milligrams) of cholesterol found in a serving. QW_CHT_MG Quantity DECIMAL(9,3)
CholesterolPercent The percent of daily recommended allowance for cholesterol in a serving. PE_CHT Percent decimal(7,4)
SodiumMilligramsCount The weight (in milligrams) of sodium found in a serving. QW_SDM_MG Quantity DECIMAL(9,3)
SodiumPercent The percent of daily recommended allowance for sodium in a serving. PE_SDM Percent decimal(7,4)
TotalCarbohydrateMilligramsCount The weight (in milligrams) of carbohydrate found in a serving. QW_CBHYD_MG_TOT Quantity DECIMAL(9,3)
Total CarbohydratePercent The percent of daily recommended allowance for carbohydrate in a serving. PE_CBHYD_TOT Percent decimal(7,4)
DietaryFiberGramsCount The weight in grams of the dietary fiber contained in a serving QW_FB_GM Quantity DECIMAL(9,3)
SugarsGramsCount The weight in grams of sugars for a serving. QW_SGR_GM Quantity DECIMAL(9,3)
ProteinGramsCount The weight of protein, in grams, for a serving QW_PRTN Quantity DECIMAL(9,3)
VitaminADailyMinimumPercent The percentage of minimum daily requirement for Vitamin A PE_VTM_A_DLY_MNM Percent decimal(7,4)
VitaminBDailyMinimumPercent The percentage of minimum daily requirement for Vitamin B PE_VTM_B_DLY_MNM Percent decimal(7,4)
VitaminCDailyMinimumPercent The percentage of minimum daily requirement for Vitamin C PE_VTM_C_DLY_MNM Percent decimal(7,4)
CalciumDailyMinimumPercent The percentage of minimum daily requirement for Calcium PE_CA_DY_MNM Percent decimal(7,4)
IronDailyMinimumPercent The percentage of minimum daily requirement for iron PE_IR_DLY_MNM Percent decimal(7,4)
NutritionalDescriptionText General text description for nutritional information. NA_NTR_TXT DescriptionNarrative varchar(4000)
HazardousMaterialFlag A flag to denote whether this product is classified as a hazardous item. FL_MTR_HZ Flag integer
HazardousMaterialTypeCode A code to denote the type of hazardous material, eg fireworks. TY_MTR_HZ Code4 char(4)


Parent Entity Verb Phrase Child Entity
StockItem describes StockItemConsumerProductLabel

Logical Views containing StockItemConsumerProductLabel

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01050 - Item Description - Labelling View