CREATE TABLE `tb_li_gerp_sew_ship` ( `pk_id` int(11) NOT NULL AUTO_INCREMENT, `corp_type` varchar(5) COLLATE utf8_bin DEFAULT NULL COMMENT '회사구분', `DC_CD` varchar(3) COLLATE utf8_bin DEFAULT NULL COMMENT '물류센터코드', `SHIPPING_LINE1` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `SHIPPING_LINE2` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `CARRIER_CODE1` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `CARRIER_CODE2` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `ORDER_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'GERP Order No', `LINE_NO` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'GERP Order Line No', `ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Allocation NO', `CC_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Allocation NO', `TOTAL_SHP_QTY` decimal(12,0) NOT NULL DEFAULT '0' COMMENT 'Total Ship Qty', `ORDER_QTY` decimal(12,0) DEFAULT NULL COMMENT 'Order Qty', `INVOICE_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Invoice No', `AFFILIATE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Y - 관계사, N -비관계사', `SHIP_METHOD` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Shipping Method', `TRANSPORT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `ACCOUNT_UNIT` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'Accounting Unit Code', `WEIGHT` decimal(19,5) NOT NULL DEFAULT '0.00000' COMMENT 'Weight', `UNIT_CBM` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Unit CBM', `CBM_SUM` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Order별 Total CBM', `PICK_RELEASE_DATE` datetime DEFAULT NULL COMMENT 'Pick Release Date', `PG_YMD` datetime DEFAULT NULL COMMENT '출하일', `IOD_DATE` datetime DEFAULT NULL COMMENT '매출 확정일', `CURRENCY_CODE` varchar(10) COLLATE utf8_bin DEFAULT NULL, `ORDER_PRICE` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Unit Selling Price', `ORDER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Order Type : Regular / Customer Pick Up 등등', `CONTAINER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '20FT, 40FT, 40HC, 45FT, 48FT...', `LCL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Y - LCL, N - FCL', `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 COMMENT '거래처코드', `BILL_TO_NAME` varchar(300) COLLATE utf8_bin DEFAULT NULL, `SHIP_TO_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL COMMENT '인도처코드', `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 COMMENT 'Destination Code', `NATION` varchar(5) COLLATE utf8_bin DEFAULT NULL COMMENT '국가 Code', `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 COMMENT 'departure place', `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 COMMENT '변경된 정보여부 판단 Flag. NEW/UPDATE/CANCEL', `ORIGIN_ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL, `DROP_QTY` decimal(12,0) NOT NULL DEFAULT '0' COMMENT '경유지 수', `INTERFACE_ID` bigint(20) NOT NULL COMMENT 'seq한 번호, ALLOCATION별로 같은 값', `OPTION_NO` decimal(20,6) DEFAULT NULL COMMENT 'GERP Order Option No', `SERVICE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Service 비용 여부', `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' COMMENT 'GSI로 데이터를 보내기위해 관리하는 컬럼', `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' COMMENT 'LOADING 시 에러가 발생하면 해당 테이블에 ERROR FLAG 마킹 후 MQ에서는 TRANSFER_FLAG = E 이면서 해당 FLAG가 N 인 건만 EDI로 전송', `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, `ATTRIBUTE21` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE22` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE23` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE24` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE25` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE26` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE27` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE28` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE29` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE30` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE31` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE32` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE33` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE34` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE35` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE36` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE37` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE38` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE39` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE40` 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`), KEY `TB_LI_GERP_SEW_SHIP_N11` (`corp_type`,`SOURCE_SYSTEM_CODE`,`TRANSFER_FLAG1`), KEY `TB_LI_GERP_SEW_SHIP_N12` (`corp_type`,`DC_CD`,`TRANSFER_FLAG`,`SERVICE_FLAG`,`PG_YMD`), KEY `TB_LI_GERP_SEW_SHIP_N13` (`corp_type`,`DC_CD`,`TRANSFER_FLAG`,`SERVICE_FLAG`,`CONTAINER_NO`), KEY `tb_li_gerp_sew_ship_n14` (`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N15` (`corp_type`,`CONTAINER_tXN_ID`,`SOURCE_SYSTEM_CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=8162924 DEFAULT CHARSET=utf8 COLLATE=utf8_bin