UPC/PLU List for Vendors This report is for EBT States only. Description This report contains the active UPCs/PLUs within a given time period. Parameters Category (All, Select One or more) Active only (categories that have – an Effective Date (FoodCategory.EffectiveDt) and End Date (FoodCategory.EndDt) within the Start and End Date parameters (inclusive)) Subcategory (All, Select One or more) Do not show any 000 – subcategories Active only (subcategories that have an Effective Date – (Product.EffectiveDt) and End Date (Product.EndDt) within the Start and End Date parameters (inclusive)) Start Date End Date Sub Titles Active from <Start Date> through <End Date> Record Based on the entered subcategories, select all UPC/PLU (DetailProduct) Selection / that were effective for any time within the entered time period. This is Filtering / based on the UPC/PLU dates (DetailProduct.EffectiveDt and Calculations DetailProduct.EndDt). Columns Category / Subcategory line: Category / Subcategory (Formatted as 99 XXX / 999 XXX) number> <category name> + + <subcategory ‘/‘ number> <subcategory name> on DP_ID, get FoodCategory.CategoryNr, FoodCategory.Name, Product.SubCategoryNr, Product.Name). Detail line: UPC/PLU DetailProduct.UPC (formatted form) – UPC Description DetailProduct.Description. – Effective Date DetailProduct.EffectiveDt – End Dates DetailProduct.EndDt – Sort Order Category / Subcategory Number, UPC/PLU Number Total / Count None Columns Totals None Primary Group None (page break) Additional None Group By Notes None
UPC/PLU List for Vendors This report is for EBT States only. Description This report contains the active UPCs/PLUs within a given time period. Parameters Category (All, Select One or more) – Active only (categories that have an Effective Date (FoodCategory.EffectiveDt) and End Date (FoodCategory.EndDt) within the Start and End Date parameters (inclusive)) Subcategory (All, Select One or more) – Do not show any 000 subcategories – Active only (subcategories that have an Effective Date (Product.EffectiveDt) and End Date (Product.EndDt) within the Start and End Date parameters (inclusive)) Start Date End Date Sub Titles Active from <Start Date> through <End Date> Record Selection / Filtering / Calculations Based on the entered subcategories, select all UPC/PLU (DetailProduct) that were effective for any time within the entered time period. This is based on the UPC/PLU dates (DetailProduct.EffectiveDt and DetailProduct.EndDt). Columns Category / Subcategory line: Category / Subcategory (Formatted as 99 XXX / 999 XXX) number> <category name> + ‘/‘ + <subcategory number> <subcategory name> on DP_ID, get FoodCategory.CategoryNr, FoodCategory.Name, Product.SubCategoryNr, Product.Name). Detail line: UPC/PLU – DetailProduct.UPC (formatted form) UPC Description – DetailProduct.Description. Effective Date – DetailProduct.EffectiveDt End Dates – DetailProduct.EndDt Sort Order Category / Subcategory Number, UPC/PLU Number Total / Count Columns None Totals None Primary Group (page break) None Additional Group By None Notes None
DFDD%20VM%20Vendor%20Management%20Reports%20(3).docx