diff options
Diffstat (limited to 'db/migrations/0182_grey_banshee.sql')
| -rw-r--r-- | db/migrations/0182_grey_banshee.sql | 1053 |
1 files changed, 1053 insertions, 0 deletions
diff --git a/db/migrations/0182_grey_banshee.sql b/db/migrations/0182_grey_banshee.sql new file mode 100644 index 00000000..2a292c71 --- /dev/null +++ b/db/migrations/0182_grey_banshee.sql @@ -0,0 +1,1053 @@ +-- [김준회] 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") +); |