思迅专卖店10/数据库字典/t bd appitem info
来自Blueidea
< 思迅专卖店10
wangyue88（讨论 | 贡献）2018-07-11T16:08:07的版本 （创建页面，内容为“{|class="Tablelist" |- !width=20%|字段名!!width=20%|字段类型(长度)!!width=20%|是否为空!!功能 |- |item_no||char(20)||NO|| |- |item_subno||varchar(15)||...”）
| 字段名 | 字段类型(长度) | 是否为空 | 功能 |
|---|---|---|---|
| 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 | |
| product_area | varchar(18) | YES | |
| price | numeric(16) | YES | |
| base_price | numeric(16) | YES | |
| sale_price | numeric(16) | YES | |
| combine_sta | char(1) | NO | |
| status | char(1) | NO | |
| display_flag | char(1) | YES | |
| other1 | varchar(20) | YES | |
| other2 | varchar(256) | YES | |
| other3 | varchar(20) | YES | |
| num1 | numeric(16) | YES | |
| num2 | numeric(16) | YES | |
| num3 | numeric(16) | YES | |
| po_cycle | int(10) | YES | |
| so_cycle | int(10) | YES | |
| automin_flag | char(1) | YES | |
| en_dis | char(1) | YES | |
| direct | 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 | |
| lose_rate | numeric(6) | YES | |
| item_sup_flag | char(1) | YES | |
| item_stock | char(1) | YES | |
| item_counter | char(20) | YES | |
| sup_ly_rate | numeric(16) | YES | |
| build_date | datetime(16) | YES | |
| modify_date | datetime(16) | YES | |
| stop_date | datetime(16) | YES | |
| return_rate | numeric(16) | YES | |
| abc | char(1) | YES | |
| branch_price | char(1) | YES | |
| item_rem | varchar(10) | YES | |
| vip_price | numeric(16) | YES | |
| sale_min_price | numeric(16) | YES | |
| base_price1 | numeric(16) | YES | |
| base_price2 | numeric(16) | YES | |
| base_price3 | numeric(16) | YES | |
| branch_no | char(6) | YES | |
| cost_compute | char(1) | YES | |
| com_flag | char(1) | YES | |
| vip_acc_flag | char(1) | YES | |
| vip_acc_num | numeric(16) | YES | |
| approve_flag | char(1) | YES | |
| oper_id | char(4) | YES | |
| oper_date | datetime(4) | 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 | |
| en_gift | char(1) | YES | |
| app_branch_no | varchar(6) | YES | |
| vip_price2 | decimal(16) | YES | |
| vip_price3 | decimal(16) | YES | |
| vip_price4 | decimal(16) | YES | |
| vip_price5 | decimal(16) | YES |
