三、U6普及型ERP财务业务一体化数据流分析

1、用友普及及型ERP U66财务业务务一体化化数据流流分析用友软件件股份有有限公司司小型管理理软件事事业本部部U6产品支持持部曹曹守义20088年9月Evaluation Warning : The document was created with Spire.Presentation for .NET财务业务务一体化化业务流流程简介介财务业务务一体化化数据流流程分析析财务业务务一体化化主要维维护点分分析Evaluation Warning : The document was created with Spire.Presentation for .NET总账初始设设置（选项设置置）基本选项

2、项设置帐套信息息 AcccInnforrmattionn打印设置置保存到到本地当设置为为“保存存到本地地”时，将Acciinfoormaatioon、GL_mmyboookttypee、PrinntExx三个Acceess表拷贝本地地的winnntsysstemm32ufccomssql目录下的的uffoormaat.mmdb数据库中中，同时时在这三三个表后面加加上“_”和账套号号。Evaluation Warning : The document was created with Spire.Presentation for .NET总账初始设设置（套打工具具）总账套打打工具只是一个个运行程

3、程序，不涉及数数据库的的变动，它是通过过调整u6ssofttzwwreepttdlxxtdprrn.mmdb中的套打打预制数据来调调整套打打数据的的，因此在调调整后需需要重新新设置套打打。（具体操操作见帮帮助）Evaluation Warning : The document was created with Spire.Presentation for .NET总账初始设设置（期初余额额录入）850以以下版本本软件升升级到UU6后，选择科科目点击击补录、引入，将回写写GL_acccvouuch、GL_acccasss表期初余额额录入Evaluation Warning : The docum

4、ent was created with Spire.Presentation for .NET总账初始设设置图（期初）Evaluation Warning : The document was created with Spire.Presentation for .NET总账日常业业务（凭证处处理）凭证选项项设置表表：GLL_VoouchherOOptiionEvaluation Warning : The document was created with Spire.Presentation for .NET总账日常业业务图图（凭证证处理）Evaluation Warning : Th

5、e document was created with Spire.Presentation for .NET总账日常业业务（出纳管管理）银行对帐帐单模板板主表:GL_moddelmmainn银行对帐帐单系统统预置字字段表:GL_moddelpprepplacce银行对帐帐单模板板子表11:GLL_moodellsubb1银行对帐帐单模板板子表22:GLL_moodellsubb2Evaluation Warning : The document was created with Spire.Presentation for .NET总账日常业业务图图（出纳纳管理）Evaluation War

6、ning : The document was created with Spire.Presentation for .NET总账日常业业务（期期末处理理）转账定义义：GLL-baautootraanEvaluation Warning : The document was created with Spire.Presentation for .NET总账日常业业务图图（期末末处理）Evaluation Warning : The document was created with Spire.Presentation for .NET应收应付付初初始设置置（一）基本选项项设置帐套信息息

7、AcccInnforrmattionnEvaluation Warning : The document was created with Spire.Presentation for .NET应收应付付初初始设置置（二）入账科目表Ap_InputCode控制科目设置表Ap_CtrlCodeEvaluation Warning : The document was created with Spire.Presentation for .NET应收应付付初初始设置置（三）购销科目设置表 Ap_InvCode结算方式科目表Ap_SStyleCode报警分类设置表Ap_AlarmSet账龄区间表A

8、p_BillAge 单据类型表Ap_VouchType坏帐计提参数表Ar_BadParaEvaluation Warning : The document was created with Spire.Presentation for .NET应收应付付初初始设置置（期初初余额）销售发票SaleBillVouchSaleBillVouchs应收/付单主表 Ap_Vouch收付款单主/子表Ap_CloseBillAp_CloseBills票据登记簿表Ap_VouchTypeEvaluation Warning : The document was created with Spire.Prese

9、ntation for .NET应收初始设设置图Evaluation Warning : The document was created with Spire.Presentation for .NET应付初始设设置图Evaluation Warning : The document was created with Spire.Presentation for .NET日常业务务（应收收单）销售发票SaleBillVouchSaleBillVouchs应收/付单主/子表 Ap_VouchAp_Vouchs凭证表GL_accvouchCoutno_id应收/付明细帐Ap_DetailcPZi

10、d生成凭证证对应关关系应收/付单主表 Ap_VouchcPZID审核后Evaluation Warning : The document was created with Spire.Presentation for .NET日常业务务（收款款单）凭证表GL_accvouchCoutno_id应收/付明细帐Ap_DetailcPZid生成凭证证对应关关系收付款单主/子表 Ap_CloseBillAp_CloseBills收付款单主表Ap_CloseBillcPZid审核后Evaluation Warning : The document was created with Spire.Prese

