ztai 10正常(已审核),0未审核 20：删除-- 会员状态不对；
syztai: 0 1 2 3 4
fllxing
## 业务表名
select * from dbo.base_a_balance ---会计科目余额
select * from dbo.base_a_detail ---会计科目明细
select * from dbo.base_account ---会计科目
select * from dbo.base_account_pos ---收费账户
select * from dbo.base_accountingtype ---核算类别
select * from dbo.base_accountingunit ---核算单元
select * from dbo.base_appendix ---附件表
select * from dbo.base_appendix_m ---附件表 移动端
select * from dbo.base_baseinfoauthorize ---基础资料授权表
select * from dbo.base_billtype ---单据对应类型
select * from dbo.base_c_balance ---往来单位余额
select * from dbo.base_c_deliveryaddress ---往来单位收货单位
select * from dbo.base_c_employee ---往来单位授权人员
select * from base_ce_prdouctauthorization ---往来单位人员商品授权
select * from base_certificates ---预置商品往来单位资质信息
select * from dbo.base_client ---往来单位
select * from dbo.base_department ---部门
select * from base_datapost ---传输任务列表
select * from dbo.base_dis_relation ---配送关系表
select * from dbo.base_distributioncenter ---分配中心
select * from dbo.base_e_relation ---职员关系表 属于那个运营中心
select * from dbo.base_employee ---职员资料
select * from dbo.base_group ---分组资料
select * from dbo.base_location ---货位资料
select * from base_locationcode ---存放位置与商品关系表
select * from dbo.base_m_notes ---修改记录
select * from base_oc_e_relation ---职员所属部门对应表
select * from dbo.base_ocenter ---只允许出现二级，1级为运营中心，2级为运营专区
select * from dbo.base_org_storage ---机构仓库表
select * from dbo.base_organization ---机构资料
select * from dbo.base_p_l_detail ---商品存放位置明细
select * from dbo.base_p_location ---商品存放位置
select * from dbo.base_p_pg_relation ---商品与价格组关联表
select * from dbo.base_packprice ---价格表
select * from dbo.base_pricegroup ---价格组
select * from dbo.base_product ---商品资料
select * from dbo.base_r_relation ---资料与经营范围关联
select * from dbo.base_range ---经营范围
select * from dbo.base_storage ---仓库资料
select * from dbo.base_type_p_relation ---分类与资料关联表
select * from dbo.base_typedetail ---分类资料明细表
select * from dbo.base_typeidx ---分类资料主表
select * from dbo.buy_buypricetrace ---采购价格跟踪表
select * from dbo.buy_detail ---入库类明细
select * from dbo.buy_idx ---入库类主表
select * from dbo.chain_distributionreceipt---配送收货单
select * from dbo.chain_distributionreceiptdetail --配送收货单明细
select * from dbo.chain_distributionreturn ---配送退货单
select * from dbo.chain_distributionreturndetail ---配送退货单明细
select * from dbo.cloudvip ---云会员大类
select * from dbo.coupons_couponsdetail ---代金券明细表
select * from dbo.coupons_couponsinfo ---代金券基本信息
select * from dbo.custom_billname ---单据名称
select * from dbo.custom_detailorthersfunction ---未知
select * from dbo.custom_idxreport ---未知
select * from dbo.custom_idxothersfunction ---未知
select * from dbo.custom_idxreport ---未知
select * from dbo.finance_accountdetail ---科目余额明细
select * from dbo.finance_billbinance ---财务类单据主表
select * from dbo.finance_billbinancedetail---财务类单据明细
select * from billsettlement_detail ---收付款结算明细
select * from dbo.gsp_detail ---GSP单据明细
select * from dbo.gsp_idx ---gsp单据主表
select * from dbo.gsp_reportname ---gsp单据名称
select * from dbo.maxdate ---最大日期
select * from dbo.ocenter_areaprice ---运营专区调价单
select * from dbo.ocenter_areapricedetail ---运营专区调价单明细
select * from dbo.ocenter_centerprice ---运营中心调价单
select * from dbo.ocenter_centerpricedetail---运营中心调价单明细
select * from dbo.ocenter_pricepriority ---价格优先级
select * from dbo.ocenter_shopprice ---门店调价单
select * from dbo.ocenter_shoppricedetail ---门店调价单明细
select * from dbo.promotion_amountdetail_buy ---满金额赠送促销单明细_购买商品列表
select * from dbo.promotion_amountdetail_gift ---满金额赠送促销单明细_赠品列表
select * from dbo.promotion_amountgift ---满金额赠送促销单
select * from dbo.promotion_buygift ---买商品赠送促销单
select * from dbo.promotion_buygiftdetail_buy ---购买商品赠送促销单明细_购买商品列表
select * from dbo.promotion_buygiftdetail_gift---购买商品赠送促销单明细_赠品列表
select * from dbo.promotion_membersday@ ---会员日促销单
select * from dbo.promotion_priority ---促销单优先级
select * from dbo.promotion_salesproduct ---特价促销单
select * from dbo.promotion_salesproductdetail---特价促销单明细
select * from dbo.promotion_specificday ---特定日促销单
select * from dbo.promotion_wholepromotion ---整单折扣促销单
select * from dbo.promotion_wholepromotiondetail ---整单促销单明细
select * from dbo.retail_detail ---零售明细
select * from dbo.retail_idx ---零售主表
select * from dbo.retail_onduty ---零售当班
select * from dbo.sale_salepricetrace ---售价跟踪表
select * from dbo.store_detail ---入库类明细表
select * from dbo.store_idx ---入库类主表
select * from dbo.store_productdetial ---商品流水
select * from dbo.store_storedetail ---库存明细
select * from dbo.store_storelocation ---库存货位
select * from dbo.store_storepricetrace ---调拨价格跟踪表
select * from dbo.store_storesum ---库存汇总
select * from dbo.Sys ---未知
select * from dbo.system_config ---系统设置
select * from dbo.system_config_m ---系统设置（移动端）
select * from dbo.system_e_config ---系统设置（个人）
select * from dbo.system_equipmentauthorization ---设备授权表
select * from dbo.system_errormessage ---过程报错信息
select * from dbo.system_fieldname ---列名中文解释
select * from dbo.system_functionnumber ---功能编号
select * from dbo.system_monthsettleinfo ---月结存
select * from dbo.system_notice ---系统通知
select * from dbo.system_noticedetail ---系统通知明细
select * from dbo.system_userlogin ---用户登录权限
select * from dbo.system_userlogin_m ---用户登录权限（移动端）
select * from dbo.tb_ ---框架表
select * from dbo.upload_ordinarybill ---上传普通单据
select * from dbo.upload_ordinarybilldetail ---上传普通单据明细
select * from dbo.upload_retailbill ---上传零售单
select * from dbo.upload_retailbilldetail ---上传零售单明细
select * from dbo.vip_balance ---会员科目明细
select * from dbo.vip_detail ---会员单据明细
select * from dbo.vip_idx ---会员单据主表
select * from dbo.vip_integralchange ---积分增减单
select * from dbo.vip_integralchangedetail ---积分增减单明细
select * from dbo.vip_integraldetail ---会员积分明细
select * from dbo.vip_integralexchange ---会员积分兑换单
select * from dbo.vip_prepaidchangedetail ---储值增减单明细
select * from dbo.vip_prepaiddetail ---会员储值明细
select * from dbo.vip_v_type ---会员卡类型
select * from dbo.vip_vipinfo ---会员基础信息
select * from dbo.weiyao_messagelist ---微药信息列表
select * from dbo.sys_datasn ---ID规则及最大值记录
select * from custom_detailorthersfunction ---自动报警明细
select * from custom_idxothersfunction ---自动报警主表
select * from rt_reportcfg ---报表表格配置
SELECT * FROM custom_idxreport ---报表主表
SELECT * FROM custom_detailreport ----报表明细条件
