金蝶K3WISE常用数据表(整理).doc

《金蝶K3WISE常用数据表(整理).doc》由会员分享，可在线阅读，更多相关《金蝶K3WISE常用数据表(整理).doc（6页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、如有侵权，请联系网站删除，仅供学习与交流金蝶K3WISE常用数据表(整理)【精品文档】第 6 页在后台数据库ICClassType表中，字段FID0的是新单。-系统设置-SELECT * FROM T_TableDescription WHERE FDescription LIKE %入库% -系统表SELECT * FROM T_TableDescription WHERE FTableName LIKE %ICStockBill% -系统表SELECT * FROM T_TableDescription WHERE FTableID=17 -系统表SELECT * FROM T_Field

2、Description WHERE FDescription LIKE %批号% -字段表SELECT * FROM T_FieldDescription WHERE FFieldName LIKE %FBatchNo% -字段表SELECT * FROM T_FieldDescription WHERE FTableID=17 -字段表 SELECT * FROM ICClassType WHERE FName_CHS LIKE %供货% -用此表基本上可以查询到所有的表 SELECT * FROM T_Log -日志表SELECT * FROM ICTemplate -字段模板表头SELE

3、CT * FROM ICTemplateEntry -字段模板分录SELECT * FROM iICListTemplate -序时薄模板 SELECT * FROM T_UserProfile -用户方案表 -多级审核-SELECT * FROM ICClassMCTemplate -审批流模板表SELECT * FROM ICClassMCTableInfo -审批流模板明细表SELECT * FROM ICClassMCTemplateMap -单据-审核流模板映射表SELECT * FROM ICClassMCStatus200000007 -单据审核步骤表SELECT * FROM

4、ICClassMCRecord200000007 -单据审核记录表-删除单据数据，导致审核流程无法修改，提示“单据正在审核”SELECT*FROMICClassMCTemplate WHEREFClasstypeID=200000008DELETE FROMICClassMCTemplate WHEREFClasstypeID=200000008DELETE FROMICClassMCTemplateMapWHEREFClasstypeID=200000008DELETE FROMICClassMCTableInfo WHEREFTemplateID=87-基础资料设置-SELECT * FR

5、OM T_Item -核算项目基础资料,其中fitemclassid值 -表示1-客户2-部门3-职员4-商品5-仓位7-单位8-供应商SELECT * FROM T_Stock -仓库 SELECT * FROM T_Emp -职员表 SELECT * FROM T_Department -部门 SELECT * FROM T_Organization -客户SELECT * FROM T_MeasureUnit -计量单位 SELECT * FROM T_Supplier -供应商表SELECT * FROM T_SubMessage -辅助资料表 SELECT * FROM SubMes

6、Type -辅助资料分类表 -物料设置-SELECT * FROM T_ICItem -物料表物料属性 1- 外购； 2- 自制（特性配置） ；3- 委外加工；4- ；5- 虚拟件；6-特征类 ；7- 配置类； 8- 规划类；9- 组装件；SELECT * FROM T_ICItemCore -核心表，通过FItemID与其它表相关联SELECT * FROM T_ICItemBase -基本资料表，包含了规则型号，单位等SELECT * FROM T_ICItemMaterial -物流资料表，包含了成本计价方法，核算会计科目SELECT * FROM T_ICItemPlan -计划资料表

7、，包含了计划策略和工艺路线等SELECT * FROM T_ICItemDesign -设计资料表，包含了净重，毛重，长宽高等SELECT * FROM T_ICItemStandard -标准资料表，包含了标准成本，工时等SELECT * FROM T_ICItemQuality -质量资料表，检验资料SELECT * FROM T_Base_ICItemEntrance -进出口资料表，英文名称，HS编码等SELECT * FROM T_ICItemCustom -物料所有自定义的字段表 -供应链设置-SELECT * FROM ICStockBill -所有出入库单表头 其中:ftran

8、type值表示单据类型如下：1-采购入库 10-其他入库 21-销售出库 29-其他出库 41-调拨单 100-成本调整单SELECT * FROM ICStockBillEntry -所有出入库单表体 表头与表体用finterid关联 SELECT * FROM ICTransactionType -出入库报表 SELECT * FROM ICInventory -实仓库存表 即时存货表 SELECT * FROM POInventory -虚仓库存表 SELECT * FROM ICBal -存货余额表SELECT * FROM ICInvBal -库房存货余额表SELECT * FROM

9、 ICInvInitial -存货初始数据表SELECT * FROM ICTransType -仓存管理 单据类型表SELECT * FROM ICSale -销售发票表头SELECT * FROM ICSaleEntry -销售发票表体 SELECT * FROM vwICBill_43 -销售发票（视图）SELECT * FROM SEOrder -销售订单表头 SELECT * FROM SEOrderEntry -销售订单表体 表头与表体用finterid关联 SELECT * FROM vwICBill_32 -销售订单（视图）SELECT * FROM PORFQ -销售报价表头

10、 SELECT * FROM PORFQEntry -销售报价表体 SELECT * FROM vwICBill_35 -销售报价单（视图） SELECT * FROM vwICBill_8 -销售出库（视图） SELECTa.*,ISNULL(b.FTable,)ASFTable,ISNULL(e.FFieldName,)asFieldNameFROMt_BillCodeRule aLEFTJOINt_Option eONa.FProjectID=e.FProjectIDANDa.FFormatIndex=e.FIDLEFTOUTERJOINt_CheckProject bONa.FBill

