| 注文 |
order_t |
|
|
|
|
|
|
|
|
|
|
|
|
受注番号 |
受注日 |
顧客ID |
ステータス |
支払分類 |
出荷予定日 |
出荷日 |
配送業者 |
追跡番号 |
到着予定日 |
代引手数料 |
送料 |
消費税 |
|
order_no |
order_date |
user_id |
sts_cd |
pay_div_cd |
deli_exp_date |
deli_date |
deli_company |
tracing_no |
arrive_exp_date |
cash_deli__comm_rate |
postage |
tax_rate |
|
1 |
2014/11/20 |
CU00000003 |
ST010 |
PY002 |
2014/11/20 |
2014/11/20 |
ヤマト |
xxxxxxxxxxx |
2014/11/21 |
0 |
1836 |
208501 |
|
2 |
2014/11/25 |
CU00000001 |
ST010 |
PY001 |
2014/11/25 |
2014/11/25 |
ヤマト |
xxxxxxxxxxx |
2014/11/26 |
0 |
1836 |
94520 |
|
3 |
2014/11/30 |
CU00000005 |
ST010 |
PY001 |
2014/12/1 |
2014/12/2 |
ヤマト |
xxxxxxxxxxx |
2014/12/3 |
0 |
1836 |
108562 |
|
4 |
2014/12/2 |
CU00000004 |
ST010 |
PY004 |
2014/12/2 |
2014/12/2 |
ヤマト |
xxxxxxxxxxx |
2014/12/3 |
510 |
1836 |
103310 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 注文詳細 |
order_detail_t |
|
|
|
|
|
|
|
|
|
|
|
|
受注番号 |
商品ID |
商品単価 |
個数 |
|
|
|
|
|
|
|
|
|
|
order_no |
goods_id |
goods_unit_price |
goods_num |
|
|
|
|
|
|
|
|
|
|
1 |
ITM0000002 |
12915 |
100 |
|
|
|
|
|
|
|
|
|
|
1 |
ITM0000005 |
10952 |
80 |
|
|
|
|
|
|
|
|
|
|
1 |
ITM0000003 |
24500 |
1 |
|
|
|
|
|
|
|
|
|
|
1 |
ITM0000004 |
3712 |
5 |
|
|
|
|
|
|
|
|
|
|
1 |
ITM0000001 |
79110 |
5 |
|
|
|
|
|
|
|
|
|
|
2 |
ITM0000001 |
79110 |
1 |
|
|
|
|
|
|
|
|
|
|
2 |
ITM0000002 |
12915 |
50 |
|
|
|
|
|
|
|
|
|
|
2 |
ITM0000004 |
3712 |
5 |
|
|
|
|
|
|
|
|
|
|
2 |
ITM0000005 |
10952 |
40 |
|
|
|
|
|
|
|
|
|
|
3 |
ITM0000001 |
79110 |
3 |
|
|
|
|
|
|
|
|
|
|
3 |
ITM0000003 |
24500 |
1 |
|
|
|
|
|
|
|
|
|
|
3 |
ITM0000005 |
10952 |
100 |
|
|
|
|
|
|
|
|
|
|
4 |
ITM0000001 |
79110 |
2 |
|
|
|
|
|
|
|
|
|
|
4 |
ITM0000002 |
12915 |
60 |
|
|
|
|
|
|
|
|
|
|
4 |
ITM0000004 |
3712 |
8 |
|
|
|
|
|
|
|
|
|
|
4 |
ITM0000005 |
10952 |
30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|