TBIST_WBOOK

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..AS516_TBIST_WBOOK

Columns
# Name Data Type Length
1 WBOOK_HIID INTEGER 4
2 PK_TBIST_WBOOK_WBOOKID INTEGER 4
3 FK_TBIST_WGROUP_WGROUPID INTEGER 4
4 BOOKNAMEDESC CHARACTER VARYING(200) 200
5 BROKERCODE CHARACTER VARYING(6) 6
6 CERTIFICATEISSUEDDATE TIMESTAMP 8
7 STARTDATE TIMESTAMP 8
8 TERMINATIONDATE TIMESTAMP 8
9 GSTFLAG INTEGER 4
10 SYSRL_USER CHARACTER VARYING(50) 50
11 SYSRL_TIMESTAMP TIMESTAMP 8
12 SYSR_DELETED INTEGER 4
13 SYSR_DELETEDBY CHARACTER VARYING(50) 50
14 SYSR_DELETEDON TIMESTAMP 8
15 VENDORNO CHARACTER VARYING(7) 7
16 PAYMENTTYPE CHARACTER(10) 10
17 BANKTYPE CHARACTER(10) 10
18 BSBTYPE CHARACTER VARYING(50) 50
19 ACCOUNTNO CHARACTER VARYING(50) 50
20 FK_TBISR_RESOURCETYPE INTEGER 4
21 FK_TBISR_STATUS INTEGER 4
22 FK_TBISR_PLR_DISTRICTID INTEGER 4
23 PHONENO CHARACTER VARYING(50) 50
24 FAXNO CHARACTER VARYING(50) 50
25 MOBILENO CHARACTER VARYING(50) 50
26 EMAILNAM CHARACTER VARYING(100) 100
27 COB DATE 4
28 DELTA_TYPE CHARACTER VARYING(1) 1
29 EFFECTIVE_STRT_DT TIMESTAMP 8
30 EFFECTIVE_END_DT TIMESTAMP 8
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
33 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
34 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8