DIM_BNK_OSX_T_FINANCIAL_INST_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 FI_OBJID INTEGER 4
2 FI_ID INTEGER 4
3 FI_INTERNALID CHARACTER VARYING(20) 20
4 FI_FULLNAME CHARACTER VARYING(150) 150
5 FI_ADDRESS CHARACTER VARYING(100) 100
6 FI_POSTCODE CHARACTER VARYING(30) 30
7 FI_CITY CHARACTER VARYING(30) 30
8 FI_STATE CHARACTER VARYING(10) 10
9 FI_BICCODE CHARACTER VARYING(11) 11
10 FI_ISOCODE CHARACTER VARYING(10) 10
11 FI_CURRENCY CHARACTER VARYING(3) 3
12 FI_PERSONINCHARGE CHARACTER VARYING(90) 90
13 FI_TELEPHONE CHARACTER VARYING(20) 20
14 FI_TELEXT CHARACTER VARYING(6) 6
15 FI_FAX CHARACTER VARYING(20) 20
16 FI_CLASSCODE INTEGER 4
17 FI_EMAIL CHARACTER VARYING(250) 250
18 FI_RECALCCODE INTEGER 4
19 FI_BCONSBYBRS CHARACTER VARYING(1) 1
20 FI_CONSMETHOD INTEGER 4
21 FI_RELPARTHQ DOUBLE PRECISION 8
22 FI_CLOSINGDATE TIMESTAMP 8
23 FI_VAT CHARACTER VARYING(20) 20
24 FI_COSTCENTER CHARACTER VARYING(16) 16
25 FI_MGRSTRUCTURE CHARACTER VARYING(32) 32
26 FI_TYPE INTEGER 4
27 FI_CONTROLMINORITYSUB INTEGER 4
28 FI_XBRL_SCHEME CHARACTER VARYING(256) 256
29 FI_IDENTIFIER_ID CHARACTER VARYING(256) 256