金蝶K3数据库各表说明

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

系统ID表ID表名En表名Chs06t_Supplier供应商表020t_Department部门表034t_CodeTypeFP编码规则分配表表047t_VoucherTplType凭证事务表054t_StockPlace仓位表110003t_AutoTransferEntry自动转账分录表110017t_Note套打表110031t_TransInitBalance往来业务初始余额表110050t_GLFF_BudgeOuterBill预算外票据主表110064t_GlBadDebts生成坏账记录表220007t_PA_ItemClass工资基础项目类别表220020t_PA_taxpamaRef所得税税率表220034t_PAFund_CalcSchemeDetail基金计提方案明细表220047t_PATrans工资系统预留二表330017t_FABalance余额表330029t_FASchmOption选项设置表330035t_FAExpenseDetailMulAlter折旧费用分配明细多次变动表330047t_FaTmpCard卡片暂存表440013cn_yhrjz银行存款日记账550015t_RP_NewReceiveBill收款单550028t_RP_SystemProfile系统参数表550035t_rp_AdjustRate660006t_rp_bill_discount应收票据贴现660019t_RPContractDetail合同已收款明细表660033t_rp_AdjustRate770016t_Rpt_PropItem2报表类别项目表990004T_CFSet报表方案集10100006t_scIntLoan贷款利息表10100019t_scPay贷款计划表10100033t_scLoanExt贷款展期表11110009t_CsIndustry行业性质11110023t_CsRight自定义报表权限11110037CR_Currency币别11110050CR_InvestBalance股权投资余额表11110065CR_RptDataDy动态表数据明细表11110077CR_SchemaItem合并报表自定义方案项目清单20200009t_SupplyEntry供应商供货明细表21210002ICInvBackup盘点备份表21210015ZPStockBillEntry虚仓出入库单据分录表21210029vwICBill_4虚仓入库(视图)22220007ICVoucherTpl凭证模板23230007SEOutStockEntry发货通知单分录表23230027ICCreditInstantEntry信用汇总即时数据物料明细表25250001ICBOMCHILDBOM分录表25250008t_WorkType生产类型表25250022t_ICTeamTimeEntry班制明细26260006ICSerialFlow序列号流转记录表27270009cbMakeDistributeInfo制造费用分配表27270030cbWCalInfo废品可修复成本计算单27270042CBCPVTargetProfit本量利目标利润录入表27270048CBOrderCostHisData订单成本历史成本数据预测表44440003t_qy_UserRptClassEIS用户报表夹表46460009t_GR_MergeExecPlan集团合并账务计划表47470001PPBom生产投料单48480005t_MgItem核算项目关系表48480012t_MgCenter责任中心结构表48480026t_MgMultiCheckLevel多级审批定义表48480039T_Mg_Receve预算接收历史表54540012t_pm_ProjectDoc项目文档表1281280002v_Report_DimissionEmpWorkInfo离职员工工作信息1281280411T_PA_personPChs工资职员变动资料表1281280418t_PABankPayFile工资系统预留一表1281280432t_PAFund_CalcSet基金计提标准定义表00t_VoucherGroup凭证字表01t_VoucherEntry凭证分录表02t_Voucher凭证表03t_User系统用户信息表04t_UnitGroup单位类别表05t_SystemProfile系统参数表1281280445t_PaZeroSet工资扣零设置表1281280459HM_EM_Files员工档案1291290314HM_EM_Code_SpecialityCategory专业类别表1291290327HM_EM_Health_Code健康状况代码1291290334HM_EM_Sex_Code性别代码1291290348Wf_biz_DemissionType辞职类别表1311310163APD_Objective_RoleSchema目标考核角色方案表1341340168Wf_biz_FireInfo辞退信息表1391390008ICItemReplaceEntry物料替代清单分录1431430000View_ICMORpt_J11任务单汇报视图1431430007PPBOM生产投料单1441440006PPBOM生产投料单1451450005SHProcRptMain工序汇报1461460004ICDeviceAccReason设备事故登记表分录1461460017ICDeviceMaintainPlan设备保养计划1461460030ICDeviceRepairRecord设备维修记录1461460043ICDeviceInspectData设备点检规程1461460056View_ICDeviceInspectPlan设备点检计划视图2002000130ORG_CompanyAttch公司信息附表2012010219REC_App_Skills应聘人技能信息表2012010232REC_InterviewOpinion_UserDept用人部门意见2012010245REC_ReqRecruitNotice招聘征集通知表2022020285REC_Code_AttchInfoTopic附加信息主题代码表2022020298REC_Code_HealthStatus健康状况代码表2022020311REC_Code_PoliticsStatus政治面貌代码表2022020320REC_Code_Sex性别代码表2022020334REC_Code_YearSalary年薪代码表2032030292HR_TR_ClassChannel培训课程渠道关系表2032030299HR_TR_ExamPaper考试试卷表2032030305HR_TR_PaperItem试卷题目表2032030291HR_TR_BookCategory图书类别表2032030312HR_TR_Suggestion培训建议表2032030313HR_TR_TrainActivity培训活动表2032030314HR_TR_TrainActivityClass培训活动课程表2032030315HR_TR_TrainApplication个人培训申请2032030316HR_TR_TrainApprival综合评价表2022020335REC_HRInitCmt录用意见代码表2022020336REC_TRM_Conclusion阶段记录结论表2022020337REC_TRM_PhaseType阶段状态表2032030282HR_TR_ActivityExam培训考试表2032030283HR_TR_ActivityExamStyle培训活动考核方式表2032030284HR_TR_ActivityMsg培训活动信息发布表2032030320HR_TR_TrainMaterial培训资料表620162010002QMICMOCKRequest产品、委外加工检验申请单620162010003QMICMOCKRequestEntry产品、委外加工检验申请单分录620162010004POInStock采购检验申请单620162010005POInStockEntry采购检验申请单分录2032030322HR_TR_TrainNotice培训征集通知表620162010006QMSaleCkRequest发货、退货检验申请单620162010007QMSaleCkRequestEntry发货、退货检验申请单分录620162010008QMINQCReq库存检验申请单620162010009QMINQCReqEntry库存检验申请单分录2032030323HR_TR_TrainPlan培训规划表2032030324HR_TR_TrainPlanClass培训规划课程表2032030325HR_TR_TrainRequirement部门培训申请2032030326HR_TR_TrainTeacher培训讲师表2042040142HR_TR_ChannelType培训渠道类型表2042040143HR_TR_Code_ApproveStatus培训审批状态代码表2042040144HR_TR_Code_ClassType课程性质2042040145HR_TR_Code_ExamStyle培训活动考核方式代码表2042040146HR_TR_Code_ExecuteStatus培训课程实施状态代码表2042040147HR_TR_Code_ScoreGrade考试成绩等级代码表2042040148HR_TR_Code_TrainNoteStatus培训记录状态代码表2042040149HR_TR_Code_TrainQuestionnaireType培训问卷类型代码表2042040150HR_TR_Code_TrainStyle培训活动培训方式代码表2042040151HR_TR_Code_TrainType培训类别2052050117HR_CMP_Competency素质指标表2052050118HR_CMP_CompetencyCategory素质指标类型表2052050119HR_CMP_CompetencyRule素质指标符合程度规则表2052050120HR_CMP_CompetencyStandard素质指标级别表2002000131ORG_Department部门信息表2002000132ORG_DepartmentAttch部门信息附表2002000133ORG_Unit组织单元信息表2012010210HR_Photo应聘人照片表2012010211REC_App_AttchInfo应聘人附加信息表2012010212REC_App_BaseInfoAttch应聘人基本信息附表2052050121HR_CMP_PositionCompetency职位素质指标表2062060110HR_CMP_CompetencyLevel素质指标级别代码表2062060111HR_CMP_Match素质指标符合程度代码表2062060112HR_CMP_PositionCompetencyImport职位核心素质重要性代码表620162010000ICQCScheme质检方案620162010001ICQCSchemeEntry质检方案分录2012010220REC_App_Training应聘人培训经历表2012010221REC_App_WorkCourse应聘人工作经验表2012010222REC_BaseInfo应聘人员基本信息表2012010223REC_HRPlan人力规划表2012010224REC_HRPlanPosition人力规划职位表2012010225REC_InterView应聘人面试表2012010233REC_InterViewP

1 / 173
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功