r_zth 1 string 账套号
r_km_code 2 string 会计科目编码
r_km_name 3 string 科目名称
r_kmlb_code 4 string 科目类别
r_mjbj_code 5 string 末级标记
r_kmjb 6 string 科目级别
r_kmxz_code 7 string 科目性质
r_yefx_code 8 string 余额方向
r_sl_fzhs 9 string 数量辅助核算
r_bz_fzhs 10 string 币种辅助核算
r_dw_fzhs 11 string 单位辅助核算
r_bm_fzhs 12 string 部门辅助核算
r_zy_fzhs 13 string 职员辅助核算
r_sybj_code 14 string 使用标记
r_tybj_code 15 string 停用标记
数据窗口
界面
（续）
SQL语法 SELECT"zz_kjkmbmb"."zth","zz_kjkmbmb"."km_code","zz_kjkmbmb"."km_name","zz_kjkmbmb"."kmlb_code","zz_kjkmbmb"."kmxz_code","zz_kjkmbmb"."kmjb","zz_kjkmbmb"."sjkm","zz_kjkmbmb"."yefx_code","zz_kjkmbmb"."mjbj_code","zz_kjkmbmb"."sl_fzhs","zz_kjkmbmb"."sldw","zz_kjkmbmb"."bz_fzhs","zz_kjkmbmb"."dw_fzhs","zz_kjkmbmb"."bm_fzhs","zz_kjkmbmb"."zy_fzhs","zz_kjkmbmb"."sybj_code","zz_kjkmbmb"."tybj_code"
FROM"zz_kjkmbmb"
WHERE("zz_kjkmbmb"."zth"like:r_zth)AND("zz_kjkmbmb"."km_code"like:r_km_code)AND("zz_kjkmbmb"."km_name"like:r_km_name)AND("zz_kjkmbmb"."kmlb_code"like:r_kmlb_code)AND("zz_kjkmbmb"."mjbj_code"like:r_mjbj_code)AND("zz_kjkmbmb"."kmjb"like:r_kmjb)AND("zz_kjkmbmb"."kmxz_code"like:r_kmxz_code)AND("zz_kjkmbmb"."yefx_code"like:r_yefx_code)AND("zz_kjkmbmb"."sl_fzhs"like:r_sl_fzhs)AND("zz_kjkmbmb"."bz_fzhs"like:r_bz_fzhs)AND("zz_kjkmbmb"."dw_fzhs"like:r_dw_fzhs)AND("zz_kjkmbmb"."bm_fzhs"like:r_bm_fzhs)AND("zz_kjkmbmb"."zy_fzhs"like:r_zy_fzhs)AND("zz_kjkmbmb"."sybj_code"like:r_sybj_code)AND("zz_kjkmbmb"."tybj_code"like:r_tybj_code)
列的编
辑属性 所选的下拉数据窗口 显示列 数据列
“zth”列 dw_zz_ztxxb_d ztmc zth
“yefx_code”列 dw_c_zz_yefx_d yefx_name yefx_code
“kmlb_code”列 dw_c_zz_kmlb_d kmlb_name kmlb_code
“kmxz_code”列 dw_c_zz_kmxz_d kmxz_name kmxz_code
“mjbj_code”列 dw_c_zz_mjbj_d mjbj_name mjbj_code
“sjkm”列 dw_zz_kjkmbmb_d kmxx km_code
5. 会计科目编码表用于条件查询的数据窗口dw_zz_kjkmbmb_i，如下表2-6-5所示。
表2-6-5 数据窗口dw_zz_kjkmbmb_i的说明
项 目 说 明
数据窗口名 dw_zz_kjkmbmb_i
说 明 会计科目编码表用于条件查询的数据窗口
主要功能 用于在窗口中设置对会计科目编码的查询条件
数据窗口
界面
SQL语法 SELECT"zz_kjkmbmb"."km_code" FROM"zz_kjkmbmb"
上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页
账务处理系统会计科目输入模块 第3页下载如图片无法显示或论文不完整，请联系qq752018766