11、ntation for .NET日常业务务（票据据管理）票据登记簿主表Ap_Note票据登记簿子表Ap_Note_Sub结算后收付款单主/子表Ap_CloseBillAp_CloseBillsEvaluation Warning : The document was created with Spire.Presentation for .NET应收应付付日日常业务务（核销销）Evaluation Warning : The document was created with Spire.Presentation for .NET日常业务务图（应应收）Evaluation Warning :

12、The document was created with Spire.Presentation for .NET日常业务务图（应应付）Evaluation Warning : The document was created with Spire.Presentation for .NET基本选项项设置工资类别别管理表表：WAA_acccouunt工资初始设设置（一一）Evaluation Warning : The document was created with Spire.Presentation for .NET工资选项WA_Account计件工资标准设置WA_Prset计件工资方

13、案设置WA_PRSchemeSetWA_PRSchemeSet_Sub附加信息 WA_PsnMsg人员类别 WA_Grade人员档案 WA_Psn部门 设置WA_Dept工资项目 WA_GZItem银行名称 WA_BankName工资初始设设置（二二）Evaluation Warning : The document was created with Spire.Presentation for .NET工资初始设设置（图图）Evaluation Warning : The document was created with Spire.Presentation for .NET计件工资统计W

14、A_PRSum工资日常业业务（计计件工资资）Evaluation Warning : The document was created with Spire.Presentation for .NETWA_GZData工资变动计算WA_GZHZB工资变动汇总工资日常业业务（工工资变动动）Evaluation Warning : The document was created with Spire.Presentation for .NET所得税数据表WA_SDS选择工资资项目中设设置需要计计税的工资资项目工资日常业业务（所所得税）Evaluation Warning : The docume

15、nt was created with Spire.Presentation for .NET工资分摊WA_GZFTcPZidGL_accvouchcoutno_id关系工资日常业业务（工工资分摊摊）Evaluation Warning : The document was created with Spire.Presentation for .NET数据接口设置WA_JKItemSet数据接口文件格式WA_JKSet进行各类类别间的（人员员调动）工资人员员表：WA_ppsn工资日常业业务（数数据接口口管理）Evaluation Warning : The document was crea

16、ted with Spire.Presentation for .NET工资日常业业务图Evaluation Warning : The document was created with Spire.Presentation for .NET固定资产产初初始设置置（一）基本选项项设置帐套信息息 AcccInnforrmattionnEvaluation Warning : The document was created with Spire.Presentation for .NET部门档案Departments部门对应折旧科目fa_Departments固定资产产初初始设置置（二）Eva

17、luation Warning : The document was created with Spire.Presentation for .NET固定资产产初初始设置置（三）资产类别fa_AssetTypes使用状况fa_Status增减方式fa_Origins折旧方法fa_Depreciations卡片项目fa_Items 、fa_ItemsOfQuery卡片样式fa_Models 、fa_ItemsOfModelEvaluation Warning : The document was created with Spire.Presentation for .NET固定资产产初初始设置

18、置图Evaluation Warning : The document was created with Spire.Presentation for .NET固定资产产日日常业务务（卡片片管理）卡片增加加（原始始、新增增、减少少）数据据表:fa_CCardds:卡卡片主主表fa_CCardds_DDetaail: 卡片片子表fa_DDeprrTraansaactiionss:折折旧数据据主表fa_DDeprrTraansaactiionss_Deetaiil:折折旧数数据子表表fa_DDepttScaale: 部门门比例构构成表fa_TTotaal:汇汇总表表Evaluation Warni

19、ng : The document was created with Spire.Presentation for .NET固定资产产日日常业务务（计提提折旧）记提折旧旧后、可可按Cttrl+Altt+G对对折旧进进行修改改记提折旧旧主要数数据表：fa_DDeprrLisst：折折旧日志志fa_DDeprrTraansaactiionss:折折旧旧数据主主表fa_DDeprrTraansaactiionss_Deetaiil:折折旧数数据子表表fa_DDeprrVouucheerMaain：折折旧分分配凭证证主表fa_DDeprrVouucheers：折折旧分分配凭证证子表fa_TTotaal

20、：汇汇总表Evaluation Warning : The document was created with Spire.Presentation for .NET固定资产产日日常业务务（批量量制单）批量制单单业务：fa_ZZWVoouchherss：折旧旧分配凭凭证临时时表GL_aaccvvoucch：凭凭证证及明细细账GL_accvouchCoutid外部凭证单据号fa_ZWVouchersCoutid外部凭证单据号关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET固定资产

