window.repositoryObject = {"parameters_custom_fields":[],"object_id":"p385","name":"cus_netpathy_mail_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_ins"},{"field":"Type","value":"Procedure"}],"script":"BEGIN\r\n\t/* TsbCustomerDao.truncateNetpathyMailCustomer */\r\n\tTRUNCATE TABLE STYLE24_MAILBATCH.NETPATHY_MEMBER;\r\n\t\r\n    /* TsbCustomerDao.createNetpathyMailCustomer */\r\n\tINSERT INTO STYLE24_MAILBATCH.NETPATHY_MEMBER (\r\n\t\t       CUST_NO\r\n\t\t     , CUST_ID\r\n\t\t     , CUST_NM\r\n\t\t     , BIRTH_YMD\r\n\t\t     , EMAIL\r\n\t\t     , EMAIL_AGREE_YN\r\n\t\t     , SEX_GB\r\n\t\t     , ZIPCODE\r\n\t\t     , JOIN_DT\r\n\t\t     , UPD_DT\r\n\t\t)\r\n\t\tSELECT C.CUST_NO                                 /*회원GUID(=회원번호)*/\r\n\t\t     , C.CUST_ID                                 /*로그인ID(=회원ID)*/\r\n\t\t     , C.CUST_NM                                 /*회원명(암호화된값)*/\r\n\t\t     , C.BIRTH_YMD                               /*생년월일(암호화된값)*/\r\n\t\t     , C.EMAIL                                   /*이메일(암호화된값)*/\r\n\t\t     , C.EMAIL_AGREE_YN                          /*메일수신여부*/\r\n\t\t     , C.SEX_GB                                  /*성별(암호화된값)*/\r\n\t\t     , CDA.RECIP_ZIPCODE              AS ZIPCODE /*우편번호*/\r\n\t\t     , IFNULL(C.JOIN_DT,'1900-01-01') AS JOIN_DT /*가입일시*/\r\n\t\t     , C.UPD_DT                                  /*수정일시*/\r\n\t\tFROM   TB_CUSTOMER C\r\n\t\tLEFT OUTER JOIN TB_CUST_DELIVERY_ADDR CDA ON C.CUST_NO = CDA.CUST_NO\r\n\t\t                                         AND CDA.DEL_YN = 'N' /*삭제안된넘*/\r\n\t\t                                         AND CDA.DEFAULT_YN = 'Y' /*기본배송지*/\r\n\t\tWHERE  CUST_STAT = 'G104_10' /*활동회원*/;\r\nEND","parameters":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};