CLMS_ARTRANS_DATAFIX

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 ACCOUNT INTEGER 4
4 SEQMTH INTEGER 4
5 TRNO INTEGER 4
6 TTYPE INTEGER 4
7 XTTYPE INTEGER 4
8 CLFLAG INTEGER 4
9 EDATE TIMESTAMP 8
10 PDATE TIMESTAMP 8
11 PTIME CHARACTER VARYING(8) 8
12 PIND CHARACTER VARYING(1) 1
13 TVAL NUMERIC(19,2) 19
14 REASON INTEGER 4
15 TGROUP INTEGER 4
16 CAPBAL NUMERIC(19,2) 19
17 CURBAL NUMERIC(19,2) 19
18 WOBAL NUMERIC(19,2) 19
19 INBABAL NUMERIC(19,2) 19
20 INTABAL NUMERIC(19,2) 19
21 UCOSBAL NUMERIC(19,2) 19
22 DPBAL NUMERIC(19,2) 19
23 PLIM NUMERIC(19,2) 19
24 GLIM NUMERIC(19,2) 19
25 DRAWN NUMERIC(19,2) 19
26 CAPLIM NUMERIC(19,2) 19
27 CAPPED NUMERIC(19,2) 19
28 GUARVAL NUMERIC(19,2) 19
29 UCOSBAL1 NUMERIC(19,2) 19
30 UCOSBAL2 CHARACTER VARYING(16) 16
31 UCOSBAL3 CHARACTER VARYING(16) 16
32 UCOSBAL4 CHARACTER VARYING(16) 16
33 UCOSBAL5 CHARACTER VARYING(16) 16
34 UCOSBAL6 CHARACTER VARYING(16) 16
35 UCOSBAL7 CHARACTER VARYING(16) 16
36 UCOSBAL8 CHARACTER VARYING(16) 16
37 UCOSBAL9 CHARACTER VARYING(16) 16
38 ASSETVAL NUMERIC(19,2) 19
39 OCOSTADJ NUMERIC(19,2) 19
40 ODLIMADJ NUMERIC(19,2) 19
41 GSTACBAL NUMERIC(19,2) 19
42 FEE CHARACTER VARYING(4) 4
43 CALCAMT NUMERIC(19,2) 19
44 WAIVER INTEGER 4
45 SUPWDESC CHARACTER VARYING(20) 20
46 DDCODE INTEGER 4
47 TNARR1 CHARACTER VARYING(20) 20
48 TNARR2 CHARACTER VARYING(20) 20
49 TELLER CHARACTER VARYING(8) 8
50 BRANCH INTEGER 4
51 PAYMETH CHARACTER VARYING(1) 1
52 SOURCE CHARACTER VARYING(2) 2
53 DATA_DATE TIMESTAMP 8
54 LOAD_ID INTEGER 4