21、产日日常业务务图Evaluation Warning : The document was created with Spire.Presentation for .NET固定资产产数数据接口口管理fa_JJKIttemSSet: 数据据接口定定义表fa_JJKSeet:数数据据接口文文件格式式表Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理基本选项项设置帐套信息息 AcccInnforrmattionnEvaluation Warning : The document wa

22、s created with Spire.Presentation for .NET采购管理理（请购单）单据格式设置表VouchersDEF_ID采购请购单主表 PU_AppVouchIDiVTid采购请购购单PU_AAppVVoucch、PPU_AAppVVoucchs审核后采采购订单单可参照使使用采购请购单子表 PU_AppVouchsID关联关系系关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET采购订单主表PO_PomainPOIDiVTid单据格式设置表Vouchers

23、DEF_ID采购订单单PO_PommainnPO_PPodeetaiils可拷贝采采购计划划、请请购单单、采购购定单、销售定定单关联关系系采购订单子表PO_PodetailsPOID关联关系系采购管理理（订单）Evaluation Warning : The document was created with Spire.Presentation for .NET单据格式设置表VouchersDEF_ID采购到货单主表PU_ArrivalVouchIDiVTid采购到货货单PU_AArriivallVouuch、PU_ArrrivaalVoouchhs可拷贝采采购订单单，到货货单不需需审核即即

24、可被采采购入库库单参照照使用采购到货单子表 PU_ArrivalVouchsID关联关系系关联关系系采购管理理（到货单）Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（请购、订订单、到货单）图解Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（入库库单）单据格式设置表VouchersDEF_ID与库存联联用、采采购入库库单在库库存管管理系系统填写写收发记录主表

25、 RdRecordsID收发记录主表 RdRecordIDVT_id关联关系系关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（入库库单）图图解Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（采购购发票）单据格式设置表VouchersDEF_ID采购发票主表PurBillVouchPBVIDiVTid采购发票子表PurBillVouchsPBVID发

26、票填写写，可拷拷贝采购购入库单单、订单单、发票票生成关联关系系关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（采购购发票）图解Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（直运运业务）采购发票子表PurBillVouchs IDiSBsID销售发票子表SaleBillVouchsAutoIDiPBVsID 关联关系系销售直运运销售发发票审核核后，

27、采采购直运运发票才才可参照照Evaluation Warning : The document was created with Spire.Presentation for .NET直运业务务图解（有订单单）Evaluation Warning : The document was created with Spire.Presentation for .NET直运业务务图解（无订单单）Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（直运运业务）图解Evaluation W

28、arning : The document was created with Spire.Presentation for .NET采购管理理（采购购结算）采购结算单主表PurSettleVouchPSVID采购结算算可按金金额、数数量、一一起结算算或分次次结算采购结算单子表PurSettleVouchsPSVID关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（结算算）图解解Evaluation Warning : The document was created

29、with Spire.Presentation for .NET采购管理理（受托托代销结结算）图图解Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理（月末末处理）修改GLL_meend表表结帐标标志，向向库存、存货系系统传递递数据Evaluation Warning : The document was created with Spire.Presentation for .NET采购管理理图解Evaluation Warning : The document was cre

30、ated with Spire.Presentation for .NET销售管理理基本选项项设置帐套信息息 AcccInnforrmattionnEvaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（报价价单）单据格式设置表VouchersDEF_ID销售报价单主表SA_QuoMainIDiVTid销售报价单子表SA_QuoDetailsID关联关系系关联关系系销售报价价单审核核后，才才可被其其他单据据参照（不包含含直运销销售）Evaluation Warning : The d

31、ocument was created with Spire.Presentation for .NET销售管理理（样品品接单管管理）单据格式设置表VouchersDEF_ID销售样品单主表ManageSampleiVT_id销售样品单子表ManageSamples关联关系系销售样品品接单管管理，可以根据据样品接接单直接接转换成成标准BOM，加快企企业新产产品的维维护速度度和效率率。Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（订单单）单据格式设置表VouchersDEF_

32、ID销售订单主表SO_SOMainIDiVTid销售订单子表SO_SODetailsID可参照审审核后的的报价单单生成关联关系系关联关系系Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（发货货单）单据格式设置表VouchersDEF_ID发货退货单主表DispatchListDLIDiVTid发货退货单子表DispatchListsDLID关联关系系关联关系系可参照已已审核、未关闭闭的销售售订单生生成Evaluation Warning : The document was

