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

在后台数据库ICClassType表中，字段FID0的是老单，FID0的是新单。----------------系统设置------------------------SELECT*FROMT_TableDescriptionWHEREFDescriptionLIKE'%入库%'--系统表SELECT*FROMT_TableDescriptionWHEREFTableNameLIKE'%ICStockBill%'--系统表SELECT*FROMT_TableDescriptionWHEREFTableID=17--系统表SELECT*FROMT_FieldDescriptionWHEREFDescriptionLIKE'%批号%'--字段表SELECT*FROMT_FieldDescriptionWHEREFFieldNameLIKE'%FBatchNo%'--字段表SELECT*FROMT_FieldDescriptionWHEREFTableID=17--字段表SELECT*FROMICClassTypeWHEREFName_CHSLIKE'%供货%'--用此表基本上可以查询到所有的表SELECT*FROMT_Log--日志表SELECT*FROMICTemplate--字段模板表头SELECT*FROMICTemplateEntry--字段模板分录SELECT*FROMiICListTemplate--序时薄模板SELECT*FROMT_UserProfile--用户方案表------------------多级审核------------------------SELECT*FROMICClassMCTemplate--审批流模板表SELECT*FROMICClassMCTableInfo--审批流模板明细表SELECT*FROMICClassMCTemplateMap--单据-审核流模板映射表SELECT*FROMICClassMCStatus200000007--单据审核步骤表SELECT*FROMICClassMCRecord200000007--单据审核记录表--删除单据数据，导致审核流程无法修改，提示“单据正在审核”SELECT*FROMICClassMCTemplateWHEREFClasstypeID=200000008DELETEFROMICClassMCTemplateWHEREFClasstypeID=200000008DELETEFROMICClassMCTemplateMapWHEREFClasstypeID=200000008DELETEFROMICClassMCTableInfoWHEREFTemplateID=87-----------------基础资料设置---------------------SELECT*FROMT_Item--核算项目基础资料,其中fitemclassid值--表示1-客户2-部门3-职员4-商品5-仓位7-单位8-供应商SELECT*FROMT_Stock--仓库SELECT*FROMT_Emp--职员表SELECT*FROMT_Department--部门SELECT*FROMT_Organization--客户SELECT*FROMT_MeasureUnit--计量单位SELECT*FROMT_Supplier--供应商表SELECT*FROMT_SubMessage--辅助资料表SELECT*FROMSubMesType--辅助资料分类表-----------------物料设置--------------------------SELECT*FROMT_ICItem--物料表物料属性1-外购；2-自制（特性配置）；3-委外加工；4-；5-虚拟件；6-特征类；7-配置类；8-规划类；9-组装件；SELECT*FROMT_ICItemCore--核心表，通过FItemID与其它表相关联SELECT*FROMT_ICItemBase--基本资料表，包含了规则型号，单位等SELECT*FROMT_ICItemMaterial--物流资料表，包含了成本计价方法，核算会计科目SELECT*FROMT_ICItemPlan--计划资料表，包含了计划策略和工艺路线等SELECT*FROMT_ICItemDesign--设计资料表，包含了净重，毛重，长宽高等SELECT*FROMT_ICItemStandard--标准资料表，包含了标准成本，工时等SELECT*FROMT_ICItemQuality--质量资料表，检验资料SELECT*FROMT_Base_ICItemEntrance--进出口资料表，英文名称，HS编码等SELECT*FROMT_ICItemCustom--物料所有自定义的字段表------------------供应链设置-----------------------SELECT*FROMICStockBill--所有出入库单表头其中:ftrantype值表示单据类型如下：1-采购入库10-其他入库21-销售出库29-其他出库41-调拨单100-成本调整单SELECT*FROMICStockBillEntry--所有出入库单表体表头与表体用finterid关联SELECT*FROMICTransactionType--出入库报表SELECT*FROMICInventory--实仓库存表即时存货表SELECT*FROMPOInventory--虚仓库存表SELECT*FROMICBal--存货余额表SELECT*FROMICInvBal--库房存货余额表SELECT*FROMICInvInitial--存货初始数据表SELECT*FROMICTransType--仓存管理单据类型表SELECT*FROMICSale--销售发票表头SELECT*FROMICSaleEntry--销售发票表体SELECT*FROMvwICBill_43--销售发票（视图）SELECT*FROMSEOrder--销售订单表头SELECT*FROMSEOrderEntry--销售订单表体表头与表体用finterid关联SELECT*FROMvwICBill_32--销售订单（视图）SELECT*FROMPORFQ--销售报价表头SELECT*FROMPORFQEntry--销售报价表体SELECT*FROMvwICBill_35--销售报价单（视图）SELECT*FROMvwICBill_8--销售出库（视图）SELECTa.*,ISNULL(b.FTable,'')ASFTable,ISNULL(e.FFieldName,'')asFieldNameFROMt_BillCodeRuleaLEFTJOINt_OptioneONa.FProjectID=e.FProjectIDANDa.FFormatIndex=e.FIDLEFTOUTERJOINt_CheckProjectbONa.FBillType=b.FBillTypeIDANDa.FProjectval=b.FFieldWHEREa.FBillTypeiID='81'ORDERBYa.FClassIndexSELECTFBillTypeID,FFormatChar,FProjectVal,FNumMaxFROMt_BillCodeByWHEREFBillTypeID='81'ANDFFormatChar='1412'ANDFProjectVal='yymm|'UPDATEt_BillCodeBySETFNumMax=10WHEREFBillTypeID='81'ANDFFormatChar='1410'ANDFProjectVal='yymm|'SELECT*FROMt_Option--单据编码格式SELECT*FROMt_BillCodeByWHEREFBillTypeID='81'--销售订单每期编号详情SELECT*FROMt_BillCodeRuleWHEREFbilltypeID='81'--销售订单编号的编码规则SELECT*FROMt_CheckProjectSELECT*FROMICPurBill--采购发票表头SELECT*FROMICPurEntry--采购发票表体SELECT*FROMvwICBill_42--采购发票（视图）SELECT*FROMPOOrder--采购订单表头SELECT*FROMPOOrderEntry--采购订单表体SELECT*FROMvwICBill_26--采购订单（视图）SELECT*FROMPOrequest--采购申请单表头SELECT*FROMPOrequestentry--采购申请单表体表头与表体用finterid关联SELECT*FROMvwICBill_25--采购申请单（视图）SELECT*FROMvwICBill_1--采购入库（视图）SELECT*FROMT_RP_NewReceiveBill--收款单SELECT*FROMT_RP_Contact--应收、应付往来表SELECT*FROMT_RP_NewCheckInfo--核销日志核销业务详细记录。FRP=1-应收：FRP=0-应付SELECT*FROMT_Rp_CheckDetail--核销明细SELECT*FROMT_RP_ContactBal--往来余额表FRP=1-应收：FRP=0-应付SELECT*FROMICItemMapping--供货信息表SELECT*FROMT_supplyentry--报价表-----------------生产管理---------------------------SELECT*FROMICmo--生产任务单SELECT*FROMPPBom--生产投料单SELECT*FROMICSubContract--委外订单表头SELECT*FROMICSubContractEntry--委外订单表体表头与表体用finterid关联-----------------财务会计----------------------------SELECT*FROMT_Account--科目表SELECT*FROMT_Balance--科目余额表SELECT*FROMT_Voucher--凭证表SELECT*FROMT_VoucherGroup--凭证字SELECT*FROMT_VoucherEntry--凭证分录表SELECT*FROMT_VoucherExp--凭证摘要表SELECT*FROMT_ItemPropDesc--核算项目附表信息描述表SELECT*FROMT_ItemDetailV--核算项目使用详情纵表SELECT*FROMT_ItemDetail--核算项目使用详情横表SELECT*FROMT_RPContractWHEREFContractNO='2014079'--合同应收SELECT*FROMt_RPContractSchemeWHEREFContractid=1546--收款计划明细表SELECTFPeriod,FYearFROMT_PeriodDateWHERE'2008-02-29'=FStartDateand'2008-02-29'=FEndDate--年份、帐期SELECT*FROMT_Currency--币别--科目挂核算项目SELECTa.FAccountID,a.FNumberFAccountNumber,a.FNameFAccountName,i.FItemClassID,i.FNumberFItemClassNumber,i.FNameFItemClassName,CASEai.FItemIDWHEN-1THEN1ELSE0ENDFBalCheckedFROMt_Accounta,t_ItemClassi,t_ItemDetailVaiWHEREa.FDetailID=ai.FDetailIDANDai.FIte