[広告]
日付 店舗コード データ番号 担当者 会員番号 商品ジャンル 商品カテゴリ 商品コード 価格 ポイント売上げ額 現金売上額 原価 現金・カード区分
2001/4/3 T4034 7 00M5365 5144M200210724 602 150 643048490 10000 2000 8000 7000 C
2001/4/3 T5142 1 99W5788 5144D200210533 599 200 312287987 11400 3420 7980 9120 G
2001/4/3 T9996 3 97M8588 4042M200010489 343 200 886603705 8100 0 8100 5670 G
2001/4/3 T4042 3 01M0862 330 200 422915431 6600 0 6600 4620 G
2001/4/3 T5144 5 94W6328 4052D200202767 402 200 395842815 7500 0 7500 6750 G
2001/4/3 T4052 5 03M8015 4034M200202206 602 200 613937821 13600 0 13600 9520 C
2001/4/3 T4044 5 03W7216 5130D200210217 500 200 150315298 11600 0 11600 8120 G
2001/4/3 T6232 3 00W8770 9996D200002874 602 200 613937821 13600 0 13600 9520 G
2001/4/3 T9991 3 03W7598 4052D200010347 330 150 422915431 6600 0 6600 4620 G
2001/4/3 T5144 1 02M3576 602 150 643048490 10000 0 10000 7000 G
2001/4/3 T5144 2 98M5999 5130M200202494 502 200 814665409 7800 3120 4680 7020 G
2001/4/3 T5130 12 98W1298 4044M200010123 500 150 150315298 11600 0 11600 9280 G
2001/4/3 T6217 5 97W4125 502 150 28883453 11900 0 11900 9520 G
2001/4/3 T6217 6 98M6629 6217D200202337 453 200 259541786 10900 4360 6540 7630 G
2001/4/3 T6230 1 01M0324 5130D200002862 599 150 312287987 11400 0 11400 10260 C
2001/4/3 T6217 13 98W7502 4034D200010654 489 150 363458759 9300 0 9300 7440 G
2001/4/3 T5130 7 95W9194 9999M200002662 453 150 259541786 10900 2180 8720 7630 G
2001/4/3 T5130 10 97M0706 5130D200010394 343 210 985378025 8100 0 8100 5670 C
2001/4/3 T9983 3 97W4927 4042M200002074 502 200 814665409 7800 0 7800 7020 C
2001/4/3 T5124 4 97M4444 5124D200202151 502 150 28883453 11900 2380 9520 9520 G
2001/4/3 T6217 4 03M7600 6217M200202359 330 150 422915431 6600 1980 4620 4620 C
2001/4/3 T5128 1 03W6180 4034M200010026 602 150 48117148 12000 1200 10800 9600 G
2001/4/3 T5144 4 02W9493 9996D200210016 502 150 28883453 11900 4760 7140 9520 C
2001/4/3 T4034 4 95W8066 4044M200202720 402 150 547669229 8000 0 8000 6400 G
2001/4/3 T9983 6 03M7674 502 210 106132761 10000 0 10000 7000 G
2001/4/3 T5144 6 03M2102 5144D200202592 450 210 323557708 8900 0 8900 6230 C
2001/4/3 T5124 1 01M9477 5124M200002688 502 150 28883453 11900 1190 10710 9520 G
2001/4/3 T5144 8 00M4406 602 200 613937821 13600 0 13600 9520 G
2001/4/3 T4034 5 03M3185 5144M200010927 450 150 323557708 8900 2670 6230 6230 C
2001/4/3 T6217 11 94M9069 6217D200002960 500 200 150315298 11600 1160 10440 8120 C
2001/4/3 T4052 2 00M4844 9996M200202499 489 150 363458759 9300 0 9300 7440 C
2001/4/3 T4044 2 02M4144 246 200 800663252 5800 0 5800 4060 C
2001/4/3 T9983 5 00W8702 9983D200202250 450 150 323557708 8900 0 8900 6230 G
2001/4/3 T5144 7 02W3733 5142D200202119 502 200 814665409 7800 3120 4680 7020 G
2001/4/3 T6217 3 94W2664 336 150 585939315 8000 0 8000 6400 C
2001/4/3 T6217 8 97M3892 246 150 742348408 4200 0 4200 2940 G
2001/4/3 T6217 9 98W8363 6217M200002815 343 150 886603705 8100 0 8100 5670 G
2001/4/3 T4042 4 01M1434 502 200 814665409 7800 0 7800 7020 G
2001/4/3 T9991 2 97M9653 5144D200202605 336 150 585939315 8000 3200 4800 6400 G
2001/4/3 T9996 6 03M2721 5130D200010586 438 150 77984106 8300 0 8300 7470 G
2001/4/3 T9983 1 95M7159 502 150 28883453 11900 0 11900 9520 G
2001/4/3 T9999 2 99M0874 9996D200010825 602 200 613937821 13600 4080 9520 9520 G
2001/4/3 T4052 7 94M2629 9991D200010300 602 200 613937821 13600 0 13600 9520 C
2001/4/3 T9996 8 94M8687 599 200 312287987 11400 0 11400 9120 G
2001/4/3 T9999 1 97M2069 4042M200210519 502 200 814665409 7800 0 7800 7020 G
2001/4/3 T4052 3 02M7200 599 200 312287987 11400 0 11400 9120 G
2001/4/3 T4034 2 96W7169 602 150 643048490 10000 0 10000 7000 C
2001/4/3 T5130 11 97W0189 5128M200010528 498 200 404868115 12400 0 12400 9920 G
2001/4/3 T9996 4 01W9462 6217D200202473 498 150 674829051 9800 2940 6860 8820 G
2001/4/3 T9994 1 94W3523 6217D200202342 502 150 479972194 10000 0 10000 7000 G
2001/4/3 T5143 1 96M2974 502 200 814665409 7800 0 7800 7020 C
2001/4/3 T4034 3 94W5857 9983M200002751 502 200 814665409 7800 1560 6240 7020 G
2001/4/3 T6231 2 96M3578 5144D200210725 502 150 28883453 11900 0 11900 9520 C
2001/4/3 T5130 4 98M5910 336 150 585939315 8000 0 8000 6400 C
2001/4/3 T4052 6 99W4259 5130M200002225 502 210 106132761 10000 0 10000 7000 C
2001/4/3 T5124 2 03W0996 9996D200202187 402 150 547669229 8000 0 8000 6400 C
2001/4/3 T9991 1 99M7221 5124D200210213 508 150 518017570 12000 0 12000 8400 G
2001/4/3 T9983 8 03M0285 4052D200210375 502 150 479972194 10000 0 10000 7000 C
2001/4/3 T6217 12 03M4128 438 150 77984106 8300 0 8300 7470 C
2001/4/3 T6217 7 98W0309 6217D200210741 506 150 518017570 6300 0 6300 5670 C
2001/4/3 T5124 3 01W2452 5144M200002562 450 150 323557708 8900 3560 5340 6230 G
2001/4/3 T5141 1 99M2411 6232D200002902 489 150 363458759 9300 930 8370 7440 C
2001/4/3 T9996 7 03M5444 9996D200202386 489 200 363458759 9300 1860 7440 8370 G
2001/4/3 T9994 2 01W1995 6217M200010539 453 200 259541786 10900 0 10900 7630 G
2001/4/3 T5130 8 00W1162 5130D200010301 506 200 227786191 12800 3840 8960 10240 G
2001/4/3 T4034 1 97M9550 5130D200010444 502 150 479972194 10000 0 10000 7000 G
2001/4/3 T4042 2 96M4797 336 200 585939315 8000 0 8000 6400 G
2001/4/3 T6217 10 98M8089 4052M200002329 498 150 674829051 9800 0 9800 8820 G
2001/4/3 T4034 8 98W4134 6217M200210706 502 150 479972194 10000 2000 8000 7000 G
2001/4/3 T4052 4 97M8615 6217D200010198 502 200 814665409 7800 780 7020 7020 G
2001/4/3 T4034 6 99M7125 5141D200002173 502 150 479972194 10000 1000 9000 7000 C
2001/4/3 T9983 4 97M3995 9983D200010273 402 150 547669229 8000 0 8000 6400 C
2001/4/3 T4044 1 97M1995 506 200 227786191 12800 0 12800 10240 G
2001/4/3 T5144 3 97M1636 5128M200210344 602 150 48117148 12000 0 12000 9600 G
2001/4/3 T4042 1 02W1632 5128M200202937 508 150 518017570 12000 0 12000 8400 G
2001/4/3 T5130 3 95W5807 4044M200010105 508 200 518017570 12000 3600 8400 9600 G
2001/4/3 T5128 2 95M3733 502 200 814665409 7800 0 7800 7020 C
2001/4/3 T9996 2 94W6345 4052D200002219 246 150 742348408 4200 420 3780 2940 G
2001/4/3 T4042 5 00M7716 453 150 259541786 10900 0 10900 7630 G
2001/4/3 T4044 4 96W2165 498 150 674829051 9800 0 9800 8820 G
2001/4/3 T9983 2 96M2299 6217D200210866 602 150 643048490 10000 4000 6000 7000 C
2001/4/3 T5130 6 97M8382 6217M200202615 502 200 814665409 7800 0 7800 7020 C
2001/4/3 T9996 1 01M8322 6217M200010162 506 200 227786191 12800 3840 8960 10240 G
2001/4/3 T9996 5 01M0499 5130D200002018 500 150 150315298 11600 2320 9280 9280 G
2001/4/3 T9983 7 95M7382 4052M200210059 602 200 613937821 13600 0 13600 9520 G
2001/4/3 T6217 1 95M9453 4034D200002179 502 200 814665409 7800 0 7800 7020 C
2001/4/3 T4052 1 99W6392 6231D200210373 438 200 77984106 8300 0 8300 7470 G
2001/4/3 T4044 3 03M4592 6217M200202454 343 200 886603705 8100 0 8100 5670 G
2001/4/3 T6217 2 03M9334 6217M200202682 508 200 518017570 12000 3600 8400 9600 C
2001/4/3 T5130 9 01M3415 6217D200202625 246 200 401982752 4000 400 3600 2800 G
2001/4/3 T5130 5 96W8667 4042M200010435 330 200 422915431 6600 0 6600 4620 G
2001/4/3 T5130 13 02W8901 5144D200202616 438 150 77984106 8300 0 8300 7470 G
 これは、CSVファイルをエクセルで開いたときのイメージです。たかが100件弱のデータですが、本当はこの数倍のデータがあるのでしょう。このCSVファイルが必要なときは、下のダウンロードというアンカーをクリックしてください。クリックするとダイアログが現れます。

