INT_ATOCRS_TREASURY_ULTIMATE_COUNTRY_INDICIA_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CIS_PROFILE_ID INTEGER 4
2 PRDT_SYS_CODE CHARACTER VARYING(3) 3
3 PRDT_SYS_CUST_NUM CHARACTER VARYING(11) 11
4 CNTRY_CODE CHARACTER VARYING(2) 2
5 FOREIGN_INDICIA_FLAG CHARACTER VARYING(7) 7
6 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(2) 2
7 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
8 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(3) 3
9 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(16) 16
10 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(21) 21
11 SOURCE_SYSTEM CHARACTER VARYING(8) 8
12 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(27) 27
13 INDICIA_COUNTRY_CHANGE_INDICATOR CHARACTER VARYING(6) 6
14 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
15 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8