プロジェクト

全般

プロフィール

ダウンロード (18.4 KB)

ToDo #596 » select itemshop_148193_20240617.csv

資料2 - 武田 遼河, 2024/06/17 11:01

 
1 
"item_cd","supplier_cd","shop_cd","startday","endday","delivery_day","item_class","start_date","end_date","update_by","update_at","id","create_by","create_at","output_flg","group"
2 
"148193","3021","00385","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300385","戸谷勇二","2023-06-24 15:52:00+00","","CH"
3 
"148193","3021","00415","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2024-06-12 05:53:00+00","14819300415","戸谷勇二","2023-06-24 15:53:00+00","","CH"
4 
"148193","3021","00210","20230704","20240617","12456","1","2023-07-04","2024-06-17","武田 遼河","2024-06-17 01:37:00+00","14819300210","戸谷勇二","2023-06-24 15:49:00+00","null","CH"
5 
"148193","3021","00411","20230704","20240615","12456","1","2023-07-04","2024-06-15","武田 遼河","2024-06-17 01:37:00+00","14819300411","戸谷勇二","2023-06-24 15:53:00+00","null","CH"
6 
"148193","3021","00225","20230704","99991231","12456","1","2023-07-04","9999-12-31","戸谷勇二","2023-08-03 06:35:00+00","14819300225","戸谷勇二","2023-06-24 15:49:00+00","99","CH"
7 
"148193","3021","00230","20230704","99991231","12456","1","2023-07-04","9999-12-31","戸谷勇二","2023-08-03 06:35:00+00","14819300230","戸谷勇二","2023-06-24 15:49:00+00","99","CH"
8 
"148193","3021","00426","20230704","99991231","12456","1","2023-07-04","9999-12-31","戸谷勇二","2023-08-03 06:35:00+00","14819300426","戸谷勇二","2023-06-24 15:54:00+00","99","CH"
9 
"148193","3021","00432","20230704","99991231","12456","1","2023-07-04","9999-12-31","戸谷勇二","2023-08-03 06:35:00+00","14819300432","戸谷勇二","2023-06-24 15:54:00+00","99","CH"
10 
"148193","3021","00701","20230704","99991231","12456","1","2023-07-04","9999-12-31","戸谷勇二","2023-08-03 06:35:00+00","14819300701","戸谷勇二","2023-06-24 15:54:00+00","99","CH"
11 
"148193","3021","00203","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300203","戸谷勇二","2023-06-24 15:48:00+00","","CH"
12 
"148193","3021","00204","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300204","戸谷勇二","2023-06-24 15:48:00+00","","CH"
13 
"148193","3021","00207","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300207","戸谷勇二","2023-06-24 15:48:00+00","","CH"
14 
"148193","3021","00208","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300208","戸谷勇二","2023-06-24 15:48:00+00","","CH"
15 
"148193","3021","00209","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300209","戸谷勇二","2023-06-24 15:49:00+00","","CH"
16 
"148193","3021","00212","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300212","戸谷勇二","2023-06-24 15:49:00+00","","CH"
17 
"148193","3021","00214","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300214","戸谷勇二","2023-06-24 15:49:00+00","","CH"
18 
"148193","3021","00216","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300216","戸谷勇二","2023-06-24 15:49:00+00","","CH"
19 
"148193","3021","00217","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300217","戸谷勇二","2023-06-24 15:49:00+00","","CH"
20 
"148193","3021","00218","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300218","戸谷勇二","2023-06-24 15:49:00+00","","CH"
21 
"148193","3021","00219","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300219","戸谷勇二","2023-06-24 15:49:00+00","","CH"
22 
"148193","3021","00220","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300220","戸谷勇二","2023-06-24 15:49:00+00","","CH"
23 
"148193","3021","00221","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300221","戸谷勇二","2023-06-24 15:49:00+00","","CH"
24 
"148193","3021","00222","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300222","戸谷勇二","2023-06-24 15:49:00+00","","CH"
25 
"148193","3021","00223","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300223","戸谷勇二","2023-06-24 15:49:00+00","","CH"
26 
"148193","3021","00226","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300226","戸谷勇二","2023-06-24 15:49:00+00","","CH"
27 
"148193","3021","00227","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300227","戸谷勇二","2023-06-24 15:49:00+00","","CH"
28 
"148193","3021","00229","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300229","戸谷勇二","2023-06-24 15:49:00+00","","CH"
29 
"148193","3021","00233","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300233","戸谷勇二","2023-06-24 15:49:00+00","","CH"
30 
"148193","3021","00234","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300234","戸谷勇二","2023-06-24 15:49:00+00","","CH"
31 
"148193","3021","00236","20230601","20230908","123456","1","2023-06-01","2023-09-08","大里 真樹","2024-01-12 23:20:00+00","14819300236","戸谷勇二","2023-06-24 15:49:00+00","","CH"
32 
"148193","3021","00238","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300238","戸谷勇二","2023-06-24 15:49:00+00","","CH"
33 
"148193","3021","00239","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300239","戸谷勇二","2023-06-24 15:49:00+00","","CH"
34 
"148193","3021","00240","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300240","戸谷勇二","2023-06-24 15:49:00+00","","CH"
35 
"148193","3021","00241","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300241","戸谷勇二","2023-06-24 15:49:00+00","","CH"
36 
"148193","3021","00242","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300242","戸谷勇二","2023-06-24 15:49:00+00","","CH"
37 
"148193","3021","00243","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300243","戸谷勇二","2023-06-24 15:49:00+00","","CH"
38 
"148193","3021","00244","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300244","戸谷勇二","2023-06-24 15:49:00+00","","CH"
39 
"148193","3021","00245","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300245","戸谷勇二","2023-06-24 15:49:00+00","","CH"
40 
"148193","3021","00246","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300246","戸谷勇二","2023-06-24 15:49:00+00","","CH"
41 
"148193","3021","00247","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300247","戸谷勇二","2023-06-24 15:49:00+00","","CH"
42 
"148193","3021","00248","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300248","戸谷勇二","2023-06-24 15:50:00+00","","CH"
43 
"148193","3021","00250","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300250","戸谷勇二","2023-06-24 15:50:00+00","","CH"
44 
"148193","3021","00251","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300251","戸谷勇二","2023-06-24 15:50:00+00","","CH"
45 
"148193","3021","00252","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300252","戸谷勇二","2023-06-24 15:50:00+00","","CH"
46 
"148193","3021","00253","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300253","戸谷勇二","2023-06-24 15:50:00+00","","CH"
47 
"148193","3021","00254","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300254","戸谷勇二","2023-06-24 15:50:00+00","","CH"
48 
"148193","3021","00255","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300255","戸谷勇二","2023-06-24 15:50:00+00","","CH"
49 
"148193","3021","00256","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300256","戸谷勇二","2023-06-24 15:50:00+00","","CH"
50 
"148193","3021","00257","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300257","戸谷勇二","2023-06-24 15:50:00+00","","CH"
51 
"148193","3021","00258","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300258","戸谷勇二","2023-06-24 15:50:00+00","","CH"
52 
"148193","3021","00261","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300261","戸谷勇二","2023-06-24 15:50:00+00","","CH"
53 
"148193","3021","00262","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300262","戸谷勇二","2023-06-24 15:50:00+00","","CH"
54 
"148193","3021","00263","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300263","戸谷勇二","2023-06-24 15:50:00+00","","CH"
55 
"148193","3021","00264","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300264","戸谷勇二","2023-06-24 15:50:00+00","","CH"
56 
"148193","3021","00265","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300265","戸谷勇二","2023-06-24 15:50:00+00","","CH"
57 
"148193","3021","00266","20230704","20230913","12456","1","2023-07-04","2023-09-13","戸谷勇二","2023-09-07 23:20:00+00","14819300266","戸谷勇二","2023-06-24 15:50:00+00","","CH"
58 
"148193","3021","00267","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300267","戸谷勇二","2023-06-24 15:50:00+00","","CH"
59 
"148193","3021","00268","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300268","戸谷勇二","2023-06-24 15:50:00+00","","CH"
60 
"148193","3021","00270","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300270","戸谷勇二","2023-06-24 15:50:00+00","","CH"
61 
"148193","3021","00271","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300271","戸谷勇二","2023-06-24 15:50:00+00","","CH"
62 
"148193","3021","00272","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300272","戸谷勇二","2023-06-24 15:50:00+00","","CH"
63 
"148193","3021","00274","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300274","戸谷勇二","2023-06-24 15:50:00+00","","CH"
64 
"148193","3021","00275","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300275","戸谷勇二","2023-06-24 15:50:00+00","","CH"
65 
"148193","3021","00276","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300276","戸谷勇二","2023-06-24 15:50:00+00","","CH"
66 
"148193","3021","00277","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300277","戸谷勇二","2023-06-24 15:50:00+00","","CH"
67 
"148193","3021","00278","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300278","戸谷勇二","2023-06-24 15:50:00+00","","CH"
68 
"148193","3021","00279","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300279","戸谷勇二","2023-06-24 15:50:00+00","","CH"
69 
"148193","3021","00280","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300280","戸谷勇二","2023-06-24 15:50:00+00","","CH"
70 
"148193","3021","00301","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300301","戸谷勇二","2023-06-24 15:50:00+00","","CH"
71 
"148193","3021","00304","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300304","戸谷勇二","2023-06-24 15:50:00+00","","CH"
72 
"148193","3021","00306","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300306","戸谷勇二","2023-06-24 15:51:00+00","","CH"
73 
"148193","3021","00308","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300308","戸谷勇二","2023-06-24 15:51:00+00","","CH"
74 
"148193","3021","00310","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300310","戸谷勇二","2023-06-24 15:51:00+00","","CH"
75 
"148193","3021","00313","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300313","戸谷勇二","2023-06-24 15:51:00+00","","CH"
76 
"148193","3021","00314","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300314","戸谷勇二","2023-06-24 15:51:00+00","","CH"
77 
"148193","3021","00315","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300315","戸谷勇二","2023-06-24 15:51:00+00","","CH"
78 
"148193","3021","00316","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300316","戸谷勇二","2023-06-24 15:51:00+00","","CH"
79 
"148193","3021","00318","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300318","戸谷勇二","2023-06-24 15:51:00+00","","CH"
80 
"148193","3021","00319","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300319","戸谷勇二","2023-06-24 15:51:00+00","","CH"
81 
"148193","3021","00321","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300321","戸谷勇二","2023-06-24 15:51:00+00","","CH"
82 
"148193","3021","00322","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300322","戸谷勇二","2023-06-24 15:51:00+00","","CH"
83 
"148193","3021","00323","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300323","戸谷勇二","2023-06-24 15:51:00+00","","CH"
84 
"148193","3021","00324","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300324","戸谷勇二","2023-06-24 15:51:00+00","","CH"
85 
"148193","3021","00325","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300325","戸谷勇二","2023-06-24 15:51:00+00","","CH"
86 
"148193","3021","00326","20240110","20230908","123456","1","2024-01-10","2023-09-08","大里 真樹","2024-01-10 23:20:00+00","14819300326","戸谷勇二","2023-06-24 15:51:00+00","","CH"
87 
"148193","3021","00328","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300328","戸谷勇二","2023-06-24 15:51:00+00","","CH"
88 
"148193","3021","00329","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300329","戸谷勇二","2023-06-24 15:51:00+00","","CH"
89 
"148193","3021","00330","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300330","戸谷勇二","2023-06-24 15:51:00+00","","CH"
90 
"148193","3021","00331","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300331","戸谷勇二","2023-06-24 15:51:00+00","","CH"
91 
"148193","3021","00332","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300332","戸谷勇二","2023-06-24 15:51:00+00","","CH"
92 
"148193","3021","00333","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300333","戸谷勇二","2023-06-24 15:51:00+00","","CH"
93 
"148193","3021","00334","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300334","戸谷勇二","2023-06-24 15:51:00+00","","CH"
94 
"148193","3021","00335","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300335","戸谷勇二","2023-06-24 15:51:00+00","","CH"
95 
"148193","3021","00336","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300336","戸谷勇二","2023-06-24 15:51:00+00","","CH"
96 
"148193","3021","00338","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300338","戸谷勇二","2023-06-24 15:51:00+00","","CH"
97 
"148193","3021","00339","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300339","戸谷勇二","2023-06-24 15:51:00+00","","CH"
98 
"148193","3021","00340","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300340","戸谷勇二","2023-06-24 15:51:00+00","","CH"
99 
"148193","3021","00342","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300342","戸谷勇二","2023-06-24 15:51:00+00","","CH"
100 
"148193","3021","00343","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300343","戸谷勇二","2023-06-24 15:51:00+00","","CH"
101 
"148193","3021","00344","20230704","20230908","12456","1","2023-07-04","2023-09-08","戸谷勇二","2023-09-07 23:20:00+00","14819300344","戸谷勇二","2023-06-24 15:51:00+00","","CH"
(2-2/2)