clms_artrans

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 account integer 32
4 seqmth integer 32
5 trno integer 32
6 ttype integer 32
7 xttype integer 32
8 clflag integer 32
9 edate timestamp without time zone
10 pdate timestamp without time zone
11 ptime character varying 24
12 pind character varying 3
13 tval numeric 19
14 reason integer 32
15 tgroup integer 32
16 capbal numeric 19
17 curbal numeric 19
18 wobal numeric 19
19 inbabal numeric 19
20 intabal numeric 19
21 ucosbal numeric 19
22 dpbal numeric 19
23 plim numeric 19
24 glim numeric 19
25 drawn numeric 19
26 caplim numeric 19
27 capped numeric 19
28 guarval numeric 19
29 ucosbal1 numeric 19
30 ucosbal2 character varying 48
31 ucosbal3 character varying 48
32 ucosbal4 character varying 48
33 ucosbal5 character varying 48
34 ucosbal6 character varying 48
35 ucosbal7 character varying 48
36 ucosbal8 character varying 48
37 ucosbal9 character varying 48
38 assetval numeric 19
39 ocostadj numeric 19
40 odlimadj numeric 19
41 gstacbal numeric 19
42 fee character varying 12
43 calcamt numeric 19
44 waiver integer 32
45 supwdesc character varying 60
46 ddcode integer 32
47 tnarr1 character varying 60
48 tnarr2 character varying 60
49 teller character varying 24
50 branch integer 32
51 paymeth character varying 3
52 source character varying 6
53 data_date timestamp without time zone
54 load_id integer 32