-- [김준회] nonsap (PLM) DB 가져오는 용도의 nonsap 테이블 -- 다른 건들은 MDG SOAP으로 받을 수 있어도, plftb_estm_proj_mast는 해양 TOP 견적프로젝트 정보를 받아올 유일한 인터페이스임 -- TARGET_IF 가 TRUE인 것만 eVCP 견적프로젝트에 넣어주면 됨 CREATE SCHEMA "nonsap"; --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_cd" ( "CD_CLF" varchar(10) NOT NULL, "CD" varchar(10) NOT NULL, "CD2" varchar(10) NOT NULL, "CD3" varchar(10) NOT NULL, "USR_DF_CHAR_1" varchar(60), "USR_DF_CHAR_2" varchar(60), "USR_DF_CHAR_3" varchar(60), "USR_DF_CHAR_4" varchar(60), "USR_DF_CHAR_5" varchar(60), "USR_DF_CHAR_6" varchar(60), "USR_DF_CHAR_7" varchar(60), "USR_DF_CHAR_8" varchar(60), "USR_DF_CHAR_9" varchar(60), "USR_DF_CHAR_10" varchar(60), "USR_DF_CHAR_11" varchar(60), "USR_DF_CHAR_12" varchar(60), "USR_DF_CHAR_13" varchar(60), "USR_DF_CHAR_14" varchar(60), "USR_DF_CHAR_15" varchar(60), "USR_DF_CHAR_16" varchar(60), "USR_DF_CHAR_17" varchar(120), "USR_DF_CHAR_18" varchar(120), "USR_DF_CHAR_19" text, "USR_DF_CHAR_20" text, "USR_DF_CHK_1" varchar(1), "USR_DF_CHK_2" varchar(1), "USR_DF_CHK_3" varchar(1), "USR_DF_CHK_4" varchar(1), "USR_DF_CHK_5" varchar(1), "USR_DF_CHK_6" varchar(1), "USR_DF_CHK_7" varchar(1), "USR_DF_CHK_8" varchar(1), "USR_DF_DT_1" varchar(8), "USR_DF_DT_2" varchar(8), "USR_DF_DT_3" varchar(8), "USR_DF_DT_4" varchar(8), "USR_DF_TM_1" varchar(6), "USR_DF_TM_2" varchar(6), "USR_DF_TM_3" varchar(6), "USR_DF_TM_4" varchar(6), "CRTER" varchar(13), "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CHGR" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "DEL_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_cd_clf" ( "CD_CLF" varchar(10) NOT NULL, "CRTER" varchar(13), "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CHGR" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "DEL_YN" varchar(1), "XSTAT" varchar(1), "XMSGS" text, "XDATS" varchar(8), "XTIMS" varchar(6) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_cd_clf_nm" ( "LANG_KEY" varchar(1) NOT NULL, "CD_CLF" varchar(10) NOT NULL, "CD_CLF_NM" varchar(120), "GRP_DSC" varchar(120), "CRTER" varchar(13), "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CHGR" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "DEL_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_cdnm" ( "LANG_KEY" varchar(1) NOT NULL, "CD_CLF" varchar(10) NOT NULL, "CD" varchar(10) NOT NULL, "CD2" varchar(10) NOT NULL, "CD3" varchar(10) NOT NULL, "CDNM" varchar(120), "GRP_DSC" text, "CRTER" varchar(13), "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CHGR" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "DEL_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_addr" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10) NOT NULL, "INTL_ADR_VER_ID" varchar(1) NOT NULL, "NTN_CD" varchar(3), "CITY_ZIP_NO" varchar(10), "POBX_ZIP_NO" varchar(10), "ADR_1" varchar(120), "ADR_2" varchar(120), "REGN_CD" varchar(3), "ETC_ADR_1" varchar(180), "ETC_ADR_2" varchar(30), "HOUSE_NR1" varchar(10), "POBX" varchar(30), "LANG_KEY" varchar(1), "VNDRNM_1" varchar(120), "VNDRNM_2" varchar(120), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "TRANS_ZONE" varchar(10) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_cfpn" ( "CSTM_CD" varchar(10) NOT NULL, "SALE_ORG_CD" varchar(4) NOT NULL, "DIST_PATH" varchar(2) NOT NULL, "PDT_GRP" varchar(2) NOT NULL, "PTNR_SKL" varchar(2) NOT NULL, "PTNR_CNT" varchar(3) NOT NULL, "BSE_PTNR_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_compny" ( "CSTM_CD" varchar(10) NOT NULL, "CO_ID" varchar(4) NOT NULL, "AR_ACNT_HDL_GB" varchar(10), "SRT_KEY" varchar(3), "AMT_RNE_GB" varchar(10), "VNDR_PAY_FRM" varchar(10), "BILL_PAY_COND_CD" varchar(4), "BILL_PAY_BLOC_CD" varchar(1), "PST_HOLD_ORDR" varchar(1), "DEL_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_general" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "REPR_SER" varchar(3), "ACNT_GRP" varchar(4), "OVLAP_CAUS" varchar(2), "CSTM_TP" varchar(2), "DEL_ORDR" varchar(1), "DEL_BLOCK" varchar(1), "PST_HOLD_ORDR" varchar(1), "CO_ID" varchar(6), "TTL" varchar(45), "COND_GRP_1" varchar(2), "CSTM_GRP_NM" varchar(60), "REPR_NM" varchar(30), "BIZTP" varchar(90), "BIZCON" varchar(90), "TX_NO_2" varchar(11), "TX_NO_3" varchar(18), "TX_NO_4" varchar(18), "TX_REG_NO" varchar(20), "BA_CD" varchar(4), "VNDRCD" varchar(10), "SRCH_COND_1" varchar(60), "SRCH_COND_2" varchar(60), "CITY_DISP_NM" varchar(105), "CRM_CD" varchar(20), "IN_FLAG" varchar(1), "INDST_CD" varchar(4), "TX_NO_TP" varchar(2), "LANG_KEY" varchar(1), "REG_DT" varchar(8), "REG_DTM" varchar(6), "REGR_ID" varchar(13), "AGR_DT" varchar(8), "AGR_TM" varchar(6), "AGR_R_ID" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "CHGR_ID" varchar(13), "FTGT_CD" varchar(10), "FTGT_NM" varchar(120), "FTDT_CD" varchar(10), "FTDT_NM" varchar(120), "FTBU_CD" varchar(10), "FTBU_NM" varchar(120), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_repremail" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10) NOT NULL, "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "EMAIL_ADR" varchar(241), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_reprfax" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10) NOT NULL, "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "NTN_CD" varchar(3), "FAXNO" varchar(30), "FAX_ETS_NO" varchar(10), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_reprtel" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10) NOT NULL, "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "NTN_CD" varchar(3), "TELNO" varchar(30), "ETX_NO" varchar(10), "HP_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_reprurl" ( "CSTM_CD" varchar(10) NOT NULL, "ADR_NO" varchar(10) NOT NULL, "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "URL" text, "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_sorg" ( "CSTM_CD" varchar(10) NOT NULL, "SALE_ORG_CD" varchar(4) NOT NULL, "DIST_PATH" varchar(2) NOT NULL, "PDT_GRP" varchar(2) NOT NULL, "SALE_REGN" varchar(1), "SALE_OFC" varchar(4), "SALE_GRP" varchar(3), "CSTM_GRP" varchar(2), "PSBL" varchar(3), "TRD_CUR" varchar(5), "EXRAT_TP" varchar(4), "PRC_PRCS_DSC_CD" varchar(1), "CSTM_STAT_GRP" varchar(1), "SHIPMT_COND" varchar(2), "MAX_TRD_QTY" numeric, "DL_COND_1" varchar(3), "DL_COND_2" varchar(84), "SPLY_COND" varchar(4), "ACNT_ASGN_GRP" varchar(2), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_taxcd" ( "CSTM_CD" varchar(10) NOT NULL, "DPRT_NTN" varchar(3) NOT NULL, "TX_CTG" varchar(4) NOT NULL, "CSTM_TX_CLF" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_customer_taxnum" ( "CSTM_CD" varchar(10) NOT NULL, "TX_NO_CTG" varchar(4) NOT NULL, "BIZ_PTNR_TX_NO" varchar(20), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_bse" ( "MAT_NO" varchar(18) NOT NULL, "SM_CD" varchar(18), "MAT_ID" varchar(50), "CLAS_CD" varchar(18), "MAT_TP" varchar(4), "MAT_GB" varchar(1), "MAT_DTL" varchar(120), "MAT_DTL_SPEC" text, "MATL" varchar(50), "OLD_MAT_NO" varchar(18), "SBST_MAT_NO" varchar(18), "UOM" varchar(3), "PDT_GRP" varchar(2), "MRC" varchar(1), "STOR_MAT_ORDR" varchar(1), "STYPE" varchar(2), "CLS" varchar(8), "WGT" numeric, "NET_WGT" numeric, "WGT_UOM" varchar(3), "LTH" numeric, "LTH_2" numeric, "WTH" numeric, "WTH_2" numeric, "THK" numeric, "STD" varchar(70), "PROF_STD" varchar(30), "CBL_OUT_DIA" numeric, "LTRM_MAT_YN" varchar(1), "PNT_AREA" numeric, "PNTIN_AREA" numeric, "PNTIN_SPEC" varchar(5), "PNTOUT_AREA" numeric, "PNTOUT_SPEC_1" varchar(5), "PNTOUT_SPEC_2" varchar(5), "PNTOUT_SPEC_3" varchar(5), "RT_INSPEC" varchar(2), "UT_INSPEC" varchar(2), "MT_INSPEC" varchar(2), "PT_INSPEC" varchar(2), "MK_DWG_NO" varchar(50), "CUT_DWG_NO" varchar(120), "PIPE_SPL_NO" varchar(40), "PIPE_LINE_NO" varchar(40), "PIPE_CLAS" varchar(10), "FLUID_KND" varchar(5), "REP_ITM_MATL" varchar(60), "REP_DIA" varchar(10), "REP_DIA_UOM" varchar(3), "REP_SCH" varchar(20), "REP_DIA_LTH" numeric, "DBLN_GB" varchar(1), "PIPE_GRD" varchar(1), "HTRET_YN" varchar(1), "BA_GALV_SPEC" varchar(3), "SSIDE_YN" varchar(1), "PNTR_PIPE_YN" varchar(1), "UBOLT_YN" varchar(1), "CTLP_PRCD_PNT" varchar(1), "PRCD_SCV_CTLP" varchar(2), "PMI_INSPEC" varchar(2), "WTRPRS" numeric, "VLV_FIT_NO" varchar(18), "TAG_NO" varchar(50), "TAG_SB_NO" varchar(10), "NM_PLATE_TP" varchar(5), "NM_PLATE_SVC_NM" varchar(60), "VRCS_MAT_NO" varchar(18), "TRSM_FIT_NO" varchar(7), "VLV_OPT_CD_LIST" varchar(20), "PUR_REQ_NO" varchar(10), "ITM_NO" varchar(20), "MDL_NO" varchar(30), "BL_NO" varchar(30), "VNDR_EQP_NO" varchar(10), "BOX_NO" varchar(20), "MMT_NO" varchar(10), "INSTL_LOC" varchar(30), "MN_EQP_YN" varchar(1), "FIXED_MAT_YN" varchar(1), "SPRE_YN" varchar(1), "TOOL_YN" varchar(1), "CBL_YN" varchar(1), "OWN_INSTL_MAT_YN" varchar(1), "NONINSTL_MAT_YN" varchar(1), "BLK_NO" varchar(5), "GYEL" varchar(2), "LNK_PTLST_NO" varchar(40), "AREA" numeric, "STOR_LOC" varchar(10), "SGUB_WGT" numeric, "DGUB_WGT" numeric, "PROJ_NO" varchar(24), "DSN_SKL" varchar(2), "RMK" text, "DEL_ORDR" varchar(1), "DEL_DT" varchar(8), "MAT_STAT" varchar(2), "IF_SYS_NO" varchar(1), "IF_STAT" varchar(1), "IF_MSG" varchar(255), "IF_DT" varchar(8), "IF_TM" varchar(6), "GLAND_SPEC_1" varchar(30), "GLAND_SPEC_2" varchar(30), "GLAND_SPEC_3" varchar(30), "MCT_MDLE_STD_1" varchar(30), "MCT_MDLE_STD_2" varchar(30), "BEELE_RISE" varchar(12), "MAX_DRUM_LTH" numeric, "AGR_DTM" varchar(14), "AGR_R_ID" varchar(13), "DISPLN" varchar(1), "LRG_KWK" varchar(1), "DTL_KWK" varchar(1), "SP_INSP_GB" varchar(1), "PNTOUT_SPEC_4" varchar(5), "OFE_MAT_NO" varchar(18), "OFE_CAB_YN" varchar(1), "INSTL_PSB_CNT" numeric, "CUTL_ML_GB" varchar(1), "FCM_INSP" varchar(2), "DOC_NO" varchar(25), "HOLD_CAUS" varchar(200), "HOLD_DT" varchar(8), "HOLD_LIFT_DT" varchar(8), "MAT_KND_GB" varchar(1), "BATCH_MNG_ORDR" varchar(1), "FS_INPR_ID" varchar(13), "FS_INP_DTM" varchar(14), "FIN_CHGR_ID" varchar(13), "FIN_CHG_DTM" varchar(14), "DWG_FILE_NM" text, "TAG_NO_CHG_DT" varchar(8), "SUB_EQP_YN" varchar(1), "ATT_MAT_YN" varchar(1), "DSN_REV_NO" varchar(4), "USR_DF_CHAR1" varchar(50), "USR_DF_CHAR2" varchar(50), "USR_DF_CHAR3" varchar(50), "USR_DF_CHAR4" varchar(50), "USR_DF_CHAR5" varchar(50) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_clas" ( "CLAS_CD" varchar(18) NOT NULL, "CLAS_NM" varchar(60), "CLAS_DTL" varchar(180), "PRNT_CLAS_CD" varchar(18), "CLAS_LVL" numeric, "DEL_ORDR" varchar(1), "UOM" varchar(3), "STYPE" varchar(2), "GRD_MATL" varchar(50), "CHG_DT" varchar(8), "BSE_UOM" varchar(3) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_clas_spchar" ( "CLAS_CD" varchar(18) NOT NULL, "SPCHAR_CD" varchar(30) NOT NULL, "SPCHAR_SEQ" varchar(3), "MNDT_YN" varchar(1), "CHG_DT" varchar(8), "DEL_ORDR" varchar(1), CONSTRAINT "cmctb_mat_clas_spchar_CLAS_CD_SPCHAR_CD_pk" PRIMARY KEY("CLAS_CD","SPCHAR_CD") ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_dsc" ( "MAT_NO" varchar(18) NOT NULL, "LANG_KEY" varchar(1) NOT NULL, "MAT_DTL" varchar(120) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_plnt" ( "MAT_NO" varchar(18) NOT NULL, "PLNT" varchar(4) NOT NULL, "DELV_UOM" varchar(3), "EA_BTCH_ND_GB" varchar(1), "PRCR_CLF" varchar(4), "PUR_CHRGR_CD" varchar(3), "PRCR_CHRGR_CD" varchar(3), "GOODS_CHRGR_CD" varchar(3), "PUR_LT" numeric, "MRP_TP" varchar(2), "MAT_STAT" varchar(2), "BULK_MAT_ORDR" varchar(1), "PRCR_TP" varchar(1), "SFTY_STCK_QTY" numeric, "SER_PROF" varchar(4), "DEL_ORDR" varchar(1), "BATCH_MNG_ORDR" varchar(1), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "IF_DT" varchar(8), "IF_TM" varchar(6), "SP_PRCR_TP" varchar(2) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_spchar" ( "MAT_NO" varchar(18) NOT NULL, "SPCHAR_CD" varchar(30) NOT NULL, "SPCHAR_DTL" varchar(90), "SPCHAR_VAL_CD" varchar(90), "SPCHAR_VAL_DTL" varchar(90), "SPCHAR_VAL_NUM" numeric, "SPCHAR_VAL_UOM" varchar(3) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_spchar_mast" ( "SPCHAR_CD" varchar(30) NOT NULL, "SPCHAR_DTL" varchar(90), "SPCHAR_TP" varchar(10), "SPCHAR_VAL_UOM" varchar(3), "SPCHAR_VAL_YN" varchar(1), "SPCHAR_GRP" varchar(10), "CHG_DT" varchar(8), "DEL_ORDR" varchar(1), CONSTRAINT "cmctb_mat_spchar_mast_SPCHAR_CD_pk" PRIMARY KEY("SPCHAR_CD") ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_spchar_val" ( "SPCHAR_CD" varchar(30) NOT NULL, "SPCHAR_VAL_CD" varchar(90) NOT NULL, "SPCHAR_VAL_DTL" varchar(90), "CHG_DT" varchar(8), "DEL_ORDR" varchar(1), CONSTRAINT "cmctb_mat_spchar_val_SPCHAR_CD_SPCHAR_VAL_CD_pk" PRIMARY KEY("SPCHAR_CD","SPCHAR_VAL_CD") ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_mat_uom" ( "MAT_NO" varchar(18) NOT NULL, "SBST_UOM" varchar(3) NOT NULL, "CNVRT_FCTR_1" numeric, "CNVRT_FCTR_2" numeric, "LTH" numeric, "WTH" numeric, "HGT" numeric, "SZ_UOM" varchar(3) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_proj_bizcls" ( "PROJ_NO" varchar(24) NOT NULL, "TYPE" varchar(1) NOT NULL, "BIZCLS" varchar(1), "QM_CLS" varchar(10), "NEW_MC_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_proj_mast" ( "PROJ_NO" varchar(24) NOT NULL, "MSHIP_NO" varchar(24), "SERS_NO" varchar(24), "REF_NO" varchar(5), "SKND" varchar(3), "SHTYPE" varchar(8), "SHTYPE_UOM" varchar(5), "DOCK_CD" varchar(3), "OWN_1" varchar(32), "CLS_1" varchar(20), "CNRT_DT" varchar(8), "CNRT_DL_DT" varchar(8), "PROJ_DSC" varchar(120), "PROJ_GB" varchar(2), "OWN_NM" varchar(120), "NEW_SKND2" varchar(30), "OWN_AB" varchar(60), "CHINA_YN" varchar(3), "PROJ_DTL_TP" varchar(2), "PROJ_PROF" varchar(7), "INQY_NO" varchar(30), "INQY_SEQ" varchar(2), "NTTP" varchar(3), "RLTD_PROJ" varchar(40), "DIGT_PDT_GRP" varchar(1), "WP_PROJ_TP" varchar(1), "TOT_CNRT_CNT" varchar(3), "PROJ_ETC_TP" varchar(1), "IF_STAT" varchar(1), "SRC_SYS_ID" varchar(1), "PRGS_STAT" varchar(1), "DEL_YN" varchar(1), "DL_CSTM_CD" varchar(10), "PDT_LVL_4" varchar(14), "AS_GRNT_PRD" numeric, "RL_DL_DT" varchar(8), "SA_DT" varchar(8), "GOV" varchar(60), "DL_BF_PROJ_NM" varchar(120), "IMO_NO" varchar(8), "DIST_PATH" varchar(2), "SALE_ORG_CD" varchar(4), "SALE_GRP" varchar(3), "BIZLOC_CD" varchar(4), "MNG_ACOT_DMN" varchar(4), "CO_CD" varchar(4), "BIZ_DMN" varchar(4), "PLNT_CD" varchar(4), "PRCTR" varchar(10), "CNRT_CNTN_YN" varchar(1), "CNRT_RESV_YN" varchar(1), "PROJ_PRGS_YN" varchar(1), "SYS_ACOT_CLSD_DT" varchar(8), "PROJ_SCP" varchar(5), "LOA" numeric, "MN_ENGN_TP_CD" varchar(30), "SPD" numeric, "GT" numeric, "BP_DL_DT" varchar(8), "SHTYPE_GRP" varchar(4), "PROJ_CRTE_REQ_EMPNO" varchar(13), "PROJ_CRTE_REQ_DT" varchar(8), "IO_GB" varchar(1), "CSTM_PO_NO" varchar(35), "GENT_CNT" varchar(5), "ORDR_GRNT_PRD" varchar(5), "ORDR_GRNT_FN_DT" varchar(8), "DSN_CHRGR" varchar(13), "DL_AF_PROJ_NM" varchar(120), "DL_AF_RL_CLNT" varchar(10), "DL_AF_SHPSRV_SCP" varchar(10), "DL_AF_NTTP" varchar(3), "DL_AF_CLS" varchar(20), "DL_AF_CALL_SIGN" varchar(20), "DL_AF_TEL_NO" varchar(20), "DL_AF_FAX_NO" varchar(20), "DL_AF_EMAIL_ADR" varchar(60), "PROJ_WBS_TP" varchar(7), "XSTAT" varchar(1), "XMSGS" text, "XDATS" varchar(8), "XTIMS" varchar(6), "CHN_PROJ_TP" varchar(1), "FIN_GRNT_FN_DT" varchar(8), "STDT" varchar(8), "SERS_YN" varchar(1), "TYPE" varchar(10), "PRO_PROJ_NO" varchar(24), "PBSD_PROJ_NO" varchar(24), "PBSD_SHIP_NM" varchar(150), "BIZCLS" varchar(10), "CLS_2" varchar(20), "SHTYPE_CD" varchar(6), "PROJ_DL_PLN_DT" varchar(8), "PROJ_DL_RT_DT" varchar(8), "TOT_AREA" numeric, "EXMPT_AREA" numeric, "EXMPT_RAT" numeric, "QM_CLS" varchar(10), "CNCT_PROJ_NO" varchar(24), "EQP_DTL_YN" varchar(1), "EXP_YN" varchar(1), "ACT_MH_YN" varchar(1), "SPEC" varchar(10), "DSGN_LIFE" varchar(10), "NEW_MC_YN" varchar(10), "WK_ENV_WT_VAL_YN" varchar(1), "GRNT_STDT" varchar(8), "TMH_ADPT_YN" varchar(1), "ZV_YN" varchar(1), "SEC_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_proj_wbs" ( "PROJ_NO" varchar(24) NOT NULL, "WBS_ELMT" varchar(24) NOT NULL, "WBS_ELMT_NM" varchar(255), "WBS_LVL" varchar(3), "FLAG" varchar(1), "WBS_INSD_ELMT" varchar(8), "HGRK_WBS_ELMT" varchar(24), "XSTAT" varchar(1), "XMSGS" varchar(100), "XDATS" varchar(8), "XTIMS" varchar(6), "SYS_STAT" varchar(8), "WBS_ELMT_1" varchar(24), "WBS_ELMT_2" varchar(24), "WBS_ELMT_3" varchar(24), "WBS_ELMT_4" varchar(24), "WBS_ELMT_5" varchar(24), "WBS_ELMT_6" varchar(24), "WBS_ELMT_7" varchar(24), "WBS_ELMT_8" varchar(24), "WBS_ELMT_9" varchar(24), "WBS_ELMT_10" varchar(24) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_addr" ( "VNDRCD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "INTL_ADR_VER_ID" varchar(1) NOT NULL, "CITY_ZIP_NO" varchar(10), "POBX_ZIP_NO" varchar(10), "ADR_1" varchar(120), "ADR_2" varchar(120), "REGN_CD" varchar(5), "TTL" varchar(90), "VNDRNM_ABRV_1" varchar(60), "VNDRNM_ABRV_2" varchar(60), "VNDRNM_1" varchar(120), "VNDRNM_2" varchar(120), "LANG_KEY" varchar(1), "ETC_ADR_1" varchar(180), "ETC_ADR_2" varchar(180), "NTN_CD" varchar(3), "POBX" varchar(30), "TRANS_ZONE" varchar(10), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "VNDRNM_3" varchar(120), "VNDRNM_4" varchar(120), "TAX_JRDT_ZONE_CD" varchar(15), "ADR_TMZ" varchar(10) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_compny" ( "VNDRCD" varchar(10) NOT NULL, "CO_CD" varchar(4) NOT NULL, "CTL_ACNT" varchar(10), "SRT_KEY" varchar(3), "PLN_GRP" varchar(10), "BF_VNDRCD" varchar(10), "SPLY_COND" varchar(4), "OVLAP_INVC_ORDR" varchar(1), "SPLY_MTHD" varchar(10), "SPLY_HOLD_ORDR" varchar(1), "TRD_BANK_SHRT_KEY" varchar(5), "PST_HOLD_ORDR" varchar(1), "HOLD_CAUS" varchar(200), "DEL_ORDR" varchar(1), "SRCE_TX_NTN_CD" varchar(3), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "MIN_ORDR" varchar(3), "SPRT_SPLY_ORDR" varchar(1), "CSTM_VNDR_CLR_ORDR" varchar(1), "SRCE_TX_CD" varchar(2), "IATA_BIC_GB" varchar(4), "REP_TP" varchar(6), "LOGST_VNDR_TP" varchar(6), "VNDR_ACNT_NO" varchar(12), "VNDR_CHRGR_NM" varchar(45), "ACOT_CHRGR_TELNO" varchar(30), "AUTH_GRP" varchar(8), "FIN_IR_CALC_DT" varchar(8), "FIN_IR_ACT_DT" varchar(8), "ACOT_CHRGR_FAXNO" varchar(31), "MK_CHRGR_EMAIL" varchar(241), "MEMO" varchar(120), "MOFFC_ACNT_NO" varchar(10), CONSTRAINT "cmctb_vendor_compny_VNDRCD_CO_CD_pk" PRIMARY KEY("VNDRCD","CO_CD") ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_general" ( "VNDRCD" varchar(10) NOT NULL, "ACNT_GRP" varchar(4), "ACNT_GRP_TP" varchar(2), "CSTM_CD" varchar(10), "PST_HOLD_ORDR" varchar(1), "PUR_HOLD_ORDR" varchar(1), "HOLD_CAUS" varchar(200), "DEL_ORDR" varchar(1), "CO_ID" varchar(6), "REPR_NM" varchar(30), "BIZTP" varchar(90), "BIZCON" varchar(90), "REG_DT" varchar(8), "REG_DTM" varchar(6), "REGR_ID" varchar(13), "AGR_DT" varchar(8), "AGR_TM" varchar(6), "AGR_R_ID" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "CHGR_ID" varchar(13), "NTN_CD" varchar(3), "REP_TEL_NO" varchar(30), "REP_FAX_NO" varchar(31), "BIZR_NO" varchar(10), "CO_REG_NO" varchar(18), "TX_CD_4" varchar(54), "CO_INST_DT" varchar(8), "VNDR_TP" varchar(2), "GBL_TOP_CD" varchar(11), "GBL_TOP_NM" varchar(120), "DMST_TOP_CD" varchar(11), "DMST_TOP_NM" varchar(120), "BIZ_UOM_CD" varchar(11), "BIZ_UOM_NM" varchar(120), "DNS_NO" varchar(11), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "TTL" varchar(45), "VAT_REG_NO" varchar(20), "GIRO_VNDR_ORDR" varchar(1), "VNDRNM_1" varchar(120), "VNDRNM_2" varchar(120), "VNDRNM_3" varchar(120), "VNDRNM_4" varchar(120), "VNDRNM_ABRV_1" varchar(60), "VNDRNM_ABRV_2" varchar(60), "PTNT_VNDRCD" varchar(10), "ADR_1" varchar(120), "ADR_2" text, "QLT_CHRGR_NM" varchar(60), "QLT_CHRGR_TELNO" varchar(30), "QLT_CHRGR_EMAIL" varchar(241), "SB_WKA_SEQ" varchar(16), "OVLAP_CAUS_CD" varchar(2), "DOC_TP" varchar(3), "DOC_NO" varchar(25), "PTN_DOC" varchar(3), "DOC_VER" varchar(2), "INB_FLAG" varchar(1), "DEL_HOLD_ORDR" varchar(1), "PUR_HOLD_DT" varchar(8), "POBX" varchar(30), "INTL_LCTN_CHK_NUM" numeric, "SRCETX_RP_SEX_KEY" varchar(1), "VNDR_CNRT_CHRGR_1" varchar(105), "VNDR_CNRT_CHRGR_2" varchar(105), "REPR_RESNO" varchar(13), "CO_VLM" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_grp" ( "VNDRCD" varchar(10) NOT NULL, "BIZ_GRP_CD" varchar(3) NOT NULL, "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CRTER_ID" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "CHGR_ID" varchar(13) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_inco" ( "VNDRCD" varchar(10) NOT NULL, "VNDRNM" varchar(120), "REPR_NM" varchar(30), "PRTNR_GB" varchar(1), "INCO_PRTNR_CD" varchar(3), "INCO_PRTNR_WKA_1" varchar(1), "INCO_PRTNR_WKA_2" varchar(1), "INCO_PRTNR_WKA_3" varchar(1), "JBTYPE_CD" varchar(2), "JBTYPE_CD_2" varchar(2), "INDV_CO_GB" varchar(2), "INCO_FOND_YN" varchar(1), "DOCK_NO" varchar(25), "OCMP_INP_DT" varchar(8), "INCO_DUSE_DT" varchar(8), "INDST_INS_PMRAT" numeric, "CNRT_PFRM_GRAMT" numeric, "WGE_RAT" numeric, "CRSPD_DEPTCD_1" varchar(30), "CRSPD_DEPTCD_2" varchar(30), "CRSPD_TEAM_BLNG" varchar(100), "INCO_PRTNR_ITM_1" varchar(120), "INCO_PRTNR_ITM_2" varchar(120), "OFC_LOC" varchar(240), "REP_OCMP_CARR" text, "INCO_DUSE_CAUS" text, "TEL_NO" varchar(30), "ADR1" varchar(200), "ADR2" varchar(200), "OLD_VNDRCD" varchar(10), "TREE_NUM" varchar(1), "CRTE_DT" varchar(8), "CRTE_TM" varchar(6), "CRTE_USR_ID" varchar(13), "CHG_DT" varchar(8), "CHG_TM" varchar(6), "CHG_USR_ID" varchar(13), "UPR_JBTYPE" varchar(2), "ZBYBP" varchar(4), "RMK" text, "WDL_PLN_YN" varchar(1), "WGE_DELY_DVL" varchar(8), "ESCROW_YN" varchar(1) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_porg" ( "VNDRCD" varchar(10) NOT NULL, "PUR_ORG_CD" varchar(4) NOT NULL, "PUR_ORD_CUR" varchar(5), "SPLY_COND" varchar(4), "DL_COND_1" varchar(3), "DL_COND_2" varchar(90), "CALC_SHM_GRP" varchar(2), "GR_BSE_INVC_VR" varchar(1), "AT_PUR_ORD_ORDR" varchar(1), "PUR_HOLD_ORDR" varchar(1), "DEL_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100), "ORD_CNFM_REQ_ORDR" varchar(1), "SALE_CHRGR_NM" varchar(120), "VNDR_TELNO" varchar(30), "CNFM_CTL_KEY" varchar(4), "PUR_HOLD_DT" varchar(8), "PUR_HOLD_CAUS" varchar(120) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_repremail" ( "VNDRCD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "EMAIL_ADR" varchar(241), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_reprfax" ( "VNDRCD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "NTN_CD" varchar(3), "FAXNO" varchar(30), "FAX_ETS_NO" varchar(10), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_reprtel" ( "VNDRCD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "NTN_CD" varchar(3), "TELNO" varchar(30), "ETX_NO" varchar(10), "HP_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_reprurl" ( "VNDRCD" varchar(10) NOT NULL, "ADR_NO" varchar(10), "REPR_SER" varchar(3) NOT NULL, "VLD_ST_DT" varchar(8) NOT NULL, "URL" text, "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_taxnum" ( "VNDRCD" varchar(10) NOT NULL, "TX_NO_CTG" varchar(4) NOT NULL, "BIZ_PTNR_TX_NO" varchar(20), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_vfpn" ( "VNDRCD" varchar(10) NOT NULL, "PUR_ORG_CD" varchar(4) NOT NULL, "VNDR_SUB_NO" varchar(6) NOT NULL, "PLNT_CD" varchar(4) NOT NULL, "PTNR_SKL" varchar(2) NOT NULL, "PTNR_CNT" varchar(3) NOT NULL, "ETC_REF_VNDRCD" varchar(10), "BSE_PTNR_ORDR" varchar(1), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."cmctb_vendor_whthx" ( "VNDRCD" varchar(10) NOT NULL, "CO_CD" varchar(4) NOT NULL, "SRCE_TX_TP" varchar(2) NOT NULL, "SRCE_TX_REL_ORDR" varchar(1), "RECIP_TP" varchar(2), "SRCE_TX_IDENT_NO" varchar(16), "SRCE_TX_NO" varchar(2), "DCHAG_CERT_NO" varchar(15), "DCHAG_RAT" numeric, "DCHAG_ST_DT" varchar(8), "DCHAG_ED_DT" varchar(8), "DCHAG_CAUS" varchar(200), "IF_DT" varchar(8), "IF_TM" varchar(6), "IF_STAT" varchar(1), "IF_MSG" varchar(100) ); --> statement-breakpoint CREATE TABLE "nonsap"."plftb_estm_proj_mast" ( "ESTM_PROJ_NO" varchar(24) NOT NULL, "AGND_NO" varchar(8), "ESTM_PROJ_NM" varchar(100), "BIZ_CLS" varchar(1), "REV_NO" numeric, "ESTM_TYPE" varchar(1), "OWNER_CD" varchar(10), "SERS_CNT" numeric, "SKND_CD" varchar(10), "SHTYPE_CD" varchar(10), "SHTYPE_SIZE" numeric, "SHTYPE_UOM" varchar(10), "CHRTR_CD" varchar(10), "NATN_CD" varchar(10), "CLS_1" varchar(10), "CLS_2" varchar(10), "CLS_3" varchar(10), "DATA_CRTE_GB" varchar(2), "FS_INPR_ID" varchar(13), "FS_INP_DTM" varchar(14), "FIN_CHGR_ID" varchar(13), "FIN_CHG_DTM" varchar(14), "VSL_VAG_1" numeric, "VSL_VAG_2" numeric, "VSL_VAG_3" numeric, "VSL_VAG_4" numeric, "ESTM_AOM_APP_ID" varchar(32), "ESTM_AOM_STAT" varchar(1), "ESTM_AOM_STAT_CHGR_ID" varchar(13), "ESTM_AOM_STAT_CHG_DTM" varchar(14), "IF_TRGT_YN" varchar(1), CONSTRAINT "plftb_estm_proj_mast_ESTM_PROJ_NO_pk" PRIMARY KEY("ESTM_PROJ_NO") );