Spreadsheet: 133811d1324647114-vlookup-formula-dnsiaec0093r-11
Sheet: WIP (2)

BU | AOG? | REF_CONSIGNEE | JOB_FILE | FLIGHT NO | MAWB | HAWB | SHIPPER | GW | CW | INV_DATE | INV_NO | NO | COST CTR | INV_AMT | TAX_AMOUNT | TTL AMT
AI | Normal/Routine | 0 | 288900 | SQ 325 | 618-39692833 | 72103027 | SCHOPF MASCHINENBAU GMBH | 393 | 393 | 2011-06-23 00:00:00 | 4048336 | 1 | ELM210 | 1963.65 | 0 | 1963.65
AI | Normal/Routine | PO# 20170308KTT | 289622 | QF094 | 081-48055755 | USLAX358300 | GOODRICH AEROSTRUCTURES GROUP | 2 | 7 | 2011-06-23 00:00:00 | 4048358 | 2 | EIM423 | 806.51 | 0 | 806.51
AI | Normal/Routine | PO# 20170473ETT | 289629 | QF0010 | 081-75790724 | 134907 | AIRLINE SERVICES COMPONENTS LTD | 11 | 11 | 2011-06-23 00:00:00 | 4048407 | 3 | EIM423 | 1036.7 | 0 | 1036.7
AI | Normal/Routine | PO# 11GBST6061 | 289631 | [NAME] | 217-34759955 | CNSHA240041 | CHINA EASTERN AVIATION IMPORT & EXP | 15 | 25.5 | 2011-06-23 00:00:00 | 4048427 | 4 | EIM423 | 963.01 | 0 | 963.01
AI | Normal/Routine | IBT001262 | 289633 | EK218 | 176-77785385 | USLAX356530 | SIA ENGINEERING COMPANY | 28 | 28 | 2011-06-23 00:00:00 | 4048441 | 5 | EIM324 | 356.76 | 0 | 356.76
AE | Urgent/Critical/Express | SIAEC-S11/ALPS/OTH/0268 | 289115 | SQ7848 | 618-49336092 | 0 | SIA ENGINEERING CO LTD | 16 | 16 | 2011-06-23 00:00:00 | 4048454 | 6 | EIM318 | 158.08 | 0 | 158.08
AI | Normal/Routine | PO# 20169446EGW | 289647 | CX091 | 160-21592174 | 0 | FIRETECH SERVICES PTE LTD | 67 | 67 | 2011-06-23 00:00:00 | 4048465 | 7 | EIM318 | 1171.82 | 0 | 1171.82
AI | AOG | 20175150FTS | 288289 | TK66 | 235-64334561 | HAM-6218 3306 | BE AEROSPACE CONSUMABLES MANAGEMENT | 0.2 | 0.5 | 2011-06-23 00:00:00 | 4048481 | 8 | EBM203 | 254.45 | 0 | 254.45
AI | AOG | 20174970TSP, 20174758FTS | 288462 | LH778 | 020-80516951 | FRA-6417 5732 | AOA AVIONICS DRESDEN GMBH | 1.5 | 3.5 | 2011-06-23 00:00:00 | 4048484 | 9 | EBM203 | 421.63 | 0 | 421.63
AI | Normal/Routine | 0 | 289653 | EK216 | 176-94396934 | USLAX539922 | SIA ENGINEERING COMPANY | 2 | 8 | 2011-06-23 00:00:00 | 4048497 | 10 | EIM324 | 634.81 | 0 | 634.81
AI | AOG | 20173940WST | 288389 | LH778 | 020-81763651 | HAM62183307 | MANKIEWICZ GEBR & CO (GMBH & CO.KG) | 143.5 | 143.5 | 2011-06-23 00:00:00 | 4048500 | 11 | EBM204 | 1474.38 | 0 | 1474.38
AE | AOG | SIAEC-S11/ALPS/OTH/0274 | 289498 | SQ828 | 618-49333793 | 0 | SIA ENGINEERING CO LTD | 16 | 16 | 2011-06-23 00:00:00 | 4048506 | 12 | EIM318 | 216.68 | 0 | 216.68
AI | Normal/Routine | 0 | 289675 | VS007 | 932-39877154 | 135608 | AIRBASE SERVICES UK LTD | 13 | 13 | 2011-06-23 00:00:00 | 4048517 | 13 | EIM324 | 718.54 | 0 | 718.54
AI | Normal/Routine | PO# 11GBST6054 | 289827 | CZ499 | 784-57689822 | CNSHA239223 | CHINA EASTERN AVIATION | 3 | 5 | 2011-06-24 00:00:00 | 4048624 | 14 | EIM318 | 532.36 | 0 | 532.36
AE | Urgent/Critical/Express | SIAEC-S11/ALPS/OTH/0270 | 289178 | SQ 227 | 618-49336103 | SGSIN289178 | SIA ENGINEERING CO LTD | 16 | 16 | 2011-06-24 00:00:00 | 4048717 | 15 | EIM423 | 276.64 | 0 | 276.64
AI | Normal/Routine | 0 | 287686 | LH 778 | 020-81763426 | 62183244 | BE AEROSPACE CONSUMABLES | 0.2 | 0.5 | 2011-06-24 00:00:00 | 4048844 | 16 | EBM204 | 368.53 | 0 | 368.53
AI | AOG | 20174804FTR | 287823 | LH778 | 020-81763463 | 62183246 | BE AEROSPACE CONSUMABLES MANAGEMENT | 1 | 1 | 2011-06-24 00:00:00 | 4048846 | 17 | EBM218 | 368.53 | 0 | 368.53
AI | AOG | 20174532LTT | 287831 | LH778 | 020-81763474 | 62183247 | AIRBUS SUPPORT DIVISION | 7 | 7 | 2011-06-24 00:00:00 | 4048848 | 18 | EQC408 | 382.92 | 0 | 382.92
AE | Urgent/Critical/Express | THALES20173904RGW | 289609 | SQ836 | 618-49336125 | 0 | THALES SOLUTIONS ASIA PTE LTE | 11 | 12 | 2011-06-24 00:00:00 | 4048852 | 19 | EIM318 | 406.66 | 0 | 406.66
AI | AOG | 20175125FTR | 288064 | [NAME] | 074-51147062 | CPH-00052687 | SATAIR A/S | 1 | 1.5 | 2011-06-27 00:00:00 | 4049061 | 20 | EBM218 | 706.74 | 0 | 706.74
AE | Urgent/Critical/Express | SIAEC-S11/ALPS/OTH/0275 | 289626 | SQ227 | 618-49336571 | SGSIN289626 | SIA ENGINEERING CO LTD | 4 | 8 | 2011-06-27 00:00:00 | 4049070 | 21 | EIM423 | 161.52 | 0 | 161.52
AI | Normal/Routine | 20174971RTT | 288849 | SQ218 | 618-36534621 | AUMEL121628 | [NAME] | 20 | 20 | 2011-06-27 00:00:00 | 4049075 | 22 | EIM423 | 473.75 | 0 | 473.75
AI | Normal/Routine | 20165692MTS | 289807 | EK 404 | 176-95633495 | 136950 | HAAS GROUP INTL | 10 | 10 | 2011-06-27 00:00:00 | 4049098 | 23 | EMT301 | 182.53 | 0 | 182.53
AI | Normal/Routine | 20175312MRP | 289808 | EK 404 | 176-95633495 | 136949 | [NAME] (UK) LTD | 3 | 5.5 | 2011-06-27 00:00:00 | 4049101 | 24 | EMT301 | 173.85 | 0 | 173.85
AI | Normal/Routine | 20175508FTS | 289811 | EK 404 | 176-95633495 | 136952 | MESSIER DOWTY LTD | 1 | 1 | 2011-06-27 00:00:00 | 4049103 | 25 | EBM204 | 166.46 | 0 | 166.46
AI | Normal/Routine | 4820160088LEC | 289806 | EK 404 | 176-95633495 | 136819 | AJ WALTER (AVIATION) LTD | 4 | 11.5 | 2011-06-27 00:00:00 | 4049105 | 26 | EIM306 | 183.21 | 0 | 183.21
AI | Normal/Routine | 20174892WSD | 289810 | EK 404 | 176-95633495 | 136818 | [NAME] (UK) LTD | 2 | 3 | 2011-06-27 00:00:00 | 4049107 | 27 | EWS201 | 251.76 | 0 | 251.76
AI | Urgent/Critical/Express | ME1F286236G | 290019 | KL835 | 074-51510023 | HAM-62183475 | INTERTURBINE LOGISTIK GMBH | 7 | 7 | 2011-06-27 00:00:00 | 4049173 | 28 | EBM215 | 432.74 | 0 | 432.74
AI | Normal/Routine | 0 | 290290 | LH457 | 020-79877044 | USLAX359455 | SIA ENGINEERING COMPANY | 2 | 3.5 | 2011-06-27 00:00:00 | 4049175 | 29 | EIM324 | 578.32 | 0 | 578.32
AI | Normal/Routine | P/N:2156-756A S/N:20749B; | 289901 | MU0545 | 781-70958742 | CNSHA243044 | CHINA EASTERN AVIATION | 7 | 17 | 2011-06-27 00:00:00 | 4049206 | 30 | EIM318 | 344.1 | 0 | 344.1
AI | Normal/Routine | 0 | 290221 | SQ 325 | 618-39692844 | 62183500 | AIRBUS OPERATIONS GMBH (EZ) | 350 | 350 | 2011-06-27 00:00:00 | 4049540 | 31 | EBM203 | 1307.52 | 0 | 1307.52
 |  |  |  |  |  |  |  |  |  |  | Total |  |  | 17475.16 | 0 | 17475.16