CREATE TABLE `tb_lm_model` ( `CORP_TYPE` varchar(5) COLLATE utf8_bin NOT NULL , `MODEL_CD` varchar(50) COLLATE utf8_bin NOT NULL , `DIV_CD` varchar(3) COLLATE utf8_bin NOT NULL , `MODEL_NM` varchar(480) COLLATE utf8_bin DEFAULT NULL , `ORD_SYS_MODEL_ID` varchar(80) COLLATE utf8_bin DEFAULT NULL , `CDC_CD` varchar(3) COLLATE utf8_bin DEFAULT NULL , `PROD_CLASS_CD` varchar(8) COLLATE utf8_bin DEFAULT NULL , `PRODUCT_PRICE` decimal(16,0) NOT NULL DEFAULT '0' , `SHP_PRICE` decimal(16,0) NOT NULL DEFAULT '0' , `L_CLASS_CD` varchar(4) COLLATE utf8_bin DEFAULT NULL , `M_CLASS_CD` varchar(5) COLLATE utf8_bin DEFAULT NULL , `S_CLASS_CD` varchar(6) COLLATE utf8_bin DEFAULT NULL , `VAL_CATEGORY_CD` varchar(9) COLLATE utf8_bin DEFAULT NULL , `FUNC_CATEGORY_CD1` varchar(7) COLLATE utf8_bin DEFAULT NULL , `FUNC_CATEGORY_CD2` varchar(7) COLLATE utf8_bin DEFAULT NULL , `FUNC_CATEGORY_CD3` varchar(7) COLLATE utf8_bin DEFAULT NULL , `FUNC_CATEGORY_CD4` varchar(8) COLLATE utf8_bin DEFAULT NULL , `GLOB_MODEL_CD` varchar(150) COLLATE utf8_bin DEFAULT NULL , `GLOB_SUFFIX_CD` varchar(150) COLLATE utf8_bin DEFAULT NULL , `KAN_CD` varchar(150) COLLATE utf8_bin DEFAULT NULL , `BAR_CD` varchar(20) COLLATE utf8_bin DEFAULT NULL , `MAKER_CD` varchar(40) COLLATE utf8_bin DEFAULT NULL , `WIDTH` decimal(19,5) NOT NULL DEFAULT '0.00000' , `LENTH` decimal(19,5) NOT NULL DEFAULT '0.00000' , `HGT` decimal(19,5) NOT NULL DEFAULT '0.00000' , `CBM` decimal(20,6) NOT NULL DEFAULT '0.000000' , `TOT_WHT` decimal(19,5) NOT NULL DEFAULT '0.00000' , `NET_WHT` decimal(19,5) NOT NULL DEFAULT '0.00000' , `GNP_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL , `UNIT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL , `BULK_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL , `MODEL_SORT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT '*' , `PALLET_CD` varchar(10) COLLATE utf8_bin DEFAULT NULL , `PALLET_WIDTH_QTY` decimal(9,0) NOT NULL DEFAULT '0' , `PALLET_LENTH_QTY` decimal(9,0) NOT NULL DEFAULT '0' , `PALLET_STACK_BUNDLE_CNT` double NOT NULL DEFAULT '0' , `PALLET_PER_QTY` decimal(9,0) NOT NULL DEFAULT '0' , `TON_BULK_RATIO` decimal(19,2) NOT NULL DEFAULT '0.00' , `HD_MODEL_REGUL_CD` varchar(8) COLLATE utf8_bin DEFAULT NULL , `MIN_GIV_ORD_AMT` decimal(9,0) NOT NULL DEFAULT '0' , `PRV_USE_MODEL_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `MNG_TARGET_MODEL_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `GIV_ORD_ABLE_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'Y' , `SHP_HOLD_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `SPECIAL_TAX_RATIO` decimal(5,2) NOT NULL DEFAULT '0.00' , `SET_MODEL_YN` char(1) COLLATE utf8_bin DEFAULT NULL , `PREMIUM_PROD_YN` char(1) COLLATE utf8_bin DEFAULT 'N' , `HD_ORD_ABLE_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `SERIAL_NO_MNG_YN` char(1) COLLATE utf8_bin DEFAULT NULL , `SERIAL_NO_MNG_QTY` decimal(9,0) NOT NULL DEFAULT '0' , `INIT_REGIST_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP , `STOCK_SUPPLY_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `MODEL_TYPE` varchar(5) COLLATE utf8_bin NOT NULL , `FINAL_USER_ID` varchar(20) COLLATE utf8_bin NOT NULL , `FINAL_UPDATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP , `USE_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'Y' , `MAKER_NM` varchar(480) COLLATE utf8_bin DEFAULT NULL , `KAN_CD_INIT` varchar(150) COLLATE utf8_bin DEFAULT NULL, `BAR_CD_INIT` varchar(20) COLLATE utf8_bin DEFAULT NULL, `KAN_CD_CONFIRM_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N', `PROD_STOP_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `ATTRIBUTE1` varchar(480) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE2` varchar(480) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE3` varchar(480) COLLATE utf8_bin DEFAULT NULL, `SS_SAFETY_STOCK_MNG_YN` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'N' , `SALES_DIV_CD` varchar(3) COLLATE utf8_bin DEFAULT NULL, `MODEL_DIV_CD` varchar(1) COLLATE utf8_bin DEFAULT NULL, `PRODUCT_CD` varchar(8) COLLATE utf8_bin DEFAULT NULL, `PALLET_HGT_QTY` decimal(9,0) NOT NULL DEFAULT '0', `PALLET_STACK_QTY` decimal(9,0) NOT NULL DEFAULT '0', `INNER_BOX_QTY` decimal(13,4) DEFAULT '1.0000', `INBOUND_SERIAL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N', `OUTBOUND_SERIAL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N', `RETURN_SERIAL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N', `SYS_FINAL_UPDATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP , `ORD_SYS_REGIST_DATE` datetime DEFAULT NULL , `ORD_SYS_FINAL_UPDATE_DATE` datetime DEFAULT NULL , `CUSTOMER_MODEL_CODE` varchar(50) COLLATE utf8_bin DEFAULT NULL , `MARKET` varchar(1) COLLATE utf8_bin DEFAULT NULL , `PUR_TYPE` varchar(1) COLLATE utf8_bin DEFAULT NULL , `DIVISION_CODE` varchar(5) COLLATE utf8_bin DEFAULT NULL , `OLD_PRODUCT_CD` varchar(8) COLLATE utf8_bin DEFAULT NULL , `OLD_PROD_CLASS_CD` varchar(8) COLLATE utf8_bin DEFAULT NULL , `CARRIER_CBM` decimal(20,6) DEFAULT '0.000000' , `CARRIER_CBM_DATE` datetime DEFAULT NULL , `UNIT_CBM` decimal(20,6) NOT NULL DEFAULT '0.000000', `MODEL_CATEGORY_CODE` varchar(30) COLLATE utf8_bin DEFAULT NULL , `CHARGEABLE_WHT` decimal(19,5) NOT NULL DEFAULT '0.00000' , `CHARGEABLE_WHT_CFM_YN` char(1) COLLATE utf8_bin DEFAULT 'N' , `CHARGEABLE_WHT_CFM_DATE` datetime DEFAULT NULL , `model_spec` varchar(10) COLLATE utf8_bin DEFAULT NULL , `CREATE_USER_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL, `CREATE_DATE` datetime DEFAULT NULL, `SYS_CREATE_DATE` datetime DEFAULT NULL, PRIMARY KEY (`MODEL_CD`,`CORP_TYPE`), KEY `TB_LM_MODEL_N09` (`ORD_SYS_MODEL_ID`,`CORP_TYPE`), KEY `TB_LM_MODEL_N01` (`CORP_TYPE`,`DIV_CD`,`USE_YN`), KEY `TB_LM_MODEL_N02` (`L_CLASS_CD`,`M_CLASS_CD`,`CORP_TYPE`), KEY `TB_LM_MODEL_N04` (`CDC_CD`,`CORP_TYPE`,`DIV_CD`,`MODEL_CD`), KEY `TB_LM_MODEL_N08` (`CORP_TYPE`,`FINAL_UPDATE_DATE`), KEY `TB_LM_MODEL_N10` (`CORP_TYPE`,`DIVISION_CODE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ; CREATE TABLE `tb_li_gerp_sew_ship` ( `pk_id` int(11) NOT NULL AUTO_INCREMENT, `corp_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `DC_CD` varchar(3) COLLATE utf8_bin DEFAULT NULL , `SHIPPING_LINE1` varchar(10) COLLATE utf8_bin DEFAULT NULL , `SHIPPING_LINE2` varchar(10) COLLATE utf8_bin DEFAULT NULL , `CARRIER_CODE1` varchar(10) COLLATE utf8_bin DEFAULT NULL , `CARRIER_CODE2` varchar(10) COLLATE utf8_bin DEFAULT NULL , `ORDER_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL , `LINE_NO` double NOT NULL DEFAULT '0' , `ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL , `CC_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL , `TOTAL_SHP_QTY` double NOT NULL DEFAULT '0' , `ORDER_QTY` double DEFAULT NULL , `INVOICE_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL , `AFFILIATE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL , `SHIP_METHOD` varchar(30) COLLATE utf8_bin DEFAULT NULL , `TRANSPORT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `ACCOUNT_UNIT` varchar(10) COLLATE utf8_bin DEFAULT NULL , `WEIGHT` decimal(19,5) NOT NULL DEFAULT '0.00000' , `UNIT_CBM` decimal(19,6) NOT NULL DEFAULT '0.000000' , `CBM_SUM` decimal(19,6) NOT NULL DEFAULT '0.000000' , `PICK_RELEASE_DATE` datetime DEFAULT NULL , `PG_YMD` datetime DEFAULT NULL , `IOD_DATE` datetime DEFAULT NULL , `CURRENCY_CODE` varchar(10) COLLATE utf8_bin DEFAULT NULL, `ORDER_PRICE` decimal(19,6) NOT NULL DEFAULT '0.000000' , `ORDER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL , `CONTAINER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL , `LCL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL , `CONTAINER_NO` varchar(20) COLLATE utf8_bin DEFAULT NULL, `MODEL_CD` varchar(50) COLLATE utf8_bin DEFAULT NULL, `PRODUCT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `BILL_TO_CODE` varchar(50) COLLATE utf8_bin DEFAULT NULL , `BILL_TO_NAME` varchar(300) COLLATE utf8_bin DEFAULT NULL, `SHIP_TO_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL , `SHIP_TO_NAME` varchar(150) COLLATE utf8_bin DEFAULT NULL, `L_PORT` varchar(5) COLLATE utf8_bin DEFAULT NULL, `D_PORT` varchar(5) COLLATE utf8_bin DEFAULT NULL, `F_DEST` varchar(5) COLLATE utf8_bin DEFAULT NULL , `NATION` varchar(5) COLLATE utf8_bin DEFAULT NULL , `TRANSFER_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N', `TRANSFER_DATE` datetime DEFAULT NULL, `CREATION_DATE` datetime DEFAULT NULL, `LAST_UPDATE_DATE` datetime DEFAULT NULL, `PRCS_MESSAGE` varchar(200) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE1` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE2` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE3` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE4` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE5` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE6` varchar(150) COLLATE utf8_bin DEFAULT NULL , `ATTRIBUTE7` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE8` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE9` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE10` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE11` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE12` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE13` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE14` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE15` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE16` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE17` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE18` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE19` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE20` varchar(150) COLLATE utf8_bin DEFAULT NULL, `LAST_UPDATE_USER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `PRCS_STATUS` varchar(1) COLLATE utf8_bin DEFAULT 'N', `TRANSFER_MESSAGE` varchar(200) COLLATE utf8_bin DEFAULT NULL, `PRICE_TERMS` varchar(10) COLLATE utf8_bin DEFAULT NULL, `PAYMENT_TERM` varchar(30) COLLATE utf8_bin DEFAULT NULL, `CUSTOMER_PO_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `INFO_CHANGE_FLAG` varchar(10) COLLATE utf8_bin DEFAULT NULL , `ORIGIN_ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL, `DROP_QTY` double NOT NULL DEFAULT '0' , `INTERFACE_ID` double NOT NULL , `OPTION_NO` double DEFAULT NULL , `SERVICE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL , `loading_type_code` varchar(40) COLLATE utf8_bin DEFAULT NULL, `SOURCE_SYSTEM_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL, `CONTAINER_tXN_ID` bigint(20) DEFAULT NULL, `LOAD_CONFIRM_DATE` datetime DEFAULT NULL, `RETURN_ORDER_DATE` datetime DEFAULT NULL, `SHUTTLE_QTY` decimal(22,0) NOT NULL DEFAULT '0', `EXPENSE_ID` bigint(20) DEFAULT NULL, `TRANSFER_FLAG1` varchar(1) COLLATE utf8_bin DEFAULT 'B' , `COMPANY_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL, `SEAL_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_INTERFACE_DATE` datetime DEFAULT NULL, `TRANSFER_DATE1` datetime DEFAULT NULL, `ERROR_EDI_INTERFACE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N' , `ERROR_EDI_INTERFACE_DATE` datetime DEFAULT NULL, `STEP_CODE` varchar(30) COLLATE utf8_bin DEFAULT NULL, `STEP_STATUS_CODE` varchar(30) COLLATE utf8_bin DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_NO` varchar(70) COLLATE utf8_bin DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_DATE` datetime DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_STATUS_CODE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `EDI_ERROR_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL, `EDI_ERROR_MESSAGE_TEXT` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `EDI_SENDER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_RECEIVER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `XML_DOCUMENT_NO` varchar(100) COLLATE utf8_bin DEFAULT NULL, `DOCUMENT_SEQ_NO` int(11) DEFAULT NULL, `EDI_ENVELOPE_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_GROUP_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_TRANSACTION_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `TRANSACTION_DATE` datetime DEFAULT CURRENT_TIMESTAMP, `D_PLACE_NAME` varchar(150) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`pk_id`), KEY `TB_LI_GERP_SEW_SHIP_N04` (`corp_type`,`ALLOCATION_NO`,`CONTAINER_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N05` (`corp_type`,`TRANSFER_FLAG`,`PRCS_STATUS`), KEY `TB_LI_GERP_SEW_SHIP_N02` (`corp_type`,`DC_CD`,`CONTAINER_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N07` (`corp_type`,`DC_CD`,`PRCS_STATUS`,`SERVICE_FLAG`,`PG_YMD`), KEY `TB_LI_GERP_SEW_SHIP_N01` (`corp_type`,`DC_CD`,`ALLOCATION_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N06` (`corp_type`,`DC_CD`,`CONTAINER_NO`,`PG_YMD`,`INTERFACE_ID`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N08` (`CONTAINER_NO`,`INTERFACE_ID`), KEY `TB_LI_GERP_SEW_SHIP_N09` (`INTERFACE_ID`,`EDI_SENDER_ID`,`EDI_RECEIVER_ID`,`TRANSACTION_DATE`), KEY `TB_LI_GERP_SEW_SHIP_n10` (`TRANSFER_FLAG1`) ) ENGINE=InnoDB AUTO_INCREMENT=8012623 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ; CREATE TABLE `tb_lm_codemapping` ( `CD_TYPE` varchar(5) COLLATE utf8_bin NOT NULL , `CORP_TYPE` varchar(5) COLLATE utf8_bin NOT NULL , `ORD_SYS_CD` varchar(20) COLLATE utf8_bin NOT NULL , `GDLS_CD` varchar(20) COLLATE utf8_bin NOT NULL , `REMARKS` varchar(400) COLLATE utf8_bin DEFAULT NULL , `USE_YN` char(1) COLLATE utf8_bin NOT NULL , `FINAL_USER_ID` varchar(20) COLLATE utf8_bin NOT NULL , `FINAL_UPDATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP , `SYS_FINAL_UPDATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP , `MAIN_CD_YN` char(1) COLLATE utf8_bin DEFAULT 'N' , `USE_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL , `DISPLAY_ORDER` double DEFAULT '0' , `ORD_SYS_ID` varchar(80) COLLATE utf8_bin DEFAULT NULL , `CD_ATTRIBUTE1` varchar(100) COLLATE utf8_bin DEFAULT NULL , `CD_ATTRIBUTE2` varchar(100) COLLATE utf8_bin DEFAULT NULL, `CD_ATTRIBUTE3` varchar(100) COLLATE utf8_bin DEFAULT NULL , `GSCP_WH_FLAG` char(1) COLLATE utf8_bin DEFAULT NULL , `HILOERP_FLAG` char(1) COLLATE utf8_bin DEFAULT 'N' , `CD_ATTRIBUTE4` varchar(100) COLLATE utf8_bin DEFAULT NULL , `CD_ATTRIBUTE5` varchar(100) COLLATE utf8_bin DEFAULT NULL , `CD_ATTRIBUTE6` varchar(100) COLLATE utf8_bin DEFAULT NULL, `CD_ATTRIBUTE7` varchar(100) COLLATE utf8_bin DEFAULT NULL, `CD_ATTRIBUTE8` varchar(100) COLLATE utf8_bin DEFAULT NULL, `CD_ATTRIBUTE9` varchar(100) COLLATE utf8_bin DEFAULT NULL, `CD_ATTRIBUTE10` varchar(100) COLLATE utf8_bin DEFAULT NULL, `create_user_id` varchar(20) COLLATE utf8_bin DEFAULT NULL, `create_date` datetime DEFAULT NULL, `SYS_CREATE_DATE` datetime DEFAULT NULL, PRIMARY KEY (`CD_TYPE`,`CORP_TYPE`,`ORD_SYS_CD`), KEY `TB_LM_CODEMAPPING_N01` (`ORD_SYS_ID`), KEY `TB_LM_CODEMAPPING_N02` (`CD_TYPE`,`CORP_TYPE`,`GDLS_CD`,`MAIN_CD_YN`,`ORD_SYS_CD`), KEY `tb_lm_codemapping_n03` (`GDLS_CD`), KEY `TB_LM_CODEMAPPING_n04` (`CORP_TYPE`,`GDLS_CD`,`ORD_SYS_CD`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `tb_lm_dcconfig` ( `corp_type` varchar(5) COLLATE utf8_bin NOT NULL , `dc_cd` varchar(3) COLLATE utf8_bin NOT NULL , `model_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `shpto_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `cust_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `cbm_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `zone_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `course_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `palletstack_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `palletqty_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `weight_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `rating_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `ord_sys_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `wms_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `final_user_id` varchar(20) COLLATE utf8_bin NOT NULL , `final_update_date` datetime NOT NULL , `sys_final_update_date` datetime NOT NULL , `gc_confirm_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `seal_no_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `req_shp_ymd_mng_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `packing_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `delivery_note_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `date_format` varchar(10) COLLATE utf8_bin DEFAULT NULL , `thousand_sep` char(1) COLLATE utf8_bin DEFAULT NULL , `decimal_sep` char(1) COLLATE utf8_bin DEFAULT NULL , `print_lang_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `picklist_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `acct_if_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `stuffinglist_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `shpconfirm_pallet_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `trans_corp_edi_type` varchar(10) COLLATE utf8_bin DEFAULT NULL , `zone_by_zip_code_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `receipt_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `reject_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `delay_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `extra_partial_available_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `pod_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `back_ord_make_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `sales_partial_available_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `shp_hold_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `truck_no_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `cust_edi_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `extra_acct_if_type` varchar(200) COLLATE utf8_bin DEFAULT NULL , `territory_expense_calc_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `ord_sys_trans_corp_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `connected_deliv_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `nota_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `auto_rma_make_by_rej_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `multi_time_delay_able_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `extra_trans_corp_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `dc_combo_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `auto_receive_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `gdls_type` varchar(5) COLLATE utf8_bin DEFAULT NULL, `prodin_manual_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `container_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `wms_dblink_nm` varchar(50) COLLATE utf8_bin DEFAULT NULL , `ord_sys_dblink_nm` varchar(50) COLLATE utf8_bin DEFAULT NULL , `gdls_stockexp_create_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `zone_by_city_code_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `export_ship_model_all_mng_yn` char(1) COLLATE utf8_bin DEFAULT NULL, `delivery_note_popup_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `sal_ord_cancel_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `lp_auto_select_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `prod_in_auto_close_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `rate_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `in_expect_qty_print_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `invoice_approval_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `dc_acct_dept_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `delivery_note_print_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `delivery_no_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `delivery_no_set_point` varchar(5) COLLATE utf8_bin DEFAULT NULL , `rate_approval_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `stack_ratio_check_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `ord_acct_dept_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `ord_amt_display_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `wh_tran_gcoa_mapping_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `wh_tran_gcoa_code` varchar(20) COLLATE utf8_bin DEFAULT NULL , `no_tax_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `make_shipment_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `wh_tran_expense_by_sales_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `alloc_gbu_check_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `amount_decimal_digit` decimal(22,0) NOT NULL DEFAULT '0' , `tax2_use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `fare_decimal_digit` decimal(22,0) NOT NULL DEFAULT '0' , `delivery_note_print_point` varchar(5) COLLATE utf8_bin DEFAULT NULL , `lge_delivery_flag_usg_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `iod_interface_sys_type` char(2) COLLATE utf8_bin DEFAULT NULL , `iod_ifrs_apply` char(1) COLLATE utf8_bin DEFAULT NULL , `iod_do_corp` char(1) COLLATE utf8_bin DEFAULT NULL , `cust_pick_up_iod_flag` char(1) COLLATE utf8_bin DEFAULT NULL , `air_conversion_rate` decimal(10,2) NOT NULL DEFAULT '0.00' , `iod_holiday_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `eutms_if_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `eutms_hilo_buying_cd` varchar(10) COLLATE utf8_bin DEFAULT NULL , `truck_alloc_in_lp_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `shpreq_if_to_ipl_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `truck_cbm_def_rate` decimal(22,0) NOT NULL DEFAULT '0' , `truck_cbm_min_rate` decimal(22,0) NOT NULL DEFAULT '0' , `loadmerge_print_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `hilo_ap_flag` char(1) COLLATE utf8_bin DEFAULT NULL , `hilo_corp_type` varchar(10) COLLATE utf8_bin DEFAULT NULL , `gtms_if_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `export_if_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `hilo_erp_flag` char(1) COLLATE utf8_bin DEFAULT NULL , `domestic_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `gwms_if_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `hilo_if_flag` char(1) COLLATE utf8_bin DEFAULT NULL , `zone_type` varchar(40) COLLATE utf8_bin DEFAULT NULL, `dc_nm` varchar(480) COLLATE utf8_bin DEFAULT NULL , `logix_type` varchar(5) COLLATE utf8_bin DEFAULT NULL , `basic_addr` varchar(300) COLLATE utf8_bin DEFAULT NULL , `detail_addr` varchar(400) COLLATE utf8_bin DEFAULT NULL , `remarks` varchar(400) COLLATE utf8_bin DEFAULT NULL , `use_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `block_yn` char(1) COLLATE utf8_bin DEFAULT NULL , `glow_transfer_flag` char(1) COLLATE utf8_bin DEFAULT NULL , `glow_transfer_date` datetime DEFAULT NULL , `glow_transfer_status` varchar(250) COLLATE utf8_bin DEFAULT NULL , `create_user_id` varchar(20) COLLATE utf8_bin DEFAULT NULL, `create_date` datetime DEFAULT NULL , `TDS_USE_YN` varchar(1) COLLATE utf8_bin DEFAULT 'N' , `LOCAL_VENDOR_USE_YN` varchar(1) COLLATE utf8_bin DEFAULT 'N' , `SYS_CREATE_DATE` datetime DEFAULT NULL, PRIMARY KEY (`corp_type`,`dc_cd`), KEY `TB_LM_DCCONFIG_N02` (`corp_type`,`dc_cd`,`gdls_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;