IJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
재고 수량 쿼리
2
매입기록 쿼리매출기록 쿼리매입기록 & 매출기록 쿼리매입기록 & 매출기록 통합 피벗테이블
3
일자품명수량년월일품명출고수량일자품명수량품명일자수량의 SUM
4
17-01-02흥아 16.00-25 32PR 417-01-02흥아 16.00-25 32PR 3 17-01-02흥아 16.00-25 32PR 4금호 6.00-15 10PR 354A 17-01-0413
5
17-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs3017-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs4 17-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs3017-04-100
6
17-01-02흥아 16.00-25 32PR 917-01-02흥아 16.00-25 32PR 4 17-01-02흥아 16.00-25 32PR 917-06-167
7
17-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs1917-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs5 17-01-02더블코인 12.00R20 솔루션 수입 176A5, 126kgs1917-08-154
8
17-01-04한국 245/45ZR18 XL 1417-01-04한국 245/45ZR18 XL 1 17-01-04한국 245/45ZR18 XL 1417-10-2917
9
17-01-04더블코인 12.00R20 솔루션 수입 176A5, 126kgs1517-01-04더블코인 12.00R20 솔루션 수입 176A5, 126kgs2 17-01-04더블코인 12.00R20 솔루션 수입 176A5, 126kgs1518-01-0215
10
17-01-04미타스 12-16.5 14PR 빅보이 317-01-04미타스 12-16.5 14PR 빅보이 4 17-01-04미타스 12-16.5 14PR 빅보이 318-02-0410
11
17-01-04Haulmax 9.00-20 18PR E-3S OTR 917-01-04Haulmax 9.00-20 18PR E-3S OTR 3 17-01-04Haulmax 9.00-20 18PR E-3S OTR 918-02-115
12
17-01-04Haulmax 8.15-15 ZM722 2117-01-04Haulmax 8.15-15 ZM722 4 17-01-04Haulmax 8.15-15 ZM722 2118-05-1723
13
17-01-04Haulmax 10.00-20 18PR GK918 SET617-01-04Haulmax 10.00-20 18PR GK918 SET5 17-01-04Haulmax 10.00-20 18PR GK918 SET618-06-1611
14
17-01-04금호 6.00-15 10PR 354A 1817-01-04금호 6.00-15 10PR 354A 5 17-01-04금호 6.00-15 10PR 354A 1818-07-016
15
17-01-04튜브 7-14 2817-01-04튜브 7-14 3 17-01-04튜브 7-14 2819-02-2016
16
17-01-05튜브 7-14 2117-01-05튜브 7-14 2 17-01-05튜브 7-14 2119-04-175
17
17-01-05흥아 26.5-25 32PR L4 1517-01-05흥아 26.5-25 32PR L4 3 17-01-05흥아 26.5-25 32PR L4 1519-10-0424
18
17-01-05튜브 8-16 717-01-05튜브 8-16 5 17-01-05튜브 8-16 719-11-1316
19
17-01-05Trelleborg 6.00-9 12PR 튜브오비포함2217-01-05Trelleborg 6.00-9 12PR 튜브오비포함4 17-01-05Trelleborg 6.00-9 12PR 튜브오비포함2219-12-1916
20
17-01-05휠 6.00-9 대우 쪽림1917-01-05휠 6.00-9 대우 쪽림1 17-01-05휠 6.00-9 대우 쪽림1920-04-0425
21
17-01-06튜브 26.5-25 2117-01-06튜브 26.5-25 4 17-01-06튜브 26.5-25 2120-06-0916
22
17-01-06휠 12-16.5 8홀2717-01-06휠 12-16.5 8홀5 17-01-06휠 12-16.5 8홀2720-08-198
23
17-01-06더블코인 245/70R19.5 폭 1952217-01-06더블코인 245/70R19.5 폭 1955 17-01-06더블코인 245/70R19.5 폭 1952220-10-233
24
17-01-07튜브 8.25-15 넥센 1017-01-07튜브 8.25-15 넥센 2 17-01-07튜브 8.25-15 넥센 10금호 6.00-15 10PR 354A 총계240
25
17-01-07튜브 6.50-10 넥센 2617-01-07튜브 6.50-10 넥센 5 17-01-07튜브 6.50-10 넥센 26넥센 5.00-8 백색 통타이어 17-04-0419
26
17-01-08튜브 3.00-15 넥센 1117-01-08튜브 3.00-15 넥센 5 17-01-08튜브 3.00-15 넥센 1117-06-0928
27
17-01-08Haulmax 10.00-20 18PR GK918 SET2517-01-08Haulmax 10.00-20 18PR GK918 SET3 17-01-08Haulmax 10.00-20 18PR GK918 SET2517-08-1311
28
17-01-08흥아 12.4-32 2017-01-08흥아 12.4-32 3 17-01-08흥아 12.4-32 2017-10-1423
29
17-01-30튜브 14.00-20 넥센 1917-01-30튜브 14.00-20 넥센 1 17-01-30튜브 14.00-20 넥센 1917-12-2717
30
17-01-31후랩 13.00/14.00-20 1717-01-31후랩 13.00/14.00-20 2 17-01-31후랩 13.00/14.00-20 1718-05-04-1
31
17-02-01링롱 18.4R38 (460/85R38) 117-02-01링롱 18.4R38 (460/85R38) 2 17-02-01링롱 18.4R38 (460/85R38) 118-06-140
32
17-02-02링롱 6.50-10 LL 2317-02-02링롱 6.50-10 LL 5 17-02-02링롱 6.50-10 LL 2318-09-1221
33
17-02-03링롱 7.00-12 LL 신형1017-02-03링롱 7.00-12 LL 신형2 17-02-03링롱 7.00-12 LL 신형1018-11-198
34
17-02-04링롱 8.25-15 14PR 신형1917-02-04링롱 8.25-15 14PR 신형5 17-02-04링롱 8.25-15 14PR 신형1918-12-2725
35
17-02-06흥아 12-16.5 12PR 1317-02-06흥아 12-16.5 12PR 5 17-02-06흥아 12-16.5 12PR 1319-01-0519
36
17-02-06한국 8.15-15 12PR 2517-02-06한국 8.15-15 12PR 1 17-02-06한국 8.15-15 12PR 2519-06-16-1
37
17-02-09한국 7.00-15 12PR 2617-02-09한국 7.00-15 12PR 5 17-02-09한국 7.00-15 12PR 2619-08-2924
38
17-02-09한국 7.00-12 12PR 1617-02-09한국 7.00-12 12PR 4 17-02-09한국 7.00-12 12PR 1619-09-2821
39
17-02-09한국 6.50-10 10PR 1417-02-09한국 6.50-10 10PR 4 17-02-09한국 6.50-10 10PR 1419-11-063
40
17-02-09한국 5.00-8 8PR 1417-02-09한국 5.00-8 8PR 3 17-02-09한국 5.00-8 8PR 1420-03-30-2
41
17-02-11타이어월드 11.2R24 (280/85R24) 217-02-11타이어월드 11.2R24 (280/85R24) 1 17-02-11타이어월드 11.2R24 (280/85R24) 220-06-085
42
17-02-11타이어월드 12-16.5 BEEFY BABY 2617-02-11타이어월드 12-16.5 BEEFY BABY 2 17-02-11타이어월드 12-16.5 BEEFY BABY 2620-08-07-2
43
17-02-11미타스 12-16.5 14PR 빅보이 2617-02-11미타스 12-16.5 14PR 빅보이 1 17-02-11미타스 12-16.5 14PR 빅보이 2620-10-137
44
17-02-16흥아 12.4-24 8PR 617 신형317-02-16흥아 12.4-24 8PR 617 신형5 17-02-16흥아 12.4-24 8PR 617 신형320-12-1610
45
17-02-18바브캣 31X12-16.5 2517-02-18바브캣 31X12-16.5 4 17-02-18바브캣 31X12-16.5 25넥센 5.00-8 백색 통타이어 총계235
46
17-02-18더블코인 12R16.5 수입2317-02-18더블코인 12R16.5 수입4 17-02-18더블코인 12R16.5 수입23더블코인 12.00R20 솔루션 수입 176A5, 126kgs17-01-0240
47
17-02-20ADVANCE 8.15-15 12PR 1217-02-20ADVANCE 8.15-15 12PR 5 17-02-20ADVANCE 8.15-15 12PR 1217-01-0413
48
17-02-20ADVANCE 8.25-15 16PR 617-02-20ADVANCE 8.25-15 16PR 3 17-02-20ADVANCE 8.25-15 16PR 617-04-0746
49
17-02-20흥아 26.5-25 28PR 674 L3 1317-02-20흥아 26.5-25 28PR 674 L3 5 17-02-20흥아 26.5-25 28PR 674 L3 1317-04-100
50
17-02-20BKT 7.5L-15 8PR AS504 2117-02-20BKT 7.5L-15 8PR AS504 1 17-02-20BKT 7.5L-15 8PR AS504 2117-06-0912
51
17-02-23ADVANCE 7.50-16 12PR 717-02-23ADVANCE 7.50-16 12PR 5 17-02-23ADVANCE 7.50-16 12PR 717-06-1426
52
17-02-23ADVANCE 6.00-9 117-02-23ADVANCE 6.00-9 1 17-02-23ADVANCE 6.00-9 117-08-1535
53
17-02-23ADVANCE 7.00R12 2117-02-23ADVANCE 7.00R12 1 17-02-23ADVANCE 7.00R12 2117-10-2043
54
17-02-23BKT 12-16.5 12PR SP SK 717-02-23BKT 12-16.5 12PR SP SK 1 17-02-23BKT 12-16.5 12PR SP SK 717-10-28-3
55
17-02-26튜브 8-18 1817-02-26튜브 8-18 5 17-02-26튜브 8-18 1818-01-0717
56
17-02-26튜브 13.6-26 1박스-4개917-02-26튜브 13.6-26 1박스-4개4 17-02-26튜브 13.6-26 1박스-4개918-01-080
57
17-02-26튜브 8.15-15 동아 417-02-26튜브 8.15-15 동아 5 17-02-26튜브 8.15-15 동아 418-01-3024
58
17-02-26튜브 16.9-30 1박스-3개2617-02-26튜브 16.9-30 1박스-3개3 17-02-26튜브 16.9-30 1박스-3개2618-02-0218
59
17-02-26후랩 7.50-16 1617-02-26후랩 7.50-16 5 17-02-26후랩 7.50-16 1618-02-046
60
17-02-28후랩 9.00-20 (동아) 217-02-28후랩 9.00-20 (동아) 2 17-02-28후랩 9.00-20 (동아) 218-02-064
61
17-02-28튜브 7.00-15 흥아 717-02-28튜브 7.00-15 흥아 4 17-02-28튜브 7.00-15 흥아 718-03-0815
62
17-03-03Haulmax 8.15-15 ZM806 2017-03-03Haulmax 8.15-15 ZM806 2 17-03-03Haulmax 8.15-15 ZM806 2018-03-1121
63
17-03-03Haulmax 6.50-10 ZM806 2117-03-03Haulmax 6.50-10 ZM806 2 17-03-03Haulmax 6.50-10 ZM806 2118-05-0710
64
17-03-06흥아 8.15-15 12PR 704 2017-03-06흥아 8.15-15 12PR 704 5 17-03-06흥아 8.15-15 12PR 704 2018-06-1644
65
17-03-06흥아 7.00-15 12PR 704 3017-03-06흥아 7.00-15 12PR 704 2 17-03-06흥아 7.00-15 12PR 704 3018-06-2216
66
17-03-08흥아 6.50-10 12PR 704 517-03-08흥아 6.50-10 12PR 704 4 17-03-08흥아 6.50-10 12PR 704 518-06-306
67
17-03-08흥아 8-18 8PR 617 917-03-08흥아 8-18 8PR 617 4 17-03-08흥아 8-18 8PR 617 918-11-19-3
68
17-03-11흥아 8-16 6PR 614 1017-03-11흥아 8-16 6PR 614 3 17-03-11흥아 8-16 6PR 614 1018-11-2725
69
17-03-11튜브 7.50-16 동아 1617-03-11튜브 7.50-16 동아 1 17-03-11튜브 7.50-16 동아 1619-01-0615
70
17-03-13튜브 7.50-15 튜브 117-03-13튜브 7.50-15 튜브 3 17-03-13튜브 7.50-15 튜브 119-01-0712
71
17-03-13튜브 7.00-15 흥아 417-03-13튜브 7.00-15 흥아 2 17-03-13튜브 7.00-15 흥아 419-01-0820
72
17-03-15Haulmax 6.00-9 ZM806 517-03-15Haulmax 6.00-9 ZM806 5 17-03-15Haulmax 6.00-9 ZM806 519-02-1124
73
17-03-15흥아 13.6-24 8PR 617 2917-03-15흥아 13.6-24 8PR 617 3 17-03-15흥아 13.6-24 8PR 617 2919-02-1810
74
17-03-15튜브 20.5-25 1417-03-15튜브 20.5-25 2 17-03-15튜브 20.5-25 1419-06-2226
75
17-03-15튜브 6.00-16 3017-03-15튜브 6.00-16 1 17-03-15튜브 6.00-16 3019-08-3014
76
17-03-17오링 흥아-26.5-25 인치 2817-03-17오링 흥아-26.5-25 인치 2 17-03-17오링 흥아-26.5-25 인치 2819-09-292
77
17-03-17한국 8.25-15 14PR 31kgs2817-03-17한국 8.25-15 14PR 31kgs1 17-03-17한국 8.25-15 14PR 31kgs2819-10-0137
78
17-03-17한국 8.15-15 12PR 1317-03-17한국 8.15-15 12PR 1 17-03-17한국 8.15-15 12PR 1319-11-069
79
17-03-17한국 7.00-12 12PR 2917-03-17한국 7.00-12 12PR 5 17-03-17한국 7.00-12 12PR 2919-11-1139
80
17-03-17한국 6.50-10 10PR 417-03-17한국 6.50-10 10PR 4 17-03-17한국 6.50-10 10PR 419-12-135
81
17-03-19ADVANCE 8.25-15 16PR 417-03-19ADVANCE 8.25-15 16PR 3 17-03-19ADVANCE 8.25-15 16PR 420-03-3033
82
17-03-19ADVANCE 7.00-15 1317-03-19ADVANCE 7.00-15 3 17-03-19ADVANCE 7.00-15 1320-04-0520
83
17-03-19ADVANCE 6.50R10 217-03-19ADVANCE 6.50R10 2 17-03-19ADVANCE 6.50R10 220-06-0314
84
17-03-19Haulmax 12.00-20 28PR ZM722 817-03-19Haulmax 12.00-20 28PR ZM722 4 17-03-19Haulmax 12.00-20 28PR ZM722 820-06-0623
85
17-03-19Haulmax 9.00-20 18PR E-3S OTR 2017-03-19Haulmax 9.00-20 18PR E-3S OTR 4 17-03-19Haulmax 9.00-20 18PR E-3S OTR 2020-06-1223
86
17-03-23Haulmax 11.00-20 ZM722 18PR E-4 1517-03-23Haulmax 11.00-20 ZM722 18PR E-4 5 17-03-23Haulmax 11.00-20 ZM722 18PR E-4 1520-08-0817
87
17-03-23Haulmax 12-16.5 2517-03-23Haulmax 12-16.5 4 17-03-23Haulmax 12-16.5 2520-08-0926
88
17-03-23Haulmax 12.00-20 GK918 20PR 2617-03-23Haulmax 12.00-20 GK918 20PR 4 17-03-23Haulmax 12.00-20 GK918 20PR 2620-08-1019
89
17-03-23BKT 7.5L-15 8PR AS504 1417-03-23BKT 7.5L-15 8PR AS504 2 17-03-23BKT 7.5L-15 8PR AS504 1420-10-178
90
17-03-27월드스톤 20.5-25 24PR E3/L3 TL 2317-03-27월드스톤 20.5-25 24PR E3/L3 TL 4 17-03-27월드스톤 20.5-25 24PR E3/L3 TL 2320-10-198
91
17-03-27싸이런 245/70R19.5 silun S702 깍두기패턴2917-03-27싸이런 245/70R19.5 silun S702 깍두기패턴1 17-03-27싸이런 245/70R19.5 silun S702 깍두기패턴2920-10-2117
92
17-03-27Haulmax 9.00-20 18PR E-3S OTR 1617-03-27Haulmax 9.00-20 18PR E-3S OTR 3 17-03-27Haulmax 9.00-20 18PR E-3S OTR 16더블코인 12.00R20 솔루션 수입 176A5, 126kgs 총계836
93
17-03-27Haulmax 10.00-20 18PR GK918 SET2817-03-27Haulmax 10.00-20 18PR GK918 SET1 17-03-27Haulmax 10.00-20 18PR GK918 SET28더블코인 12R16.5 수입17-02-1819
94
17-04-01Haulmax 12-16.5 R4 2917-04-01Haulmax 12-16.5 R4 4 17-04-01Haulmax 12-16.5 R4 2917-05-048
95
17-04-01더블코인 8.25R15 1517-04-01더블코인 8.25R15 2 17-04-01더블코인 8.25R15 1517-07-0911
96
17-04-01더블코인 7.00R12 717-04-01더블코인 7.00R12 2 17-04-01더블코인 7.00R12 717-09-12-2
97
17-04-01비마 12R16.5 CST76 14PR 2717-04-01비마 12R16.5 CST76 14PR 4 17-04-01비마 12R16.5 CST76 14PR 2717-11-1328
98
17-04-01한국 205/55R16 1117-04-01한국 205/55R16 2 17-04-01한국 205/55R16 1118-03-173
99
17-04-02ADVANCE 8.15-15 12PR 2117-04-02ADVANCE 8.15-15 12PR 3 17-04-02ADVANCE 8.15-15 12PR 2118-04-0120
100
17-04-02ADVANCE 7.00-15 2917-04-02ADVANCE 7.00-15 5 17-04-02ADVANCE 7.00-15 2918-11-0619