OPC_HST_NOSM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_NOSM

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