update in_main set aux2='EA' where partno = 'DTAP'
update in_main set aux2='BT' where partno = 'LAV5'
update in_main set aux2='EA' where partno = 'FRH10'
update in_main set aux2='DR' where partno = '3DG20'
update in_main set aux2='BT' where partno = 'WIP5'
update in_main set aux2='EA' where partno = 'R1C'
update in_main set aux2='BT' where partno = 'HAND5'
update in_main set aux2='BT' where partno = 'D5M'
update in_main set aux2='BT' where partno = 'COS5'
update in_main set aux2='BT' where partno = 'BL5'
update in_main set aux2='BT' where partno = 'COFB250'
update in_main set aux2='EA' where partno = 'CLP20'
update in_main set aux2='DR' where partno = 'MA20'
update in_main set aux2='BT' where partno = 'PH5'
update in_main set aux2='EA' where partno = 'FLA5'
update in_main set aux2='BT' where partno = 'D07'
update in_main set aux2='BT' where partno = 'CITS5'
update in_main set aux2='BT' where partno = 'CARS5'
update in_main set aux2='BT' where partno = 'D500'
update in_main set aux2='BT' where partno = 'D5SP'
update in_main set aux2='BT' where partno = 'D07A'
update in_main set aux2='BT' where partno = 'D08'
update in_main set aux2='BT' where partno = 'D1M'
update in_main set aux2='EA' where partno = 'D4SL'
update in_main set aux2='BT' where partno = 'CH5'
update in_main set aux2='BT' where partno = 'WB5'
update in_main set aux2='BT' where partno = 'PREST5'
update in_main set aux2='BT' where partno = 'SAN5'
update in_main set aux2='BT' where partno = 'SPRU5'
update in_main set aux2='BT' where partno = 'EX5'
update in_main set aux2='BT' where partno = 'ULT5'
update in_main set aux2='BT' where partno = 'COU1'
update in_main set aux2='BT' where partno = 'SPI5'
update in_main set aux2='BT' where partno = 'ORC5'
update in_main set aux2='BT' where partno = 'GRI5'
update in_main set aux2='BT' where partno = 'DL1'
update in_main set aux2='BT' where partno = 'SHIN5'
update in_main set aux2='BT' where partno = 'RU250'
update in_main set aux2='BT' where partno = 'BON5'
update in_main set aux2='BT' where partno = 'AUB5'
update in_main set aux2='BT' where partno = 'FRC5'
update in_main set aux2='BT' where partno = 'VIG5'
update in_main set aux2='BT' where partno = 'SPL5'
update in_main set aux2='EA' where partno = 'SOF500'
update in_main set aux2='EA' where partno = 'SPO500'
update in_main set aux2='EA' where partno = 'DSPAN'
update in_main set aux2='BT' where partno = 'D4S'
update in_main set aux2='BT' where partno = 'D1N'
update in_main set aux2='BT' where partno = 'D02'
update in_main set aux2='BT' where partno = 'GRAF1'
update in_main set aux2='BT' where partno = 'D10'
update in_main set aux2='BT' where partno = 'D09ST'
update in_main set aux2='DR' where partno = 'TRA20'
update in_main set aux2='BT' where partno = 'GAR5'
update in_main set aux2='BT' where partno = 'D01'
update in_main set aux2='BT' where partno = 'D05'
update in_main set aux2='BT' where partno = 'D03'
update in_main set aux2='BT' where partno = 'REN5'
update in_main set aux2='BT' where partno = 'D06'
update in_main set aux2='DR' where partno = 'SCRB20'
update in_main set aux2='BT' where partno = 'D1S'
update in_main set aux2='BT' where partno = 'STA5'
update in_main set aux2='BT' where partno = 'STE5'
update in_main set aux2='BT' where partno = 'D7AF'
update in_main set aux2='BT' where partno = 'SOF5'
update in_main set aux2='BT' where partno = 'D7B'
update in_main set aux2='BT' where partno = 'BOW5'
update in_main set aux2='BT' where partno = 'D09'
update in_main set aux2='BT' where partno = 'D7S'
update in_main set aux2='BT' where partno = 'HC5'
update in_main set aux2='BT' where partno = 'TRA5'
update in_main set aux2='EA' where partno = 'DHP30'
update in_main set aux2='BT' where partno = 'D1BL'
update in_main set aux2='BT' where partno = 'D1LE'
update in_main set aux2='BT' where partno = 'D1P'
update in_main set aux2='BT' where partno = 'D1L'
update in_main set aux2='BT' where partno = 'D7H'
update in_main set aux2='BT' where partno = 'D1V'
update in_main set aux2='EA' where partno = 'CLP5'
update in_main set aux2='EA' where partno = 'DTR'
update in_main set aux2='BT' where partno = 'MIC5'
update in_main set aux2='DR' where partno = 'GAR20'
update in_main set aux2='BT' where partno = 'LE5'
update in_main set aux2='BT' where partno = 'D1F'
update in_main set aux2='BT' where partno = 'GSO1'
update in_main set aux2='BT' where partno = 'METH5'
update in_main set aux2='BT' where partno = 'CARSB5'
update in_main set aux2='BT' where partno = 'GR5'
update in_main set aux2='EA' where partno = 'CGR/V'
update in_main set aux2='BT' where partno = 'D5SA'
update in_main set aux2='BT' where partno = 'COU5'
update in_main set aux2='BT' where partno = 'D1C'
update in_main set aux2='BT' where partno = 'D5C'
update in_main set aux2='BT' where partno = 'D7G'
update in_main set aux2='BT' where partno = 'D750'
update in_main set aux2='BT' where partno = 'FLO5'
update in_main set aux2='DR' where partno = 'CH20'
update in_main set aux2='DR' where partno = 'FLO20'
update in_main set aux2='DR' where partno = 'SPE20'
update in_main set aux2='DR' where partno = 'NO20'
update in_main set aux2='BT' where partno = 'NUG5'
update in_main set aux2='DR' where partno = 'FRM20'
update in_main set aux2='BT' where partno = 'ANF5'
update in_main set aux2='BT' where partno = 'TOP5'
update in_main set aux2='EA' where partno = 'SAF10'
update in_main set aux2='DR' where partno = 'FLP20'
update in_main set aux2='DR' where partno = 'BRE20'
update in_main set aux2='EA' where partno = 'FLA15'
update in_main set aux2='BT' where partno = 'VEN5'
update in_main set aux2='BT' where partno = 'DU5'
update in_main set aux2='DR' where partno = 'SYM20'
update in_main set aux2='DR' where partno = 'DR20'
update in_main set aux2='DR' where partno = 'FIR20'
update in_main set aux2='BT' where partno = 'CU1'
update in_main set aux2='BT' where partno = '20G5'
update in_main set aux2='DR' where partno = 'STR20'
update in_main set aux2='DR' where partno = 'DU20'
update in_main set aux2='DR' where partno = 'SUPN20'
update in_main set aux2='DR' where partno = 'FRC20'
update in_main set aux2='DR' where partno = 'PH20'
update in_main set aux2='DR' where partno = 'TAK20'
update in_main set aux2='BT' where partno = 'NUG500'
update in_main set aux2='DR' where partno = 'GRAN20'
update in_main set aux2='DR' where partno = '20G20'
update in_main set aux2='BT' where partno = 'MAS5'
update in_main set aux2='DR' where partno = 'ORC20'
update in_main set aux2='DR' where partno = 'ULT20'
update in_main set aux2='BT' where partno = 'GRAF5'
update in_main set aux2='BT' where partno = 'SYM5'
update in_main set aux2='DR' where partno = 'SOL20'
update in_main set aux2='DR' where partno = 'TANG20'
update in_main set aux2='DR' where partno = 'HF20'
update in_main set aux2='BT' where partno = 'AL5'
update in_main set aux2='BT' where partno = 'TAK5'
update in_main set aux2='BT' where partno = 'DL5'
update in_main set aux2='DR' where partno = 'EX20'
update in_main set aux2='DR' where partno = 'METH20'
update in_main set aux2='DR' where partno = 'AUD20'
update in_main set aux2='DR' where partno = 'TAU20'
update in_main set aux2='DR' where partno = 'PREST20'
update in_main set aux2='EA' where partno = 'FLA25'
update in_main set aux2='BT' where partno = 'SUPN5'
update in_main set aux2='DR' where partno = 'BOW20'
update in_main set aux2='DR' where partno = 'MAS20'
update in_main set aux2='BT' where partno = 'DR5'
update in_main set aux2='BT' where partno = 'TAU5'
update in_main set aux2='DR' where partno = 'AU20'
update in_main set aux2='DR' where partno = 'LI20'
update in_main set aux2='DR' where partno = 'LE20'
update in_main set aux2='DR' where partno = 'AMM20'
update in_main set aux2='DR' where partno = 'WIP20'
update in_main set aux2='BT' where partno = 'AMB5'
update in_main set aux2='BT' where partno = '3DG5'
update in_main set aux2='BT' where partno = 'STR5'
update in_main set aux2='BT' where partno = 'AC5'
update in_main set aux2='BT' where partno = 'FIR5'
update in_main set aux2='DR' where partno = 'FAS20'
update in_main set aux2='BT' where partno = 'SCRB5'
update in_main set aux2='BT' where partno = 'NO5'
update in_main set aux2='BT' where partno = 'HF5'
update in_main set aux2='BT' where partno = 'SPE5'
update in_main set aux2='BT' where partno = 'TANG5'
update in_main set aux2='BT' where partno = 'SI5'
update in_main set aux2='BT' where partno = 'SUPF5'
update in_main set aux2='BT' where partno = 'ANF1'
update in_main set aux2='BT' where partno = 'TRU5'
update in_main set aux2='BT' where partno = 'OCE5'
update in_main set aux2='BT' where partno = 'GSO5'
update in_main set aux2='BT' where partno = 'SAT10'
update in_main set aux2='BT' where partno = 'MA5'
update in_main set aux2='EA' where partno = 'DTC20'
update in_main set aux2='BT' where partno = 'LI5'
update in_main set aux2='BT' where partno = 'BRE5'
update in_main set aux2='BT' where partno = 'SEQ5'
update in_main set aux2='BT' where partno = 'FRM5'
update in_main set aux2='BT' where partno = 'SHIF5'
update in_main set aux2='BT' where partno = 'FIN5'
update in_main set aux2='BT' where partno = 'FLP5'
update in_main set aux2='BT' where partno = 'SOL5'
update in_main set aux2='BT' where partno = 'AMM5'
update in_main set aux2='DR' where partno = 'BL20'
update in_main set aux2='BT' where partno = 'FLD5'
update in_main set aux2='BT' where partno = 'SHO5'
update in_main set aux2='EA' where partno = 'GAL5'
update in_main set aux2='BT' where partno = 'ON5'
update in_main set aux2='BT' where partno = 'GRAN5'
update in_main set aux2='EA' where partno = 'DHP20'
update in_main set aux2='BT' where partno = 'AU5'
update in_main set aux2='BT' where partno = 'AMS1'
update in_main set aux2='BT' where partno = 'SPR5'
update in_main set aux2='BT' where partno = 'META500'