CLL_TCLLL_SIPARTICIPANT_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SECURITYINSTRUMENT_ID BIGINT 8
2 PARTICIPANT_ID BIGINT 8
3 SIGNATORY_TYPE CHARACTER VARYING(10) 10
4 CONTARCTOR_INDIVIDUALNAME CHARACTER VARYING(100) 100
5 CONTARCTOR_COMPANY_NAME CHARACTER VARYING(100) 100
6 CONTARCTOR_COMPANYNO_TYPE CHARACTER VARYING(10) 10
7 CONTARCTOR_COMPANY_NO BIGINT 8
8 CONTARCTOR_GTOR_NAME CHARACTER VARYING(100) 100
9 CONTARCTOR_GTOR_COMPNAME CHARACTER VARYING(100) 100
10 CONTARCTOR_GTORCOMP_NOTYPE CHARACTER VARYING(10) 10
11 CONTARCTOR_GTORCOMP_NO BIGINT 8
12 ROLE CHARACTER VARYING(50) 50
13 TYPE_OF_LIMITATION CHARACTER VARYING(10) 10
14 LIMITATION_VALUE NUMERIC(15,2) 19
15 SECURITY_INSTR_PROVIDER CHARACTER VARYING(100) 100
16 CREATED_BY CHARACTER VARYING(7) 7
17 CREATED_DATE TIMESTAMP 8
18 MODIFIED_BY CHARACTER VARYING(7) 7
19 MODIFIED_DATE TIMESTAMP 8
20 DELETED_FLAG CHARACTER VARYING(1) 1
21 VERSION_NO INTEGER 4