| 1 |
- 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"};
|
