INT_ATOCRS_KYCRP_INDICIA_ADDRESS_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 RELATED_PARTY_ID BIGINT 8
2 ADDR_TYP_CODE CHARACTER VARYING(5) 5
3 ADDR_LNE_1 CHARACTER VARYING(50) 50
4 ADDR_LNE_2 CHARACTER VARYING(50) 50
5 ADDR_LNE_3 CHARACTER VARYING(50) 50
6 ADDR_LNE_4 CHARACTER VARYING(1) 1
7 ADDR_LNE_5 CHARACTER VARYING(1) 1
8 SBRB_CODE CHARACTER VARYING(50) 50
9 PCODE CHARACTER VARYING(10) 10
10 STATE_DESC CHARACTER VARYING(30) 30
11 CNTRY_CODE CHARACTER VARYING(2) 2
12 FOREIGN_INDICIA_FLAG CHARACTER VARYING(7) 7
13 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
14 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
15 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(100) 100
16 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(7) 7
17 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(8) 8
18 SOURCE_SYSTEM CHARACTER VARYING(6) 6
19 DATA_SOURCE_APPLICATION CHARACTER VARYING(3) 3
20 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(35) 35
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8