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 ----報表明細條件