8348-2-OOLU9229870-SIF-3043-20-Bellini-Paul-6-5315-Boys . 20" . Trekking . 6 SPD . AL . -HA-C40-2-Shoratge(16)-2019-04-18-Pcs-IF-4791
9003-3-OOLU9229870-SIF-3043-Muddyfox-Idaho-24-4631-Mens . 24" . MTB . 21 SPD . Full Sus FRAME BIKE . Disc Brake . -MTS-309-2-Shoratge(1)-2019-04-18-Pcs-IF-4782
9005-4-OOLU9229870-SIF-3043-Bronco-27.5-D-5055-Mens . 27.5" . MTB . 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -CH-389A-27.5-Shoratge(1)-2019-04-18-Pcs-IF-4798
9007-4-OOLU9229870-SIF-3043-Crusador-29-D-5100-Mens . 29" . MTB . 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -CH-389A-29-Shoratge(1)-2019-04-18-Pcs-IF-4798
9009-1-OOLU9229870-SIF-3043-Muddyfox-Typhoon-24-4507-Boys . 24" . MTB . 18 SPD . Full Sus FRAME BIKE . -MTB-153-Shoratge(1)-2019-04-18-Pcs-IF-4798
9013-1-OOLU9229870-SIF-3043-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -HA-C40-2-Shoratge(1)-2019-04-18-Pcs-IF-4799
9014-9-OOLU9229870-SIF-3043-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -HA-C40-2-Shoratge(1)-2019-04-18-Pcs-IF-4799
9014-14-OOLU9229870-SIF-3043-Bobbin-Gingersnap-24-4466-Kids . 24" . Kids . 7 SPD . -HA-C40-2-Shoratge(1)-2019-04-18-Pcs-IF-4799
9014-16-OOLU9229870-SIF-3043-Bobbin-Moonbug-16-4467-Kids . 16" . Kids . -HA-C39-2-Shoratge(1)-2019-04-18-Pcs-IF-4799
9015-3-OOLU9229870-SIF-3043-Bobbin-Gingersnap-16-4464-Kids . 16" . Kids . -HA-C40-2-Shoratge(1)-2019-04-18-Pcs-IF-4799
9016-11-OOLU9229870-SIF-3043-Classic Heritage 26"-4521-Ladies . 26" . Classic . 7 SPD . -MTS-309-2-Shoratge(1)-2019-04-18-Pcs-IF-4798
9026-1-OOLU9229870-SIF-3043-Muddyfox-Typhoon-24-4507-Boys . 24" . MTB . 18 SPD . Full Sus FRAME BIKE . -MTB-153-Shoratge(1)-2019-04-18-Pcs-IF-4798
9026-1-OOLU9229870-SIF-3043-Muddyfox-Typhoon-24-4507-Boys . 24" . MTB . 18 SPD . Full Sus FRAME BIKE . -MTS-309-2-Shoratge(1)-2019-04-18-Pcs-IF-4798
9027-2-OOLU9229870-SIF-3043-Muddyfox-Prevail-24-4502-Boys . 24" . MTB . 18 SPD . Front Sus FRAME BIKE . -MTS-309-2-Shoratge(1)-2019-04-18-Pcs-IF-4798
9027-2-OOLU9229870-SIF-3043-Muddyfox-Prevail-24-4502-Boys . 24" . MTB . 18 SPD . Front Sus FRAME BIKE . -MTB-153-Shoratge(1)-2019-04-18-Pcs-IF-4798
9034-2-CFS TO CFS-SIF-3050-Muddyfox-Diva-14 (UK)-4325-Girls . 14" . Kids . AL . -MTB-AL-156TP-Shoratge(10)-2019-05-29-Pcs-IF-4810
9037-6-CFS TO CFS-SIF-3050-Muddyfox-Icon-18 (UK)-4333-Boys . 18" . Kids . AL . -HA-C60-2-Shoratge(1)-2019-05-29-Pcs-IF-4809
9080-4-CFS TO CFS-SIF-3050-Maximus-29-D-24sp-2886-Mens . 29" . MTB 24 SPD . AL . Front Sus FRAME BIKE . -SP-C208-Shoratge(1)-2019-05-29-Pcs-IF-4818
9080-4-CFS TO CFS-SIF-3050-Maximus-29-D-24sp-2886-Mens . 29" . MTB 24 SPD . AL . Front Sus FRAME BIKE . -TDS-C302-8FOV-Shoratge(40)-2019-05-29-Pcs-IF-4818
9105-5-OOLU8139643-SIF-3055-Professional-City-M-5472-Mens . 700C . Trekking . 6 SPD . -MTS-307-2-Shoratge(1)-2019-06-18-Pcs-IF-4828
9105-10-OOLU8139643-SIF-3055-Professional-City-M-5472-Mens . 700C . Trekking . 6 SPD . -MTS-307-2-Shoratge(1)-2019-06-18-Pcs-IF-4828
9112-3-TCLU6496724-SIF-3060-Fusion 26 21Sp-3604-Mens . 26" . MTB . 21 SPD . Front Sus FRAME BIKE . -CH-327E-26-Shoratge(1)-2019-06-30-Pcs-IF-4833
9114-4-TCLU6496724-SIF-3060-Bronco-27.5-D-5055-Mens . 27.5" . MTB . 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -CH-389A-27.5-Shoratge(1)-2019-06-30-Pcs-IF-4841
9125-1-TCLU6496724-SIF-3060-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -HA-C40-2-Shoratge(1)-2019-06-30-Pcs-IF-4841
9125-4-TCLU6496724-SIF-3060-Bobbin-Gingersnap-16-4464-Kids . 16" . Kids . -HA-C40-2-Shoratge(1)-2019-06-30-Pcs-IF-4841
9125-14-TCLU6496724-SIF-3060-Bobbin-Gingersnap-24-4466-Kids . 24" . Kids . 7 SPD . -HA-C40-2-Shoratge(1)-2019-06-30-Pcs-IF-4841
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3059' AND Sc_No='9125' AND Seq_No='11' AND Item_Code='SP-C208' AND Shortage_Qty='5' AND PO_No='IF-4832'
9129-3-OOCU7262261-SIF-3063-Schwinn-Rocket-5-Men-5439-Mens . 27.5" . MTB . 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -CH-386A-27.5-Shoratge(1)-2019-07-14-Pcs-IF-4847
9147-1-OOLU9860361-SIF-3071-Forme-Hartington-JR-14-5468-Girls . 14" . Kids . AL . F/R Caliper . -HA-C40-2-Shoratge(1)-2019-08-05-Pcs-IF-4854
9161-1-CFS TO CFS-SIF-3075-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -SP-C208-Shoratge(1)-2019-08-26-Pcs-IF-4859
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3079' AND Sc_No='9213' AND Seq_No='7' AND Item_Code='MTS-307-2' AND Shortage_Qty='6' AND PO_No='IF-4874'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3083' AND Sc_No='9205' AND Seq_No='16' AND Item_Code='TDS-C302-8FOV' AND Shortage_Qty='1' AND PO_No='IF-4869'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3090' AND Sc_No='9234' AND Seq_No='4' AND Item_Code='MTB-153' AND Shortage_Qty='1' AND PO_No='IF-4886'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3093' AND Sc_No='9246' AND Seq_No='1' AND Item_Code='MTS-291-5' AND Shortage_Qty='1' AND PO_No='IF-4897'
9265-3-OOLU4490602-SIF-3099-Muddyfox-Icon-16 (EU)-4335-Boys . 16" . Kids . AL . -SP-C208-Shoratge(1)-2019-10-22-Pcs-IF-4905
9269-7-CFS TO CFS-SIF-3104-Muddyfox-Diva-18 (EU)-4330-Girls . 18" . Kids . AL . -HA-C60-2-Shoratge(1)-2019-11-20-Pcs-IF-4913
9286-1-OOLU8974441-SIF-3109-Mongoose-Switch-R50-4914-Boys . 20" . FS . U-Brake . -MX-536-Shoratge(2)-2019-11-24-Pcs-IF-4927
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3108' AND Sc_No='9286' AND Seq_No='1' AND Item_Code='B107N' AND Shortage_Qty='2' AND PO_No='IF-4921'
9327-1-CBHU9481233-SIF-3129-Aeron-700C-5690-Mens . 700C . Road Bike 16 SPD . AL . F/R Caliper . -WAN700251076FBTY-Shoratge(1)-2020-01-28-Pr-IF-4959
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3136' AND Sc_No='9339' AND Seq_No='3' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-4955'
9361-3-OOLU7318428-SIF-3143-Maximus-29-D-24sp-2886-Mens . 29" . MTB 24 SPD . AL . Front Sus FRAME BIKE . -TDS-C302-8FOV-Shoratge(1)-2020-05-28-Pcs-IF-4980
9359-2-OOLU6770644-SIF-3146-Tailwind 26 6S-310-Ladies . 26" . MTB . 6 SPD . AL . -CH-327E-26-Shoratge(1)-2020-06-04-Pcs-IF-4970
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3146' AND Sc_No='9370' AND Seq_No='2' AND Item_Code='CH-327E-24' AND Shortage_Qty='1' AND PO_No='IF-4978'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3155' AND Sc_No='9359' AND Seq_No='1' AND Item_Code='CH-327E-26' AND Shortage_Qty='1' AND PO_No='IF-4970'
9405-2-OOLU8369034-SIF-3152-Axxis-D-29-5700-Mens . 29" . MTB . Front Sus FRAME BIKE . Disc Brake . -CH-381A-29-Shoratge(1)-2020-06-14-Pcs-IF-4990
9408-1-OOLU8369034-SIF-3152-Karma-7sp-5769-Ladies . 700C . Trekking 7 SPD . AL . Front Sus FRAME BIKE . -CH-130-700C-Shoratge(1)-2020-06-14-Pcs-IF-4990
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3157' AND Sc_No='20047' AND Seq_No='2' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5004'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3175' AND Sc_No='20126' AND Seq_No='1' AND Item_Code='MX-625-8' AND Shortage_Qty='1' AND PO_No='IF-5035'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3190' AND Sc_No='20063' AND Seq_No='16' AND Item_Code='DSI2017559FCTY' AND Shortage_Qty='15' AND PO_No='IF-5024'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3184' AND Sc_No='20131' AND Seq_No='4' AND Item_Code='MX-536' AND Shortage_Qty='1' AND PO_No='IF-5049'
20166-4-CSNU6173282-SIF-3191-Charger-27.5-D-6221-Mens . 27.5" . MTB 27SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C302-8FOV-Shoratge(5)-2020-08-25-Pcs-IF-5069
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3201' AND Sc_No='20162' AND Seq_No='6' AND Item_Code='DSI14212509FBTYLB' AND Shortage_Qty='15' AND PO_No='IF-5085'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3201' AND Sc_No='20162' AND Seq_No='6' AND Item_Code='DSI142125BRAVTUTP' AND Shortage_Qty='15' AND PO_No='IF-5085'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3198' AND Sc_No='20185' AND Seq_No='18' AND Item_Code='TDS-C301-8FOV' AND Shortage_Qty='2' AND PO_No='IF-5098'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3198' AND Sc_No='20200' AND Seq_No='3' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-5091'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3206' AND Sc_No='20196' AND Seq_No='3' AND Item_Code='KT-AJ9R' AND Shortage_Qty='1' AND PO_No='IF-5082'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3208' AND Sc_No='20217' AND Seq_No='2' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-5074'
20171-1-FCIU9679572-SIF-3212-Karma-21sp-MS-6208-Ladies . 700C . Trekking 21 SPD . AL . Front Sus FRAME BIKE . -CH-130-700C-Shoratge(1)-2020-10-07-Pcs-IF-5070
20177-2-FCIU9679572-SIF-3212-Mountana-21SP-29-4429-Mens . 29" . MTB . 21 SPD . AL . Front Sus FRAME BIKE . -CH-386-29-Shoratge(1)-2020-10-07-Pcs-IF-5070
20189-4-FCIU9679572-SIF-3212-Viper-18-5074-Boys . 18" . MTB . 6 SPD . AL . Front Sus FRAME BIKE . -CH-327L-18-Shoratge(1)-2020-10-07-Pcs-IF-5070
20189-5-FCIU9679572-SIF-3212-Viper-20-5075-Boys . 20" . MTB . 6 SPD . AL . Front Sus FRAME BIKE . -CH-327-20-Shoratge(1)-2020-10-07-Pcs-IF-5070
20189-6-FCIU9679572-SIF-3212-Viper-24-5076-Boys . 24" . MTB . 6 SPD . AL . Front Sus FRAME BIKE . -CH-327-24-Shoratge(1)-2020-10-07-Pcs-IF-5070
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3223' AND Sc_No='20183' AND Seq_No='4' AND Item_Code='DSI142125BRAVTUTP' AND Shortage_Qty='30' AND PO_No='IF-5104'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3223' AND Sc_No='20183' AND Seq_No='4' AND Item_Code='DSI14212509FBTYLB' AND Shortage_Qty='30' AND PO_No='IF-5104'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3204' AND Sc_No='20233' AND Seq_No='3' AND Item_Code='PASO-ML-120L-122.5' AND Shortage_Qty='1' AND PO_No='IF-5077'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3214' AND Sc_No='20178' AND Seq_No='12' AND Item_Code='MTS-291-5' AND Shortage_Qty='1' AND PO_No='IF-5111'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3219' AND Sc_No='20178' AND Seq_No='18' AND Item_Code='WAN700380BRAV48TUTP' AND Shortage_Qty='15' AND PO_No='IF-5121'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3219' AND Sc_No='20178' AND Seq_No='18' AND Item_Code='WAN700381024FBTY' AND Shortage_Qty='15' AND PO_No='IF-5121'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3216' AND Sc_No='20247' AND Seq_No='1' AND Item_Code='MTB-AL-101BT(FOV)' AND Shortage_Qty='1' AND PO_No='IF-5119'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3230' AND Sc_No='20279' AND Seq_No='1' AND Item_Code='PASO-ML-120L-122.5' AND Shortage_Qty='5' AND PO_No='IF-5144'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3246' AND Sc_No='20333' AND Seq_No='9' AND Item_Code='HA-C40-2' AND Shortage_Qty='2' AND PO_No='IF-5167'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3246' AND Sc_No='20422' AND Seq_No='2' AND Item_Code='TDS-D507A-8-FOV' AND Shortage_Qty='1' AND PO_No='IF-5257'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3248' AND Sc_No='20382' AND Seq_No='3' AND Item_Code='WAN70035BRAV48MMTUTP' AND Shortage_Qty='12.5' AND PO_No='IF-5211'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3248' AND Sc_No='20382' AND Seq_No='3' AND Item_Code='WAN700351024FBWFLTY' AND Shortage_Qty='12.5' AND PO_No='IF-5211'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3263' AND Sc_No='20281' AND Seq_No='15' AND Item_Code='SP-C208-V' AND Shortage_Qty='3' AND PO_No='IF-5311'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3278' AND Sc_No='20268' AND Seq_No='37' AND Item_Code='DSI182125BRDVTUTP' AND Shortage_Qty='15' AND PO_No='IF-5141'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3278' AND Sc_No='20268' AND Seq_No='37' AND Item_Code='DSI1819085FBTYLB' AND Shortage_Qty='15' AND PO_No='IF-5141'
20369-1-CCLU7814660-SIF-3269-Charger-27.5-D-6221-Mens . 27.5" . MTB 27SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MTB-AL-101BT(FOV)-Shoratge(1)-2021-01-23-Pcs-IF-5206
20371-1-CCLU7814660-SIF-3269-Tornado-27.5-24sp-MS-6200-Mens . 27.5" . MTB 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MTB-AL-312BT-FOV-Shoratge(1)-2021-01-23-Pcs-IF-5224
20398-6-CCLU7814660-SIF-3269-Poison2.0-24-7spd-MY21-5872-Unisex . 24" . MTB 7 SPD . AL . Front Sus FRAME BIKE . -TDS-C308-8-Shoratge(1)-2021-01-23-Pcs-IF-5296
20399-5-CCLU7814660-SIF-3269-BadGirl1.0-14spd-MY21-6161-Girls . 24" . MTB 14 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C308-8-Shoratge(1)-2021-01-23-Pcs-IF-5297
20400-5-CCLU7814660-SIF-3269-Queen-24-3spd-MY21-5863-Ladies . 24" . Classic 3 SPD . AL . -HA-C40-5-Shoratge(4)-2021-01-23-Pcs-IF-5298
20400-6-CCLU7814660-SIF-3269-Queen-24-3spd-MY21-5863-Ladies . 24" . Classic 3 SPD . AL . -HA-C40-5-Shoratge(1)-2021-01-23-Pcs-IF-5298
20400-7-CCLU7814660-SIF-3269-Queen-26-6spd-MY21-5861-Ladies . 26" . MTB 6 SPD . AL . Front Sus FRAME BIKE . -HA-C40-5-Shoratge(4)-2021-01-23-Pcs-IF-5298
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3265' AND Sc_No='20430' AND Seq_No='1' AND Item_Code='X10' AND Shortage_Qty='5' AND PO_No='IF-5252'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3276' AND Sc_No='20427' AND Seq_No='11' AND Item_Code='VP-535' AND Shortage_Qty='6' AND PO_No='IF-5460'
20423-2-CBHU9526868-SIF-3270-J5-24-OCCANO-6034-Boys . 24" . MTB 8 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MD-M280F-Shoratge(4)-2021-02-13-Sets-IF-5276
20423-3-CBHU9526868-SIF-3270-J7-26-OCCANO-6035-Mens . 26" . MTB 8 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MD-M280R-Shoratge(4)-2021-02-13-Sets-IF-5276
20430-1-CBHU9526868-SIF-3274-Barracuda-Boulder-6082-Mens . 27.5" . MTB 10 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-D507A-8-FOV-Shoratge(1)-2021-02-13-Pcs-IF-5248
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3299' AND Sc_No='20521' AND Seq_No='1' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5399'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3295' AND Sc_No='20521' AND Seq_No='1' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-5353'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3295' AND Sc_No='20524' AND Seq_No='1' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-5353'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3306' AND Sc_No='20505' AND Seq_No='2' AND Item_Code='TDS-C301-8-FOV-V' AND Shortage_Qty='2' AND PO_No='IF-5354'
20505-3-CFS TO CFS-SIF-3306-Forme-Peak-Trail-1-ms-6278-Mens . 700C . Trekking 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MTB-AL-312BT-FOV-V-Shoratge(1)-2021-05-04-Pcs-IF-5354
20506-2-CFS TO CFS-SIF-3306-Forme-Peak-Trail-2-ms-6280-Mens . 700C . Trekking 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C301-8-FOV-V-Shoratge(1)-2021-05-04-Pcs-IF-5354
20407-3-BMOU4618318-SIF-3314-Muddyfox-Icon-16 (UK)-4332-Boys . 16" . Kids . AL . -HS-C40-2-Shoratge(9)-2021-05-11-Pcs-IF-5334
20408-3-BMOU4618318-SIF-3314-Muddyfox-Diva-16 (EU)-4329-Girls . 16" . Kids . AL . -HS-C40-2-Shoratge(1)-2021-05-11-Pcs-IF-5334
20409-4-BMOU4618318-SIF-3314-Muddyfox-Icon-18 (EU)-4336-Boys . 18" . Kids . AL . -SP-C208-Shoratge(1)-2021-05-11-Pcs-IF-5332
20458-1-TRLU8046073-SIF-3321-Road-Runner-Pro-V-21sp-MS-6211-Mens . 700C . Trekking 21 SPD . AL . Front Sus FRAME BIKE . -TDS-C331-8-Shoratge(1)-2021-05-29-Pcs-IF-5373
20526-20-TRLU8046073-SIF-3321-Bobbin-Moonbug-12-5021-Boys . 12" . Kids . -HA-C39-2-Shoratge(1)-2021-05-29-Pcs-IF-5403
20550-6-TRLU8046073-SIF-3321-Summit-26-5603-Mens . 26" . MTB . 18 SPD . Full Sus FRAME BIKE . -TDS-C41-8-Shoratge(1)-2021-05-29-Pcs-IF-5471
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3305' AND Sc_No='20413' AND Seq_No='3' AND Item_Code='WAN2021251023BWRLTY' AND Shortage_Qty='0.5' AND PO_No='IF-5269'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3305' AND Sc_No='20413' AND Seq_No='3' AND Item_Code='WAN202125BRAVTUTP' AND Shortage_Qty='0.5' AND PO_No='IF-5269'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3326' AND Sc_No='20638' AND Seq_No='6' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5441'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3328' AND Sc_No='20687' AND Seq_No='1' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-5498'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3339' AND Sc_No='20536' AND Seq_No='2' AND Item_Code='WAN14212501023FCTY' AND Shortage_Qty='25' AND PO_No='IF-5431'
20645-1-TGBU5110480-SIF-3351-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -HA-C40-2-Shoratge(4)-2021-08-30-Pcs-IF-5495
20654-7-TGBU5110480-SIF-3351-Bobbin-Gingersnap-26-ms-6337-Ladies . 26" . Classic 7 SPD . -HA-C60-2-Shoratge(100)-2021-08-30-Pcs-IF-5559
20576-3-UETU5637328-SIF-3344-Barracuda-Carina-700-7S-ms-6330-Ladies . 700C . city . 7 SPD . AL . F/R Caliper . -SP-C208-Shoratge(50)-2021-08-12-Pcs-IF-5520
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3359' AND Sc_No='20517' AND Seq_No='27' AND Item_Code='MTS-C297-5' AND Shortage_Qty='1' AND PO_No='IF-5413'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3341' AND Sc_No='20664' AND Seq_No='6' AND Item_Code='CH-327-26' AND Shortage_Qty='1' AND PO_No='IF-5489'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3356' AND Sc_No='20705' AND Seq_No='6' AND Item_Code='HS-C40-2' AND Shortage_Qty='4' AND PO_No='IF-5582'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3348' AND Sc_No='20542' AND Seq_No='3' AND Item_Code='WAN1621251023BWBRLTY' AND Shortage_Qty='12.5' AND PO_No='IF-5638'
20614-1-TGBU7043571-SIF-3366-Typhoon-27.5-6186-Mens . 27.5" . MTB 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C302-8FOV-Shoratge(1)-2021-10-31-Pcs-IF-5536
20614-1-TGBU7043571-SIF-3366-Typhoon-27.5-6186-Mens . 27.5" . MTB 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -SP-C207-Shoratge(6)-2021-10-31-Pcs-IF-5536
20727-1-TGBU7043571-SIF-3366-Badboy1.0-14spd-MY22-6291-Mens . 24" . MTB 14 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C308-8-Shoratge(1)-2021-10-31-Pcs-IF-5614
20627-5-TCKU7449925-SIF-3371-Road-Runner-Pro-V-21sp-MS-6211-Mens . 700C . Trekking 21 SPD . AL . Front Sus FRAME BIKE . -TDS-C331-8-Shoratge(1)-2021-11-10-Pcs-IF-5551
20665-2-MRSU5091571-SIF-3368-Mongoose-Define-M-6138-Mens . 700C . Gravel 14 SPD . AL . Disc Brake . -SP-C208-Shoratge(1)-2021-11-20-Pcs-IF-5575
20709-14-MRSU5091571-SIF-3368-Tempo200-M-NEW-EU-ms-6183-Mens . 700C . Hybrid 24 SPD . AL . Front Sus FRAME BIKE . -CH-141-700C-Shoratge(20)-2021-11-20-Pcs-IF-5586
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3376' AND Sc_No='20723' AND Seq_No='1' AND Item_Code='CH-327E-20' AND Shortage_Qty='1' AND PO_No='IF-5609'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3383' AND Sc_No='20724' AND Seq_No='3' AND Item_Code='TDS-C308-8' AND Shortage_Qty='1' AND PO_No='IF-5633'
21092-1-CMAU4521784-SIF-3388-Tornado-27.5-24sp-MS-6200-Mens . 27.5" . MTB 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -MTB-AL-312BT-FOV-Shoratge(2)-2021-12-28-Pcs-IF-5727
21102-1-CMAU4521784-SIF-3388-Karma-7sp-MS-6209-Ladies . 700C . Trekking 7 SPD . AL . Front Sus FRAME BIKE . -TDS-C331-8-Shoratge(3)-2021-12-28-Pcs-IF-5746
21153-1-GESU6334150-SIF-3396-X24-24-OCCANO-6352-Boys . 24" . MTB 8 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -SP-C208-Shoratge(1)-2022-02-13-Pcs-IF-5776
21159-1-GESU6334150-SIF-3396-Bobbin-Gingersnap-12-4463-Kids . 12" . Kids . -HA-C40-2-Shoratge(3)-2022-02-13-Pcs-IF-5819
21155-1-SEGU6367266-SIF-3400-Muddyfox-Icon-14 (UK)-4331-Boys . 14" . Kids . AL . -HS-C40-2-Shoratge(4)-2022-03-02-Pcs-IF-5904
21157-4-SEGU6367266-SIF-3400-Muddyfox-Icon-18 (UK)-4333-Boys . 18" . Kids . AL . -HA-C60-2-Shoratge(20)-2022-03-02-Pcs-IF-5906
21188-1-SEGU6367266-SIF-3400-Barracuda-Rock-ms2-6447-Mens . 27.5" . MTB 21 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C41-8-Shoratge(1)-2022-03-02-Pcs-IF-5908
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3403' AND Sc_No='21050' AND Seq_No='1' AND Item_Code='DB-330R' AND Shortage_Qty='2' AND PO_No='IF-5737'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3403' AND Sc_No='21050' AND Seq_No='1' AND Item_Code='DB-330F' AND Shortage_Qty='2' AND PO_No='IF-5737'
21116-1-GESU5860918-SIF-3409-Tornado-27.5-24sp-MS-6200-Mens . 27.5" . MTB 24 SPD . AL . Front Sus FRAME BIKE . Disc Brake . -TDS-C302-8FOV-Shoratge(1)-2022-04-27-Pcs-IF-5753
21289-1-GESU5860918-SIF-3409-Schwinn-Wayfarer-L-5844-Ladies . 700C . Hybrid 7 SPD . -HS-C80-5-Shoratge(1)-2022-04-27-Pcs-IF-5924
21244-1-MSMU6156466-SIF-3411-RH7-700C-6559-Mens . 700C . Trekking 24 SPD . AL . Disc Brake . -HB-875-F-CR-01-Shoratge(2)-2022-05-29-Sets-IF-5815
21246-1-MSMU6156466-SIF-3411-RH7-700C-6559-Mens . 700C . Trekking 24 SPD . AL . Disc Brake . -HB-875-R-CR-01-Shoratge(2)-2022-05-29-Sets-IF-5817
21387-1-MSMU6156466-SIF-3413-Schwinn-Campus-20-5677-Boys . 20" . Kids 7 SPD . AL . -HS-C398-5-Shoratge(2)-2022-05-29-Pcs-IF-5983
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3418' AND Sc_No='21399' AND Seq_No='1' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-6475'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3421' AND Sc_No='21217' AND Seq_No='9' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5823'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3423' AND Sc_No='21386' AND Seq_No='3' AND Item_Code='X10' AND Shortage_Qty='2' AND PO_No='IF-5865'
21243-19-WHLU0589890-SIF-3425-RHW5-700C-6558-Ladies . 700C . Trekking 21 SPD . AL . Disc Brake . -TDS-C301-8-FOV-V-Shoratge(2)-2022-07-05-Pcs-IF-5849
21245-15-WHLU0589890-SIF-3425-RH5-700C-6557-Mens . 700C . Trekking 21 SPD . AL . Disc Brake . -TDS-C301-8-FOV-V-Shoratge(4)-2022-07-05-Pcs-IF-5851
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3428' AND Sc_No='21456' AND Seq_No='1' AND Item_Code='X10' AND Shortage_Qty='10' AND PO_No='IF-6087'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3434' AND Sc_No='21380' AND Seq_No='19' AND Item_Code='Z1-WIDE' AND Shortage_Qty='2' AND PO_No='IF-5992'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3436' AND Sc_No='21392' AND Seq_No='3' AND Item_Code='MTB-AL-3500BT' AND Shortage_Qty='1' AND PO_No='IF-5985'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3442' AND Sc_No='21381' AND Seq_No='1' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-5971'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3447' AND Sc_No='21369' AND Seq_No='9' AND Item_Code='CH-565-27.5-AMS' AND Shortage_Qty='1' AND PO_No='IF-6163'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3452' AND Sc_No='21463' AND Seq_No='5' AND Item_Code='KT-TD7F' AND Shortage_Qty='2' AND PO_No='IF-6120'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3454' AND Sc_No='21368' AND Seq_No='9' AND Item_Code='HA-C40-5-V' AND Shortage_Qty='1' AND PO_No='IF-6162'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3460' AND Sc_No='21463' AND Seq_No='1' AND Item_Code='KT-305RB' AND Shortage_Qty='1' AND PO_No='IF-6120'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3461' AND Sc_No='21464' AND Seq_No='5' AND Item_Code='XC-105' AND Shortage_Qty='4' AND PO_No='IF-6130'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3462' AND Sc_No='21465' AND Seq_No='3' AND Item_Code='TY813' AND Shortage_Qty='1' AND PO_No='IF-6132'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3468' AND Sc_No='23028' AND Seq_No='3' AND Item_Code='CH-327-24' AND Shortage_Qty='1' AND PO_No='IF-6643'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3472' AND Sc_No='23006' AND Seq_No='2' AND Item_Code='TY813' AND Shortage_Qty='2' AND PO_No='IF-6631'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3473' AND Sc_No='23006' AND Seq_No='2' AND Item_Code='XC-105' AND Shortage_Qty='2' AND PO_No='IF-6633'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3484' AND Sc_No='23004' AND Seq_No='2' AND Item_Code='HS-C60-2' AND Shortage_Qty='2' AND PO_No='IF-6617'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3484' AND Sc_No='23037' AND Seq_No='6' AND Item_Code='MTB-AL-152BT' AND Shortage_Qty='1' AND PO_No='IF-6655'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3504' AND Sc_No='24039' AND Seq_No='4' AND Item_Code='SP-C208' AND Shortage_Qty='2' AND PO_No='IF-6800'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3504' AND Sc_No='24039' AND Seq_No='6' AND Item_Code='TDS-C41-8' AND Shortage_Qty='1' AND PO_No='IF-6800'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3515' AND Sc_No='24026' AND Seq_No='1' AND Item_Code='AT-83' AND Shortage_Qty='1' AND PO_No='IF-6764'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3527' AND Sc_No='24068' AND Seq_No='1' AND Item_Code='NR-14' AND Shortage_Qty='2' AND PO_No='IF-6914'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3527' AND Sc_No='24068' AND Seq_No='7' AND Item_Code='NR-14' AND Shortage_Qty='1' AND PO_No='IF-6914'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3528' AND Sc_No='24066' AND Seq_No='1' AND Item_Code='TY813' AND Shortage_Qty='1' AND PO_No='IF-6916'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3521' AND Sc_No='24061' AND Seq_No='1' AND Item_Code='GOAL-120L-122MM' AND Shortage_Qty='3' AND PO_No='IF-6855'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3534' AND Sc_No='25021' AND Seq_No='6' AND Item_Code='CH-327E-26' AND Shortage_Qty='1' AND PO_No='IF-6952'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3544' AND Sc_No='25049' AND Seq_No='2' AND Item_Code='TDS-D507A-8-FOV' AND Shortage_Qty='1' AND PO_No='IF-6987'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3557' AND Sc_No='25079' AND Seq_No='11' AND Item_Code='CH-565D-27.5-AMS' AND Shortage_Qty='1' AND PO_No='IF-7060'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3565' AND Sc_No='25080' AND Seq_No='1' AND Item_Code='MTB-AL-153BT' AND Shortage_Qty='8' AND PO_No='IF-7056'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3565' AND Sc_No='25095' AND Seq_No='1' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-7113'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3572' AND Sc_No='25122' AND Seq_No='5' AND Item_Code='XC-989' AND Shortage_Qty='2' AND PO_No='IF-7191'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3572' AND Sc_No='25122' AND Seq_No='5' AND Item_Code='XC-105' AND Shortage_Qty='2' AND PO_No='IF-7191'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3574' AND Sc_No='25088' AND Seq_No='1' AND Item_Code='CH-327E-24' AND Shortage_Qty='1' AND PO_No='IF-7195'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3584' AND Sc_No='25129' AND Seq_No='12' AND Item_Code='SP-C255' AND Shortage_Qty='1' AND PO_No='IF-7219'
84