金蝶K3WISE常用數(shù)據(jù)表(整理

1、在后臺數(shù)據(jù)庫ICClassType表中，字段FID0的是新單。-系統(tǒng)設(shè)置-SELECT * FROM T_TableDescription WHERE FDescription LIKE %入庫% -系統(tǒng)表SELECT * FROM T_TableDescription WHERE FTableName LIKE %ICStockBill% -系統(tǒng)表SELECT * FROM T_TableDescription WHERE FTableID=17 -系統(tǒng)表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 -審批流模板明細(xì)表SELECT * FROM ICClassMCTemplateMap -單據(jù)-審核流模板映射表SELECT * FROM ICClassMCStatus -單據(jù)審核步驟表SELECT * FROM ICClassMCRecord -單據(jù)審核記錄表-刪除單據(jù)數(shù)據(jù)，導(dǎo)致審核流程無法修改，提示“單據(jù)正在審核”SELE

4、CT*FROMICClassMCTemplate WHEREFClasstypeID=DELETE FROMICClassMCTemplate WHEREFClasstypeID=DELETE FROMICClassMCTemplateMapWHEREFClasstypeID=DELETE FROMICClassMCTableInfo WHEREFTemplateID=87-基礎(chǔ)資料設(shè)置-SELECT * FROM T_Item -核算項(xiàng)目基礎(chǔ)資料,其中fitemclassid值 -表示1-客戶2-部門3-職員4-商品5-倉位7-單位8-供應(yīng)商SELECT * FROM T_Stock -倉庫

5、 SELECT * FROM T_Emp -職員表 SELECT * FROM T_Department -部門 SELECT * FROM T_Organization -客戶SELECT * FROM T_MeasureUnit -計(jì)量單位 SELECT * FROM T_Supplier -供應(yīng)商表SELECT * FROM T_SubMessage -輔助資料表 SELECT * FROM SubMesType -輔助資料分類表 -物料設(shè)置-SELECT * FROM T_ICItem -物料表物料屬性 1- 外購； 2- 自制（特性配置） ；3- 委外加工；4- ；5- 虛擬件；6-

6、特征類 ；7- 配置類； 8- 規(guī)劃類；9- 組裝件；SELECT * FROM T_ICItemCore -核心表，通過FItemID與其它表相關(guān)聯(lián)SELECT * FROM T_ICItemBase -基本資料表，包含了規(guī)則型號，單位等SELECT * FROM T_ICItemMaterial -物流資料表，包含了成本計(jì)價(jià)方法，核算會計(jì)科目SELECT * FROM T_ICItemPlan -計(jì)劃資料表，包含了計(jì)劃策略和工藝路線等SELECT * FROM T_ICItemDesign -設(shè)計(jì)資料表，包含了凈重，毛重，長寬高等SELECT * FROM T_ICItemStandard

7、 -標(biāo)準(zhǔn)資料表，包含了標(biāo)準(zhǔn)成本，工時等SELECT * FROM T_ICItemQuality -質(zhì)量資料表，檢驗(yàn)資料SELECT * FROM T_Base_ICItemEntrance -進(jìn)出口資料表，英文名稱，HS編碼等SELECT * FROM T_ICItemCustom -物料所有自定義的字段表 -供應(yīng)鏈設(shè)置-SELECT * FROM ICStockBill -所有出入庫單表頭 其中:ftrantype值表示單據(jù)類型如下：1-采購入庫 10-其他入庫 21-銷售出庫 29-其他出庫 41-調(diào)撥單 100-成本調(diào)整單SELECT * FROM ICStockBillEntry -

8、所有出入庫單表體 表頭與表體用finterid關(guān)聯(lián) SELECT * FROM ICTransactionType -出入庫報(bào)表 SELECT * FROM ICInventory -實(shí)倉庫存表 即時存貨表 SELECT * FROM POInventory -虛倉庫存表 SELECT * FROM ICBal -存貨余額表SELECT * FROM ICInvBal -庫房存貨余額表SELECT * FROM ICInvInitial -存貨初始數(shù)據(jù)表SELECT * FROM ICTransType -倉存管理 單據(jù)類型表SELECT * FROM ICSale -銷售發(fā)票表頭SELECT

9、 * FROM ICSaleEntry -銷售發(fā)票表體 SELECT * FROM vwICBill_43 -銷售發(fā)票（視圖）SELECT * FROM SEOrder -銷售訂單表頭 SELECT * FROM SEOrderEntry -銷售訂單表體 表頭與表體用finterid關(guān)聯(lián) SELECT * FROM vwICBill_32 -銷售訂單（視圖）SELECT * FROM PORFQ -銷售報(bào)價(jià)表頭 SELECT * FROM PORFQEntry -銷售報(bào)價(jià)表體 SELECT * FROM vwICBill_35 -銷售報(bào)價(jià)單（視圖） 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-單據(jù)編碼格式SELECT*FROMt_BillCodeByWHEREFBillTypeID = 81-銷售訂單每期編號詳情SELECT*

12、FROMt_BillCodeRuleWHEREFbilltypeID=81-銷售訂單編號的編碼規(guī)則SELECT*FROMt_CheckProjectSELECT * FROM ICPurBill -采購發(fā)票表頭SELECT * FROM ICPurEntry -采購發(fā)票表體SELECT * FROM vwICBill_42 -采購發(fā)票（視圖）SELECT * FROM POOrder -采購訂單表頭 SELECT * FROM POOrderEntry -采購訂單表體 SELECT * FROM vwICBill_26 -采購訂單（視圖）SELECT * FROM POrequest -采購申

13、請單表頭SELECT * FROM POrequestentry -采購申請單表體 表頭與表體用finterid關(guān)聯(lián) SELECT * FROM vwICBill_25 -采購申請單（視圖） SELECT * FROM vwICBill_1 -采購入庫（視圖） SELECT * FROM T_RP_NewReceiveBill -收款單SELECT * FROM T_RP_Contact -應(yīng)收、應(yīng)付往來表SELECT * FROM T_RP_NewCheckInfo -核銷日志 核銷業(yè)務(wù)詳細(xì)記錄。FRP= 1-應(yīng)收 ：FRP = 0-應(yīng)付SELECT * FROM T_Rp_CheckDet

14、ail -核銷明細(xì) SELECT * FROM T_RP_ContactBal - 往來余額表 FRP= 1-應(yīng)收 ：FRP = 0-應(yīng)付SELECT * FROM ICItemMapping -供貨信息表 SELECT * FROM T_supplyentry -報(bào)價(jià)表-生產(chǎn)管理- SELECT * FROM ICmo -生產(chǎn)任務(wù)單 SELECT * FROM PPBom -生產(chǎn)投料單 SELECT * FROM ICSubContract -委外訂單表頭 SELECT * FROM ICSubContractEntry -委外訂單表體 表頭與表體用finterid關(guān)聯(lián) -財(cái)務(wù)會計(jì)-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 -核算項(xiàng)目附表信息描述表SELECT * FROM T_ItemDetailV -核算項(xiàng)目使用詳情縱表SELECT * FROM T_ItemDetail -核算項(xiàng)目使用詳情橫

16、表SELECT * FROM T_RPContract WHERE FContractNO= -合同應(yīng)收SELECT * FROM t_RPContractScheme WHERE FContractid=1546 -收款計(jì)劃明細(xì)表 SELECT FPeriod,FYear FROM T_PeriodDate WHERE 2008-02-29=FStartDate and 2008-02-29=FEndDate -年份、帳期 SELECT * FROM T_Currency -幣別 -科目掛核算項(xiàng)目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單據(jù)模板信息：-單據(jù)整體屬性表SELECT * FROM icclasstype WHERE FName_CHS LIKE %費(fèi)用報(bào)銷單%-單據(jù)體屬性表SELECT * FROM ICClassTypeEntry WHERE FParentID=-單據(jù)字段模板信息表SELECT * FROM ICClassTableInfo WHERE FClassTypeID= -單據(jù)轉(zhuǎn)換流程模板信息：-單據(jù)轉(zhuǎn)換流程整體信息表SELECT * FROM ICClassLink-轉(zhuǎn)換流程中字段對應(yīng)關(guān)系表SELECT * FROM ICClassLinkEntry-鉤稽關(guān)系中控制字段、關(guān)閉字段、控件字段