函数名 gf_kjkm
作用 根据行业性质，生成指定账套号的预设会计科目
参数 名称 说明 类型
r_hyxz 行业性质 string
r_zth 指定账套号 string
脚本 delete from zz_kjkmbm where zth=:r_zth; //删除账套号为r_zth的会计科目信息
choose case r_hyxz
case ' 工业企业','商品流通企业','运输业','房地产开发业','金融企业','农业企业'
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
论文范文 VALUES (:r_zth,'101','现金','1','01','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'102','银行存款','1','02','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'109','其他货币资金','1','06','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'111','短期投资','1','06','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'112','应收票据','1','06','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'113','应收账款','1','03','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'114','坏账准备','1','06','贷','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'115','预付账款','1','06','借','Y',NULL,1,'N','N',null,'N','N','N','Y','N');
INSERT INTO zz_kjkmbm (zth,km_code,km_name,kmlb_code,kmxz_code,yefx_code,mjbj_code,sjkm,kmjb,bz_fzhs,sl_fzhs,sldw,dw_fzhs,bm_fzhs,zy_fzhs,sybj_code,tybj_code)
VALUES (:r_zth,'118','应收补贴
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >>
账务处理系统账套设置与管理模块设计 第3页下载如图片无法显示或论文不完整，请联系qq752018766
