# 1. 테이블 레이아웃

### 1) QUPID\_SEND\_DATA (발송요청 테이블)

<table data-full-width="true"><thead><tr><th width="219">컬럼ID</th><th width="174">데이터타입</th><th width="560">컬럼명</th><th width="56" data-type="checkbox">M</th><th width="54" data-type="checkbox">P</th><th width="69" data-type="checkbox">필수</th></tr></thead><tbody><tr><td>SEQ_NO</td><td>NUMBER</td><td>일련번호</td><td>true</td><td>true</td><td>true</td></tr><tr><td>REQ_TYPE</td><td>VARCHAR2(2)</td><td>요청구분(01:접수, 02:발송, *03:접수+발송, 07:취소요청)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>REQ_GUID</td><td>VARCHAR2(64)</td><td>요청GUID (큐피드에서 발급, 상태조회시 식별키로 사용)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>CUST_ID</td><td>VARCHAR2(30)</td><td>고객사아이디 (큐피드에서 등록)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>BR_CD</td><td>VARCHAR2(2)</td><td>지점코드 (00:기본, 큐피드에서 별도 등록 필요)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>SEND_TYPE</td><td>VARCHAR2(1)</td><td>발송구분 (M:전자문서, P:전자우편)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>RECV_NM</td><td>VARCHAR2(50)</td><td>수신자 성명 (발송후 마스킹)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>MOBILE_NO</td><td>VARCHAR2(20)</td><td>수신자 휴대폰번호 (발송 후 마스킹)</td><td>true</td><td>false</td><td>true</td></tr><tr><td>BIRTH</td><td>VARCHAR2(8)</td><td>생년월일 (YYYYMMDD, 전자우편은 미사용)</td><td>true</td><td>false</td><td>true</td></tr><tr><td>SUBJECT</td><td>VARCHAR2(100)</td><td>제목 (알림톡 표시)</td><td>true</td><td>false</td><td>true</td></tr><tr><td>TMPL_NO</td><td>VARCHAR2(3)</td><td>템플릿번호 (큐피드에 등록한 일련번호)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>SAVE_REPO_YN</td><td>VARCHAR2(1)</td><td>공전소 등록여부 (Y/N, 기본값:N)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>RESERVED_YN</td><td>VARCHAR2(1)</td><td>예약발송여부 (Y/N, 기본값:N)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>RESERVED_DATE</td><td>VARCHAR2(16)</td><td>예약발송일시 (YYYY-MM-DD hh:mm)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>RECV_POST_NO</td><td>VARCHAR2(6)</td><td>수신자 우편번호</td><td>false</td><td>true</td><td>true</td></tr><tr><td>RECV_ADDR1</td><td>VARCHAR2(100)</td><td>수신자 기본주소</td><td>false</td><td>true</td><td>true</td></tr><tr><td>RECV_ADDR2</td><td>VARCHAR2(200)</td><td>수신자 상세주소 (발송후 마스킹)</td><td>false</td><td>true</td><td>true</td></tr><tr><td>SEND_NM</td><td>VARCHAR2(50)</td><td>발신자 이름</td><td>false</td><td>true</td><td>true</td></tr><tr><td>SEND_POST_NO</td><td>VARCHAR2(6)</td><td>발신자 우편번호</td><td>false</td><td>true</td><td>true</td></tr><tr><td>SEND_ADDR1</td><td>VARCHAR2(100)</td><td>발신자 기본주소</td><td>false</td><td>true</td><td>true</td></tr><tr><td>SEND_ADDR2</td><td>VARCHAR2(200)</td><td>발신자 상세주소</td><td>false</td><td>true</td><td>true</td></tr><tr><td>POST_TYPE</td><td>VARCHAR2(3)</td><td>우편종류 (000:일반, 001:등기, 005:내용증명, 008:내용증명+배달증명)</td><td>false</td><td>true</td><td>true</td></tr><tr><td>ENVELOPE_TYPE</td><td>VARCHAR2(3)</td><td>봉투종류 (*010:봉합식, 020:접착식)</td><td>false</td><td>true</td><td>true</td></tr><tr><td>POST_RGST_NO</td><td>VARCHAR2(13)</td><td>등기번호 (큐피드에서 발송후 업데이트)</td><td>false</td><td>true</td><td>true</td></tr><tr><td>PDF_FILE_PATH</td><td>VARCHAR2(100)</td><td>PDF파일 절대경로+파일명</td><td>true</td><td>true</td><td>false</td></tr><tr><td>SEND_YN</td><td>VARCHAR2(1)</td><td>큐피드접수여부 (Y/N)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>STATUS</td><td>VARCHAR2(2)</td><td>진행상태코드 (<a href="2.">상태코드</a> 참조)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>SUB_STATUS</td><td>VARCHAR2(4)</td><td>세부상태코드 (<a href="2.">상태코드</a> 참조)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>RES_CODE</td><td>VARCHAR2(4)</td><td>응답코드 (<a href="../qupid-api/2.-api">API 기본응답</a> 참조)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>RES_MSG</td><td>VARCHAR2(200)</td><td>응답메시지</td><td>true</td><td>true</td><td>false</td></tr><tr><td>REQ_ID</td><td>VARCHAR2(50)</td><td>요청아이디 (고객사 조회용)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>PARAM1</td><td>VARCHAR2(50)</td><td>사용자파라메타1 (고객사 관리용)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>PARAM2</td><td>VARCHAR2(50)</td><td>사용자파라메타2 (고객사 관리용)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>PARAM3</td><td>VARCHAR2(50)</td><td>사용자파라메타3 (고객사 관리용)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>CRT_ID</td><td>VARCHAR2(50)</td><td>등록자ID (고객사 시스템)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>CRT_DTM</td><td>VARCHAR2(14)</td><td>등록일시 (YYYYMMDDhhmmss)</td><td>true</td><td>true</td><td>true</td></tr><tr><td>CHG_DTM</td><td>VARCHAR2(14)</td><td>변경일시 (YYYYMMDDhhmmss)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>STATUS_CHG_DTM</td><td>VARCHAR2(14)</td><td>상태변경일시(큐피드)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>SEND_DTM</td><td>VARCHAR2(14)</td><td>전송(발송요청)일시(고객사->큐피드)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>REQ_DTM</td><td>VARCHAR2(14)</td><td>최초접수일시</td><td>true</td><td>true</td><td>false</td></tr><tr><td>SENT_DTM</td><td>VARCHAR2(14)</td><td>발송일시(페이사인)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>RECEIVE_DTM</td><td>VARCHAR2(14)</td><td>수신일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>READ_DTM</td><td>VARCHAR2(14)</td><td>열람일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>COMPLETE_DTM</td><td>VARCHAR2(14)</td><td>서명완료일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>EXPIRE_DTM</td><td>VARCHAR2(14)</td><td>서명/열람기한만료일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>GENERATE_PDF_DTM</td><td>VARCHAR2(14)</td><td>PDF생성일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>GENERATE_TSA_DTM</td><td>VARCHAR2(14)</td><td>타임스탬프생성일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>DATA_FILLED_DTM</td><td>VARCHAR2(14)</td><td>데이터입력완료일시</td><td>true</td><td>false</td><td>false</td></tr><tr><td>SIGNED_PDF_PATH</td><td>VARCHAR2(100)</td><td>서명PDF저장경로 (환경설정지정경로+REQ_GUID)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>SIGNED_PDF_DOWN_DTM</td><td>VARCHAR2(14)</td><td>서명PDF다운로드일시 (YYYYMMDDhhmmss)</td><td>true</td><td>false</td><td>false</td></tr><tr><td>DOC_PARAM_DATA</td><td>VARCHAR2(4000)</td><td>템플릿 문자열 치환 데이터(JSON)</td><td>true</td><td>true</td><td>false</td></tr><tr><td>ORG_PDF_PATH</td><td>VARCHAR2(100)</td><td>원본PDF저장경로</td><td>true</td><td>true</td><td>false</td></tr><tr><td>ORG_PDF_DOWN_DTM</td><td>VARCHAR2(14)</td><td>원본PDF다운로드일시</td><td>true</td><td>true</td><td>false</td></tr><tr><td>DELIVERED_DTM</td><td>VARCHAR2(!4)</td><td>배달일시</td><td>false</td><td>true</td><td>false</td></tr><tr><td>DELIV_RSLT_CD</td><td>VARCHAR2(1)</td><td>배달결과코드<br>(1:배달완료,2:배달중,3:이사간곳발송,4:반송,5:반송불능,8:계약등기주소갱신)</td><td>false</td><td>true</td><td>false</td></tr><tr><td>DELIV_RCPT_NM</td><td>VARCHAR2(50)</td><td>수령인명</td><td>false</td><td>true</td><td>false</td></tr><tr><td>DELIV_RCPT_REL_NM</td><td>VARCHAR2(50)</td><td>수령인관계</td><td>false</td><td>true</td><td>false</td></tr><tr><td>NON_DELIV_REASON</td><td>VARCHAR2(30)</td><td>미배달사유</td><td>false</td><td>true</td><td>false</td></tr><tr><td>SB_FG</td><td>VARCHAR2(1)</td><td>반송불필요여부(Y:반송X, N:반송)</td><td>false</td><td>true</td><td>false</td></tr><tr><td>FILLED_DATA</td><td>VARCHAR2(1000)</td><td>수신인입력데이터(JSON)</td><td>true</td><td>false</td><td>false</td></tr></tbody></table>

