mdldbconst.bas

客户管理是CRM的基础核心部分

Attribute VB_Name = "mdlDbConst"
Option Explicit
'编号 客户名称 法人代表 性质 类型 来源 电话 传真 邮件 网址
' 行业 信誉等级 开户银行 帐号 税号 重要程度 地区 国家 省份 城市 地址 邮编
' 概况 责任人 登记日期 备注 审核标志
Public Const DB_TABLE_CLIENT As String = "客户"

Public Const DB_FIELD_CLIENT_ID As String = "编号"
Public Const DB_FIELD_CLIENT_NAME As String = "客户名称"
Public Const DB_FIELD_CLIENT_CORPORATION As String = "法人代表"
Public Const DB_FIELD_CLIENT_PROPERTY As String = "性质"
Public Const DB_FIELD_CLIENT_KIND As String = "类型"
Public Const DB_FIELD_CLIENT_SOURCE As String = "来源"
Public Const DB_FIELD_CLIENT_PHONE As String = "电话"
Public Const DB_FIELD_CLIENT_FAX As String = "传真"
Public Const DB_FIELD_CLIENT_MAIL As String = "邮件"
Public Const DB_FIELD_CLIENT_URL As String = "网址"
Public Const DB_FIELD_CLIENT_INDUSTRY As String = "行业"
Public Const DB_FIELD_CLIENT_CREDIT As String = "信誉等级"
Public Const DB_FIELD_CLIENT_BANK As String = "开户银行"
Public Const DB_FIELD_CLIENT_ACCOUNT As String = "帐号"
Public Const DB_FIELD_CLIENT_TAX_NUMBER As String = "税号"
Public Const DB_FIELD_CLIENT_IMPORTANT As String = "重要程度"
Public Const DB_FIELD_CLIENT_AREA As String = "地区"
Public Const DB_FIELD_CLIENT_COUNTRY As String = "国家"
Public Const DB_FIELD_CLIENT_PROVINCE As String = "省份"
Public Const DB_FIELD_CLIENT_CITY As String = "城市"
Public Const DB_FIELD_CLIENT_ADDRESS As String = "地址"
Public Const DB_FIELD_CLIENT_POSTALCODE As String = "邮编"
Public Const DB_FIELD_CLIENT_SURVEY As String = "概况"
Public Const DB_FIELD_CLIENT_DUTY_PERSON As String = "责任人"
Public Const DB_FIELD_CLIENT_REGISTER_DATE As String = "登记日期"
Public Const DB_FIELD_CLIENT_REMARK As String = "备注"
Public Const DB_FIELD_CLIENT_AUDITING As String = "审核标志"


Public Const INT_DB_FIELD_COUNT_NUMBER As Integer = 27