INT_ATOCRS_HIST_ENTITY_AMLBOCP_INDICIA_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ENTITY_CIS_PROFILE_ID BIGINT 8
2 ENTITY_PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 ENTITY_PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
4 RELATED_PARTY_ID BIGINT 8
5 AMLBOCP_CIS_PROFILE_ID BIGINT 8
6 AML_METHOD CHARACTER VARYING(5) 5
7 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(15) 15
8 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(16) 16
9 AMLBOCP_GCIS_ADDRESS_FLAG CHARACTER VARYING(1) 1
10 AMLBOCP_GCIS_PHONE_FLAG CHARACTER VARYING(1) 1
11 AMLBOCP_KYC_ADDRESS_FLAG CHARACTER VARYING(1) 1
12 AMLBOCP_KYC_EVIDENCE_FLAG CHARACTER VARYING(1) 1
13 AMLBOCP_CREST_RESPONSE_FLAG CHARACTER VARYING(1) 1
14 ENTITY_BOCP_REL_START_TIMESTAMP TIMESTAMP 8
15 ENTITY_BOCP_REL_END_TIMESTAMP TIMESTAMP 8