CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE GC_ORG_INFO(ORG_CODE VARCHAR(200) NOT NULL PRIMARY KEY,ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200),TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(50))
CREATE MEMORY TABLE GC_GLOBAL_INFO(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),SON_COUNT INTEGER,PN_SBJ INTEGER,PNS_SBJ INTEGER,PN_TJJ INTEGER,PNS_TJJ INTEGER,PN_CJ INTEGER,PNS_CJ INTEGER,PN_KJX INTEGER,PNS_KJX INTEGER,PN_GQRY INTEGER,PNS_GQRY INTEGER,PN_SUM INTEGER,PNS_SUM INTEGER,CN_SBJ INTEGER,CNS_SBJ INTEGER,CN_YBGW INTEGER,CNS_YBGW INTEGER,CN_ZFZQ INTEGER,CNS_ZFZQ INTEGER,CN_QT INTEGER,CNS_QT INTEGER,CN_SUM INTEGER,CNS_SUM INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_LTX_INFO(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),MNG_ORG_NAME VARCHAR(200),MNG_ORG_TYPE CHAR(1),PN_SBJ INTEGER,PNS_SBJ INTEGER,PN_TJJ INTEGER,PNS_TJJ INTEGER,PN_CJ INTEGER,PNS_CJ INTEGER,PN_SUM INTEGER,PNS_SUM INTEGER,XJ_SBJ INTEGER,XJ_TJJ INTEGER,XJ_CJ INTEGER,XJ_SUM INTEGER,CN_ZSBJ INTEGER,CNS_ZSBJ INTEGER,CN_FSBJ INTEGER,CNS_FSBJ INTEGER,CN_QT INTEGER,CNS_QT INTEGER,CN_SUM INTEGER,CNS_SUM INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_CAR_INFO(ORG_CODE VARCHAR(20),CREATE_DATE VARCHAR(20),OWNER_NAME VARCHAR(50),PPXX VARCHAR(100),CPHM VARCHAR(50),CJH VARCHAR(50),FDJH VARCHAR(50),PQL DECIMAL,GZJG DECIMAL,REG_DATE VARCHAR(20),TYPE CHAR(1),HZRS INTEGER,SYXZ CHAR(1),USER_NAME VARCHAR(50),ZW VARCHAR(100),RZQK CHAR(1),JB CHAR(1),TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),IS_BJ CHAR(1),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_CAR_COST(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),CN_SBJ_S INTEGER,CF_LC_SBJ_S DECIMAL,CF_FJ_SBJ_S DECIMAL,CF_SUM_SBJ_S DECIMAL,CN_SBJ_T INTEGER,CF_LC_SBJ_T DECIMAL,CF_FJ_SBJ_T DECIMAL,CF_SUM_SBJ_T DECIMAL,CN_YBGWC_S INTEGER,CF_LC_YBGWC_S DECIMAL,CF_FJ_YBGWC_S DECIMAL,CF_SUM_YBGWC_S DECIMAL,CN_YBGWC_T INTEGER,CF_LC_YBGWC_T DECIMAL,CF_FJ_YBGWC_T DECIMAL,CF_SUM_YBGWC_T DECIMAL,CN_JYTX_S INTEGER,CF_LC_JYTX_S DECIMAL,CF_FJ_JYTX_S DECIMAL,CF_SUM_JYTX_S DECIMAL,CN_JYTX_T INTEGER,CF_LC_JYTX_T DECIMAL,CF_FJ_JYTX_T DECIMAL,CF_SUM_JYTX_T DECIMAL,CN_LGB_S INTEGER,CF_LC_LGB_S DECIMAL,CF_FJ_LGB_S DECIMAL,CF_SUM_LGB_S DECIMAL,CN_LGB_T INTEGER,CF_LC_LGB_T DECIMAL,CF_FJ_LGB_T DECIMAL,CF_SUM_LGB_T DECIMAL,CN_SCFW_S INTEGER,CF_LC_SCFW_S DECIMAL,CF_FJ_SCFW_S DECIMAL,CF_SUM_SCFW_S DECIMAL,CN_SCFW_T INTEGER,CF_LC_SCFW_T DECIMAL,CF_FJ_SCFW_T DECIMAL,CF_SUM_SCFW_T DECIMAL,CN_YBZF_S INTEGER,CF_LC_YBZF_S DECIMAL,CF_FJ_YBZF_S DECIMAL,CF_SUM_YBZF_S DECIMAL,CN_YBZF_T INTEGER,CF_LC_YBZF_T DECIMAL,CF_FJ_YBZF_T DECIMAL,CF_SUM_YBZF_T DECIMAL,CN_ZFZQ_S INTEGER,CF_LC_ZFZQ_S DECIMAL,CF_FJ_ZFZQ_S DECIMAL,CF_SUM_ZFZQ_S DECIMAL,CN_ZFZQ_T INTEGER,CF_LC_ZFZQ_T DECIMAL,CF_FJ_ZFZQ_T DECIMAL,CF_SUM_ZFZQ_T DECIMAL,CN_SUM_S INTEGER,CF_LC_SUM_S DECIMAL,CF_FJ_SUM_S DECIMAL,CF_SUM_S DECIMAL,CN_SUM_T INTEGER,CF_LC_SUM_T DECIMAL,CF_FJ_SUM_T DECIMAL,CF_SUM_T DECIMAL,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_GWC_COST(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),CN_SBJ_S INTEGER,CF_SUM_SBJ_S DECIMAL,CF_RL_SBJ_S DECIMAL,CF_WX_SBJ_S DECIMAL,CF_BX_SBJ_S DECIMAL,CF_QT_SBJ_S DECIMAL,CN_SBJ_T INTEGER,CF_SUM_SBJ_T DECIMAL,CF_RL_SBJ_T DECIMAL,CF_WX_SBJ_T DECIMAL,CF_BX_SBJ_T DECIMAL,CF_QT_SBJ_T DECIMAL,CN_YBGWC_S INTEGER,CF_SUM_YBGWC_S DECIMAL,CF_RL_YBGWC_S DECIMAL,CF_WX_YBGWC_S DECIMAL,CF_BX_YBGWC_S DECIMAL,CF_QT_YBGWC_S DECIMAL,CN_YBGWC_T INTEGER,CF_SUM_YBGWC_T DECIMAL,CF_RL_YBGWC_T DECIMAL,CF_WX_YBGWC_T DECIMAL,CF_BX_YBGWC_T DECIMAL,CF_QT_YBGWC_T DECIMAL,CN_JYTX_S INTEGER,CF_SUM_JYTX_S DECIMAL,CF_RL_JYTX_S DECIMAL,CF_WX_JYTX_S DECIMAL,CF_BX_JYTX_S DECIMAL,CF_QT_JYTX_S DECIMAL,CN_JYTX_T INTEGER,CF_SUM_JYTX_T DECIMAL,CF_RL_JYTX_T DECIMAL,CF_WX_JYTX_T DECIMAL,CF_BX_JYTX_T DECIMAL,CF_QT_JYTX_T DECIMAL,CN_LGB_S INTEGER,CF_SUM_LGB_S DECIMAL,CF_RL_LGB_S DECIMAL,CF_WX_LGB_S DECIMAL,CF_BX_LGB_S DECIMAL,CF_QT_LGB_S DECIMAL,CN_LGB_T INTEGER,CF_SUM_LGB_T DECIMAL,CF_RL_LGB_T DECIMAL,CF_WX_LGB_T DECIMAL,CF_BX_LGB_T DECIMAL,CF_QT_LGB_T DECIMAL,CN_SCFW_S INTEGER,CF_SUM_SCFW_S DECIMAL,CF_RL_SCFW_S DECIMAL,CF_WX_SCFW_S DECIMAL,CF_BX_SCFW_S DECIMAL,CF_QT_SCFW_S DECIMAL,CN_SCFW_T INTEGER,CF_SUM_SCFW_T DECIMAL,CF_RL_SCFW_T DECIMAL,CF_WX_SCFW_T DECIMAL,CF_BX_SCFW_T DECIMAL,CF_QT_SCFW_T DECIMAL,CN_ZFZQ_S INTEGER,CF_SUM_ZFZQ_S DECIMAL,CF_RL_ZFZQ_S DECIMAL,CF_WX_ZFZQ_S DECIMAL,CF_BX_ZFZQ_S DECIMAL,CF_QT_ZFZQ_S DECIMAL,CN_ZFZQ_T INTEGER,CF_SUM_ZFZQ_T DECIMAL,CF_RL_ZFZQ_T DECIMAL,CF_WX_ZFZQ_T DECIMAL,CF_BX_ZFZQ_T DECIMAL,CF_QT_ZFZQ_T DECIMAL,CN_HJ_S INTEGER,CF_SUM_HJ_S DECIMAL,CF_RL_HJ_S DECIMAL,CF_WX_HJ_S DECIMAL,CF_BX_HJ_S DECIMAL,CF_QT_HJ_S DECIMAL,CN_HJ_T INTEGER,CF_SUM_HJ_T DECIMAL,CF_RL_HJ_T DECIMAL,CF_WX_HJ_T DECIMAL,CF_BX_HJ_T DECIMAL,CF_QT_HJ_T DECIMAL,CN_QTZC_S DECIMAL,CN_QTZC_T DECIMAL,CN_NDFYZJ_S DECIMAL,CN_NDFYZJ_T DECIMAL,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_SQRY_INFO(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),CN_GL_S INTEGER,CNS_GL_S INTEGER,CN_GDYY_GB_GL_SUM INTEGER,CN_GDYY_GB_GL_WY INTEGER,CN_GDYY_GB_GL_SW INTEGER,CN_GDYY_GB_GL_SS INTEGER,CN_GDYY_GB_GL_SL INTEGER,CN_GDYY_GR_GL_SUM INTEGER,CN_GDYY_GR_GL_WY INTEGER,CN_GDYY_GR_GL_SW INTEGER,CN_GDYY_GR_GL_SS INTEGER,CN_GDYY_GR_GL_SL INTEGER,CN_PYHT_GL_SUM INTEGER,CN_PYHT_GL_WY INTEGER,CN_PYHT_GL_SW INTEGER,CN_PYHT_GL_SS INTEGER,CN_PYHT_GL_SL INTEGER,CN_LDHT_GL_SUM INTEGER,CN_LDHT_GL_WY INTEGER,CN_LDHT_GL_SW INTEGER,CN_LDHT_GL_SS INTEGER,CN_LDHT_GL_SL INTEGER,CN_LWPQ_GL_SUM INTEGER,CN_LWPQ_GL_WY INTEGER,CN_LWPQ_GL_SW INTEGER,CN_LWPQ_GL_SS INTEGER,CN_LWPQ_GL_SL INTEGER,CN_SBJSJ_S INTEGER,CNS_SBJSJ_S INTEGER,CN_GDYY_GB_SBJSJ_SUM INTEGER,CN_GDYY_GB_SBJSJ_WY INTEGER,CN_GDYY_GB_SBJSJ_SW INTEGER,CN_GDYY_GB_SBJSJ_SS INTEGER,CN_GDYY_GB_SBJSJ_SL INTEGER,CN_GDYY_GR_SBJSJ_SUM INTEGER,CN_GDYY_GR_SBJSJ_WY INTEGER,CN_GDYY_GR_SBJSJ_SW INTEGER,CN_GDYY_GR_SBJSJ_SS INTEGER,CN_GDYY_GR_SBJSJ_SL INTEGER,CN_PYHT_SBJSJ_SUM INTEGER,CN_PYHT_SBJSJ_WY INTEGER,CN_PYHT_SBJSJ_SW INTEGER,CN_PYHT_SBJSJ_SS INTEGER,CN_PYHT_SBJSJ_SL INTEGER,CN_LDHT_SBJSJ_SUM INTEGER,CN_LDHT_SBJSJ_WY INTEGER,CN_LDHT_SBJSJ_SW INTEGER,CN_LDHT_SBJSJ_SS INTEGER,CN_LDHT_SBJSJ_SL INTEGER,CN_LWPQ_SBJSJ_SUM INTEGER,CN_LWPQ_SBJSJ_WY INTEGER,CN_LWPQ_SBJSJ_SW INTEGER,CN_LWPQ_SBJSJ_SS INTEGER,CN_LWPQ_SBJSJ_SL INTEGER,CN_QTSJ_S INTEGER,CNS_QTSJ_S INTEGER,CN_GDYY_GB_QTSJ_SUM INTEGER,CN_GDYY_GB_QTSJ_WY INTEGER,CN_GDYY_GB_QTSJ_SW INTEGER,CN_GDYY_GB_QTSJ_SS INTEGER,CN_GDYY_GB_QTSJ_SL INTEGER,CN_GDYY_GR_QTSJ_SUM INTEGER,CN_GDYY_GR_QTSJ_WY INTEGER,CN_GDYY_GR_QTSJ_SW INTEGER,CN_GDYY_GR_QTSJ_SS INTEGER,CN_GDYY_GR_QTSJ_SL INTEGER,CN_PYHT_QTSJ_SUM INTEGER,CN_PYHT_QTSJ_WY INTEGER,CN_PYHT_QTSJ_SW INTEGER,CN_PYHT_QTSJ_SS INTEGER,CN_PYHT_QTSJ_SL INTEGER,CN_LDHT_QTSJ_SUM INTEGER,CN_LDHT_QTSJ_WY INTEGER,CN_LDHT_QTSJ_SW INTEGER,CN_LDHT_QTSJ_SS INTEGER,CN_LDHT_QTSJ_SL INTEGER,CN_LWPQ_QTSJ_SUM INTEGER,CN_LWPQ_QTSJ_WY INTEGER,CN_LWPQ_QTSJ_SW INTEGER,CN_LWPQ_QTSJ_SS INTEGER,CN_LWPQ_QTSJ_SL INTEGER,CN_XLG_S INTEGER,CNS_XLG_S INTEGER,CN_GDYY_GB_XLG_SUM INTEGER,CN_GDYY_GB_XLG_WY INTEGER,CN_GDYY_GB_XLG_SW INTEGER,CN_GDYY_GB_XLG_SS INTEGER,CN_GDYY_GB_XLG_SL INTEGER,CN_GDYY_GR_XLG_SUM INTEGER,CN_GDYY_GR_XLG_WY INTEGER,CN_GDYY_GR_XLG_SW INTEGER,CN_GDYY_GR_XLG_SS INTEGER,CN_GDYY_GR_XLG_SL INTEGER,CN_PYHT_XLG_SUM INTEGER,CN_PYHT_XLG_WY INTEGER,CN_PYHT_XLG_SW INTEGER,CN_PYHT_XLG_SS INTEGER,CN_PYHT_XLG_SL INTEGER,CN_LDHT_XLG_SUM INTEGER,CN_LDHT_XLG_WY INTEGER,CN_LDHT_XLG_SW INTEGER,CN_LDHT_XLG_SS INTEGER,CN_LDHT_XLG_SL INTEGER,CN_LWPQ_XLG_SUM INTEGER,CN_LWPQ_XLG_WY INTEGER,CN_LWPQ_XLG_SW INTEGER,CN_LWPQ_XLG_SS INTEGER,CN_LWPQ_XLG_SL INTEGER,CN_SUM_S INTEGER,CNS_SUM_S INTEGER,CN_GDYY_GB_SUM INTEGER,CN_GDYY_GB_SUM_WY INTEGER,CN_GDYY_GB_SUM_SW INTEGER,CN_GDYY_GB_SUM_SS INTEGER,CN_GDYY_GB_SUM_SL INTEGER,CN_GDYY_GR_SUM INTEGER,CN_GDYY_GR_SUM_WY INTEGER,CN_GDYY_GR_SUM_SW INTEGER,CN_GDYY_GR_SUM_SS INTEGER,CN_GDYY_GR_SUM_SL INTEGER,CN_PYHT_SUM INTEGER,CN_PYHT_SUM_WY INTEGER,CN_PYHT_SUM_SW INTEGER,CN_PYHT_SUM_SS INTEGER,CN_PYHT_SUM_SL INTEGER,CN_LDHT_SUM INTEGER,CN_LDHT_SUM_WY INTEGER,CN_LDHT_SUM_SW INTEGER,CN_LDHT_SUM_SS INTEGER,CN_LDHT_SUM_SL INTEGER,CN_LWPQ_SUM INTEGER,CN_LWPQ_SUM_WY INTEGER,CN_LWPQ_SUM_SW INTEGER,CN_LWPQ_SUM_SS INTEGER,CN_LWPQ_SUM_SL INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_SQRY_COST(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),CN_GLRY INTEGER,CNS_GLRY INTEGER,CF_GZ_GLRY_S DECIMAL,CF_JT_GLRY_S DECIMAL,CF_WY_GLRY_S DECIMAL,CF_WX_GLRY_S DECIMAL,CF_GJJ_GLRY_S DECIMAL,CF_YL_GLRY_S DECIMAL,CF_QT_GLRY_S DECIMAL,CF_SUM_GLRY_S DECIMAL,CF_GZ_GLRY_T DECIMAL,CF_JT_GLRY_T DECIMAL,CF_WY_GLRY_T DECIMAL,CF_WX_GLRY_T DECIMAL,CF_GJJ_GLRY_T DECIMAL,CF_YL_GLRY_T DECIMAL,CF_QT_GLRY_T DECIMAL,CF_SUM_GLRY_T DECIMAL,CN_SBJSJ INTEGER,CNS_SBJSJ INTEGER,CF_GZ_SBJSJ_S DECIMAL,CF_JT_SBJSJ_S DECIMAL,CF_WY_SBJSJ_S DECIMAL,CF_WX_SBJSJ_S DECIMAL,CF_GJJ_SBJSJ_S DECIMAL,CF_YL_SBJSJ_S DECIMAL,CF_QT_SBJSJ_S DECIMAL,CF_SUM_SBJSJ_S DECIMAL,CF_GZ_SBJSJ_T DECIMAL,CF_JT_SBJSJ_T DECIMAL,CF_WY_SBJSJ_T DECIMAL,CF_WX_SBJSJ_T DECIMAL,CF_GJJ_SBJSJ_T DECIMAL,CF_YL_SBJSJ_T DECIMAL,CF_QT_SBJSJ_T DECIMAL,CF_SUM_SBJSJ_T DECIMAL,CN_QTSJ INTEGER,CNS_QTSJ INTEGER,CF_GZ_QTSJ_S DECIMAL,CF_JT_QTSJ_S DECIMAL,CF_WY_QTSJ_S DECIMAL,CF_WX_QTSJ_S DECIMAL,CF_GJJ_QTSJ_S DECIMAL,CF_YL_QTSJ_S DECIMAL,CF_QT_QTSJ_S DECIMAL,CF_SUM_QTSJ_S DECIMAL,CF_GZ_QTSJ_T DECIMAL,CF_JT_QTSJ_T DECIMAL,CF_WY_QTSJ_T DECIMAL,CF_WX_QTSJ_T DECIMAL,CF_GJJ_QTSJ_T DECIMAL,CF_YL_QTSJ_T DECIMAL,CF_QT_QTSJ_T DECIMAL,CF_SUM_QTSJ_T DECIMAL,CN_XLG INTEGER,CNS_XLG INTEGER,CF_GZ_XLG_S DECIMAL,CF_JT_XLG_S DECIMAL,CF_WY_XLG_S DECIMAL,CF_WX_XLG_S DECIMAL,CF_GJJ_XLG_S DECIMAL,CF_YL_XLG_S DECIMAL,CF_QT_XLG_S DECIMAL,CF_SUM_XLG_S DECIMAL,CF_GZ_XLG_T DECIMAL,CF_JT_XLG_T DECIMAL,CF_WY_XLG_T DECIMAL,CF_WX_XLG_T DECIMAL,CF_GJJ_XLG_T DECIMAL,CF_YL_XLG_T DECIMAL,CF_QT_XLG_T DECIMAL,CF_SUM_XLG_T DECIMAL,CN_TOTAL INTEGER,CNS_TOTAL INTEGER,CF_GZ_TOTAL_S DECIMAL,CF_JT_TOTAL_S DECIMAL,CF_WY_TOTAL_S DECIMAL,CF_WX_TOTAL_S DECIMAL,CF_GJJ_TOTAL_S DECIMAL,CF_YL_TOTAL_S DECIMAL,CF_QT_TOTAL_S DECIMAL,CF_TOTAL_S DECIMAL,CF_GZ_TOTAL_T DECIMAL,CF_JT_TOTAL_T DECIMAL,CF_WY_TOTAL_T DECIMAL,CF_WX_TOTAL_T DECIMAL,CF_GJJ_TOTAL_T DECIMAL,CF_YL_TOTAL_T DECIMAL,CF_QT_TOTAL_T DECIMAL,CF_TOTAL_T DECIMAL,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_ZGFCGDW_GWYC_INFO(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),RY_ZS_DWGS INTEGER,RY_ZS_BZS INTEGER,RY_ZS_SYRS INTEGER,RY_ZS_SQRYS INTEGER,RY_ZGST_DWGS INTEGER,RY_ZGST_BZS INTEGER,RY_ZGST_SYRS INTEGER,RY_ZGST_SQRYS INTEGER,RY_SSTT_DWGS INTEGER,RY_SSTT_BZS INTEGER,RY_SSTT_SYRS INTEGER,RY_SSTT_SQRYS INTEGER,RY_QT_DWGS INTEGER,RY_QT_BZS INTEGER,RY_QT_SYRS INTEGER,RY_QT_SQRYS INTEGER,JF_ZS_SQRYZC_S DECIMAL,JF_ZS_SQRYZC_T DECIMAL,JF_ZS_CLGZF_S DECIMAL,JF_ZS_CLGZF_T DECIMAL,JF_ZS_CLYXF_S DECIMAL,JF_ZS_CLYXF_T DECIMAL,JF_ZGST_SQRYZC_S DECIMAL,JF_ZGST_SQRYZC_T DECIMAL,JF_ZGST_CLGZF_S DECIMAL,JF_ZGST_CLGZF_T DECIMAL,JF_ZGST_CLYXF_S DECIMAL,JF_ZGST_CLYXF_T DECIMAL,JF_SSTT_SQRYZC_S DECIMAL,JF_SSTT_SQRYZC_T DECIMAL,JF_SSTT_CLGZF_S DECIMAL,JF_SSTT_CLGZF_T DECIMAL,JF_SSTT_CLYXF_S DECIMAL,JF_SSTT_CLYXF_T DECIMAL,JF_QT_SQRYZC_S DECIMAL,JF_QT_SQRYZC_T DECIMAL,JF_QT_CLGZF_S DECIMAL,JF_QT_CLGZF_T DECIMAL,JF_QT_CLYXF_S DECIMAL,JF_QT_CLYXF_T DECIMAL,CL_ZS_SBJYC INTEGER,CL_ZS_YBGWYC INTEGER,CL_ZS_ZFZQYC INTEGER,CL_ZS_TOTAL INTEGER,CL_ZGST_SBJYC INTEGER,CL_ZGST_YBGWYC INTEGER,CL_ZGST_ZFZQYC INTEGER,CL_ZGST_TOTAL INTEGER,CL_SSTT_SBJYC INTEGER,CL_SSTT_YBGWYC INTEGER,CL_SSTT_ZFZQYC INTEGER,CL_SSTT_TOTAL INTEGER,CL_QT_SBJYC INTEGER,CL_QT_YBGWYC INTEGER,CL_QT_ZFZQYC INTEGER,CL_QT_TOTAL INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_CZGLDW_GWYC_INFO(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),RY_XZ_DWGS INTEGER,RY_XZ_BZS INTEGER,RY_XZ_SYRS INTEGER,RY_XZ_SQRYS INTEGER,RY_CG_DWGS INTEGER,RY_CG_BZS INTEGER,RY_CG_SYRS INTEGER,RY_CG_SQRYS INTEGER,RY_QT_DWGS INTEGER,RY_QT_BZS INTEGER,RY_QT_SYRS INTEGER,RY_QT_SQRYS INTEGER,JF_XZ_SQRYZC_S DECIMAL,JF_XZ_SQRYZC_T DECIMAL,JF_XZ_CLGZF_S DECIMAL,JF_XZ_CLGZF_T DECIMAL,JF_XZ_CLYXF_S DECIMAL,JF_XZ_CLYXF_T DECIMAL,JF_CG_SQRYZC_S DECIMAL,JF_CG_SQRYZC_T DECIMAL,JF_CG_CLGZF_S DECIMAL,JF_CG_CLGZF_T DECIMAL,JF_CG_CLYXF_S DECIMAL,JF_CG_CLYXF_T DECIMAL,JF_QT_SQRYZC_S DECIMAL,JF_QT_SQRYZC_T DECIMAL,JF_QT_CLGZF_S DECIMAL,JF_QT_CLGZF_T DECIMAL,JF_QT_CLYXF_S DECIMAL,JF_QT_CLYXF_T DECIMAL,CL_XZ_YBGWYC_BZS INTEGER,CL_XZ_YBGWYC_SS INTEGER,CL_XZ_ZFZQYC_BZS INTEGER,CL_XZ_ZFZQYC_SS INTEGER,CL_CG_YBGWYC_BZS INTEGER,CL_CG_YBGWYC_SS INTEGER,CL_CG_ZFZQYC_BZS INTEGER,CL_CG_ZFZQYC_SS INTEGER,CL_QT_YBGWYC_BZS INTEGER,CL_QT_YBGWYC_SS INTEGER,CL_QT_ZFZQYC_BZS INTEGER,CL_QT_ZFZQYC_SS INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE MEMORY TABLE GC_SZ_GWYC_HZB(ORG_CODE VARCHAR(20) NOT NULL,CREATE_DATE VARCHAR(20) NOT NULL,IS_BJ CHAR(1),IS_HZ CHAR(1),RY_XZ_DWGS INTEGER,RY_XZ_BZS INTEGER,RY_XZ_SYRS INTEGER,RY_XZ_SQRYS INTEGER,RY_CG_DWGS INTEGER,RY_CG_BZS INTEGER,RY_CG_SYRS INTEGER,RY_CG_SQRYS INTEGER,RY_QT_DWGS INTEGER,RY_QT_BZS INTEGER,RY_QT_SYRS INTEGER,RY_QT_SQRYS INTEGER,JF_XZ_SQRYZC_S DECIMAL,JF_XZ_SQRYZC_T DECIMAL,JF_XZ_CLGZF_S DECIMAL,JF_XZ_CLGZF_T DECIMAL,JF_XZ_CLYXF_S DECIMAL,JF_XZ_CLYXF_T DECIMAL,JF_CG_SQRYZC_S DECIMAL,JF_CG_SQRYZC_T DECIMAL,JF_CG_CLGZF_S DECIMAL,JF_CG_CLGZF_T DECIMAL,JF_CG_CLYXF_S DECIMAL,JF_CG_CLYXF_T DECIMAL,JF_QT_SQRYZC_S DECIMAL,JF_QT_SQRYZC_T DECIMAL,JF_QT_CLGZF_S DECIMAL,JF_QT_CLGZF_T DECIMAL,JF_QT_CLYXF_S DECIMAL,JF_QT_CLYXF_T DECIMAL,CL_XZ_YBGWYC_BZS INTEGER,CL_XZ_YBGWYC_SS INTEGER,CL_XZ_ZFZQYC_BZS INTEGER,CL_XZ_ZFZQYC_SS INTEGER,CL_CG_YBGWYC_BZS INTEGER,CL_CG_YBGWYC_SS INTEGER,CL_CG_ZFZQYC_BZS INTEGER,CL_CG_ZFZQYC_SS INTEGER,CL_QT_YBGWYC_BZS INTEGER,CL_QT_YBGWYC_SS INTEGER,CL_QT_ZFZQYC_BZS INTEGER,CL_QT_ZFZQYC_SS INTEGER,TBR_NAME VARCHAR(50),TBR_BM VARCHAR(50),LINK_PHONE VARCHAR(20),FAX_NUMBER VARCHAR(20),ORG_NAME VARCHAR(200),P_ORG_CODE VARCHAR(200),P_ORG_NAME VARCHAR(200),IS_SD CHAR(1),XZ_TYPE CHAR(1),ADDRESS VARCHAR(200))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
