用友U8数据库表名参照表

用友U8数据库表名参照表Accessaries成套件表AccInformation帐套参数表AdjustPVouchAdjustPVouchsAp_AlarmSet单位报警分类设置表Ap_BillAge帐龄区间表Ap_Cancel核销情况表Ap_CancelNo生成自动序号Ap_CloseBill收付款结算表Ap_CtrlCode控制科目设置表Ap_Detail应收/付明细帐Ap_DigSetAP_DispSet查询显示列设置表Ap_InputCode入帐科目表Ap_InvCode存货科目设置表Ap_Lock操作互斥表Ap_MidExchAp_MyTableSet查询条件存储表Ap_Note票据登记簿Ap_Note_Sub票据登记簿结算表Ap_SstyleCode结算方式科目表Ap_Sum应收/付总帐表Ap_Vouch应付/收单主表Ap_Vouchs应付/收单主表的关联表Ap_VouchType单据类型表Ar_BadAge坏帐计提帐龄期间表Ar_BadPara坏帐计提参数表ArrivalVouch到货单、质检单主表***ArrivalVouchs到货单、质检单子表***AssemVouch组装、拆卸、形态转换单主表AssemVouchs组装、拆卸、形态转换单子表Bank本企业开户银行及帐号CA_ACR按产品产量约当分配率表CA_AllMt分配率分配方法表CA_AmoCt各项费用成本表CA_AsDIF辅助部门内部固定分配率表CA_AssCW辅助费用耗用表CA_AssMP辅助部门计划单价表CA_AWPC各项费用耗用计划表CA_Batchmx_tempCA_Batchmxhy_tmpCA_Batchmxhy_tmp1CA_bmmx_tmpCA_CBSys系统设置表CA_ClassDef产品类别定义CA_ComPD完工产品处理表CA_ComPS完工产品统计表CA_ControlCA_ControlCA_CostCD费用明细定义表CA_DaCPS完工产品产量日报表CA_DaMBW材料及外购半成品耗用日报表CA_DayTiS工时日报表CA_Depcf部门预测录入表CA_DepCs折旧费用表CA_DepDf部门属性表CA_DepFR部门预测结果表CA_DepHC部门历史成本表CA_DepPMA部门计划人工费用率表CA_DirMA直接人工费用表CA_DistrInputCA_DistrItemCA_EnMMC月末部门共用材料盘点表CA_EnMOM月末在产品原材料盘点表CA_EnMOP月末在产品盘点表CA_IDMAC记入直接材料费用的出库类别表CA_MaBSW材料及外购半成品耗用表CA_ManCt制造费用表CA_MAPC人工费用人员类别表CA_MatDf材料定义表CA_MenuDefCA_OnlIA其它费用表CA_OnpB在产品年初数表CA_OnPCE在产品每月变动约当系数表CA_OnPQu在产品约当系数表CA_OnpQuo在产品定额表CA_PlanC计划成本表CA_PPUDR工序产品领用日报表CA_PreDf工序定义表CA_ProCF产品成本预测表CA_ProNb产品批号表CA_ProPMA工序计划人工费用率表CA_ProPt工序产品属性表CA_ProPU工序产品领用表CA_Quo定额表CA_RptAdd成本报表自定义加项CA_RptFld成本报表自定义栏目表CA_RptHZBTmpCA_RptSub成本报表自定义减项CA_RptSum成本汇总表CA_RptSys成本汇总报表系统备份CA_SAmoCt服务项目费用成本表CA_SerPri服务价格表CA_SPDf结转凭证定义表CA_TimSt工时统计表CA_UserProperty操作员权限表CA_WasPR废品回收表CheckVouch盘点单主表CheckVouchs盘点单子表Code科目表ColumnSetCostJustVouch计划价/售价调整主表CostJustVouchs计划价/售价调整子表CostObj成本对象表CurrentStock现存量表Customer客户档案CustomerClass客户分类体系CW_CodePlan科目计划初始(codeplan)CW_CodePlus科目追加计划(codeplus)CW_DeptPlan部门计划初始(departmentplan)CW_DeptPlus部门追加计划(departmentplus)CW_ProfPlan利润计划初始(profitplan)CW_ProfPlus利润追加计划(profitplus)CW_ProjPlan项目计划初始(projectplan)CW_ProjPlus项目追加计划(projectplus)CW_WideDeptCode粗放部门计划控制科目(widedepartmentcode)CW_WideProjCode粗放项目计划控制科目(wideprojectcode)Dep_AuthDepartment部门档案DispatchList发货单、委托代销结算单主表DispatchLists发货单、委托代销结算单子表DistrictClass地区分类体系Dsign凭证类别表Dsigns凭证类别子表dtpropertiesDynTemplet打印版面临时表模版EnDispatch委托代销发货单主表EnDispatchs委托代销发货单子表Exch汇率表ExpenseItem销售费用项目ExpenseVouch代垫费用主表ExpenseVouchs代垫费用子表fa_AssetAttached17_附属设备fa_AssetTypes06_资产类别Ufa_Cards16_卡片fa_CardsSheets34_卡片Sheets表fa_Control30_记录互斥fa_Departments07_部门fa_Depreciations11_折旧方法fa_DeprList34_折旧日志fa_DeprTransactions19_折旧fa_DeprVoucherMain23_折旧分配凭证主表fa_DeprVouchers24_折旧分配凭证fa_DeprVouchers_pre24_折旧分配凭证_准备fa_Dictionary12_常用参照字典fa_uateMain21_评估单主表fa_uateVouchers22_评估单fa_Items12_项目fa_ItemsManual32_自定义项目fa_ItemsOfModel14_对应各样式的项目fa_ItemsOfQuery35_查询项目fa_JKItemSet数据接口设置表fa_JKSet数据接口文件格式表fa_Log33_日志fa_Models13_样式fa_Msg29_信息fa_Objects03_对象表fa_Operators02_操作员fa_Origins09_增减方式fa_QueryFilters05_查询条件fa_Querys04_查询fa_ReportTempfa_Status10_使用状况fa_Total31_汇总表fa_Vouchers20_变动单fa_WorkLoad18_工作量fa_ZWVouchers外部凭证临时表FD_AccDef帐户定义表FD_AccSet帐户设置表FD_AccSum累积类帐户总帐表FD_AccUnit开户单位定义表FD_CadAcr结息日结转利息单据表FD_CadSet结息日设置表FD_CadSets结息日设置子表FD_Class单据类别表FD_CreAcrRcp贷款利息还款单据表FD_Cred贷款表FD_Dzd对帐单FD_DzdUnit对帐单单位FD_Fetch取款表FD_Hasten催款单FD_Intra利率设置表FD_Intras利率设置子表FD_Item项目大类定义表FD_Items项目定义表FD_Itemss项目科目、项目帐户表FD_Option选项FD_Return还款表FD_Sav存款表FD_SettAcc结算表FD_UnwAcrRcp拆借利息还款单据表FD_UnwDeb内部拆借表FD_UnwRet内部拆借还款表FD_Vouch凭证借贷方科目定义表Fitem项目大类fitemgrademode项目分类定义模版fitemstructure项目结构定义fitemstrumode项目目录定义模版foreigncurrency币种表GL_accass辅助总帐GL_accsum科目总帐GL_accvouch凭证及明细帐GL_bage往来帐龄区间定义GL_bautotran自动转帐定义GL_bdigest常用摘要表GL_bfreq常用凭证GL_bmulti多栏定义GL_bmultiGroupGL_btext往来函证信息GL_CashTableGL_DigestDispGL_mccontrol科目并发控制表GL_mcodeauth科目权限表GL_mcodeused科目常用项GL_mend帐套结帐状态表GL_merror对帐出错信息GL_mitemused项目常用项GL_mpostcond最近一次记帐凭证GL_mpostcond1GL_msysname系统名称对照表GL_mvcontrol凭证并发控制表GL_mvocontrol外部凭证并发控制表GL_myaccount我的帐簿GL_mybooktype帐簿套打格式GL_myoutput输出栏目GL_ViewItemGL_VouchSyncGL_XmZcDetailGradeDef编码规则表IA_DifRateDefIA_HeadSet存货科目设置表IA_IndividualIA_InvTData存货临时表IA_MoneyPlan存货核算资金占用规划表IA_OppHeadIA_QueCondition查询条件IA_Subsidiary存货核算存货明细帐IA_Summary存货核算存货总帐IA_tblRCsetMIA_ValuationAss存货核算计价辅助数据表Inventory存货目录InventoryClass存货分类体系InvoiceItem单据项目定义InvoiceItem_单据项目定义InvoiceItem_Ap单据项目定义InvoiceItem_PRN单据项目定义InvoiceItem_sal单据项目定义Invoiceitem_salPRN单据项目定义InvoiceItema单据项目定义InvoiceItemaPRN单据项目定义InvPositionItemDef用户可选择项目表JustInVouch出入库调整单主表JustInVouchs出入库调整单子表KCHSItem单据项目定义KCHSItemPRN单据项目定义LockVouch单据锁定表MainBatch批次主文件MatchVouchMatchVouchsMaxVouch最大单号表NowReceipt现收款表OverStockVouch呆滞积压处理单主表OverStockVouchs呆滞积压处理单子表PayCondition付款条件Person职员档案Po采购定单定义PO_Podetails采购定单（明细）PO_Pomain采购定单（主表）PO_Quodetails询/报价单（明细）PO_Quomain询/报价单（主表）PO_VendorProcucts供应商产品PositionPP_IMRPdetails独立需求计划（明细）PP_IMRPmain独立需求计划（主表）PP_LockPP_MPSdetails生产计划（明细）PP_MPSmain生产计划（主表）PP_period计划周期PP_PeriodToPP_PPCDetails采购计划（明细）PP_PPCmain采购计划（主表）PP_PU采购计划-采购入库对照表PP_RelateXSPP_RMRPdetails相关需求计划（明细）PP_RMRPmain相关需求计划（主表）PriceJustify调价记录表PrintDef表格头尾项目定义PrintExProductStructure产品结构主表ProductStructures产品结构子表PS采购结算单显示定义PU_LeftSum采购余额一览表PurBillVouch采购发票主表PurBillVouchs采购发票子表PurchaseType采购类型PurSettleVouch采购结算单主表PurSettleVouchs采购结算单子表QuotedPriceVouch报价单主表QuotedPriceVouchs报价单子表Rd_Style收发类别RdRecord收发记录主表RdRecords收发记录子表RP_bankrecp银行对帐单（银行日记帐）RP_cheque支票登记簿Rpt_FldDEF报表查询项目定义Rpt_FltDEF筛选条件定义Rpt_Folder帐夹管理Rpt_GlbDEF报表查询定义RPT_GRPDEF分组定义RPT_ItmDEF报表单元选项Rpt_RelDEF关系定义SA_Account销售总帐SA_INIMainSA_INISubSA_SalePlan销售计划表SA_WrapLease包装物租借表SaleBillVouch销售发票主表SaleBillVouchs销售发票子表SalePayVouch销售支出单主表SalePayVouchs销售支出单子表SalePrice销售价目表SaleRelation销售关联表SaleRelation_BakSales_Control销售菜单表SaleType销售类型ScrapVouch报废单主表ScrapVouchs报废单子表SettleStyle结算方式ShippingChoice发运方式表SindexsSO_SODetails销售订单子表SO_SOMain销售订单主表SO_SOText销售订单合同文本SrelationsST_TotalAccount库存总帐TableNameTableRelation表间关联描述TransVouch转库单主表TransVouchs转库单子表Ua_accountUa_account_subUa_authUa_controlUa_holdauthUa_periodUa_subsysUa_userUFFA_Model_AccInfomation_InitUFFA_Model_fa_AssetAttached_InitUFFA_Model_fa_AssetTypes_InitUFFA_Model_fa_Cards_InitUFFA_Model_fa_CardsSheets_InitUFFA_Model_fa_Control_InitUFFA_Model_fa_Departments_InitUFFA_Model_fa_Depreciations_InitUFFA_Model_fa_DeprList_InitUFFA_Model_fa_DeprTransactions_InitUFFA_Model_fa_DeprVoucherMain_InitUFFA_Model_fa_DeprVouchers_InitUFFA_Model_fa_DeprVouchers_per_InitUFFA_Model_fa_Dictionary_InitUFFA_Model_fa_uateMain_InitUFFA_Model_fa_uateVouchers_InitUFFA_Model_fa_Items_InitUFFA_Model_fa_ItemsManual_InitUFFA_Model_fa_ItemsOfModel_InitUFFA_Model_fa_ItemsOfQuery_InitUFFA_Model_fa_Log_InitUFFA_Model_fa_Models_InitUFFA_Model_fa_Msg_InitUFFA_Model_fa_Objects_InitUFFA_Model_fa_Operators_InitUFFA_Model_fa_Origins_InitUFFA_Model_fa_QueryFilters_InitUFFA_Model_fa_Querys_InitUFFA_Model_fa_ReportTemp_InitUFFA_Model_fa_Status_InitUFFA_Model_fa_Total_InitUFFA_Model_fa_Vouchers_InitUFFA_Model_fa_WorkLoad_InitUFFA_Model_fa_ZWVouchers_InitUserDef自定义项定义表UserDefine自定义项数值表Vendor供应商档案VendorClass供应商分类体系Vouch