CSVファイルをダウンロードする
※このデータは架空のデータです
日付,店舗コード,データ番号,担当者,会員番号,商品ジャンル,商品カテゴリ,商品コード,価格,ポイント売上げ額,現金売上額,原価,現金・カード区分
2001/4/3,T4034,7,00M5365,5144M200210724,602,150,643048490,10000,2000,8000,7000,C
2001/4/3,T5142,1,99W5788,5144D200210533,599,200,312287987,11400,3420,7980,9120,G
2001/4/3,T9996,3,97M8588,4042M200010489,343,200,886603705,8100,0,8100,5670,G
2001/4/3,T4042,3,01M0862,,330,200,422915431,6600,0,6600,4620,G
2001/4/3,T5144,5,94W6328,4052D200202767,402,200,395842815,7500,0,7500,6750,G
2001/4/3,T4052,5,03M8015,4034M200202206,602,200,613937821,13600,0,13600,9520,C
2001/4/3,T4044,5,03W7216,5130D200210217,500,200,150315298,11600,0,11600,8120,G
2001/4/3,T6232,3,00W8770,9996D200002874,602,200,613937821,13600,0,13600,9520,G
2001/4/3,T9991,3,03W7598,4052D200010347,330,150,422915431,6600,0,6600,4620,G
2001/4/3,T5144,1,02M3576,,602,150,643048490,10000,0,10000,7000,G
2001/4/3,T5144,2,98M5999,5130M200202494,502,200,814665409,7800,3120,4680,7020,G
2001/4/3,T5130,12,98W1298,4044M200010123,500,150,150315298,11600,0,11600,9280,G
2001/4/3,T6217,5,97W4125,,502,150,28883453,11900,0,11900,9520,G
2001/4/3,T6217,6,98M6629,6217D200202337,453,200,259541786,10900,4360,6540,7630,G
2001/4/3,T6230,1,01M0324,5130D200002862,599,150,312287987,11400,0,11400,10260,C
2001/4/3,T6217,13,98W7502,4034D200010654,489,150,363458759,9300,0,9300,7440,G
2001/4/3,T5130,7,95W9194,9999M200002662,453,150,259541786,10900,2180,8720,7630,G
2001/4/3,T5130,10,97M0706,5130D200010394,343,210,985378025,8100,0,8100,5670,C
2001/4/3,T9983,3,97W4927,4042M200002074,502,200,814665409,7800,0,7800,7020,C
2001/4/3,T5124,4,97M4444,5124D200202151,502,150,28883453,11900,2380,9520,9520,G
2001/4/3,T6217,4,03M7600,6217M200202359,330,150,422915431,6600,1980,4620,4620,C
2001/4/3,T5128,1,03W6180,4034M200010026,602,150,48117148,12000,1200,10800,9600,G
2001/4/3,T5144,4,02W9493,9996D200210016,502,150,28883453,11900,4760,7140,9520,C
2001/4/3,T4034,4,95W8066,4044M200202720,402,150,547669229,8000,0,8000,6400,G
2001/4/3,T9983,6,03M7674,,502,210,106132761,10000,0,10000,7000,G
2001/4/3,T5144,6,03M2102,5144D200202592,450,210,323557708,8900,0,8900,6230,C
2001/4/3,T5124,1,01M9477,5124M200002688,502,150,28883453,11900,1190,10710,9520,G
2001/4/3,T5144,8,00M4406,,602,200,613937821,13600,0,13600,9520,G
2001/4/3,T4034,5,03M3185,5144M200010927,450,150,323557708,8900,2670,6230,6230,C
2001/4/3,T6217,11,94M9069,6217D200002960,500,200,150315298,11600,1160,10440,8120,C
2001/4/3,T4052,2,00M4844,9996M200202499,489,150,363458759,9300,0,9300,7440,C
2001/4/3,T4044,2,02M4144,,246,200,800663252,5800,0,5800,4060,C
2001/4/3,T9983,5,00W8702,9983D200202250,450,150,323557708,8900,0,8900,6230,G
2001/4/3,T5144,7,02W3733,5142D200202119,502,200,814665409,7800,3120,4680,7020,G
2001/4/3,T6217,3,94W2664,,336,150,585939315,8000,0,8000,6400,C
2001/4/3,T6217,8,97M3892,,246,150,742348408,4200,0,4200,2940,G
2001/4/3,T6217,9,98W8363,6217M200002815,343,150,886603705,8100,0,8100,5670,G
2001/4/3,T4042,4,01M1434,,502,200,814665409,7800,0,7800,7020,G
2001/4/3,T9991,2,97M9653,5144D200202605,336,150,585939315,8000,3200,4800,6400,G
2001/4/3,T9996,6,03M2721,5130D200010586,438,150,77984106,8300,0,8300,7470,G
2001/4/3,T9983,1,95M7159,,502,150,28883453,11900,0,11900,9520,G
2001/4/3,T9999,2,99M0874,9996D200010825,602,200,613937821,13600,4080,9520,9520,G
2001/4/3,T4052,7,94M2629,9991D200010300,602,200,613937821,13600,0,13600,9520,C
2001/4/3,T9996,8,94M8687,,599,200,312287987,11400,0,11400,9120,G
2001/4/3,T9999,1,97M2069,4042M200210519,502,200,814665409,7800,0,7800,7020,G
2001/4/3,T4052,3,02M7200,,599,200,312287987,11400,0,11400,9120,G
2001/4/3,T4034,2,96W7169,,602,150,643048490,10000,0,10000,7000,C
2001/4/3,T5130,11,97W0189,5128M200010528,498,200,404868115,12400,0,12400,9920,G
2001/4/3,T9996,4,01W9462,6217D200202473,498,150,674829051,9800,2940,6860,8820,G
2001/4/3,T9994,1,94W3523,6217D200202342,502,150,479972194,10000,0,10000,7000,G
2001/4/3,T5143,1,96M2974,,502,200,814665409,7800,0,7800,7020,C
2001/4/3,T4034,3,94W5857,9983M200002751,502,200,814665409,7800,1560,6240,7020,G
2001/4/3,T6231,2,96M3578,5144D200210725,502,150,28883453,11900,0,11900,9520,C
2001/4/3,T5130,4,98M5910,,336,150,585939315,8000,0,8000,6400,C
2001/4/3,T4052,6,99W4259,5130M200002225,502,210,106132761,10000,0,10000,7000,C
2001/4/3,T5124,2,03W0996,9996D200202187,402,150,547669229,8000,0,8000,6400,C
2001/4/3,T9991,1,99M7221,5124D200210213,508,150,518017570,12000,0,12000,8400,G
2001/4/3,T9983,8,03M0285,4052D200210375,502,150,479972194,10000,0,10000,7000,C
2001/4/3,T6217,12,03M4128,,438,150,77984106,8300,0,8300,7470,C
2001/4/3,T6217,7,98W0309,6217D200210741,506,150,518017570,6300,0,6300,5670,C
2001/4/3,T5124,3,01W2452,5144M200002562,450,150,323557708,8900,3560,5340,6230,G
2001/4/3,T5141,1,99M2411,6232D200002902,489,150,363458759,9300,930,8370,7440,C
2001/4/3,T9996,7,03M5444,9996D200202386,489,200,363458759,9300,1860,7440,8370,G
2001/4/3,T9994,2,01W1995,6217M200010539,453,200,259541786,10900,0,10900,7630,G
2001/4/3,T5130,8,00W1162,5130D200010301,506,200,227786191,12800,3840,8960,10240,G
2001/4/3,T4034,1,97M9550,5130D200010444,502,150,479972194,10000,0,10000,7000,G
2001/4/3,T4042,2,96M4797,,336,200,585939315,8000,0,8000,6400,G
2001/4/3,T6217,10,98M8089,4052M200002329,498,150,674829051,9800,0,9800,8820,G
2001/4/3,T4034,8,98W4134,6217M200210706,502,150,479972194,10000,2000,8000,7000,G
2001/4/3,T4052,4,97M8615,6217D200010198,502,200,814665409,7800,780,7020,7020,G
2001/4/3,T4034,6,99M7125,5141D200002173,502,150,479972194,10000,1000,9000,7000,C
2001/4/3,T9983,4,97M3995,9983D200010273,402,150,547669229,8000,0,8000,6400,C
2001/4/3,T4044,1,97M1995,,506,200,227786191,12800,0,12800,10240,G
2001/4/3,T5144,3,97M1636,5128M200210344,602,150,48117148,12000,0,12000,9600,G
2001/4/3,T4042,1,02W1632,5128M200202937,508,150,518017570,12000,0,12000,8400,G
2001/4/3,T5130,3,95W5807,4044M200010105,508,200,518017570,12000,3600,8400,9600,G
2001/4/3,T5128,2,95M3733,,502,200,814665409,7800,0,7800,7020,C
2001/4/3,T9996,2,94W6345,4052D200002219,246,150,742348408,4200,420,3780,2940,G
2001/4/3,T4042,5,00M7716,,453,150,259541786,10900,0,10900,7630,G
2001/4/3,T4044,4,96W2165,,498,150,674829051,9800,0,9800,8820,G
2001/4/3,T9983,2,96M2299,6217D200210866,602,150,643048490,10000,4000,6000,7000,C
2001/4/3,T5130,6,97M8382,6217M200202615,502,200,814665409,7800,0,7800,7020,C
2001/4/3,T9996,1,01M8322,6217M200010162,506,200,227786191,12800,3840,8960,10240,G
2001/4/3,T9996,5,01M0499,5130D200002018,500,150,150315298,11600,2320,9280,9280,G
2001/4/3,T9983,7,95M7382,4052M200210059,602,200,613937821,13600,0,13600,9520,G
2001/4/3,T6217,1,95M9453,4034D200002179,502,200,814665409,7800,0,7800,7020,C
2001/4/3,T4052,1,99W6392,6231D200210373,438,200,77984106,8300,0,8300,7470,G
2001/4/3,T4044,3,03M4592,6217M200202454,343,200,886603705,8100,0,8100,5670,G
2001/4/3,T6217,2,03M9334,6217M200202682,508,200,518017570,12000,3600,8400,9600,C
2001/4/3,T5130,9,01M3415,6217D200202625,246,200,401982752,4000,400,3600,2800,G
2001/4/3,T5130,5,96W8667,4042M200010435,330,200,422915431,6600,0,6600,4620,G
2001/4/3,T5130,13,02W8901,5144D200202616,438,150,77984106,8300,0,8300,7470,G
 ちなみにCSVデータというのは、このようなカンマ(,)区切りの訳の分からないデータです。メモ帳などのテキストエディタで開くと、このようなものが表示されます。

Copyright(C) 1999-2006 結城圭介。 All rights reserved