window.repositoryObject = {"parameters_custom_fields":[],"object_id":"p387","name":"cus_netpathy_mail_withdrawal_ins","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"cus_netpathy_mail_withdrawal_ins"},{"field":"Type","value":"Procedure"}],"script":"BEGIN\r\n\t/* TsbCustomerDao.truncateNetpathyMailWithdrawalCustomer */\r\n\tTRUNCATE TABLE STYLE24_MAILBATCH.NETPATHY_WITHDRAWAL;\r\n    \r\n    /* TsbCustomerDao.createNetpathyMailWithdrawalCustomer */\r\n\t\tINSERT INTO STYLE24_MAILBATCH.NETPATHY_WITHDRAWAL (\r\n\t\t       CUST_NO\r\n\t\t     , CUST_ID\r\n\t\t     , CUST_NM\r\n\t\t     , JOIN_DT\r\n\t\t     , REG_DT\r\n\t\t)\r\n\t\tSELECT CUST_NO                              /*회원GUID(=회원번호)*/\r\n\t\t     , CUST_ID                              /*로그인ID(=회원ID)*/\r\n\t\t     , CUST_NM                              /*회원명(암호화된값)*/\r\n\t\t     , IFNULL(JOIN_DT,SECEDE_DT) AS JOIN_DT /*가입일시*/\r\n\t\t     , SECEDE_DT                 AS REG_DT  /*등록일시*/\r\n\t\tFROM   TB_SECEDE_CUST\r\n\t\tUNION ALL\r\n\t\tSELECT CUST_NO              /*회원GUID(=회원번호)*/\r\n\t\t     , CUST_ID              /*로그인ID(=회원ID)*/\r\n\t\t     , CUST_NM              /*회원명(암호화된값)*/\r\n\t\t     , JOIN_DT              /*가입일시*/\r\n\t\t     , DORMANT_DT AS REG_DT /*등록일시*/\r\n\t\tFROM   TB_DORMANT_CUST;\r\nEND","parameters":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};