여신

테이블 (4)

TBLN_APL

  • BRCD — CHAR — 기본 키 — NOT NULL — Branch
  • APLID — CHAR — 기본 키 — NOT NULL — application
  • APLSEQ — VARCHAR2 — 기본 키 — NOT NULL — application
  • VRFFLG — CHAR — NOT NULL — verify
  • STSCD — CHAR — NOT NULL — Status
  • APPSTATUS — CHAR — NOT NULL — application
  • TRDT — CHAR — NOT NULL — Transaction
  • USRIDOP — VARCHAR2 — NOT NULL — User
  • USRIDMNGR — VARCHAR2 — User
  • CNCLDT — CHAR — Cancel
  • USRIDCNCLOP — VARCHAR2 — User
  • USRIDCNCLMNGR — VARCHAR2 — User
  • LSTUPDTDT — DATE — NOT NULL — Last
  • BRCDLN — CHAR — NOT NULL — Branch
  • CUSTSEQLN — CHAR — NOT NULL — customer
  • BRCDPAYEE — CHAR — Branch
  • CUSTSEQPAYEE — CHAR — Customer
  • BRCDPAYER — CHAR — Branch
  • CUSTSEQPAYER — CHAR — Customer
  • APLTPCD — CHAR — NOT NULL — application
  • CSLTDT — CHAR — consultation
  • EMPNOCSLT — CHAR — employee
  • CSLTTPCD — CHAR — consultation
  • CSLTRSPNDT — CHAR — consultation
  • CSLTRSPNCD — CHAR — consultation
  • CSLTRSPNNOTCDT — CHAR — consultation
  • APLDT — CHAR — application
  • APPRRQSTDT — CHAR — approval
  • ATHRTYTPCD — CHAR — authorization
  • BRCDAPPRDEPT — CHAR — Branch
  • LNANALOPN — VARCHAR2 — Loan
  • LNAUTHDT — CHAR — loan
  • AUTHFLG — CHAR — authorization
  • NAPPRCS — VARCHAR2 — cause
  • BRCDAUTH — CHAR — Branch
  • AUTHID — CHAR — authorization
  • AUTHSEQ — VARCHAR2 — authorization
  • BRCDAPPR — CHAR — Branch
  • APPRID — CHAR — approval
  • APPRSEQ — VARCHAR2 — approval
  • APPRACCTDT — CHAR — approval
  • LNORGTPCD — CHAR — NOT NULL — loan
  • LNACCTTPCD — CHAR — NOT NULL — Loan
  • LNTPCD — CHAR — loan
  • FACLCD — CHAR — facility
  • CRDTLINETPCD — CHAR — NOT NULL — credit
  • CCYCD — CHAR — NOT NULL — currency
  • AMT — NUMBER — NOT NULL — amount
  • FNDPRPSTPCD — VARCHAR2 — NOT NULL — fund
  • LNTRMTPCD — CHAR — NOT NULL — loan
  • MATDT — CHAR — maturity
  • LNTRMYY — NUMBER — loan
  • LNTRMMM — NUMBER — loan
  • LNTRMDD — NUMBER — loan
  • RPMTPROGCD — CHAR — NOT NULL — repayment
  • GRCPRDYY — NUMBER — grace
  • GRCPRDMM — NUMBER — grace
  • GRCPRDDD — NUMBER — grace
  • RPMTAMRTPRD — NUMBER — repayment
  • RPMTSORCCD — CHAR — NOT NULL — repayment
  • … +145

TBLN_APPR

  • BRCD — CHAR — 기본 키 — NOT NULL — Branch
  • APPRID — CHAR — 기본 키 — NOT NULL — approval
  • APPRSEQ — VARCHAR2 — 기본 키 — NOT NULL — approval
  • VRFFLG — CHAR — verify
  • STSCD — CHAR — NOT NULL — Status
  • TRDT — CHAR — NOT NULL — Transaction
  • USRIDOP — VARCHAR2 — NOT NULL — User
  • USRIDMNGR — VARCHAR2 — User
  • CNCLDT — CHAR — Cancel
  • USRIDCNCLOP — VARCHAR2 — User
  • USRIDCNCLMNGR — VARCHAR2 — User
  • LSTUPDTDT — DATE — NOT NULL — Last
  • BRCDLN — CHAR — NOT NULL — Branch
  • CUSTSEQLN — CHAR — NOT NULL — customer
  • BRCDPAYEE — CHAR — Branch
  • CUSTSEQPAYEE — CHAR — Customer
  • BRCDPAYER — CHAR — Branch
  • CUSTSEQPAYER — CHAR — Customer
  • APLFLG — CHAR — NOT NULL — application
  • COMTFLG — CHAR — commitment
  • APPRDT — CHAR — NOT NULL — approval
  • APPRACCTFLG — CHAR — approval
  • APPRACCTDT — CHAR — approval
  • LNAUTHDT — CHAR — NOT NULL — loan
  • LNORGTPCD — CHAR — NOT NULL — loan
  • LNACCTTPCD — CHAR — NOT NULL — Loan
  • LNTPCD — CHAR — loan
  • FACLCD — CHAR — facility
  • CRDTLINETPCD — CHAR — NOT NULL — credit
  • CCYCD — CHAR — NOT NULL — currency
  • APPRAMT — NUMBER — NOT NULL — approval
  • FNDPRPSTPCD — VARCHAR2 — NOT NULL — fund
  • LNTRMTPCD — CHAR — NOT NULL — loan
  • MATDT — CHAR — maturity
  • LNTRMYY — NUMBER — loan
  • LNTRMMM — NUMBER — loan
  • LNTRMDD — NUMBER — loan
  • RPMTPROGCD — CHAR — NOT NULL — repayment
  • GRCPRDYY — NUMBER — grace
  • GRCPRDMM — NUMBER — grace
  • GRCPRDDD — NUMBER — grace
  • RPMTAMRTPRD — NUMBER — repayment
  • RPMTSORCCD — CHAR — NOT NULL — repayment
  • INTRTTPCD — CHAR — interest
  • BSRTCD — CHAR — base
  • SPRD — NUMBER — spread
  • BENF — VARCHAR2 — beneficiary
  • ADVSBANK — VARCHAR2 — Advice
  • REFRNO — VARCHAR2 — reference
  • DSBSTRMLMT — CHAR — disbursement
  • OUTAPPRCNDTFLG — CHAR — approval
  • INVTRMDD — NUMBER — Invoice
  • CNTRCTTP — CHAR — Contract
  • CNTRCTSTYL — CHAR — Contract
  • PAYBYINTPCT1 — NUMBER — Pay
  • PAYBYINTPCT2 — NUMBER — Pay
  • PAYBYHNDPCT1 — NUMBER — Pay
  • PAYBYHNDPCT2 — NUMBER — Pay
  • PAYBYDEINTPCT1 — NUMBER — Pay
  • PAYBYDEINTPCT2 — NUMBER — Pay
  • … +110

Untitled

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Key (Key2) — 외래 키 → Untitled2.Key — NOT NULL

Untitled2

  • Key — 기본 키 — NOT NULL