新增文章

文章标题分类内容

select * from btype  -- 往来单位
   select * from ptype  -- 商品信息
   select * from atype  -- 科目

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 商品信息

select
       a1.prec
      ,a1.leveal 
      ,a1.ptypeid 
      ,a1.ParId
       
      ,a2.pusercode Code1 ,a2.pname Name1
      ,a1.pusercode Code2 ,a1.pname Name2
      
      ,a3.Unit1  Unit
   
   from      ptype         a1
   left join ptype         a2  on a2.ptypeid = a1.ParId 
   left join xw_PtypeUnit  a3  on a3.PTypeId = a1.ptypeid

where a3.Unit1 != ''

select * from xw_P_PtypePrice
   select * from xw_F_VchFlow

select * from Dlyndx

select * from DlySale
   select * from DlyBuy

select * from GoodsStocks
   select * from T_GoodsStocksGlide
   select * from employee
   select * from DlyA

select * from atype

select * from T_ReportTree
   select * from T_ReportInfo
   select * from Stock
   select * from Department
   select * from city
   select * from RefIndustry
   select * from Province

select * from xw_PtypeUnit

select * from xw_P_PtypeBPrice
   select * from xw_P_PriceOrderM
   select * from xw_P_PriceType
   select * from xw_P_PriceOrderD
   select * from xw_P_PriceFollow

select * from xw_OperUpdateLog
   select * from xwc_SysMenu

select * from AreaType
   select * from BRtype
   select * from PMtype
   select * from WGtype
   select * from FCtype
   select * from GXtype
   select * from Wtype
   select * from SlType
   select * from xjtype
   select * from kwtype
   select * from pptype
   select * from LXTYPE
   select * from ZCTYPE
   select * from SXTYPE

select * from STYPE
   select * from FMTYPE
   select * from Ftype

select * from CashRunType
   select * from Cash_Atype

select * from C4Type
   select * from C3Type
   select * from C2Type
   select * from C1Type
   select * from MTYPE
   select * from ZeroType
   select * from Vchtype

select * from Pos_Dummy_Ptype
   select * from InOutVchType
   select * from VchColConfig
   select * from Xw_ColorManType
   select * from T_Billmonthnumber
   select * from MonthProc

select * from BR_ACTIONLOG
   select * from LEOHOTKEY

select * from loginuser
   select * from vchcon

select * from FixedChangeType
   select * from FixedUseOf
   select * from FixedType
   select * from AdvConfig
   select * from sys_update_flag

select * from sysdata
   select * from syscon

select * from t_gbl_FieldTypeList
   select * from t_gbl_DataTypeList
   select * from t_gbl_ActionList

select * from BillPrintSetting
   select * from HHLOCKINFO
   select * from DitDefFomat

select * from itemSale
   select * from SetTip

select * from Xw_SelfData
   select * from Xw_SelfBT

select * from xwc_functionlist
   select * from xw_UpdateLog

select * from xw_gridfieldconfig
   select * from xw_baseupdatetag

select * from Xw_colorMan
   select * from Xw_SysData
   select * from Xw_BusinessDataNdx
   select * from Xw_BusinessDataParam

select * from YearInfo

select * from WEOverCost
   select * from FcOverCost
   select * from OrderVchType
   select * from NavSetting
   select * from Pos_ColCfg
   select * from CustomBalanceKey
   select * from WxTemplateSet
   select * from SMSTemplateSet
   select * from ERPConfig
   select * from Plu_SS_SysInfo
   select * from DDMessageSet
   select * from ProfitVchType
   select * from DlyndxExte
   select * from VoucherType
   select * from FtypeLevLenModel

select * from AtypeRelateModel
   select * from AccountModel

select * from BOM_Type