OPIC_NOSM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 NOS CHARACTER VARYING(15) 15
3 EXTACCTNO CHARACTER VARYING(35) 35
4 MAINACCTIND CHARACTER VARYING(1) 1
5 TARGETBAL NUMERIC(19,4) 19
6 MINMOVEAMT NUMERIC(19,4) 19
7 DAYSFWD CHARACTER VARYING(2) 2
8 EXCLUDEIND CHARACTER VARYING(1) 1
9 TEXT CHARACTER VARYING(70) 70
10 SUPRECIND CHARACTER VARYING(1) 1
11 SUPPAYIND CHARACTER VARYING(1) 1
12 PAYPRIORITY CHARACTER VARYING(1) 1
13 RECPRIORITY CHARACTER VARYING(1) 1
14 ALTBIC CHARACTER VARYING(11) 11
15 IOPER CHARACTER VARYING(4) 4
16 LSTMNTDTE TIMESTAMP 8
17 LASTSTMTNO CHARACTER VARYING(5) 5
18 FINCAL CHARACTER VARYING(15) 15
19 SETTLDAYS CHARACTER VARYING(2) 2
20 CREATE202 CHARACTER VARYING(1) 1
21 EXTSWFTIND CHARACTER VARYING(1) 1
22 UPDATECOUNTER BIGINT 8
23 ODGLNO CHARACTER VARYING(15) 15
24 AUSTRACLRIND CHARACTER VARYING(1) 1
25 CLSDATE TIMESTAMP 8
26 TEXT1 CHARACTER VARYING(35) 35
27 TEXT2 CHARACTER VARYING(35) 35
28 DATE1 TIMESTAMP 8
29 DATE2 TIMESTAMP 8
30 AMOUNT1 NUMERIC(19,4) 19
31 AMOUNT2 NUMERIC(19,4) 19
32 RATE1_8 NUMERIC(18,8) 19
33 RATE2_8 NUMERIC(18,8) 19
34 CLSIND CHARACTER VARYING(1) 1
35 CONVERT210 CHARACTER VARYING(1) 1
36 INTERMEDIARY CHARACTER VARYING(11) 11
37 ROUNDAMT NUMERIC(19,4) 19
38 UNREPORTEDDRCR NUMERIC(19,4) 19
39 INTACCTNO CHARACTER VARYING(35) 35
40 INACCTNO CHARACTER VARYING(35) 35
41 AWACCTNO CHARACTER VARYING(35) 35
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
46 EXTACCTREF CHARACTER VARYING(35) 35