固定资产系统数据库结构 数据字典 "表 名：FA_Gdlb " "中文名：固定资产类别表 " "说 明：保存固定资产类别 " "主 键：gsdm、lbdm " "索 引： " "序号 "中文字段名 "字段名 "类型、长度 "说明 " "1 "公司代码 "gsdm "Char(12) "PK、NOT " " " " " "NULL、DEFAULT（''） " "2 "类别代码 "lbdm "char(40) "PK、NOT NULL " "3 "类别名称 "lbmc "Char(50) "NOT NULL " "4 "预计年限 "Yjnx "Int "NULL " "5 "净残值率 "Cjl "Float "NULL、DEFAULT（0） " "6 "计量单位 "Jldw "Char(6) "NULL " "7 "计提属性 "Jtss "Char(1) "NULL " "8 "折旧方法 "Zjff "Smallint "NOT NULL " "9 "卡片样式 "Kpys "Smallint "NULL " "表 名：FA_Bmzj " "中文名：部门折旧科目设置 " "说 明：保存部门对应折旧科目 " "主 键：gsdm、bmdm " "索 引： " "序号 "中文字段名 "字段名 "类型、长度 "说明 " "1 "公司代码 "Gsdm "Char(12) "PK、NOT " " " " " "NULL、DEFAULT('') " "2 "部门代码 "Bmdm "Char(12) "PK、NOT NULL " "3 "科目代码 "Kmdm "Char(16) "NULL " "4 "科目名称 "Kmmc "Char(20) "NULL " "表 名：FA_Kpjg " "中文名：卡片结构表 " "说 明：保存卡片项目结构 " "主 键：gsdm、xmdm " "索 引： " "序号 "中文字段名 "字段名 "类型、长度 "说明 " "1 "公司代码 "Gsdm "Char(12) "PK、NOT " " " " " "NULL、DEFAULT（''）" "2 "卡片项目名称 "Name "Char(16) "NOT NULL " "3 "项目代码 "Xmdm "Int "PK、NOT NULL " "4 "字段名 "FName "Char(10) "Not NULL " "5 "数据类型 "FType "Char(1) "NOT " " " " " "NULL、DEFAULT（'C' " " " " " "） " "6 "数据长度 "FLen "Smallint "NULL、DEFAULT（0） " "7 "小数位 "FDec "Smallint "NULL、DEFAULT（0） " "8 "是否固定项（ "Gdyn "Char(1) "NOT " " "是"1"、否"0" " " "NULL、DEFAULT（0） " " "） " " " " "表 名：FA_Yslb " "中文名：卡片样式类别 " "说 明：定义卡片样式类别 " "主 键：gsdm、ysdm " "索 引： " "序 "中文字段名 "字段名 "类型、长度"说明 " "号 " " " " " "1 "公司代码 "Gsdm "Char(12) "PK、NOT " " " " " "NULL、DEFAULT('') " "2 "样式代码 "Ysdm "Smallint "PK、NOT NULL " " 3 "样式名称 "Ysmc "Char(20) "NOT NULL " "表 名：FA_Ys " "中文名：卡片样式 " "说 明：保存卡片样式的定义 " "主 键： " "索 引：Ix_FA_ys(gsdm、ysdm、xmdm) " "序号 "中文字段名 "字段名 "类型、长度"说明 " "1 "公司代码 "Gsdm "Char(12) "FK、NOT " " " " " "NULL、DEFAULT('') " "2 "样式代码 "Ysdm "Smallint "FK、NOT NULL " "3 "卡片项目代码"Xmdm "Int "FK、NOT NULL " "4 "卡片项目名称"Xmmc "Char(16) "NOT NULL " "5 "卡片项样式（"Style "Char(1) "NOT NULL、DEFAULT（'0' " " "'0'卡片，'1'" " "） " " "直线） " " " " "6 "项目左侧位置"Xleft "Int "NOT NULL " "7 "项目上部位置"Xtop "Int "NOT NULL " "8 "项目宽度 "Xwidth "Int "NOT NULL " "9 "项目高度 "Xheight"Int "NOT NULL
