《2014用友数据库透视表.docVIP

新建用友数据库 透视表 建立流程图 步骤一： 完成数据库 表 he_code导入 SQL企业管理器——FIN_SEVER——数据库（选择用友账套）——表（单击左键 如图1）——所有任务——导入数据—— *重点* 选择表he_code进行导入目标账套（从023-2011至024-2011账套 如图2）——完成。 图1 图2 建立数据库 视图（5个表） 选择数据库（024_2011）视图——右击新建视图（接以下顺序新建视图如表1）——完成。 明细如下： 1.he_customer_district ============================================ SELECT dbo.GL_accvouch.dbill_date AS 制单日期, dbo.GL_accvouch.csign AS 凭证类别, dbo.GL_accvouch.ino_id AS 凭证号码, dbo.GL_accvouch.cdigest AS 摘要, dbo.GL_accvouch.mc AS 贷方, dbo.GL_accvouch.md AS 借方, dbo.Customer.cCusAbbName AS 客户名称, dbo.Department.cDepName AS 部门名称, dbo.code.ccode_name AS 科目名称, dbo.DistrictClass.cDCName AS 地区, dbo.CustomerClass.cCCName AS 所属系统, LEFT(dbo.Customer.cDCCode, 2) AS 地区代码, LEFT(dbo.GL_accvouch.ccode, 4) AS 科目代码, dbo.GL_accvouch.iperiod AS 期间 FROM dbo.GL_accvouch INNER JOIN dbo.Customer ON dbo.GL_accvouch.ccus_id = dbo.Customer.cCusCode INNER JOIN dbo.CustomerClass ON dbo.Customer.cCCCode = dbo.CustomerClass.cCCCode INNER JOIN dbo.DistrictClass ON dbo.Customer.cDCCode = dbo.DistrictClass.cDCCode INNER JOIN dbo.Department ON dbo.GL_accvouch.cdept_id = dbo.Department.cDepCode INNER JOIN dbo.code ON dbo.GL_accvouch.ccode = dbo.code.ccode WHERE (dbo.GL_accvouch.iflag IS NULL) 2.he_customer_districtnew ============================================ SELECT dbo.he_customer_district.*, dbo.code.ccode_name AS 总帐科目, dbo.DistrictClass.cDCName AS 区域 FROM dbo.he_customer_district INNER JOIN dbo.DistrictClass ON dbo.he_customer_district.地区代码 = dbo.DistrictClass.cDCCode INNER JOIN dbo.code ON dbo.he_customer_district.科目代码 = dbo.code.ccode 3.he_customer ============================================ SELECT 部门名称, 所属系统, 客户名称, 总帐科目, 科目名称, 借方 - 贷方 AS [发生额(借减贷)], 期间, 区域 FROM dbo.he_customer_districtnew 4.he_gl_accvouch ============================================ SELECT dbo.GL_accvouch.dbill_date AS 制单日期, dbo.GL_accvouch.c