|
||
|
| 天維論壇>>計算機數據庫 |  |
| 标題：K3WISE常用(yòng)數據表整理(lǐ) |
 樓主：shainwang1 發貼數：3 篇 精(jīng)華：0 篇 |
發表于：2024-06-19 12:29:01 SELECT FROM ICClassType WHERE FName_CHS LIKE --用(yòng)此表基本上可(kě)以查詢到所有(yǒu)的表 select * from t_SystemProfile --系統參數表 select * from t_SysFunction -- 系統功能(néng)表 select * from t_SubSystem --子系統登記表 |
-----------------------------------------------------------------------------------
| |
 |
|
用(yòng)戶名(míng)：shainwang1 |
回複于：2024-06-19 12:30:37 SELECT * FROM icclasstype where fid=1000002 --單據類型表 SELECT * FROM ICTransType --單據類型表，查詢業務(wù)單據類型FTranTypeID，經常和出入庫表配合精(jīng)确查詢 SELECT * FROM ICTransactionType --業務(wù)單據類型 INSERT INTO t_VoucherTemplateType (FName) select bbbb加單引号 --模式憑證分(fēn)類後台添加 --單據表和單據類型 Select t2.FID AS FID_O,t2.FHeadTable AS FHeadTable_O,t2.FEntryTable AS FEntryTable_O, t2.FName AS FName_O, abs(t1.FID) AS FID_N as 單據類型,t1.FTableName AS FHeadTable_N, t1.FName_CHS AS FName_N From ICClassType t1 left join ICTransactiontype t2 on abs(t1.FID)=t2.FID Where abs(t1.FID)=1000020 |
-----------------------------------------------------------------------------------
| |
|