搜索
本源码下载地址：科目属性(ZWKMSX) 别名列名数据类型空值缺省规则注释编号ZWKMSX_BHChar(2)No名称ZWKMSX_MCvarchar(20)No余额方向ZWKMSX_YEFXchar(1)No ‘0’ ‘0’,’1’,’2’ ‘0’:任意 ‘1’:借方 ‘2’:贷方首位字符ZWKMSX_SWZFCHAR(2)同类科目的开头字符(不强制) Index: unique clustered zwkmsx on(ZWKMSX_BH) 科目字典(ZWKMZD) 别名列名数据类型空值缺省规则注释科目编号ZWKMZD_KMBHvarchar(30)No科目级数ZWKMZD_JSchar(1)No科目属性ZWKMZD_SXCHAR(2)No明细否ZWKMZD_MXIntNO10,1科目名称ZWKMZD_KMMCVarchar(60)No助记码ZWKMZD_ZJMVarchar(20)核算数量ZWKMZD_HSSLChar(1)No ‘0’ ‘0’;’1’ ‘0’不核算:;’1’:核算核算外币ZWKMZD_HSWBChar(1)No0 ‘0’,’1’,’2’ ‘0’:不核算;’1’:单一外币;’2’:所有币种外币编号ZWKMZD_WBBHVarchar(10)科目性质ZWKMZD_XZChar(1)No ‘0’ ‘0’,’1’,’2’ ‘0’:普通科目;’1’:借方栏目;’2’:贷方栏目帐页格式ZWKMZD_ZYGSChar(1)No ‘0’ ‘0’,’1’,’2’, ’3’,’4’ ‘0’:不定义‘1’:金额帐‘2’:数量金额帐 ‘3’:外币金额帐 ‘4’:数量外币金额帐是否日记帐ZWKMZD_RJZChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ’0’:否是否银行帐ZWKMZD_YHZChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否余额方向ZWKMZD_YEFXChar(1)No ‘1’ ‘1’,’2’ ‘1’:借方 ‘2’:贷方现金科目ZWKMZD_XJKMChar(1)No ‘0’ ‘0’,’1’,’2’, ’3’ ‘0’:其他 ‘1’:现金 ‘2’:银行存款 ‘3’:其它现金及现金等价物个人往来ZWKMZD_GRWLChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否单位往来ZWKMZD_DWWLChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否专项核算ZWKMZD_ZXHSChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否部门核算ZWKMZD_BMHSChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否计量单位ZWKMZD_XX01Varchar(30)此三项用规格型号ZWKMZD_XX02Varchar(30)于数量帐类型ZWKMZD_XX03Varchar(30)均可重新定义现金限额ZWKMZD_XJXEU0001No0原始凭证ZWKMZD_YSPZChar(2)台帐类别ZWKMZD_TZLBChar(2)期末结平ZWKMZD_QMJPChar(1)No ‘0’ ‘0’,’1’ 定义总帐科目期末是否结平Index:1.uniqueclusteredzwkmzdon(ZWKMZD_KMBH)2.uniquezwkmzd_jsbhon(ZWKMZD_JS,ZWKMZD_KMBH)科目金额余额帐(ZWKMJE) 别名列名数据类型空值缺省规则注释科目编号ZWKMJE_KMBHVarchar(30)No会计年度ZWKMJE_KJNDChar(4)No会计期间ZWKMJE_KJQJChar(2)No年初余额ZWKMJE_NCYEU001No0借方累计ZWKMJE_JFLJU001NO0贷方累计ZWKMJE_DFLJU001No0借方发生ZWKMJE_JFFSU001No0贷方发生ZWKMJE_DFFSU001No0当前余额ZWKMJE_DQYEU001No0Index:1.uniqueclusteredzwkmjeon(ZWKMJE_KMBH,ZWKMJE_KJQJ,ZWKMJE_KJND)2.uniquezwkmje_qjbhon(ZWKMJE_KJND,ZWKMJE_KJQJ,ZWKMJE_KMBH)科目数量余额帐(ZWKMSL) 别名列名数据类型空值缺省规则注释科目编号ZWKMSL_KMBHVarchar(30)No会计年度ZWKMSL_KJNDChar(4)No会计期间ZWKMSL_KJQJChar(2)No年初余额ZWKMSL_NCYEU001No0借方累计ZWKMSL_JFLJU001NO0贷方累计ZWKMSL_DFLJU001No0借方发生ZWKMSL_JFFSU001No0贷方发生ZWKMSL_DFFSU001No0当前余额ZWKMSL_DQYEU001No0Index:1.uniqueclusteredzwkmslon(ZWKMSL_BH,ZWKMSL_KJQJ,ZWKMSL_KJND)2.uniquezwkmsl_qjbhon(ZWKMSL_KJND,ZWKMSL_KJQJ,ZWKMSL_BH)外币余额帐(ZWKMWB) 别名列名数据类型空值缺省规则注释科目编号ZWKMWB_KMBHVarchar(30)No会计期间ZWKMWB_KJQJChar(2)No会计年度ZWKMWB_KJNDChar(4)NO外币编号ZWKMWB_WBBHVARCHAR(10)No年初余额(外币)ZWKMWB_WBNCYEU001No0借方累计(外币)ZWKMWB_WBJFLJU001NO0贷方累计(外币)ZWKMWB_WBDFLJU001No0借方发生(外币)ZWKMWB_WBJFFSU001No0贷方发生(外币)ZWKMWB_WBDFFSU001No0当前余额(外币)ZWKMWB_WBDQYEU001No0年初余额(数量)ZWKMWB_SLNCYEU001No0借方累计(数量)ZWKMWB_SLJFLJU001NO0贷方累计(数量)ZWKMWB_SLDFLJU001No0借方发生(数量)ZWKMWB_SLJFFSU001No0贷方发生(数量)ZWKMWB_SLDFFSU001No0当前余额(数量)ZWKMWB_SLDQYEU001No0年初余额ZWKMWB_NCYEU001No0借方累计ZWKMWB_JFLJU001NO0贷方累计ZWKMWB_DFLJU001No0借方发生ZWKMWB_JFFSU001No0贷方发生ZWKMWB_DFFSU001No0当前余额ZWKMWB_DQYEU001No0Index:1.uniqueclusteredzwkmwbon(ZWKMWB_KMBH,ZWKMWB_WBBH,ZWKMWB_KJQJ,ZWKMWB_KJND)2.uniquezwkmwb_qjbhon(ZWKMWB_KJND,ZWKMWB_KJQJ,ZWKMWB_KMBH,ZWKMWB_WBBH)部门字典(ZWBMZD) 别名列名数据类型空值缺省规则注释部门编号ZWBMZD_BMBHvarchar(20)No部门名称ZWBMZD_BMMCVarchar(40)No级数ZWBMZD_JSChar(1)No ‘1’ 明细否ZWBMZD_MXintNo1备注ZWBMZD_NOTEVarchar(60) Index: unique clustered zwbmzd on(ZWBMZD_BMBH)职工字典(ZWZGZD) 别名列名数据类型空值缺省规则注释职工编号ZWZGZD_ZGBHVarchar(6)No职工姓名ZWZGZD_ZGXMVarchar(20)No所属部门ZWZGZD_BMBHVarchar(20)NoIndex:uniqueclusteredzwzgzdon(ZWZGZD_ZGBH)项目类别(ZWXMLB) 别名列名数据类型空值缺省规则注释类别编号ZWXMLB_LBBHChar(2)No类别名称ZWXMLB_LBMCVarchar(30)No结转累计否ZWXMLB_JZLJChar(1)No ‘0’ ‘0’,’1’ ‘1’:是; ’0’:否Index:uniqueclusteredzwxmlbon(ZWXMLB_LBBH)项目结构(ZWXMJG) 别名列名数据类型空值缺省规则注释类别编号ZWXMJG_LBBHchar(2)No项目列名ZWXMJG_XMLMChar(11)No名称ZWXMJG_XMMCVarchar(30)No精度ZWXMJG_JDIntNo0类型ZWXMJG_LXCHAR(1)No ‘C’ ‘C’,’D’,’N’ ‘C’:字符型‘D’:日期型 ‘N’:数值型Index:uniqueclusteredzwxmjgon(ZWXMJG_LBBH,ZWXMJG_XMLM)核算项目(ZWHSXM) 别名列名数据类型空值缺省规则注释项目内码ZWHSXM_XMNMChar(6)No项目编号ZWHSXM_XMBHVARchar(20)No项目名称ZWHSXM_XMMCVarchar(40)No项目类别ZWHSXM_LBBHCHAR(2)No编号级数ZWHSXM_JSChar(1)No明细否ZWHSXM_MXIntNo1完工否ZWHSXM_WGFChar(1)NO ‘0’ ‘0’,’1’ ‘1’:是; ‘0’:否完工日期ZWHSXM_WGRQCHAR(8)数值项目1ZWHSXM_SJ01U001No0数值项目2ZWHSXM_SJ02U001No0数值项目3ZWHSXM_SJ03U001No0数值项目4ZWHSXM_SJ04U001No0数值项目5ZWHSXM_SJ05U001No0字符项目01ZWHSXM_XM01Varchar(100)字符项目02ZWHSXM_XM02Varchar(100)字符项目03ZWHSXM_XM03Varchar(100)字符项目04ZWHSXM_XM04Varchar(100)字符项目05ZWHSXM_XM05Varchar(100)字符项目06ZWHSXM_XM06Varchar(100)字符项目07ZWHSXM_XM07Varchar(100)字符项目08ZWHSXM_XM08Varchar(100)字符项目09ZWHSXM_XM09Varchar(100)字符项目10ZWHSXM_XM10Varchar(100)Index:1.uniqueclusteredzwhsxmon(ZWHSXM_LBBH,ZWHSXM_XMBH)2.uniquezwhsxm_xmnmon(ZWHSXM_XMNM)科目专项(ZWKMZX) 别名列名数据类型空值缺省规则注释科目编号ZWKMZX_KMBHVARchar(30)No项目类别ZWKMZX_LBBHchar(2)No项目顺序ZWKMZX_XMSXChar(1)NoIndex:1.uniqueclusteredzwkmzxon(ZWKMZX_KMBH,ZWKMZX_LBBH)2.UNIQUEzwkmzx_lbbhon(ZWKMZX_LBBH,ZWKMZX_KMBH)辅助原始凭证(ZWFZYS) 别名列名数据类型空值缺省规则注释凭证内码ZWFZYS_PZNMVarChar(9)No分录内码ZWFZYS_FLNMVarchar(9)No科目编号ZWFZYS_KMBHVARchar(30)No部门编号ZWFZYS_BMBHVarchar(20)单位编号ZWFZYS_DWBHVARCHAR(10)职工编号ZWFZYS_ZGBHchar(6)核算项目1ZWFZYS_XM01Varchar(6)核算项目2ZWFZYS_XM02Varchar(6)核算项目3ZWFZYS_XM03Varchar(6)核算项目4ZWFZYS_XM04Varchar(6)核算项目5ZWFZYS_XM05Varchar(6)外币编号ZWFZYS_WBBHVarchar(10)记帐方向ZWFZYS_JZFXChar(1)No ‘1’,’2’ ‘1’