思迅专卖店10/数据库字典/t bd item setup
来自Blueidea
< 思迅专卖店10
| 字段名 | 字段类型(长度) | 是否为空 | 功能 |
|---|---|---|---|
| item_no | char(20) | NO | |
| item_subno | varchar(15) | NO | |
| item_name | varchar(40) | NO | |
| item_subname | varchar(20) | YES | |
| item_clsno | char(20) | NO | |
| item_brand | char(20) | NO | |
| item_brandname | char(20) | NO | |
| unit_no | char(4) | YES | |
| item_size | varchar(20) | YES | |
| price | numeric(16) | NO | |
| base_price | numeric(16) | NO | |
| sale_price | numeric(16) | NO | |
| combine_sta | char(1) | NO | |
| status | char(1) | NO | |
| display_flag | char(1) | YES | |
| po_cycle | int(10) | YES | |
| so_cycle | int(10) | YES | |
| automin_flag | char(1) | YES | |
| en_dis | char(1) | YES | |
| change_price | char(1) | YES | |
| purchase_tax | numeric(4) | YES | |
| sale_tax | numeric(4) | YES | |
| purchase_spec | numeric(8) | YES | |
| shipment_spec | numeric(8) | YES | |
| item_supcust | char(20) | YES | |
| main_supcust | char(8) | YES | |
| item_stock | char(1) | YES | |
| build_date | datetime(1) | YES | |
| modify_date | datetime(1) | YES | |
| stop_date | datetime(1) | YES | |
| abc | char(1) | YES | |
| branch_price | char(1) | YES | |
| item_rem | varchar(10) | YES | |
| vip_price | numeric(16) | NO | |
| sale_min_price | numeric(16) | NO | |
| com_flag | char(1) | YES | |
| vip_acc_flag | char(1) | YES | |
| vip_acc_num | numeric(16) | YES | |
| dpfm_type | char(1) | YES | |
| return_rate | numeric(16) | YES | |
| update_date | char(10) | YES | |
| pro_code1 | char(6) | YES | |
| pro_code2 | char(6) | YES | |
| pro_code3 | char(6) | YES | |
| pro_code4 | char(6) | YES | |
| pro_code5 | char(6) | YES | |
| pro_code6 | char(6) | YES | |
| item_picture | image(2147483647) | YES | |
| en_gift | char(1) | YES | |
| promote_flag | char(1) | YES |