{% hint style="info" %}
DOC\_PARAM\_DATA : { "key" : "value" }형태의 JSON 문자열로 입력하며 큐피드 또는 페이사인에 등록된 템플릿에서 {key}로 입력된 부분이 value로 치환된다.

```
{
    "name" : "홍길동",
    "contract_date" : "2023-10-27",
    "sale_amt" : "5,000,000원",
    "br_nm" : "성남지점",
    "due_day" : "25일"
}
```

{% endhint %}

### 2) QUPID\_SEND\_HIST (우편배송이력)

<table data-full-width="false"><thead><tr><th width="167">컬럼ID</th><th width="165">데이터타입</th><th width="399">컬럼명</th><th data-hidden></th></tr></thead><tbody><tr><td>SEQ_NO</td><td>NUMBER</td><td>발송요청 일련번호 (QUPID_SEND_DATA.SEQ_NO)</td><td></td></tr><tr><td>NO</td><td>NUMBER(3)</td><td>순번</td><td></td></tr><tr><td>DT</td><td>VARCHAR2(10)</td><td>일자</td><td></td></tr><tr><td>TM</td><td>VARCHAR2(5)</td><td>시간</td><td></td></tr><tr><td>ORG</td><td>VARCHAR2(30)</td><td>발생국</td><td></td></tr><tr><td>TEL</td><td>VARCHAR2(20)</td><td>전화번호</td><td></td></tr><tr><td>STATUS</td><td>VARCHAR2(20)</td><td>처리상태</td><td></td></tr><tr><td>RESULT</td><td>VARCHAR2(50)</td><td>배달결과</td><td></td></tr><tr><td>FAIL</td><td>VARCHAR2(50)</td><td>미배달사유</td><td></td></tr><tr><td>RETURN_SID</td><td>VARCHAR2(20)</td><td>반품등기번호</td><td></td></tr><tr><td>RETURN_DT</td><td>VARCHAR2(10)</td><td>반품일자</td><td></td></tr><tr><td>REG_DTM</td><td>VARCHAR2(14)</td><td>등록일시</td><td></td></tr></tbody></table>
