Spreadsheet: 156052d1337164214-extracting-multiple-records-from-one-lookup-value-fz-reporting-16-may-2012
Sheet: GIT

SWISS PERFUMES FZE
Goods in Transit Vs Material Receipt Notes 01-01-2011 To 16-05-2012
Shipment Type | Date | Voucher | Links | Account | Code | Product Description | Units | Currency | Rate | Quantity | Balance | Payment Terms | LC No: | L/C Expiry DT | Delivery Date | Remarks
IMPORT | 2012-04-11 00:00:00 | Git:275 | Por:SP/PO/2012/00644 | CHIRAG PACK INDIA PVT LTD | CAP/CH/SO/RDBR/100/EN/M/NO INSERT | CAP BROWNISH RED 504 C SOGO NO INSERT 100ML _x000D_ | PCS | US Dollar | 0.043 | 10000 | 432 | LC PAYABLE FOR 60 DAYS FROM BL DAT |  | -- | END OF FEBRUARY` | CP/90/11-12
IMPORT | 2012-04-11 00:00:00 | Git:275 | Por:SP/PO/2012/00644 | CHIRAG PACK INDIA PVT LTD | CAP/CH/TR/RDBR/100/EN/W | CAP REDDISH BROWN TRIANGLE 100ML (CHIRAG) | PCS | US Dollar | 0.035 | 20000 | 486 | LC PAYABLE FOR 60 DAYS FROM BL DAT |  | -- | END OF FEBRUARY` | CP/90/11-12
IMPORT | 2012-04-11 00:00:00 | Git:275 | Por:SP/PO/2012/00644 | CHIRAG PACK INDIA PVT LTD | CAP/CH/SL/SLVR/100/EN/M | [NAME] SLEEK 100ML (CHIRAG) | PCS | US Dollar | 0.038 | 42800 | 495 | LC PAYABLE FOR 60 DAYS FROM BL DAT |  | -- | END OF FEBRUARY` | CP/90/11-12
IMPORT | 2012-05-15 00:00:00 | Git:286 | Por:SP/PO/2012/00668 | CHIRAG PACK INDIA PVT LTD | CAP/CH/KU/GOLD/100/SC/M | CAP SHINY GOLD KUBIK LUTECE PP-STYLE COLLECTION- MEN - CHIRAG | PCS | US Dollar | 0.06 | 25000 | 25000 | LC PAYABLE FOR 60 DAYS FROM BL DAT | 799T1U4120945283-AD | -- | 3WEEKS FROM PO DATE | CP/03/12-13
IMPORT | 2012-05-15 00:00:00 | Git:286 | Por:SP/PO/2012/00668 | CHIRAG PACK INDIA PVT LTD | CAP/CH/KU/SLV/100/SC/M | [NAME] SHINY SILVER KUBIK LUTECE PP-STYLE COLLECTION-MEN - CHIRAG | PCS | US Dollar | 0.06 | 75000 | 75000 | LC PAYABLE FOR 60 DAYS FROM BL DAT | 799T1U4120945283-AD | -- | 3WEEKS FROM PO DATE | CP/03/12-13
IMPORT | 2012-05-02 00:00:00 | Git:281 | Por:SP/PO/2012/00624 | COSTER INDIA PACKAGING PVT. LTD. | FER/CI/15MM/GOLD | FERRULE - GOLD 15MM - LOW PROFILE CPS  - COSTER INDIA | PCS | US Dollar | 0.043 | 250000 | 250000 | LC PAYABLE FOR 120 DAYS FROM THE B | TF1205949664-NBF | -- | 26.02.12 | COSTER/SEZ/14/1213
IMPORT | 2012-05-02 00:00:00 | Git:281 | Por:SP/PO/2012/00624 | COSTER INDIA PACKAGING PVT. LTD. | ACT/CI/CPS/GOLD | ACTUATOR -  GOLD SHELLED  - ACTUATOR -  VO4.1233(CODE S/G) - COSTER I | PCS | US Dollar | 0.019 | 250000 | 250000 | LC PAYABLE FOR 120 DAYS FROM THE B | TF1205949664-NBF | -- | 26.02.12 | COSTER/SEZ/14/1213
IMPORT | 2012-05-02 00:00:00 | Git:281 | Por:SP/PO/2012/00624 | COSTER INDIA PACKAGING PVT. LTD. | FER/CI/20MM/SLVR | FERRULE - SILVER 20MM - LOW PROFILE CPS - COSTER INDIA | PCS | US Dollar | 0.043 | 50000 | 50000 | LC PAYABLE FOR 120 DAYS FROM THE B | TF1205949664-NBF | -- | 26.02.12 | COSTER/SEZ/14/1213
IMPORT | 2012-05-02 00:00:00 | Git:281 | Por:SP/PO/2012/00624 | COSTER INDIA PACKAGING PVT. LTD. | ACT/CI/CPS/SLVR | ACTUATOR -  SILVER SHELLED - ACTUATOR - VO4.1233(CODE S/S) COSTER IND | PCS | US Dollar | 0.019 | 50000 | 50000 | LC PAYABLE FOR 120 DAYS FROM THE B | TF1205949664-NBF | -- | 26.02.12 | COSTER/SEZ/14/1213
IMPORT | 2012-03-29 00:00:00 | Git:271 | Por:SP/PO/2012/00597 | FLYING DRAGON INTL INDUSTRY CO.L | BOT/FD/VIAL/CLER/3ML | BOTTLE CLEAR GLASS VIAL TZP 3ML (FLYING DRAGON)_x000D_ | PCS | US Dollar | 0.055 | 20000 | 20000 | 30% ADVANCE BAL. BEFORE SHIPMNT. |  | -- | 22/3/12 PROD FINISH | READY FOR DISPATCH, WTNG FOR BAL PYMNT USD17
IMPORT | 2012-03-29 00:00:00 | Git:271 | Por:SP/PO/2012/00597 | FLYING DRAGON INTL INDUSTRY CO.L | PUP&ACT/FD/VIAL/3ML | PUMP & ACTUATOR VIAL TZP 3ML (FLYING DRAGON)_x000D_ | PCS | US Dollar | 0.07 | 20000 | 20000 | 30% ADVANCE BAL. BEFORE SHIPMNT. |  | -- | 22/3/12 PROD FINISH | READY FOR DISPATCH, WTNG FOR BAL PYMNT USD17
IMPORT | 2012-03-14 00:00:00 | Git:262 | Por:SP/PO/2011/00541 | PIRAMAL GLASS | BOT/PR/SO/CL/100/EN/M | BOTTLE CLEAR GLASS SOGO 100ML (PIRAMAL) | PCS | US Dollar | 0.135 | 24960 | 20 | LC PAYABLE FOR 45 DAYS FROM BL DAT | 101IMLU120180002-B |  | TBA | ARVD IN SHJ, WTNG FR ORIG DOCS.
IMPORT | 2012-04-02 00:00:00 | Git:274 | Por:SP/PO/2011/00498 | SMB GLOBAL LTD- HONG KONG | CAP/SG/BU/CLER/95/OD/M&W | CAP SURLYN CLEAR BUMP 95ML(SMB GLOBAL) | PCS | US Dollar | 0.55 | 18000 | 18000 | 50% ON BL COPY & BAL. 15DAYS AFTR |  |  | U/C READY/BAL 15/1 | REVISED PURCHASE ORDER DUE TO PRICE INCREASE
IMPORT | 2012-04-02 00:00:00 | Git:274 | Por:SP/PO/2011/00557 | SMB GLOBAL LTD- HONG KONG | CAP/SG/NU/CL/100/OD/M | CAP NUSHI SURLYN CLEAR SURAT/SENATORE MEN 100ML (SMB GLOBAL) | PCS | US Dollar | 0.38 | 27000 | 27000 | 50% ON BL COPY & BAL. 15DAYS AFTR |  |  | U/C READY/BAL 15/1 | REVISED PURCHASE ORDER DUE TO PRICE INCREASE
IMPORT | 2012-04-02 00:00:00 | Git:274 | Por:SP/PO/2011/00574 | SMB GLOBAL LTD- HONG KONG | BOT/SG/YI/CLR/105/M | BOTTLE YI CLEAR GLASS 105ML MEN - SMB GLOBAL | PCS | US Dollar | 0.1375 | 100000 | 100000 | 50% ON BL COPY & BAL. 15DAYS AFTR |  |  | U/C READY/BAL 15/1 | REVISED PURCHASE ORDER DUE TO PRICE INCREASE
IMPORT | 2012-04-02 00:00:00 | Git:274 | Por:SP/PO/2011/00574 | SMB GLOBAL LTD- HONG KONG | CAP/SG/YI/SLVR/105/M | [NAME] WITH SHOULDER UV GALVANISED SILVER COLOUR FOR MEN 105 ML YI BOTTL | PCS | US Dollar | 0.2125 | 95000 | 95000 | 50% ON BL COPY & BAL. 15DAYS AFTR |  |  | U/C READY/BAL 15/1 | REVISED PURCHASE ORDER DUE TO PRICE INCREASE
IMPORT | 2012-04-02 00:00:00 | Git:274 | Por:SP/PO/2012/00621 | SMB GLOBAL LTD- HONG KONG | CAP/SG/HC/CLPP/100/LU/W | CAP SURLYN&PURPLE HECTOR/LUTECE WOMEN  100ML (SMB GLOBAL) | PCS | US Dollar | 0.28 | 10000 | 10000 | 50% ON BL COPY & BAL. 15DAYS AFTR |  |  | U/C READY/BAL 15/1 | REVISED PURCHASE ORDER DUE TO PRICE INCREASE
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/SW5/GT/100/RO/M | UNIT CARTON - GYM & TONIQ - UTILITY PRINT PACK | PCS | US Dollar | 0.17 | 5740 | 5740 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/BU/CAB/95/OD/W | UNIT CARTON - CABANA FEMME 95 ML - UTILITY PRINT PACK | PCS | US Dollar | 0.11 | 6200 | 6200 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/JA/OL/100/OL/W | UNIT CARTON - OMBRE LUMIERE FEMME - UTILITY PRINT PACK | PCS | US Dollar | 0.11 | 11000 | 11000 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | TRY/UT/SIX/DU/100/RO/M | TRAY-THE DUKE-UTILITY PRINT PACK | PCS | US Dollar | 0.2 | 9700 | 9700 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | BPT/UT/SIX/DU/100/RO/M | BASE PLATE-THE DUKE-UTILITY PRINT PACK | PCS | US Dollar | 0.02 | 9700 | 9700 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00609 | UTILITY PRINTPACK PRIVATE LIMITED | SLV/UT/SIX/DU/100/RO/M | SLEEVE-THE DUKE-UTILITY PRINT PACK | PCS | US Dollar | 0.18 | 9700 | 9700 | LC PAYABLE FOR 120 DAYS FROM THE B | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00632 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/SL/BAS/100/EN/M | UNIT CARTON - SLEEK MEN 100ML BASE CODE -UTILITY PRINT PACK | PCS | US Dollar | 0.1 | 9300 | 9300 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00635 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/TR/ROCO/100/EN/W | UNIT CARTON - ROCOCO TRIANGLE 100ML -UTILITY PRINT PACK | PCS | US Dollar | 0.1 | 2380 | 2380 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00659 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/YI/FOR/100/SC/M | UNIT CARTON FORWARD 100ML YI MEN- STYLE COLLECTION - UTILITY PRINT PA | PCS | US Dollar | 0.1 | 26070 | 26070 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00659 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/YI/GLI/100/SC/M | UNIT CARTON GLITZ 100ML YI MEN - STYLE COLLECTION - UTILITY PRINT PAC | PCS | US Dollar | 0.1 | 26100 | 26100 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00659 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/YI/BLA/100/SC/M | UNIT CARTON BLACK NIGHT 100ML YI MEN - STYLE COLLECTION - UTILITY PRI | PCS | US Dollar | 0.1 | 26300 | 26300 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00659 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/YI/RED/100/SC/M | UNIT CARTON RED LINE 100ML YI MEN - STYLE COLLECTION - UTILITY PRINT | PCS | US Dollar | 0.1 | 26100 | 26100 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00672 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/KU/RUN/100/SC/M | UNIT CARTON RUNNING DESIRE 100ML KUBIK MEN STYLE COLLECTION - UTILITY | PCS | US Dollar | 0.1 | 25820 | 25820 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00661 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/T91/ORGE/100/SC/W | UNIT CARTON - ORANGE BLOSSOM 100ML T91 WOMEN STYLE COLLECTION - UTILI | PCS | US Dollar | 0.1 | 18800 | 18800 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00661 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/T91/MISS/100/SC/W | UNIT CARTON MISS CHEER 100ML T91 WOMEN STYLE COLLECTION - UTILITY PRI | PCS | US Dollar | 0.1 | 18850 | 18850 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00661 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/T91/ADD/100/SC/W | UNIT CARTON ADD SHINE 100ML T91 WOMEN STYLE COLLECTION - UTILITY PRIN | PCS | US Dollar | 0.1 | 18770 | 18770 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00672 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/KU/RCH/100/SC/M | UNIT CARTON #1 RICH MAN 100ML- KUBIK-MEN-STYLE COLLECTION - UTILITY P | PCS | US Dollar | 0.095 | 25450 | 25450 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00672 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/KU/ATT/100/SC/M | UNIT CARTON ATTRACTION 100ML KUBIK MEN STYLE COLLECTION - UTILITY PRI | PCS | US Dollar | 0.095 | 25850 | 25850 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12
IMPORT | 2012-05-15 00:00:00 | Git:285 | Por:SP/PO/2012/00672 | UTILITY PRINTPACK PRIVATE LIMITED | UCN/UT/KU/BLK/100/SC/M | UNIT CARTON BLACK MOUNT LEADER 100ML KUBIK MEN STYLE COLLECTION - UTI | PCS | US Dollar | 0.095 | 23650 | 23650 | LC PAYABLE FOR 90 DAYS FROM THE BL | DPCJBA250311-HSBC | -- | -- | DISPATCH ON 25.04.12