员工
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| creditQuantity (T+12.1) | 信用额度 | decimal | 13 | True | |
| identificationType (T+12.1) | 证件类型 | int | 4 | True | |
| mobilePhoneNo (T+12.1) | 手机 | nvarchar | 20 | True | |
| priuserdefdecm1 (T+12.1) | 数值专用自定义项1 | decimal | 13 | True | |
| idMarketingOrgan (T+12.1) | 所属营销机构ID | int | 4 | True | |
| IsOperator (T+12.1) | 操作员 | tinyint | 1 | True | |
| familyPhoneNo (T+12.1) | 家庭电话 | nvarchar | 100 | True | |
| priuserdefnvc5 (T+12.1) | 字符专用自定义项5 | nvarchar | 500 | True | |
| msnAddr (T+12.1) | MSN号 | nvarchar | 30 | True | |
| code (T+12.1) | 编号 | nvarchar | 32 | True | |
| priuserdefnvc3 (T+12.1) | 字符专用自定义项3 | nvarchar | 500 | True | |
| priuserdefdecm3 (T+12.1) | 数值自定义项3 | decimal | 13 | True | |
| identityNo (T+12.1) | 证件号码 | nvarchar | 20 | True | |
| createdTime (T+12.1) | CreatedTime | datetime | 8 | True | |
| updated (T+12.1) | 更新时间 | datetime | 8 | True | |
| officePhoneNo (T+12.1) | 办公电话 | nvarchar | 100 | True | |
| priuserdefdecm2 (T+12.1) | 数值专用自定义项2 | decimal | 13 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
| disabled (T+12.1) | 停用 | tinyint | 1 | True | |
| nativePlace (T+12.1) | 籍贯 | nvarchar | 30 | True | |
| postCode (T+12.1) | 邮政编码 | nvarchar | 50 | True | |
| priuserdefnvc2 (T+12.1) | 字符专用自定义项2 | nvarchar | 500 | True | |
| emailAddr (T+12.1) | 电子邮件 | nvarchar | 100 | True | |
| uuNo (T+12.1) | UU号 | nvarchar | 30 | True | |
| IsNavigator (T+12.1) | 导购员 | tinyint | 1 | True | |
| qqcode (T+12.1) | QQ号 | nvarchar | 30 | True | |
| aPBalance_Abandon (T+13.0) | 应付余额废弃字段 | decimal | 13 | True | |
| birthday (T+12.1) | 出生日期 | datetime | 8 | True | |
| shorthand (T+12.1) | 助记码 | nvarchar | 50 | True | |
| education (T+12.1) | 学历 | int | 4 | True | |
| madeDate (T+12.1) | 制单日期 | datetime | 8 | True | |
| priuserdefnvc1 (T+12.1) | 字符专用自定义项1 | nvarchar | 500 | True | |
| priuserdefdecm5 (T+12.1) | 数值自定义项5 | decimal | 13 | True | |
| gender (T+12.1) | 性别 | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| autoCreateOperator (T+13.0) | 自动生成操作员 | bit | 1 | False | |
| priuserdefdecm4 (T+12.1) | 数值自定义项4 | decimal | 13 | True | |
| priuserdefnvc4 (T+12.1) | 字符专用自定义项4 | nvarchar | 500 | True | |
| updatedBy (T+12.1) | 更新者 | nvarchar | 32 | True | |
| name (T+12.1) | 名称 | nvarchar | 200 | True | |
| postAddr (T+12.1) | 地址 | nvarchar | 200 | True | |
| iddepartment (T+12.1) | 部门id | int | 4 | True | |
| aRBalance_Abandon (T+13.0) | 应收余额废弃字段 | decimal | 13 | True | |
| isSalesman (T+12.1) | 是否销售员 | tinyint | 1 | True | |
| VisitManage (T+13.0) | 拜访管理 | tinyint | 1 | True | |
| position (T+12.1) | Position | int | 4 | True | |
| creditDate (T+12.1) | 信用天数 | decimal | 13 | True | |
| personUserType (T+13.0) | 账号类型 | int | 4 | True | |
| idUserGroup (T+13.0) | 所属用户组 | int | 4 | True |
Copyright 2019 Chanjet Inc.