K3 Wise 词典 系统基础表和语句

1、用户登录：用户表--- t_user，用户组---t_Group，权限表--- t_UserProfile，部门表，日志表-- t_log

2、系统相关

　　A、系统设置：t_SystemProfile 界面设置： t_DataFlowSubSystem   t_DataFlowTopClass

　　B、系统基础资料：t_ItemClass

　　

　　　　

3、财务资料：会计月份--t_Balance

4、单据相关

　　A、单据类型：

　　　　SELECT FbillID, FBillName AS FBillName,FDesc,
　　　　　　( case FCanAlterBillNo when 1 then '是' else '否' end) FCanAlterBillNo,
　　　　　　( case FCheckAfterSave when 1 then '是' else '否' end) FCheckAfterSave,
　　　　　　( case FUseBillCodeRule when 1 then '是' else '否' end) FUseBillCodeRule,
　　　　　　( case FSingleApproval when 1 then '是' when 0 then '否' else '' end) FSingleApproval,
　　　　　　( case FSingleUnApproval when 1 then '是' when 0 then '否' else '' end) FSingleUnApproval,
　　　　　　( case FEditSelfBill when 1 then '是' when 0 then '否' else '' end) FEditSelfBill 
　　　　FROM ICBillNo where FBillID IN (SELECT ABS(FID) FROM ICClassType WHERE FControl&32>0) Order by FPos

　　B、单据对应数据表：select FName_CHS,FTableName,FEPrimaryKey from ICClassType where 1=1 order by FName_CHS　　

　　C、单据编号：select * from t_billcodeby --最大编号表

　　D、菜单名称和类型：select * from t_ObjectType 

　　E、显示模板 ： ICTemplate ICTransactionType 

select FBillTypeID,FFormatChar,FProjectVal,FNumMax from t_billcodeby where FBillTypeID = '71'
SELECT t1.FID,t1.FCtlIndex,t1.FTabIndex,t1.FCaption AS FCaption,t1.FCtlType,t1.FLookupCls,t1.FNeedSave,t1.FValueType,t1.FSaveValue,t1.FFieldName,t1.FLeft,t1.FTop,t1.FWidth,t1.FHeight,t1.FEnable,t1.FPrint,t1.FSelBill,t1.FMustInput,t1.FFilter,t1.FRelationID,
t1.FAction,t1.FLockA,t1.FROB,t1.FDefaultCtl,t1.FVisForBillType,t1.FVBACtlType,t1.FRelateOutTbl,t1.FSysMustInputItem,t1.FInEntryForSPrint,t1.FRMustInput,t1.FFormat,t1.FMaxValue,t1.FMinValue,t1.FDefaultValue,t1.FCtlIndex AS FNewCtlIndex,t1.FTabIndex AS FNewTabIndex,t1.FMaxValue,t1.FMinValue,t1.FAllowCopy, t1.FFontName, t1.FFontSize,t1.FLookUpType
,ISNULL(t1.FLeftForBarCode,0) AS FLeftForBarCode,ISNULL(t1.FTopForBarCode,0) AS FTopForBarCode,ISNULL(t1.FWidthForBarCode,0) AS FWidthForBarCode,ISNULL(t1.FHeightForBarCode,0) AS FHeightForBarCode
FROM ICTemplate t1 INNER JOIN ICTransactionType t2 ON t1.FID=t2.FTemplateID
WHERE t2.FID= 71
AND t1.FCtlType NOT IN ( 25)
ORDER BY t1.FCtlIndex

 

转载于:https://www.cnblogs.com/GetSetFree/p/10166982.html