CORE-POS/IS4C

View on GitHub
pos/is4c-nf/install/data/MasterSuperDepts.sql

Summary

Maintainability
Test Coverage
('5','HBC','92')
('5','HBC','104')
('1','BULK','14')
('4','GROCERY','191')
('9','Gen Merch','246')
('9','Gen Merch','249')
('6','Produce','247')
('6','Produce','248')
('9','Gen Merch','250')
('1','BULK','1')
('1','BULK','2')
('1','BULK','3')
('1','BULK','4')
('1','BULK','5')
('1','BULK','6')
('1','BULK','7')
('1','BULK','8')
('1','BULK','10')
('1','BULK','11')
('1','BULK','12')
('1','BULK','13')
('1','BULK','15')
('1','BULK','16')
('1','BULK','17')
('1','BULK','18')
('1','BULK','19')
('1','BULK','21')
('1','BULK','22')
('1','BULK','23')
('1','BULK','24')
('1','BULK','25')
('2','COOL/FROZEN','26')
('2','COOL/FROZEN','27')
('2','COOL/FROZEN','28')
('2','COOL/FROZEN','29')
('2','COOL/FROZEN','30')
('2','COOL/FROZEN','31')
('2','COOL/FROZEN','32')
('4','GROCERY','188')
('2','COOL/FROZEN','34')
('2','COOL/FROZEN','38')
('2','COOL/FROZEN','39')
('2','COOL/FROZEN','40')
('2','COOL/FROZEN','41')
('2','COOL/FROZEN','42')
('8','Meat','261')
('2','COOL/FROZEN','44')
('2','COOL/FROZEN','45')
('2','COOL/FROZEN','46')
('4','GROCERY','189')
('2','COOL/FROZEN','54')
('2','COOL/FROZEN','55')
('2','COOL/FROZEN','56')
('2','COOL/FROZEN','57')
('4','GROCERY','190')
('2','COOL/FROZEN','59')
('3','DELI','60')
('3','DELI','63')
('3','DELI','64')
('3','DELI','65')
('3','DELI','66')
('3','DELI','67')
('3','DELI','68')
('3','DELI','69')
('3','DELI','70')
('3','DELI','71')
('3','DELI','72')
('3','DELI','73')
('3','DELI','74')
('3','DELI','150')
('4','GROCERY','151')
('4','GROCERY','152')
('4','GROCERY','153')
('4','GROCERY','154')
('4','GROCERY','155')
('4','GROCERY','156')
('4','GROCERY','157')
('4','GROCERY','158')
('4','GROCERY','159')
('4','GROCERY','160')
('4','GROCERY','161')
('4','GROCERY','162')
('4','GROCERY','163')
('4','GROCERY','164')
('4','GROCERY','165')
('4','GROCERY','166')
('4','GROCERY','167')
('4','GROCERY','168')
('4','GROCERY','169')
('4','GROCERY','170')
('4','GROCERY','171')
('4','GROCERY','172')
('4','GROCERY','173')
('4','GROCERY','174')
('4','GROCERY','175')
('4','GROCERY','176')
('4','GROCERY','177')
('4','GROCERY','178')
('4','GROCERY','179')
('4','GROCERY','180')
('4','GROCERY','181')
('4','GROCERY','182')
('4','GROCERY','183')
('4','GROCERY','185')
('4','GROCERY','186')
('1','BULK','251')
('1','BULK','252')
('1','BULK','253')
('1','BULK','254')
('1','BULK','255')
('1','BULK','256')
('1','BULK','257')
('1','BULK','245')
('1','BULK','239')
('5','HBC','93')
('5','HBC','94')
('5','HBC','95')
('5','HBC','96')
('5','HBC','97')
('5','HBC','98')
('5','HBC','99')
('5','HBC','100')
('5','HBC','101')
('5','HBC','102')
('5','HBC','103')
('9','Gen Merch','244')
('1','BULK','258')
('1','BULK','259')
('5','HBC','123')
('5','HBC','124')
('5','HBC','125')
('9','Gen Merch','243')
('5','HBC','127')
('5','HBC','128')
('0','Misc','600')
('4','GROCERY','187')
('6','Produce','500')
('6','Produce','502')
('0','Misc','604')
('6','Produce','503')
('6','Produce','505')
('6','Produce','507')
('6','Produce','200')
('6','Produce','201')
('6','Produce','202')
('6','Produce','203')
('6','Produce','204')
('6','Produce','205')
('6','Produce','206')
('6','Produce','208')
('6','Produce','209')
('6','Produce','210')
('6','Produce','220')
('0','Misc','900')
('0','Misc','990')
('0','Misc','991')
('0','Misc','700')
('6','Produce','508')
('6','Produce','510')
('0','Misc','703')
('6','Produce','512')
('6','Produce','513')
('0','Misc','992')
('3','DELI','61')
('3','DELI','62')
('3','DELI','225')
('3','DELI','226')
('3','DELI','227')
('3','DELI','228')
('3','DELI','229')
('3','DELI','230')
('3','DELI','231')
('3','DELI','232')
('3','DELI','233')
('2','COOL/FROZEN','37')
('2','COOL/FROZEN','35')
('8','Meat','260')
('9','Gen Merch','242')
('0','Misc','902')
('3','DELI','234')
('7','Marketing','235')
('6','Produce','501')
('9','Gen Merch','240')
('9','Gen Merch','241')
('8','Meat','262')
('8','Meat','263')
('2','COOL/FROZEN','53')
('0','Misc','800')
('6','Produce','238')
('0','Misc','708')
('3','DELI','75')
('6','Produce','207')
('0','Misc','610')
('3','DELI','76')
('6','Produce','504')
('5','HBC','86')
('6','Produce','506')
('6','Produce','509')
('6','Produce','511')
('6','Produce','514')
('6','Produce','515')
('6','Produce','516')
('6','Produce','517')
('6','Produce','518')
('6','Produce','519')
('6','Produce','520')
('6','Produce','521')
('6','Produce','522')
('6','Produce','523')
('6','Produce','524')
('6','Produce','525')
('6','Produce','526')
('6','Produce','527')
('6','Produce','528')
('6','Produce','529')
('6','Produce','540')
('6','Produce','541')
('6','Produce','542')
('6','Produce','543')
('6','Produce','544')
('6','Produce','545')
('6','Produce','546')
('6','Produce','547')
('6','Produce','548')
('6','Produce','549')
('6','Produce','550')
('6','Produce','551')
('6','Produce','552')
('6','Produce','553')
('6','Produce','554')
('6','Produce','555')
('6','Produce','556')
('6','Produce','557')
('6','Produce','535')
('5','HBC','87')
('5','HBC','88')
('5','HBC','89')
('5','HBC','90')
('5','HBC','91')
('5','HBC','105')
('5','HBC','106')
('5','HBC','107')
('5','HBC','108')
('0','Misc','881')
('0','Misc','882')
('7','Marketing','236')