clms_arlbals

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 action_code character varying 3
2 account integer 32
3 baserate numeric 14
4 effrate numeric 14
5 yldrate numeric 9
6 margin numeric 9
7 penamt numeric 15
8 maninba timestamp without time zone
9 inbasts integer 32
10 inbapedate timestamp without time zone
11 ooidate timestamp without time zone
12 arinstcnt integer 32
13 ardays integer 32
14 expdte timestamp without time zone
15 expbln numeric 19
16 capbal numeric 19
17 curbal numeric 19
18 dpbal numeric 19
19 plim numeric 19
20 glim numeric 19
21 drawn numeric 19
22 caplim numeric 19
23 capped numeric 19
24 guarval numeric 19
25 authcode integer 32
26 authno integer 32
27 babfdd integer 32
28 babffee character varying 12
29 lfeedate timestamp without time zone
30 nfeedate timestamp without time zone
31 lfrate numeric 9
32 negrate numeric 9
33 neinstaamnt numeric 19
34 neinstadate timestamp without time zone
35 nespecinstaamnt numeric 19
36 nxtspecinstadt timestamp without time zone
37 totlimit numeric 19
38 inbabal numeric 19
39 wobal numeric 19
40 intabal numeric 19
41 acintabal numeric 19
42 ucosbal numeric 19
43 ucosbal1 numeric 19
44 ucosbal2 numeric 19
45 ucosbal3 numeric 19
46 ucosbal4 numeric 19
47 ucosbal5 numeric 19
48 ucosbal6 numeric 19
49 ucosbal7 numeric 19
50 ucosbal8 numeric 19
51 ucosbal9 numeric 19
52 gstacbal numeric 19
53 cmint numeric 19
54 cmcaptint numeric 19
55 lcapbal numeric 19
56 lcapdate timestamp without time zone
57 currinsafrqmnth integer 32
58 arrear_amnt_0_1_mnth numeric 19
59 arrear_amnt_1_2_mnth numeric 19
60 arrear_amnt_2_3_mnth numeric 19
61 arrear_amnt_3_4_mnth numeric 19
62 arrear_amnt_4_5_mnth numeric 19
63 arrear_amnt_5_6_mnth numeric 19
64 arrear_amnt_6_plus_mnth numeric 19
65 tot_arrear_amnt numeric 19
66 tot_out_fee_amnt numeric 19
67 old_arrear_grad_cde integer 32
68 amu_flag character varying 3
69 undrawn_amnt numeric 19
70 currbabfv numeric 19
71 dueday character varying 6
72 ldddate timestamp without time zone
73 comcycle integer 32
74 lenddate timestamp without time zone
75 cenddate timestamp without time zone
76 odimarg numeric 19
77 highmarg numeric 19
78 conardays integer 32
79 data_date timestamp without time zone
80 load_id integer 32