Vendor Management Reports General Reports Vendor List Description List all WIC-authorized active vendors in the selected Local Agency to be given to new clients so they know where to shop. Include Store name and address, phone number, and store type. Parameters Chain, Vendor Status (All, Active or Inactive), Local Agency, City, Peer Group, Store Type, Date, Sort By (‘Vendor ID’, Name’ or City), ‘Vendor Group By (‘Local Agency’ or Group’) ‘Peer Note: City is disabled the Local Agency value(s) is selected. After the Local Agency value(s) is selected, the City values that are available are presented based on the physical address of the vendors assigned to the selected Local Agencies. Record Return all vendors associated with the selection parameters. Selection / Type = TIP type. Date = Use when determining selection for Filtering / Vendor Status and Store Type. Calculations Columns If Group By = Agency’ ‘Local Local Agency Vendor.LA_ID – If Group By = Group’ ‘Peer Peer VendorPGFactor.PG_ID based on date – Any By parameter Vendor ID Vendor.FFVendorID – Vendor Vendor.StoreName – Street Address VendorAddress.StreetAddrLine1 and – StreetAddrLine2 (Physical Address) Location VendorAddress.Location (Physical Address) – City VendorAddress.City (Physical Address) – Zip VendorAddress.ZipCode + ZipPlue4 (Physical Address) – Vendor.GeneralStoreAreaCd + Vendor. GeneralStorePhoneNr – Store Type – VendorOperations.TIPStoreTypeCd based on date
Vendor Management Reports General Reports Vendor List Description List all WIC-authorized active vendors in the selected Local Agency to be given to new clients so they know where to shop. Include Store name and address, phone number, and store type. Parameters Chain, Vendor Status (All, Active or Inactive), Local Agency, City, Peer Group, Store Type, Date, Sort By (‘Vendor ID’, ‘Vendor Name’ or City), Group By (‘Local Agency’ or ‘Peer Group’) Note: City is disabled the Local Agency value(s) is selected. After the Local Agency value(s) is selected, the City values that are available are presented based on the physical address of the vendors assigned to the selected Local Agencies. Record Selection / Filtering / Calculations Return all vendors associated with the selection parameters. Type = TIP type. Date = Use when determining selection for Vendor Status and Store Type. Columns If Group By = ‘Local Agency’ Local Agency – Vendor.LA_ID If Group By = ‘Peer Group’ Peer – VendorPGFactor.PG_ID based on date Any By parameter Vendor ID – Vendor.FFVendorID Vendor – Vendor.StoreName Street Address – VendorAddress.StreetAddrLine1 and StreetAddrLine2 (Physical Address) Location – VendorAddress.Location (Physical Address) City – VendorAddress.City (Physical Address) Zip – VendorAddress.ZipCode + ZipPlue4 (Physical Address) – Vendor.GeneralStoreAreaCd + Vendor. GeneralStorePhoneNr Store Type – VendorOperations.TIPStoreTypeCd based on date
DFDD%20VM%20Vendor%20Management%20Reports%20(3).docx