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