여신
테이블 (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