SELECT color.hinban, color.color, color.del_plan_flag, zaiko.jpn_stock, zaiko.jpn_meter ,zaiko.up5_2,zaiko.up5_3,zaiko.up6_1,zaiko.up6_2,zaiko.up6_3,zaiko.up7_1,zaiko.up7_2,zaiko.up7_3,zaiko.up8_1 FROM color LEFT JOIN ( SELECT z1.id, z1.hinban, z1.color, z1.jpn_stock, z1.jpn_meter ,z2.up5_2,z2.up5_3,z2.up6_1,z2.up6_2,z2.up6_3,z2.up7_1,z2.up7_2,z2.up7_3,z2.up8_1 FROM ( SELECT z_all.id, z_all.hinban, z_all.color, z_all.jpn_stock, z_all.jpn_meter FROM hcd_shop.zaiko AS z_all LEFT JOIN ( SELECT id, hinban, color, shubetsu, jpn_stock, jpn_meter FROM hcd_shop.zaiko WHERE shubetsu = '現物' AND hinban = 'AD2678L' GROUP BY hinban,color ) AS z_genbutsu ON z_all.hinban = z_genbutsu.hinban AND z_all.color = z_genbutsu.color WHERE z_all.hinban = 'AD2678L' GROUP BY z_all.hinban,z_all.color ) AS z1, ( SELECT z_all.hinban, z_all.color ,z_kakou1.up5_2,z_kakou1.up5_3,z_kakou1.up6_1,z_kakou1.up6_2,z_kakou1.up6_3,z_kakou1.up7_1,z_kakou1.up7_2,z_kakou1.up7_3,z_kakou1.up8_1 FROM hcd_shop.zaiko AS z_all LEFT JOIN ( SELECT hinban, color ,sum(up5_2) AS up5_2,sum(up5_3) AS up5_3,sum(up6_1) AS up6_1,sum(up6_2) AS up6_2,sum(up6_3) AS up6_3,sum(up7_1) AS up7_1,sum(up7_2) AS up7_2,sum(up7_3) AS up7_3,sum(up8_1) AS up8_1 FROM hcd_shop.zaiko WHERE shubetsu = '加工中' AND hinban = 'AD2678L' AND year = DATE_FORMAT(NOW(),'%Y') GROUP BY hinban,color ) AS z_kakou1 ON z_all.hinban = z_kakou1.hinban AND z_all.color = z_kakou1.color WHERE z_all.hinban = 'AD2678L' GROUP BY z_all.hinban,z_all.color ) AS z2 WHERE (z1.hinban = z2.hinban AND z1.color = z2.color)) zaiko ON color.hinban = zaiko.hinban AND color.color = zaiko.color WHERE color.hinban = 'AD2678L' ORDER BY color.disp_sort ASCArray ( [hinban] => AD2678L [color] => KW [del_plan_flag] => 0 [jpn_stock] => 30 [jpn_meter] => 1034.3 [up5_2] => [up5_3] => [up6_1] => [up6_2] => [up6_3] => [up7_1] => [up7_2] => [up7_3] => [up8_1] => ) PRODUCTS SEARCH | コスモテキスタイル株式会社 FOR HOME HOBBY
コスモテキスタイル株式会社

PRODUCTS SEARCH

商品詳細

[AD2678L] AD2678L H/W 33Mﾏﾙﾏｷ

素材

C 100% WRINKLED DYED SHEETING

巾×長さ

110.0CM×33.0M

混率

C100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
30 990
OW
No Image
26 858
KN
No Image
25 825
3
No Image
10 330
10
No Image
30 990
24
No Image
16 528
32
No Image
15 495
36
No Image
24 792
38
No Image
9 297
50
No Image
17 561
82
No Image
9 297
84
No Image
17 561
108
No Image
20 660
137
No Image
12 396
149
No Image
17 561
152
No Image
13 429
214
No Image
10 330
217
No Image
17 561
247
No Image
14 462
256
No Image
8 264
258
No Image
15 495
261
No Image
13 429
264
No Image
18 594
266
No Image
21 693
267
No Image
36 1188
278
No Image
22 726
286
No Image
15 495
289
No Image
29 957
300
No Image
37 1221
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
30
26
25
10
30
16
15
24
9
17
9
17
20
12
17
13
10
17
14
8
15
13
18
21
36
22
15
29
37

※M以外は反数単位で表示となります。
※原反在庫は30分ごとに更新しています。
※カット反の有無は1日1度、朝に更新した情報です。

Back

RECOMMEND ITEM