金蝶K3WISE常用数据表(整理

1、在后台数据库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_FieldDescription WHERE FDescription LIKE %批号% -字段表SEL

2、ECT * 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 -字段模板表头SELECT * FROM ICTemplateEntry -字段模板分录SELECT * FROM i

3、ICListTemplate -序时薄模板 SELECT * FROM T_UserProfile -用户方案表 -多级审核-SELECT * FROM ICClassMCTemplate -审批流模板表SELECT * FROM ICClassMCTableInfo -审批流模板明细表SELECT * FROM ICClassMCTemplateMap -单据-审核流模板映射表SELECT * FROM ICClassMCStatus -单据审核步骤表SELECT * FROM ICClassMCRecord -单据审核记录表-删除单据数据，导致审核流程无法修改，提示“单据正在审核”SELE

4、CT*FROMICClassMCTemplate WHEREFClasstypeID=DELETE FROMICClassMCTemplate WHEREFClasstypeID=DELETE FROMICClassMCTemplateMapWHEREFClasstypeID=DELETE FROMICClassMCTableInfo WHEREFTemplateID=87-基础资料设置-SELECT * FROM T_Item -核算项目基础资料,其中fitemclassid值 -表示1-客户2-部门3-职员4-商品5-仓位7-单位8-供应商SELECT * FROM T_Stock -仓库

5、 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 SubMesType -辅助资料分类表 -物料设置-SELECT * FROM T_ICItem -物料表物料属性 1- 外购； 2- 自制（特性配置） ；3- 委外加工；4- ；5- 虚拟件；6-

6、特征类 ；7- 配置类； 8- 规划类；9- 组装件；SELECT * FROM T_ICItemCore -核心表，通过FItemID与其它表相关联SELECT * FROM T_ICItemBase -基本资料表，包含了规则型号，单位等SELECT * FROM T_ICItemMaterial -物流资料表，包含了成本计价方法，核算会计科目SELECT * FROM T_ICItemPlan -计划资料表，包含了计划策略和工艺路线等SELECT * FROM T_ICItemDesign -设计资料表，包含了净重，毛重，长宽高等SELECT * FROM T_ICItemStandard

7、 -标准资料表，包含了标准成本，工时等SELECT * FROM T_ICItemQuality -质量资料表，检验资料SELECT * FROM T_Base_ICItemEntrance -进出口资料表，英文名称，HS编码等SELECT * FROM T_ICItemCustom -物料所有自定义的字段表 -供应链设置-SELECT * FROM ICStockBill -所有出入库单表头 其中:ftrantype值表示单据类型如下：1-采购入库 10-其他入库 21-销售出库 29-其他出库 41-调拨单 100-成本调整单SELECT * FROM ICStockBillEntry -

8、所有出入库单表体 表头与表体用finterid关联 SELECT * FROM ICTransactionType -出入库报表 SELECT * FROM ICInventory -实仓库存表 即时存货表 SELECT * FROM POInventory -虚仓库存表 SELECT * FROM ICBal -存货余额表SELECT * FROM ICInvBal -库房存货余额表SELECT * FROM ICInvInitial -存货初始数据表SELECT * FROM ICTransType -仓存管理 单据类型表SELECT * FROM ICSale -销售发票表头SELECT

9、 * FROM ICSaleEntry -销售发票表体 SELECT * FROM vwICBill_43 -销售发票（视图）SELECT * FROM SEOrder -销售订单表头 SELECT * FROM SEOrderEntry -销售订单表体 表头与表体用finterid关联 SELECT * FROM vwICBill_32 -销售订单（视图）SELECT * FROM PORFQ -销售报价表头 SELECT * FROM PORFQEntry -销售报价表体 SELECT * FROM vwICBill_35 -销售报价单（视图） SELECT * FROM vwICBill

10、_8 -销售出库（视图） SELECTa.*,ISNULL(b.FTable,)ASFTable,ISNULL(e.FFieldName,)asFieldNameFROMt_BillCodeRule aLEFTJOINt_Option eONa.FProjectID=e.FProjectIDANDa.FFormatIndex=e.FIDLEFTOUTERJOINt_CheckProject bONa.FBillType=b.FBillTypeIDANDa.FProjectval=b.FFieldWHEREa.FBillTypeiID = 81ORDERBYa.FClassIndexSELECT

11、FBillTypeID,FFormatChar,FProjectVal,FNumMaxFROMt_BillCodeByWHEREFBillTypeID = 81ANDFFormatChar=1412ANDFProjectVal=yymm|UPDATEt_BillCodeBy SET FNumMax=10WHEREFBillTypeID = 81ANDFFormatChar=1410ANDFProjectVal=yymm|SELECT*FROMt_Option-单据编码格式SELECT*FROMt_BillCodeByWHEREFBillTypeID = 81-销售订单每期编号详情SELECT*

12、FROMt_BillCodeRuleWHEREFbilltypeID=81-销售订单编号的编码规则SELECT*FROMt_CheckProjectSELECT * FROM ICPurBill -采购发票表头SELECT * FROM ICPurEntry -采购发票表体SELECT * FROM vwICBill_42 -采购发票（视图）SELECT * FROM POOrder -采购订单表头 SELECT * FROM POOrderEntry -采购订单表体 SELECT * FROM vwICBill_26 -采购订单（视图）SELECT * FROM POrequest -采购申

13、请单表头SELECT * FROM POrequestentry -采购申请单表体 表头与表体用finterid关联 SELECT * FROM vwICBill_25 -采购申请单（视图） SELECT * FROM vwICBill_1 -采购入库（视图） SELECT * FROM T_RP_NewReceiveBill -收款单SELECT * FROM T_RP_Contact -应收、应付往来表SELECT * FROM T_RP_NewCheckInfo -核销日志 核销业务详细记录。FRP= 1-应收 ：FRP = 0-应付SELECT * FROM T_Rp_CheckDet

14、ail -核销明细 SELECT * FROM T_RP_ContactBal - 往来余额表 FRP= 1-应收 ：FRP = 0-应付SELECT * FROM ICItemMapping -供货信息表 SELECT * FROM T_supplyentry -报价表-生产管理- SELECT * FROM ICmo -生产任务单 SELECT * FROM PPBom -生产投料单 SELECT * FROM ICSubContract -委外订单表头 SELECT * FROM ICSubContractEntry -委外订单表体 表头与表体用finterid关联 -财务会计-SELE

15、CT * 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_ItemPropDesc -核算项目附表信息描述表SELECT * FROM T_ItemDetailV -核算项目使用详情纵表SELECT * FROM T_ItemDetail -核算项目使用详情横

16、表SELECT * FROM T_RPContract WHERE FContractNO= -合同应收SELECT * FROM t_RPContractScheme WHERE FContractid=1546 -收款计划明细表 SELECT FPeriod,FYear FROM T_PeriodDate WHERE 2008-02-29=FStartDate and 2008-02-29=FEndDate -年份、帐期 SELECT * FROM T_Currency -币别 -科目挂核算项目SELECT a.FAccountID,a.FNumber FAccountNumber,a.F

17、Name 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.FDetailID = ai.FDetailID AND ai.FItemClassID = i.FItemClassID AND ai.FItemID IN(-1,-2) ORDER BY a.FAccountI

18、D, i.FNumber -BOS单据模板信息：-单据整体属性表SELECT * FROM icclasstype WHERE FName_CHS LIKE %费用报销单%-单据体属性表SELECT * FROM ICClassTypeEntry WHERE FParentID=-单据字段模板信息表SELECT * FROM ICClassTableInfo WHERE FClassTypeID= -单据转换流程模板信息：-单据转换流程整体信息表SELECT * FROM ICClassLink-转换流程中字段对应关系表SELECT * FROM ICClassLinkEntry-钩稽关系中控制字段、关闭字段、控件字段