INT_ATOCRS_TREASURY_INDICIA_ADDRESS_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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