33、created with Spire.Presentation for .NET销售管理理（先发发货后开开票）图图解一Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（先发发货后开开票）图图解二Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（先发发货后开开票）图图解三Evaluation Warning : The document was created w

34、ith Spire.Presentation for .NET销售管理理（先发发货后开开票）图图解合并并Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（销售售发票）单据格式设置表VouchersDEF_ID销售发票主表SaleBillVouchSBVIDiVTid销售发票子表SaleBillVouchsSBVID关联关系系关联关系系销售发票票可参照照已审核核尚未关关闭的销销售订单单或入库库单生成成Evaluation Warning : The document was cr

35、eated with Spire.Presentation for .NET销售管理理（先开开票后发发货）图图解一Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（先开开票后发发货）图图解二Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（先开开票后发发货）图图解三Evaluation Warning : The document was created wit

36、h Spire.Presentation for .NET销售管理理（先开开票后发发货）图图解合并并Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（直运运业务）图解Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（委托托代销发发货单）发货退货单主表DispatchListDLIDiVTid单据格式设置表VouchersDEF_ID发货退货单子表Dispatch

37、ListsDLID关联关系系关联关系系可参照委委托代销销业务类类型、已已审核尚尚未关闭闭的销售售订单生生成Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（委托托代销发发货单）图解Evaluation Warning : The document was created with Spire.Presentation for .NET单据格式设置表VouchersDEF_ID委托代销结算单主表SA_SettleVouchIDiVTid关联关系系委托代销结算单子表SA_Settl

38、eVouchsID关联关系系可参照已已审核的的委托代代销发货货单生成成销售管理理（委托托代销结结算单）Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（委托托代销结结算）图图解一Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（委托托代销结结算）图图解二Evaluation Warning : The document was created with Spir

39、e.Presentation for .NET销售管理理（委托托代销结结算）图图解合并并Evaluation Warning : The document was created with Spire.Presentation for .NET销售发票主表SaleBillVouchSBVIDiVTid销售发票子表SaleBillVouchsSBVID关联关系系单据格式设置表VouchersDEF_ID关联关系系销售调拨拨单复核核后，生生成发货货单、销销售出库库单销售管理理（销售售调拨单单）Evaluation Warning : The document was created with Sp

40、ire.Presentation for .NET销售管理理（销售售调拨单单）图解解Evaluation Warning : The document was created with Spire.Presentation for .NET单据格式设置表VouchersDEF_ID销售发票主表SaleBillVouchSBVIDiVTid销售发票子表SaleBillVouchsSBVID关联关系系关联关系系零售日报报复核后后，生成发货货单、销售出库库单销售管理理（零售售日报）Evaluation Warning : The document was created with Spire.Pre

41、sentation for .NET销售管理理（零售售日报）图解Evaluation Warning : The document was created with Spire.Presentation for .NET代垫费用用单审核核后，向向应收应应付提供供数据销售管理理（代垫垫费用单单、销售售支出单单）Evaluation Warning : The document was created with Spire.Presentation for .NET销售管理理（代垫垫、支出出单）图图解Evaluation Warning : The document was created wit

42、h Spire.Presentation for .NET库存管理理初初始设置置基本选项项设置帐套信息息 AcccInnforrmattionnEvaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（采购购入库/销售出出库单）单据格式设置表VouchersDEF_ID收发记录主表 RdRecordsID收发记录主表 RdRecordIDVT_id关联关系系关联关系系销售出库库单可在在选项中中设置：销售或或库存中中生成Evaluation Warning : The document

43、was created with Spire.Presentation for .NET库存管理理（其他他出/入入库单）关联关系系关联关系系收发记录主表 RdRecordIDVT_id收发记录主表 RdRecordsID单据格式设置表VouchersDEF_IDEvaluation Warning : The document was created with Spire.Presentation for .NET单据格式设置表VouchersDEF_ID收发记录主表 RdRecordIDVT_id收发记录主表 RdRecordsID关联关系系关联关系系库存管理理（产成成品入库库单）产成品入入

44、库单可可参照物物料需求求计划中中的生产产订单父项产产品生生成、或或直接录录入Evaluation Warning : The document was created with Spire.Presentation for .NET材料出库库单可参照物物料需求求计划中中的生产产订单子项产产品生生成、配配比出库库或直接接录入单据格式设置表VouchersDEF_ID收发记录主表 RdRecordIDVT_id关联关系系关联关系系收发记录主表 RdRecordsID库存管理理（材料料出库单单）Evaluation Warning : The document was created with Sp

