RPS
Tables (7)
ACCOUNT (계약기본)
- ACC_NO (계약번호) — VARCHAR2(20) — Primary key — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- CONTRACT_STATUS (계약상태) — VARCHAR2(20)
- CNTR_ESTB_DT (계약성립일자) — VARCHAR2(8)
- CNTR_TRMT_DT (계약소멸일자) — VARCHAR2(8)
- CUST_ID (고객ID) — VARCHAR2(20) — Foreign key → CUSTOMER_MASTER.CUST_ID
ACC_BLNC (잔고)
- ACC_BLNC_NO (잔고번호) — VARCHAR2(20) — Primary key — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- ACC_NO (계약번호) — VARCHAR2(20)
- PROD_ID (상품ID) — VARCHAR2(20)
- BLNC_DVSN_CODE (잔고구분코드) — VARCHAR2(4)
- MGIV_ORGN_CODE (운용관리기관코드) — VARCHAR2(4)
- ASET_ORGN_CODE (자산관리기관코드) — VARCHAR2(4)
- BLNC_ACUT (잔고좌수) — NUMBER(18, 0)
- CASH_BALANCE (평가금액) — NUMBER(18, 0)
- OGTX_AMT (원본금액) — NUMBER(18, 0)
- DTLS_DATE (명세일자) — VARCHAR2(8)
- MTRT_DATE (만기일자) — VARCHAR2(8)
- IRRT (이율) — NUMBER(18, 12)
CUSTOMER_MASTER (고객기본)
- CUST_ID (고객ID) — VARCHAR2(20) — Primary key
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50)
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- CUST_NAME (고객명) — VARCHAR2(100) — NOT NULL
- RESIDENT_NO (주민번호) — VARCHAR2(13) — NOT NULL
- JOIN_DATE (가입일자) — DATE — NOT NULL
DAILY_ACC_BLNC (일자별잔고)
- EVAL_DT (평가기준일자) — DATE — Primary key — NOT NULL
- ACC_BLNC_NO (잔고번호) — VARCHAR2(20) — Foreign key → ACC_BLNC.ACC_BLNC_NO — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- ACC_NO (계약번호) — VARCHAR2(20)
- PROD_ID (상품ID) — VARCHAR2(20)
- BLNC_DVSN_CODE (잔고구분코드) — VARCHAR2(4)
- MGIV_ORGN_CODE (운용관리기관코드) — VARCHAR2(4)
- ASET_ORGN_CODE (자산관리기관코드) — VARCHAR2(4)
- BLNC_ACUT (잔고좌수) — NUMBER(18, 0)
- CASH_BALANCE (평가금액) — NUMBER(18, 0)
- OGTX_AMT (원본금액) — NUMBER(18, 0)
- DTLS_DATE (명세일자) — VARCHAR2(8)
- MTRT_DATE (만기일자) — VARCHAR2(8)
- IRRT (이율) — NUMBER(18, 12)
IRP_ALLOCATION_RATIO (배분비율)
- ACC_NO (계약번호) — VARCHAR2(20) — Primary key — NOT NULL
- PROD_ID (상품ID) — VARCHAR2(20) — Primary key — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- RATIO (배분비율) — NUMBER(5, 4) — NOT NULL
- RATIO_REPT_DATE (배분비율접수일자) — VARCHAR2(8)
ORDER (주문기본)
- ORDER_NO (거래번호) — NUMBER(18, 0) — Primary key — NOT NULL
- ACC_BLNC_NO (잔고번호) — VARCHAR2(20) — Foreign key → ACC_BLNC.ACC_BLNC_NO — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- ACC_NO (계약번호) — VARCHAR2(20) — Foreign key → IRP_ALLOCATION_RATIO.ACC_NO — NOT NULL
- PROD_ID (상품ID) — VARCHAR2(20) — Foreign key → IRP_ALLOCATION_RATIO.PROD_ID — NOT NULL
- ORDER_STATUS (주문상태코드) — VARCHAR2(20) — NOT NULL
- ORDER_DATE (운용지시일자) — DATE — NOT NULL
- MGIV_ORGN_CODE (운용관리기관코드) — VARCHAR2(4)
- ASET_ORGN_CODE (자산관리기관코드) — VARCHAR2(4)
- PROD_ORGN_CODE (상품제공기관코드) — VARCHAR2(4)
- MGIV_ORGN_MGMT_NO (운용기관관리번호) — VARCHAR2(20)
- ASET_ORGN_MGMT_NO (자산기관관리번호) — VARCHAR2(20)
- DTLS_DATE (명세일자) — DATE
- BYSL_UNIT_CODE (매매단위코드) — VARCHAR2(4)
- BUY_AMT (매매지시금액) — NUMBER(18, 0) — NOT NULL
- BUY_QTY (매매지시수량) — NUMBER(18, 0)
- TRNN_TPYE_CODE (거래유형코드) — VARCHAR2(4)
- BYSL_DVSN_CODE (매매구분코드) — VARCHAR2(4)
- MDTM_SRDR_CODE (중도해지코드) — VARCHAR2(4)
- STLM_DATE (결제일자) — DATE
- STLM_AMT (결제금액) — NUMBER(18, 0)
- STLM_QTY (결제수량) — NUMBER(18, 0)
- IRRT (이율) — NUMBER(18, 12)
- APRV_DTTM (승인일시) — DATE
- APRT_EMPNO (승인자사번) — VARCHAR2(20)
- TLGR_MGMT_NO (전문거래번호) — VARCHAR2(20)
- ACC_NO (계약번호2) — VARCHAR2(20) — Foreign key → ACCOUNT.ACC_NO — NOT NULL
VIRTUAL_ACCOUNT (가상계좌)
- V_ACC_NO (가상계좌번호) — VARCHAR2(20) — Primary key — NOT NULL
- REG_PROG_ID (등록프로그램ID) — VARCHAR2(50) — NOT NULL
- REG_DT (등록일시) — DATE — NOT NULL
- REG_EMP_NO (등록자사번) — VARCHAR2(20) — NOT NULL
- CHG_PROG_ID (최종변경프로그램ID) — VARCHAR2(50) — NOT NULL
- CHG_DT (최종변경일시) — DATE — NOT NULL
- CHG_EMP_NO (최종변경자사번) — VARCHAR2(20) — NOT NULL
- DLTN_YN (삭제여부) — CHAR(1)
- ACC_NO (계약번호) — VARCHAR2(20) — Foreign key → ACCOUNT.ACC_NO — NOT NULL
- ALLOC_DATE (할당일자) — VARCHAR2(8) — NOT NULL
- DUSE_DATE (폐기일자) — VARCHAR2(8)
- ACNT_BANK_CODE (은행기관코드) — VARCHAR2(3)
- MGIV_ORGN_CODE (운용관리기관코드) — VARCHAR2(4)
- ASET_ORGN_CODE (자산관리기관코드) — VARCHAR2(4)