Spreadsheet: 90935d1290620082-query-data-to-make-new-sheet-janet-test-aging-af
Sheet: Output

Customer Name
Dell*
Ccn | [NAME] | Customer Name | Terms | [NAME] | Invoice Date | Net Due Date | [NAME] | Current | 40208 | 31-60 | 61-Over
C97 | 111344 | DELL JAPAN INC | N45 | 1708 | 2010-11-22 00:00:00 | 2011-01-06 00:00:00 | I | 750 | 0 | 0 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 78871 | 2010-09-27 00:00:00 | 2010-11-11 00:00:00 | I | 0 | 950 | 0 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 80911 | 2010-11-22 00:00:00 | 2011-01-06 00:00:00 | I | 1300 | 0 | 0 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 78144 | 2010-09-06 00:00:00 | 2010-10-21 00:00:00 | I | 0 | 0 | 1620 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 78138 | 2010-09-06 00:00:00 | 2010-10-21 00:00:00 | I | 0 | 0 | 1900 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 78147 | 2010-09-06 00:00:00 | 2010-10-21 00:00:00 | I | 0 | 0 | 1904 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 79219 | 2010-10-06 00:00:00 | 2010-11-20 00:00:00 | I | 0 | 2118.5 | 0 | 0
C4 | 111344 | DELL JAPAN INC | N45 | 74946 | 2010-06-30 00:00:00 | 2010-08-14 00:00:00 | I | 0 | 0 | 0 | 2160
C2 | 136B1 | [NAME] A/P |  | 002848/00006 | 2006-04-13 00:00:00 | 2006-04-13 00:00:00 | U | 0 | 0 | 0 | -3535.15
C2 | 136B1 | [NAME] A/P | N45 | 243030 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 195 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 242483 | 2010-10-07 00:00:00 | 2010-11-21 00:00:00 | I | 0 | 225 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243691 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 225 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243031 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 245 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243688 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 540 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 244134 | 2010-11-02 00:00:00 | 2010-12-17 00:00:00 | I | 675 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243032 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 715 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243692 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 920 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243033 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 965 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 241403 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 990 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 240923 | 2010-09-14 00:00:00 | 2010-10-29 00:00:00 | I | 0 | 995 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243026 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 1080 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243028 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 1120 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243027 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 1625 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 241404 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 1680 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243690 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 1840 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 245420 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 1930 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 241405 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 2150 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243024 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 2575 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243025 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 2575 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243029 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 2900 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243687 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 3300 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243689 | 2010-10-26 00:00:00 | 2010-12-10 00:00:00 | I | 5150 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243023 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 5150 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 244604 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 5750 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 244594 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 6600 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 244593 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 7200 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 243970 | 2010-10-29 00:00:00 | 2010-12-13 00:00:00 | I | 8250 | 0 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 241406 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 8750 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 242484 | 2010-10-07 00:00:00 | 2010-11-21 00:00:00 | I | 0 | 13200 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 241538 | 2010-09-23 00:00:00 | 2010-11-07 00:00:00 | I | 0 | 14400 | 0 | 0
C2 | 136B1 | [NAME] A/P | N45 | 245421 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 15600 | 0 | 0 | 0
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 205089 | 2009-05-19 00:00:00 | 2009-07-03 00:00:00 | I | 0 | 0 | 0 | 3180
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 226351 | 2010-03-18 00:00:00 | 2010-05-02 00:00:00 | I | 0 | 0 | 0 | 6750
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 216640 | 2009-11-06 00:00:00 | 2009-12-21 00:00:00 | I | 0 | 0 | 0 | 19000
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 222715 | 2010-02-01 00:00:00 | 2010-03-18 00:00:00 | I | 0 | 0 | 0 | 23471
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 223514 | 2010-02-10 00:00:00 | 2010-03-27 00:00:00 | I | 0 | 0 | 0 | 23615
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 226973 | 2010-03-25 00:00:00 | 2010-05-09 00:00:00 | I | 0 | 0 | 0 | 27475
C2 | 140B1 | DELL GLOBAL BV SG BRANCH - LIMERICK | N45 | 223186 | 2010-02-05 00:00:00 | 2010-03-22 00:00:00 | I | 0 | 0 | 0 | 76379
C4 | 16554 | DELL CHINA CO LTD | N45 | 80278 | 2010-11-04 00:00:00 | 2010-12-19 00:00:00 | I | 650 | 0 | 0 | 0
C4 | 16554 | DELL CHINA CO LTD | N45 | 80385 | 2010-11-08 00:00:00 | 2010-12-23 00:00:00 | I | 1350 | 0 | 0 | 0
C4 | 16554 | DELL CHINA CO LTD | N45 | 80975 | 2010-11-24 00:00:00 | 2011-01-08 00:00:00 | I | 2100 | 0 | 0 | 0
C2 | 16555 | DELL (XIAMEN) CO. LTD. | N45 | 244120 | 2010-11-02 00:00:00 | 2010-12-17 00:00:00 | I | 45804 | 0 | 0 | 0
C2 | 1858B1 | [NAME] | N30 | 239132 | 2010-08-19 00:00:00 | 2010-09-18 00:00:00 | I | 0 | 0 | 0 | 388
C2 | 1858B1 | [NAME] | N45 | 234611 | 2010-06-23 00:00:00 | 2010-08-07 00:00:00 | I | 0 | 0 | 0 | 3250
C2 | 1858B1 | [NAME] | N45 | 245594 | 2010-11-23 00:00:00 | 2011-01-07 00:00:00 | I | 3540 | 0 | 0 | 0
C2 | 1858B1 | [NAME] | N30 | 237611 | 2010-07-30 00:00:00 | 2010-08-29 00:00:00 | I | 0 | 0 | 0 | 17733
C2 | 1858B1 | [NAME] | N45 | 224631 | 2010-02-26 00:00:00 | 2010-04-12 00:00:00 | I | 0 | 0 | 0 | 29400
C2 | 1858B1 | [NAME] | N45 | 222191 | 2010-01-26 00:00:00 | 2010-03-12 00:00:00 | I | 0 | 0 | 0 | 108000
C2 | 186870 | [NAME] BRANCH | N30 | 23990 | 2010-10-07 00:00:00 | 2010-11-06 00:00:00 | C | 0 | -575262 | 0 | 0
C2 | 186870 | [NAME] BRANCH | N30 | 23680 | 2010-08-17 00:00:00 | 2010-09-16 00:00:00 | C | 0 | 0 | 0 | -61760
C2 | 186870 | [NAME] BRANCH | N30 | 22236 | 2010-02-02 00:00:00 | 2010-03-04 00:00:00 | C | 0 | 0 | 0 | -175
C2 | 186870 | [NAME] BRANCH | N30 | 23611 | 2010-08-02 00:00:00 | 2010-09-01 00:00:00 | C | 0 | 0 | 0 | -51.48
C2 | 186870 | [NAME] BRANCH | N30 | 237322 | 2010-07-28 00:00:00 | 2010-08-27 00:00:00 | I | 0 | 0 | 0 | 88787.16
C2 | 186870 | [NAME] BRANCH | N30 | 236814 | 2010-07-21 00:00:00 | 2010-08-20 00:00:00 | I | 0 | 0 | 0 | 92384.16
C2 | 186870 | [NAME] BRANCH | N30 | 237861 | 2010-08-04 00:00:00 | 2010-09-03 00:00:00 | I | 0 | 0 | 0 | 110874.72
C2 | 186870 | [NAME] BRANCH | N30 | 237865 | 2010-08-04 00:00:00 | 2010-09-03 00:00:00 | I | 0 | 0 | 0 | 113229.6
C2 | 186870 | [NAME] BRANCH | N30 | 236815 | 2010-07-21 00:00:00 | 2010-08-20 00:00:00 | I | 0 | 0 | 0 | 118797.36
C2 | 186870 | [NAME] BRANCH | N30 | 236813 | 2010-07-21 00:00:00 | 2010-08-20 00:00:00 | I | 0 | 0 | 0 | 145197.36
C2 | 186870 | [NAME] BRANCH | N30 | 237321 | 2010-07-28 00:00:00 | 2010-08-27 00:00:00 | I | 0 | 0 | 0 | 171446.88
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 7333 | 2010-09-07 00:00:00 | 2010-10-22 00:00:00 | C | 0 | 0 | -5074 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 78387 | 2010-09-13 00:00:00 | 2010-10-28 00:00:00 | I | 0 | 2850 | 0 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 78886 | 2010-09-27 00:00:00 | 2010-11-11 00:00:00 | I | 0 | 3980 | 0 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 78388 | 2010-09-13 00:00:00 | 2010-10-28 00:00:00 | I | 0 | 6805 | 0 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 79771 | 2010-10-22 00:00:00 | 2010-12-06 00:00:00 | I | 11542 | 0 | 0 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 80002 | 2010-10-28 00:00:00 | 2010-12-12 00:00:00 | I | 11600 | 0 | 0 | 0
C4 | 1868B1 | DELLGLOBAL B.V.(SINGAPORE BRANCH) | N45 | 78630 | 2010-09-17 00:00:00 | 2010-11-01 00:00:00 | I | 0 | 11600 | 0 | 0
C2 | 1868B2 | DELL ASIA PACIFIC SDN BHD -PLOT P27 | N45 | 244427 | 2010-11-05 00:00:00 | 2010-12-20 00:00:00 | I | 2862 | 0 | 0 | 0
C2 | 1868B2 | DELL ASIA PACIFIC SDN BHD -PLOT P27 | N45 | 244324 | 2010-11-04 00:00:00 | 2010-12-19 00:00:00 | I | 5088 | 0 | 0 | 0
C4 | 2751 | DELL ASIA PACIFIC SDN BHD-MALAYSIA | N45 | 7314 | 2010-08-18 00:00:00 | 2010-10-02 00:00:00 | C | 0 | 0 | -41.5 | 0
C2 | 2751 | DELL ASIA PACIFIC SDN BHD-MALAYSIA | N45 | 239178 | 2010-08-19 00:00:00 | 2010-10-03 00:00:00 | I | 0 | 0 | 267000 | 0
C2 | 27B1 | [NAME] BRANCH |  | 006502/00022 | 2010-08-06 00:00:00 | 2010-08-06 00:00:00 | U | 0 | 0 | 0 | -6683
C2 | 27B1 | [NAME] BRANCH | N45 | 241780 | 2010-09-27 00:00:00 | 2010-11-11 00:00:00 | I | 0 | 125 | 0 | 0
C2 | 27B1 | [NAME] BRANCH | N45 | 244844 | 2010-11-11 00:00:00 | 2010-12-26 00:00:00 | I | 1590 | 0 | 0 | 0
C2 | 27B1 | [NAME] BRANCH | N45 | 241242 | 2010-09-20 00:00:00 | 2010-11-04 00:00:00 | I | 0 | 2520 | 0 | 0
C2 | 27B1 | [NAME] BRANCH | N30 | 238556 | 2010-08-12 00:00:00 | 2010-09-11 00:00:00 | I | 0 | 0 | 0 | 11390
C2 | 27B1 | [NAME] BRANCH | N30 | 239091 | 2010-08-19 00:00:00 | 2010-09-18 00:00:00 | I | 0 | 0 | 0 | 16750
C2 | 27B1 | [NAME] BRANCH | N30 | 238336 | 2010-08-10 00:00:00 | 2010-09-09 00:00:00 | I | 0 | 0 | 0 | 24120
C2 | 27B1 | [NAME] BRANCH | N30 | 242361 | 2010-10-05 00:00:00 | 2010-11-04 00:00:00 | I | 0 | 55500 | 0 | 0
C2 | 27B1 | [NAME] BRANCH | N45 | 240599 | 2010-09-09 00:00:00 | 2010-10-24 00:00:00 | I | 0 | 0 | 426695 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P |  | 006715/00016 | 2010-11-09 00:00:00 | 2010-11-09 00:00:00 | U | 0 | -98 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244598 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 170 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245423 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 225 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 241550 | 2010-09-23 00:00:00 | 2010-11-07 00:00:00 | I | 0 | 240 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245422 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 295 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245348 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 305 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 238703 | 2010-08-13 00:00:00 | 2010-09-27 00:00:00 | I | 0 | 0 | 338 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244597 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 472 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244601 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 675 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244595 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 675 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244603 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 975 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 241447 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 979 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245378 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 1540 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 242447 | 2010-10-06 00:00:00 | 2010-11-20 00:00:00 | I | 0 | 1734 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 243034 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 2525 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244599 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 2650 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 241407 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 2775 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 234305SP | 2010-09-09 00:00:00 | 2010-10-24 00:00:00 | D | 0 | 0 | 3000 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244602 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 3025 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244596 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 3025 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 243268 | 2010-10-19 00:00:00 | 2010-12-03 00:00:00 | I | 3340 | 0 | 0 | 0
C99 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N60 | 33616 | 2010-10-15 00:00:00 | 2010-12-14 00:00:00 | I | 4400 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244220 | 2010-11-03 00:00:00 | 2010-12-18 00:00:00 | I | 5649 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 243058 | 2010-10-15 00:00:00 | 2010-11-29 00:00:00 | I | 8036 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 241426 | 2010-09-21 00:00:00 | 2010-11-05 00:00:00 | I | 0 | 8327 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244600 | 2010-11-09 00:00:00 | 2010-12-24 00:00:00 | I | 9330 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245424 | 2010-11-19 00:00:00 | 2011-01-03 00:00:00 | I | 9330 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 243616 | 2010-10-25 00:00:00 | 2010-12-09 00:00:00 | I | 10854 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 244711 | 2010-11-10 00:00:00 | 2010-12-25 00:00:00 | I | 11094 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 241810 | 2010-09-27 00:00:00 | 2010-11-11 00:00:00 | I | 0 | 14694 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 245498 | 2010-11-22 00:00:00 | 2011-01-06 00:00:00 | I | 22521 | 0 | 0 | 0
C2 | 83139 | DELL COMPUTER CORP - PRODUCTION A/P | N45 | 240939 | 2010-09-14 00:00:00 | 2010-10-29 00:00:00 | I | 0 | 26839 | 0 | 0