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 ;