LockSystem
Tables (16)
LK_ACTRCPREQPCLDTL_H
- ACT_RCP_REQ_PCL_DTL_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_RCP_REQ_DTL_ID — NUMBER(20, 0) — NOT NULL — 계정수납요청상세ID
- ACT_RCP_REQ_PCL_ID — NUMBER(20, 0) — 계정수납요청내역ID
- REQ_PCL_DIV_CD — VARCHAR2(3) — 요청내역구분코드
- RECOG_AMT — NUMBER(20, 0) — 승인금액
- LOCK_ACT_SPS — VARCHAR2(20) — Lock계좌적요
- SVC_TRD_LGR_SPS — VARCHAR2(20) — 서비스거래원장적요
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_ACTRCPREQPCL_H
- ACT_RCP_REQ_PCL_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_RCP_REQ_PCL_ID — NUMBER(20, 0) — NOT NULL — 계정수납요청내역ID
- ACT_TRD_LGR_ID — NUMBER(20, 0) — 계정거래원장ID
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- ACT_RCP_AMT — NUMBER(20, 0) — 계정수납금액
- RDP_DTL_CNT — NUMBER(20, 0) — 수납상세건수
- RECOG_STS — VARCHAR2(2) — 승인상태
- RECOG_MG — VARCHAR2(20) — 승인관리자
- RECOG_DH — TIMESTAMP — 승인일시
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_ACTRNDIFO_H
- ACT_RND_IFO_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- LOCK_ACT_ID — NUMBER(20, 0) — NOT NULL — LOCK계좌ID
- SVC_ID — VARCHAR2(3) — 서비스ID
- SVC_MO_ACT_RND — NUMBER(20, 0) — 서비스모계좌잔액
- SVC_RND — NUMBER(20, 0) — 서비스잔액
- NYT_RECOG_RCP_RND — NUMBER(20, 0) — 미승인수납잔액
- RDP_OBJ_TAMT — NUMBER(20, 0) — 상환대상총액
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_ACTTNSPCSPCL_H
- ACT_TNS_PCS_PCL_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_TNS_PCS_PCL_ID — NUMBER(20, 0) — NOT NULL — 계정이체처리내역ID
- ACT_TNS_PCS_CNT — NUMBER(20, 0) — 계정이체요청건수
- ACT_TNS_PCS_AMT — NUMBER(20, 0) — 계정이체요청금액
- ACT_TNS_PCS_STS — VARCHAR2(2) — 계정이체처리상태
- TRD_BNK_CD — VARCHAR2(3) — 거래은행코드
- TRD_ACT_NO — VARCHAR2(64) — 거래계좌번호
- ACT_TRD_LGR_ID — NUMBER(20, 0) — 계정거래원장ID
- ACT_TRD_PCS_DH — TIMESTAMP — 계정거래처리일시
- MO_ACTNO — VARCHAR2(64) — 모계좌번호
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_ACTTNSREQPCL_H
- ACT_TNS_REQ_PCL_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_TNS_REQ_PCL_ID — NUMBER(20, 0) — NOT NULL — 계정이체요청내역ID
- ACT_TNS_PCS_PCL_ID — NUMBER(20, 0) — 계정이체처리내역ID
- SVC_TRD_LGR_ID — NUMBER(20, 0) — 서비스거래원장ID
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- ACT_TRD_RECOG_STS — VARCHAR2(2) — 계정거래승인상태
- ACT_TRD_RECOG_MG — VARCHAR2(20) — 계정거래승인관리자
- ACT_TRD_STS — VARCHAR2(2) — 계정거래상태
- CAN_SVC_TRD_LGR_ID — NUMBER(20, 0) — 취소서비스거래원장ID
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_ACTTRDLGR_H
- ACT_TRD_LGR_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 계정거래원장ID
- ORG_TRD_TX_NO — VARCHAR2(6) — 원거래전문번호
- SVC_ID — VARCHAR2(3) — 서비스ID
- TRD_DIV_CD — VARCHAR2(1) — 거래구분코드
- TRD_AMT — NUMBER(20, 0) — 거래금액
- SVC_MO_ACT_RND — NUMBER(20, 0) — 서비스모계좌잔액
- SPS_RMK — VARCHAR2(20) — 적요비고
- DRN_ACT_BNK_CD — VARCHAR2(3) — 출금계좌은행코드
- DRN_ACT_NO — VARCHAR2(64) — 출금계좌번호
- RPM_ACT_BNK_CD — VARCHAR2(3) — 입금계좌은행코드
- RPM_ACT_NO — VARCHAR2(64) — 입금계좌번호
- TRD_DH — TIMESTAMP — 거래일시
- TRD_DT — VARCHAR2(8) — 거래일자
- TRD_REQPE — VARCHAR2(20) — 거래요청자
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_LOCKACTIFO_H
- LOCK_ACT_IFO_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- LOCK_ACT_ID — NUMBER(20, 0) — NOT NULL — LOCK계좌ID
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACTNO — VARCHAR2(64) — LOCK계좌번호
- BNK_CD — VARCHAR2(3) — 은행코드
- TMT_STP_CD — VARCHAR2(7) — 취급점포코드
- DRN_SPN_RGS_STS — VARCHAR2(2) — 출금동의등록상태
- DRN_SPN_RGS_DH — TIMESTAMP — 출금동의등록일시
- DRN_SPN_RLS_DH — TIMESTAMP — 출금동의해제일시
- RCP_ST_DT — VARCHAR2(8) — 수납시작일자
- RCP_ABR_DT — VARCHAR2(8) — 수납중지일자
- ACT_STS — VARCHAR2(2) — 계좌상태
- CUS_DIV_CD — VARCHAR2(2) — 고객구분코드
- CUS_UQE_NO — VARCHAR2(13) — 고객고유번호
- ACT_MST_NM — VARCHAR2(64) — 계좌주명
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_LOCKACTSVCIFO_H
- LOCK_ACT_SVC_IFO_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- SVC_ID — VARCHAR2(3) — NOT NULL — 서비스ID
- SVC_NM — VARCHAR2(128) — 서비스명
- MO_ACTNO — VARCHAR2(64) — 모계좌번호
- FRBN_ID — VARCHAR2(12) — 펌뱅킹ID
- RCP_DRN_CYCL — VARCHAR2(2) — 수납출금주기
- RCP_PCS_MTD — VARCHAR2(2) — 수납처리방식
- SCD_RDP_PCS_MTD — VARCHAR2(2) — 스케줄상환처리방식
- RDP_CBK_USYN — VARCHAR2(1) — 상환콜백사용여부
- RDP_CBK_URL — VARCHAR2(256) — 상환콜백
- USE_YN — VARCHAR2(1) — 사용여부
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_NYPAYACTTRDLGR_H
- NYPAY_ACT_TRD_LGR_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- NYPAY_ACT_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 미지급계정거래원장ID
- ORG_TRD_TX_NO — VARCHAR2(6) — 원거래전문번호
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- TRD_DIV_CD — VARCHAR2(1) — 거래구분코드
- TRD_AMT — NUMBER(20, 0) — 거래금액
- NYPAY_ACT_RND — NUMBER(20, 0) — 미지급계정잔액
- SPS_RMK — VARCHAR2(20) — 적요비고
- DRN_ACT_BNK_CD — VARCHAR2(3) — 출금계좌은행코드
- DRN_ACT_NO — VARCHAR2(64) — 출금계좌번호
- RPM_ACT_BNK_CD — VARCHAR2(3) — 입금계좌은행코드
- RPM_ACT_NO — VARCHAR2(64) — 입금계좌번호
- TRD_DH — TIMESTAMP — 거래일시
- TRD_DT — VARCHAR2(8) — 거래일자
- TRD_REQPE — VARCHAR2(20) — 거래요청자
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_NYPAYACTTRDLGR_R
- NYPAY_ACT_TRD_LGR_REL_SEQ — NUMBER(20, 0) — NOT NULL
- ACT_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 계정거래원장ID
- NYPAY_ACT_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 미지급계정거래원장ID
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_RDPREQPCLIFO_H
- RDP_REQ_PCL_IFO_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- RDP_REQ_PCL_ID — NUMBER(20, 0) — NOT NULL — 상환요청내역ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- SVC_ID — VARCHAR2(3) — 서비스ID
- BND_ID — VARCHAR2(128) — 채권ID
- RDP_REQ_DT — VARCHAR2(8) — 상환요청일자
- RDP_XPN_DT — VARCHAR2(8) — 상환예정일자
- RDP_AMT — NUMBER(20, 0) — 상환금액
- RRN_AMT — NUMBER(20, 0) — 반환금액
- TOT_TNS_AMT — NUMBER(20, 0) — 총이체금액
- RDP_PCS_STS — VARCHAR2(2) — 상환처리상태
- RDP_PCS_DH — TIMESTAMP — 상환처리일시
- RRN_PCS_STS — VARCHAR2(2) — 반환처리상태
- RRN_PCS_DH — TIMESTAMP — 반환처리일시
- RDP_REQ_PCL_PCS_STS — VARCHAR2(2) — 상환요청내역처리상태
- RDP_REQ_SPS — VARCHAR2(20) — 상환요청적요
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_RDPREQPCLSVCTRDLGR_R
- RDP_REQ_PCL_SVC_TRD_LGR_REL_SEQ — NUMBER(20, 0) — NOT NULL
- RDP_REQ_PCL_ID — NUMBER(20, 0) — NOT NULL — 상환요청내역ID
- SVC_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 서비스거래원장ID
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_RDPRRNACTIFO_H
- RDP_RRN_ACT_IFO_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- ACT_ID — NUMBER(20, 0) — NOT NULL — 계좌ID
- ACT_DIV — VARCHAR2(2) — 계좌구분
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- ACTNO — VARCHAR2(3) — 계좌번호
- BNK_CD — VARCHAR2(64) — 은행코드
- ACT_MST_NM — VARCHAR2(64) — 계좌주명
- ACT_USE_YN — VARCHAR2(1) — 계좌사용여부
- ACT_RGS_DH — TIMESTAMP — 계좌등록일시
- ACT_CHG_DH — TIMESTAMP — 계좌변경일시
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_SVCACTRCPREQDTL_R
- SVC_ACT_RCP_REQ_DTL_REL_SEQ — NUMBER(20, 0) — NOT NULL
- SVC_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 서비스거래원장ID
- ACT_RCP_REQ_DTL_ID — NUMBER(20, 0) — NOT NULL — 계정수납요청상세ID
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_SVCACTTRDLGR_R
- SVC_ACT_TRD_LGR_REL_SEQ — NUMBER(20, 0) — NOT NULL
- SVC_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 서비스거래원장ID
- ACT_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 계정거래원장ID
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID
LK_SVCTRDLGR_H
- SVC_TRD_LGR_SEQ — NUMBER(10, 0) — Primary key — NOT NULL
- SVC_TRD_LGR_ID — NUMBER(20, 0) — NOT NULL — 서비스거래원장ID
- ORG_TRD_TX_NO — VARCHAR2(6) — 원거래전문번호
- SVC_ID — VARCHAR2(3) — 서비스ID
- LOCK_ACT_ID — NUMBER(20, 0) — LOCK계좌ID
- TRD_DIV_CD — VARCHAR2(1) — 거래구분코드
- TRD_AMT — NUMBER(20, 0) — 거래금액
- SVC_RMN_AMT — NUMBER(20, 0) — 서비스잔여금액
- SPS_RMK — VARCHAR2(20) — 적요비고
- TRD_BNK_CD — VARCHAR2(3) — 거래은행코드
- TRD_ACT_NO — VARCHAR2(64) — 거래계좌번호
- TRD_DH — TIMESTAMP — 거래일시
- TRD_DT — VARCHAR2(8) — 거래일자
- TRD_REQPE — VARCHAR2(20) — 거래요청자
- RGS_DTM — TIMESTAMP — NOT NULL — 등록일시
- RGS_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 등록회원식별ID
- UPT_DTM — TIMESTAMP — NOT NULL — 수정일시
- UPT_MB_IDT_ID — VARCHAR2(20) — NOT NULL — 수정회원식별ID