思迅专卖店10/数据库字典/t bd branch info
来自Blueidea
< 思迅专卖店10
wangyue88（讨论 | 贡献）2018-07-11T16:16:57的版本 （创建页面，内容为“{|class="Tablelist" |- !width=20%|字段名!!width=20%|字段类型(长度)!!width=20%|是否为空!!功能 |- |branch_no||char(6)||NO|| |- |branch_name||varchar(30)...”）
| 字段名 | 字段类型(长度) | 是否为空 | 功能 |
|---|---|---|---|
| branch_no | char(6) | NO | |
| branch_name | varchar(30) | NO | |
| property | char(1) | YES | |
| branch_man | varchar(16) | YES | |
| address | varchar(40) | YES | |
| zip | varchar(10) | YES | |
| branch_email | varchar(40) | YES | |
| branch_tel | varchar(18) | YES | |
| branch_fax | varchar(18) | YES | |
| display_flag | char(1) | NO | |
| area | numeric(10) | YES | |
| trade_type | char(1) | YES | |
| com_grant | char(1) | YES | |
| account | char(1) | YES | |
| com_init | char(1) | YES | |
| init_date | datetime(1) | YES | |
| indep_bal | char(1) | YES | |
| dc_no | char(6) | YES | |
| com_date_up | datetime(6) | YES | |
| com_date_down | datetime(6) | YES | |
| com_oper_up | char(4) | YES | |
| com_oper_down | char(4) | YES | |
| pi_limited | numeric(18) | YES | |
| dec_rate | numeric(18) | YES | |
| price_ratio | numeric(18) | YES | |
| price_option | char(1) | YES | |
| vip_flag | char(1) | YES | |
| vip_quota | numeric(16) | YES | |
| vip_type | char(1) | YES | |
| acc_flag | char(1) | YES | |
| query_local_flag | char(1) | YES | |
| operator_flag | char(1) | YES | |
| branch_clsno | varchar(6) | YES | |
| zbtg_flag | char(1) | YES | |
| version_flag | char(1) | NO | |
| num_oper | varchar(6) | YES | |
| query_self | char(1) | YES | |
| price_reference | char(6) | YES | |
| include_spec | char(1) | YES | |
| branch_up | varchar(6) | YES |