45、ire.Presentation for .NET库存管理理（产成成品入库库/材料料出库）图解Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（调拨拨单）库存调拨单主表TransVouchIDVT_id关联关系系关联关系系单据格式设置表VouchersDEF_ID库存调拨单子表TransVouchsID调拨单审审核后生生成其他他出/入入库单，写入收收发记录录主子表表Evaluation Warning : The document was created with Spire.

46、Presentation for .NET库存管理理（调拨拨单）图图解Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（盘点点单）单据格式设置表VouchersDEF_ID盘点单主表CheckVouchIDVT_id关联关系系关联关系系盘点单子表CheckVouchsID盘点单审审核时，盘盈盈的存货货生成其其他入库库单，盘盘亏的存存货生成成其他出出库单。Evaluation Warning : The document was created with Spire.Presen

47、tation for .NET库存管理理（盘点点单）图图解Evaluation Warning : The document was created with Spire.Presentation for .NET单据格式设置表VouchersDEF_ID库存管理理（限额额领料单单）限额领料单主表MatchVouchIDVT_id关联关系系关联关系系限额领料单子表MatchVouchsID限额领料料单可参照物物料需求求计划中中的生产产订单生生成或直直接录入入，可根根据分单单规则生生成材料料出库单单Evaluation Warning : The document was created wit

48、h Spire.Presentation for .NET库存管理理（限额额领料单单）图解解Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（形态态转换单单）关联关系系关联关系系单据格式设置表VouchersDEF_ID形态转换单主表AssemVouchIDVT_id形态转换单子表AssemVouchsID形态转换换单审核核后修改改现存量量、生成成其他出出/入库库单Evaluation Warning : The document was created with Spire.

49、Presentation for .NET库存管理理（形态态转换单单）图解解Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（货位位调整单单）关联关系系关联关系系单据格式设置表VouchersDEF_ID货位调整单主表AdjustPVouchIDVT_id货位调整单主表AdjustPVouchsID保存后在在存货货货位记录录表（IInvPPosiitioon）追追加记录录Evaluation Warning : The document was created with Spi

50、re.Presentation for .NET库存管理理（组装装拆卸单单）关联关系系关联关系系单据格式设置表VouchersDEF_ID组装拆卸单主表AssemVouchIDVT_id组装拆卸单子表AssemVouchsID组装拆卸卸单审核核后修改改现存量量、生成成其他出出/入库库单Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（组装装拆卸单单）图解解Evaluation Warning : The document was created with Spire.Prese

51、ntation for .NET库存管理理（不合合格品记记录单）关联关系系关联关系系单据格式设置表VouchersDEF_ID报废单主表ScrapVouchIDVT_id报废单子表ScrapVouchsID不合格品品记录单单审核后生生成其他他出库单单、修改改现存量量Evaluation Warning : The document was created with Spire.Presentation for .NET库存管理理（不合合格品记记录单）图解Evaluation Warning : The document was created with Spire.Presentation f

52、or .NET库存管理理图解Evaluation Warning : The document was created with Spire.Presentation for .NET委外管理理Evaluation Warning : The document was created with Spire.Presentation for .NET委外管理理主要功功能点Evaluation Warning : The document was created with Spire.Presentation for .NET委外管理理主流程程Evaluation Warning : The do

53、cument was created with Spire.Presentation for .NET委外单据据数据流流程Evaluation Warning : The document was created with Spire.Presentation for .NET红字委外外单据Evaluation Warning : The document was created with Spire.Presentation for .NET委外产品品接口图图Evaluation Warning : The document was created with Spire.Presentati

54、on for .NET在目前数数据表名名称前加加上前缀缀“OM_”（仅对目前前表名前前缀没有有OM_的数据表表），从从而达到到委外模模块数据据表名称称的规范范统一。表名Evaluation Warning : The document was created with Spire.Presentation for .NET存货核算算初初始设置置基本选项项设置帐套信息息 AcccInnforrmattionnEvaluation Warning : The document was created with Spire.Presentation for .NET存货核算算（假退退料单）单据格式设

55、置表VouchersDEF_ID收发记录主表 RdRecordsID收发记录主表 RdRecordIDVT_id关联关系系关联关系系月末结账账时，根根据当月月已记账账的假退退料单自自动生成成假退料料的回冲冲单,假假退料不不修改现现存量。Evaluation Warning : The document was created with Spire.Presentation for .NET存货核算算（假退退料单）图解Evaluation Warning : The document was created with Spire.Presentation for .NET存货核算算（出/入库调调整单）出入库调整单子表 JustInVouchscJVCode单据格式设置表VouchersDEF_ID出入库调整单主表 JustInVouchcJVCodeVT_id关联关系系关联关系系Evaluation Warning : The docume