-- [김준회] 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")
);
