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