浪潮账务辅助管理数据库表结构

账务辅助数据结构标准科目字典（ZWBZKM）别名列名数据类型空值缺省规则注释科目级数F_KMJSCHAR(1)N科目级数科目编号F_KMBHVchar(30)N科目编号科目名称F_KMMCVchar(60)N科目名称科目属性F_SXChar(2)N科目属性栏目否F_LMChar(1)栏目否明细否F_MXTinyintN明细否标准类别F_BZLBChar(2)标准类别标准编码F_BZBMVchar(60)标准编码Index:createuniqueindexZWBZKMonZWBZKM(F_KMBH)2.科目余额上报设置(ZWKMSB)别名列名数据类型空值缺省规则科目编号F_KMBHVARCHAR(30)N上报设置F_SBSZVarchar(9)Index:createuniqueindexZWKMSBonZWKMSB(F_KMBH)3.标准单位字典（ZWBZDW）别名列名数据类型空值缺省规则注释单位编号F_DWBHVChar(30)N单位名称F_DWMCVChar(60)内码F_DWNMVarchar(30N级数F_JSChar(1)N明细F_MXIntN所属版块F_LSSGVchar(20)业务单元F_LSBUVchar(30)上级编号F_SJBHVchar(30)Index:createuniqueindexZWBZDWonZWBZDW(F_DWBH)4.内部、关联交易科目定义（ZWHBSX）别名列名数据类型空值缺省规则注释科目编号F_KMBHChar(30)N交易名称F_JYMCChar(60)N关联交易F_GLJYChar(1)N“1”，“0”内部交易F_NBJYChar(1)N“1”，“0”数据项目F_SJXMChar(4)“JFYE”“DFYE”“JDCE”“DJCE”在什么方向时必须输入对方单位F_FXJCChar(1)N“J”、“D”、“A”缺省对方单位F_QXDWvarchar(20)Index:createuniqueindexZWHBSXonZWHBSX(F_KMBH)5.单位类别编码规则（ZWDWGZ）别名列名数据类型空值缺省规则注释性质F_XZChar(1)编码规格F_BMGZvarchar(10)‘’说明F_SMvarchar(20)“1”，“0”Index:createuniqueindexZWDWGZonZWDWGZ(F_XZ)6.科目权限表（ZWKMQX）别名列名数据类型空值缺省规则注释科目编号ZWKMQX_KMBHVarchar(30)N维护级数ZWKMQX_WHJSVarchar(1)N删除权限ZWKMQX_SCQXVarchar(1)N‘1’“0”：不限制删除；“1”：限制删除修改权限ZWKMQX_XGQXVarchar(1)N‘1’“0”：不限制修改；“1”：限制修改增加权限ZWKMQX_ZJQXVarchar(1)N‘1’“0”：不限制增加；“1”：限制增加Index:createuniqueindexZWKMQXonZWKMQX(ZWKMQX_KMBH,ZWKMQX_WHJS)7．标准属性字典(ZWBZSX)别名列名数据类型空值缺省规则注释属性编号F_SXBHVarchar(20)N属性名称F_SXMCVarchar(60)N属性级数F_JSVarchar(1)N明细否F_MXIntN标识F_BSChar(1)‘0’‘0’：系统定义‘1’：用户定义Index:createuniqueindexZWBZSXonZWBZSX(F_SXBH)8.单位属性表(ZWDWSX)别名列名数据类型空值缺省规则注释单位编号F_DWBHVarchar(30)N属性编号F_SXBHVarchar(20)NIndex:createuniqueindexZWDWSXonZWDWSX(F_DWBH,F_SXBH)9．数据上报（ZWSBJY）别名列名数据类型空值缺省规则注释单位编号F_DWBHVARCHAR(20)N会计年度F_KJNDCHAR(4)N会计期间F_KJQJCHAR(2)N科目编号F_KMBHVARCHAR(30)N对方单位F_DFDWVARCHAR(20)金额F_JEU001N返回F_FHCHAR(1)NIndex:createuniqueindexzwsbjyonZWSBJY(F_KJND,F_KJQJ,F_KMBH,F_DFDW)10.职工单据（ZWZGDJ）别名列名数据类型空值缺省规则注释内码ZWZGDJ_NMvarchar(9)N职工编号ZWZGDJ_ZGBHvarchar(20)N会计年度ZWZGDJ_KJNDchar(4)N会计区间ZWZGDJ_KJQJchar(2)N凭证日期ZWZGDJ_PZRQchar(8)N凭证编号ZWZGDJ_PZBHvarchar(8)N分录编号ZWZGDJ_FLBHchar(4)N摘要ZWZGDJ_ZYvarchar(60)N科目编号ZWZGDJ_KMBHvarchar(30)N记账方向ZWZGDJ_JZFXchar(1)外币ZWZGDJ_WBBHvarchar(10)金额ZWZGDJ_JEu001N0外币ZWZGDJ_WBu001N0汇率ZWZGDJ_HLu001N0票据编号ZWZGDJ_PJBHvarchar(20)业务日期ZWZGDJ_YWRQchar(8)责任人ZWZGDJ_ZRRvarchar(20)部门编号ZWZGDJ_BMBHvarchar(20)项目1ZWZGDJ_XM01varchar(20)项目2ZWZGDJ_XM02varchar(20)项目3ZWZGDJ_XM03varchar(20)项目4ZWZGDJ_XM04varchar(20)项目5ZWZGDJ_XM05varchar(20)业务号ZWZGDJ_YWHvarchar(20)核销金额ZWZGDJ_HXJEu001N‘0’核销外币ZWZGDJ_HXWBu001N‘0’完成否ZWZGDJ_WCFchar(1)N‘0’11.职工启用（ZWZGQY）别名列名数据类型空值缺省规则注释职工编号ZWZGQY_ZGBHvarchar(20)N科目编号ZWZGQY_KMBHvarchar(30)N币种ZWZGQY_WBBHvarchar(10)日期ZWZGQY_QYRQchar(8)12．职工核销（ZWZGHX）别名列名数据类型空值缺省规则注释核销日期ZWZGHX_HXRQvarchar(8)N职工编号ZWZGHX_ZGBHvarchar(20)N会计年度ZWZGHX_KJNDchar(4)N会计区间ZWZGHX_KJQJchar(2)N凭证日期ZWZGHX_PZRQchar(8)N凭证编号ZWZGHX_PZBHvarchar(8)N分录编号ZWZGHX_FLBHchar(4)N摘要ZWZGHX_ZYvarchar(60)N科目编号ZWZGHX_KMBHvarchar(30)N记账方向ZWZGHX_JZFXchar(1)币种ZWZGHX_WBBHvarchar(10)金额ZWZGHX_JEu001N0外币ZWZGHX_WBu001N0汇率ZWZGHX_HLu001N0票据编号ZWZGHX_PJBHvarchar(20)业务日期ZWZGHX_YWRQchar(8)责任人ZWZGHX_ZRRvarchar(20)部门编号ZWZGHX_BMBHvarchar(20)项目1ZWZGHX_XM01varchar(20)项目2ZWZGHX_XM02varcha