FCT_BNK_CRHDS_LNBASE

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COID INTEGER 4
2 LNPRD CHARACTER VARYING(30) 30
3 LNNUM CHARACTER VARYING(40) 40
4 PRD_GRP CHARACTER VARYING(1) 1
5 LNTYPE CHARACTER VARYING(30) 30
6 LN_DESC CHARACTER VARYING(120) 120
7 LNTRM NUMERIC(18,0) 19
8 ORGTRM BIGINT 8
9 LNBAL NUMERIC(35,2) 19
10 LNAPR DOUBLE PRECISION 8
11 BCH_NAME CHARACTER VARYING(105) 105
12 BOR1 CHARACTER VARYING(40) 40
13 PCDE1 CHARACTER VARYING(30) 30
14 BOR2 CHARACTER VARYING(40) 40
15 PCDE2 CHARACTER VARYING(30) 30
16 BOR3 CHARACTER VARYING(40) 40
17 PCDE3 CHARACTER VARYING(30) 30
18 BOR4 CHARACTER VARYING(40) 40
19 PCDE4 CHARACTER VARYING(30) 30
20 A_FLAG CHARACTER VARYING(1) 1
21 A_TIME CHARACTER VARYING(10) 10
22 REPO CHARACTER VARYING(1) 1
23 AR_AMT NUMERIC(35,2) 19
24 PRIM_OFF CHARACTER VARYING(50) 50
25 BROKER CHARACTER VARYING(20) 20
26 SALE_OFF CHARACTER VARYING(254) 254
27 DT_FUND CHARACTER VARYING(200) 200
28 APR_DT CHARACTER VARYING(200) 200
29 VALUE NUMERIC(18,2) 19
30 SP_PROV NUMERIC(18,2) 19
31 AR_DAY DOUBLE PRECISION 8
32 SEC_OFF CHARACTER VARYING(40) 40
33 NA_FLAG CHARACTER VARYING(1) 1
34 NA_AMT DOUBLE PRECISION 8
35 MAT_DT CHARACTER VARYING(200) 200
36 INSCO CHARACTER VARYING(50) 50
37 POLICY CHARACTER VARYING(20) 20
38 NAME CHARACTER VARYING(250) 250
39 INSAMT CHARACTER(15) 15
40 PAYMT NUMERIC(18,2) 19
41 FHOF CHARACTER VARYING(1) 1
42 BDAY CHARACTER VARYING(200) 200
43 SEX CHARACTER(3) 3
44 OCC CHARACTER VARYING(30) 30
45 EMP CHARACTER VARYING(120) 120
46 D_G INTEGER 4
47 D30 INTEGER 4
48 D60 INTEGER 4
49 D90 INTEGER 4
50 D120 INTEGER 4
51 LOAN_ISS CHARACTER VARYING(200) 200
52 FEE_ARREARS_AMT DOUBLE PRECISION 8