OPIC_SACC

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 ACCOUNTNO CHARACTER VARYING(15) 15
3 TRAD CHARACTER VARYING(4) 4
4 OPENDATE TIMESTAMP 8
5 ACCTTITLE CHARACTER VARYING(70) 70
6 COST CHARACTER VARYING(11) 11
7 CNO CHARACTER VARYING(10) 10
8 DISCRETIND CHARACTER VARYING(1) 1
9 GLNO CHARACTER VARYING(15) 15
10 LSTMNTDATE TIMESTAMP 8
11 LASTSTMTDATE TIMESTAMP 8
12 NEXTSTMTDATE TIMESTAMP 8
13 NOSTROVOSTRO CHARACTER VARYING(1) 1
14 STMTCYCLE CHARACTER VARYING(1) 1
15 STMTDAY CHARACTER VARYING(3) 3
16 STMTDAYRULE CHARACTER VARYING(1) 1
17 TIMELIMIT CHARACTER VARYING(8) 8
18 PORT CHARACTER VARYING(4) 4
19 SHORTPOSIND CHARACTER VARYING(1) 1
20 AUTOSETTIND CHARACTER VARYING(1) 1
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8