11、Type=b.FBillTypeIDANDa.FProjectval=b.FFieldWHEREa.FBillTypeiID = 81ORDERBYa.FClassIndexSELECTFBillTypeID,FFormatChar,FProjectVal,FNumMaxFROMt_BillCodeByWHEREFBillTypeID = 81ANDFFormatChar=1412ANDFProjectVal=yymm|UPDATEt_BillCodeBy SET FNumMax=10WHEREFBillTypeID = 81ANDFFormatChar=1410ANDFProjectVal=

12、yymm|SELECT*FROMt_Option-单据编码格式SELECT*FROMt_BillCodeByWHEREFBillTypeID = 81-销售订单每期编号详情SELECT*FROMt_BillCodeRuleWHEREFbilltypeID=81-销售订单编号的编码规则SELECT*FROMt_CheckProjectSELECT * FROM ICPurBill -采购发票表头SELECT * FROM ICPurEntry -采购发票表体SELECT * FROM vwICBill_42 -采购发票（视图）SELECT * FROM POOrder -采购订单表头 SELEC

13、T * FROM POOrderEntry -采购订单表体 SELECT * FROM vwICBill_26 -采购订单（视图）SELECT * FROM POrequest -采购申请单表头SELECT * FROM POrequestentry -采购申请单表体 表头与表体用finterid关联 SELECT * FROM vwICBill_25 -采购申请单（视图） SELECT * FROM vwICBill_1 -采购入库（视图） SELECT * FROM T_RP_NewReceiveBill -收款单SELECT * FROM T_RP_Contact -应收、应付往来表SE

14、LECT * FROM T_RP_NewCheckInfo -核销日志 核销业务详细记录。FRP= 1-应收 ：FRP = 0-应付SELECT * FROM T_Rp_CheckDetail -核销明细 SELECT * FROM T_RP_ContactBal - 往来余额表 FRP= 1-应收 ：FRP = 0-应付SELECT * FROM ICItemMapping -供货信息表 SELECT * FROM T_supplyentry -报价表-生产管理- SELECT * FROM ICmo -生产任务单 SELECT * FROM PPBom -生产投料单 SELECT * FR

15、OM ICSubContract -委外订单表头 SELECT * FROM ICSubContractEntry -委外订单表体 表头与表体用finterid关联 -财务会计-SELECT * FROM T_Account -科目表SELECT * FROM T_Balance -科目余额表SELECT * FROM T_Voucher -凭证表SELECT * FROM T_VoucherGroup -凭证字SELECT * FROM T_VoucherEntry -凭证分录表SELECT * FROM T_VoucherExp -凭证摘要表SELECT * FROM T_ItemProp

16、Desc -核算项目附表信息描述表SELECT * FROM T_ItemDetailV -核算项目使用详情纵表SELECT * FROM T_ItemDetail -核算项目使用详情横表SELECT * FROM T_RPContract WHERE FContractNO=2014079 -合同应收SELECT * FROM t_RPContractScheme WHERE FContractid=1546 -收款计划明细表 SELECT FPeriod,FYear FROM T_PeriodDate WHERE 2008-02-29=FStartDate and 2008-02-29=F

17、EndDate -年份、帐期 SELECT * FROM T_Currency -币别 -科目挂核算项目SELECT a.FAccountID,a.FNumber FAccountNumber,a.FName FAccountName,i.FItemClassID,i.FNumber FItemClassNumber,i.FName FItemClassName,CASE ai.FItemID WHEN -1 THEN 1 ELSE 0 END FBalChecked FROM t_Account a,t_ItemClass i,t_ItemDetailV ai WHERE a.FDetail

18、ID = ai.FDetailID AND ai.FItemClassID = i.FItemClassID AND ai.FItemID IN(-1,-2) ORDER BY a.FAccountID, i.FNumber -BOS单据模板信息：-单据整体属性表SELECT * FROM icclasstype WHERE FName_CHS LIKE %费用报销单%-单据体属性表SELECT * FROM ICClassTypeEntry WHERE FParentID=1000050-单据字段模板信息表SELECT * FROM ICClassTableInfo WHERE FClass

19、TypeID=1000050 -单据转换流程模板信息：-单据转换流程整体信息表SELECT * FROM ICClassLink-转换流程中字段对应关系表SELECT * FROM ICClassLinkEntry-钩稽关系中控制字段、关闭字段、控件字段信息表SELECT * FROM ICClassLinkCommit -单据转换流程在BOS集成开发工具里的显示与布局信息：-单据转换流程名称信息表SELECT * FROM ICClassWorkFlow-单据转换流程中单据的位置信息表SELECT * FROM ICClassWorkFlowBill-单据转换流程中两个单据之间的连线信息表S

20、ELECT * FROM ICClassWorkFlowJoin -审批流程设计时的模板信息：-审批流整体信息表SELECT * FROM ICClassMCTemplate-审批流的流程节点、转换级次及其属性的明细信息表SELECT * FROM ICClassMCTableInfo -审核记录信息表：ICClassMCRecord+单据类型ID-例如费用报销单ID为1000050，那么它的审核记录表就是ICClassMCRecord1000050SELECT * FROM ICClassMCRecord1000050-审核状态信息表：ICClassMCStatus+单据类型ID-例如费用报销单ID为1000050，那么它的审核记录表就是ICClassMCStatus1000050SELECT * FROM ICClassMCStatus1000050 一级菜单：t_subsystem二级菜单：t_dataflowsubsystem三级菜单：t_dataflowsubfunc四级菜单：t_dataflowdetailfunc