Rolling Back

Issues

query
RESULTSET
query
  CountsCases_LBS assignedContractNbr col_9 contractDescription contractEnd contractStart contractType fseContractId fseUpdated partnerName status
1 N 1069071.XA can't find this program Cold Stone Formula Pricing 03/31/2021 01/01/2021 FS TOP 100 CHAIN (REBATE) - RATE PER CASE 0 N COLD STONE CREAMERY APPROVED
2 N 1069073.XA can't find this program Cold Stone 2% accrual account 03/31/2021 01/01/2021 FS TOP 100 CHAIN (REBATE) - RATE PER CASE 0 N COLD STONE CREAMERY APPROVED
3 N 1069113.XA can't find this program Coldstone Accrual 4% additional rebate 03/31/2021 01/01/2021 FS TOP 100 CHAIN (REBATE) - RATE PER CASE 0 N COLD STONE CREAMERY APPROVED
CACHED false
EXECUTIONTIME 1
SQL select * from qmd_source where fseContractId = 0

Changes

query
RESULTSET
query
  CountsCases_LBS assignedContractNbr col_9 contractDescription contractEnd contractStart contractType fseContractId fseUpdated partnerName status
1 Y 1068436.XA [empty string] Avendra 2017 Rebate Program 12/31/2021 01/01/2021 FS GPO'S (REBATE) - RATE PER CASE 52776 Y AVENDRA LLC APPROVED
2 Y 1056664.ZF [empty string] 07/01/2020 06/30/2021 Canteen of Central New Mexico 06/30/2021 07/01/2020 FS K-12 SCHOOLS - COMMERCIAL - COMPETITIVE PRICE 50466 Y Canteen Vending APPROVED
3 Y 1069069.ZF can't find this program Cold Stone Creamery SYGMA pricing 03/31/2021 01/01/2021 FS T0P 100 CHAIN (PRICING) - NET PRICE 55063 Y COLD STONE CREAMERY APPROVED
4 Y 1069070.ZF can't find this program Cold Stone Creamery Topping Pricing (non SYGMA) 03/31/2021 01/01/2021 FS T0P 100 CHAIN (PRICING) - NET PRICE 55064 Y COLD STONE CREAMERY APPROVED
5 N 1069072.XA can't find this program Cold Stone 6% accrual account. All DC's. 03/31/2021 01/01/2021 FS TOP 100 CHAIN (REBATE) - RATE PER CASE 55066 Y COLD STONE CREAMERY APPROVED
6 Y 1068590.XA [empty string] Compass Foodbuy Tier 3 Rebate 12/31/2021 01/01/2021 FS GPO'S (REBATE) - RATE PER CASE 52700 Y Compass Group NA APPROVED
7 N 1068544.ZF [empty string] Dairy Queen Pricing 2021 12/31/2021 01/01/2021 FS REGION CHAINS - NET PRICE 54795 Y DAIRY QUEEN INC - INT'L APPROVED
8 Y 1064438.ZF [empty string] Great Wolf Lodge 12/31/2021 01/01/2021 FS REGION CHAINS - NET PRICE 51104 Y Great Wolf Resorts APPROVED
9 N 1067284.XA [empty string] Guest Services 12/31/2021 01/01/2021 FS GPO'S (REBATE) - RATE PER CASE 53953 Y GUEST SERVICES INC APPROVED
10 N 1068437.XA [empty string] HPS Services 2018 Program 12/31/2021 01/01/2021 FS GPO'S (REBATE) - RATE PER CASE 54730 Y HPS APPROVED
11 N 1067322.XA [empty string] Aramark Global NVD (Rebate) 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55636 Y HQ 2400 MARKET CAFE APPROVED
12 Y 1068254.XA [empty string] ARAMARK SCHOOL ONLY REBATE 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55637 Y HQ 2400 MARKET CAFE APPROVED
13 Y 1068255.XA checkign with Avery Aramark Catch All 2021 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55638 Y HQ 2400 MARKET CAFE APPROVED
14 Y 1068256.XA checkign with Avery Aramark Casa Catch All 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55639 Y HQ 2400 MARKET CAFE APPROVED
15 Y 1068257.XA checkign with Avery Aramark Meats + Protein Rebate 2018 2019 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55640 Y HQ 2400 MARKET CAFE APPROVED
16 Y 1068875.XA [empty string] Aramark Rebate (NVD) 2021 12/31/2021 01/01/2021 FS CONTRACT MANAGEMENT (REBATE) - Rate Per Case 55645 Y HQ 2400 MARKET CAFE APPROVED
17 N 1057085.ZF [empty string] IKEA 07/31/2021 08/01/2020 FS CONTRACT MGMT (PRICING) - NET PRICE 50589 Y IKEA North American APPROVED
18 N 1052960.ZA [empty string] Jiffy Trip 12/31/2022 01/01/2020 FS LOCAL OPERATOR - RATE PER CASE 42490 Y Jiffy Trip APPROVED
19 N 1068570.ZF [empty string] JSPVP Pricing 12/31/2021 01/01/2021 FS CONTRACT MGMT (PRICING) - NET PRICE 54814 Y JSPVP ESCROW ACCOUNT/ONE2ONEUS APPROVED
20 Y 1069038.ZA [empty string] Kum N Go Rebate 12/31/2021 01/01/2021 FS REGION CHAINS - RATE PER CASE 56411 Y KUM & GO, L.C. APPROVED
21 N 1052349.ZA [empty string] Liberty Foodservice 12/31/2022 01/01/2020 FS LOCAL OPERATOR - RATE PER CASE 42125 Y LIBERTY FOOD SERVICE APPROVED
22 Y 1044938.XA Could use this maybe? Covers all categories but excludes private label topping PREMIER 3% Admin Fee 03/31/2021 04/01/2018 FS GPO'S (REBATE) - RATE PER CASE 50397 Y PREMIER K-12 APPROVED
23 N 1068892.XA [empty string] PREMIER FROZEN BREAD REBATES 12/31/2021 01/01/2021 FS GPO'S (REBATE) - RATE PER CASE 52784 Y PREMIER PURCHASING APPROVED
24 Y 1067345.ZA [empty string] "Spendifference (Big Boy, RB, Sizzler)" 12/31/2021 01/01/2021 FS REGION CHAINS - RATE PER CASE 56728 Y SPENDIFFERENCE APPROVED
CACHED false
EXECUTIONTIME 0
SQL select * from qmd_source where fseUpdated = 'Y'