DIM_BNK_OSX_T_ENTITY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ENTITY CHARACTER VARYING(12) 12
2 NAME CHARACTER VARYING(128) 128
3 DESCRIPTION CHARACTER VARYING(1024) 1024
4 CALENDAR CHARACTER VARYING(10) 10
5 ACCOUNT_CATEGORY CHARACTER VARYING(8) 8
6 PREV_COB_DATE DATE 4
7 COB_DATE DATE 4
8 NEXT_COB_DATE DATE 4
9 CURRENT_YEAR INTEGER 4
10 CURRENT_PERIOD INTEGER 4
11 REPORTING_YEAR INTEGER 4
12 REPORTING_PERIOD INTEGER 4
13 ED_NUM_PERIODS_FORWARD INTEGER 4
14 ED_NUM_PERIODS_BACK INTEGER 4
15 VD_NUM_PERIODS_FORWARD INTEGER 4
16 VD_NUM_PERIODS_BACK INTEGER 4
17 LCL_CURRENCY CHARACTER VARYING(3) 3
18 RPT_CURRENCY CHARACTER VARYING(3) 3
19 TYP_LGE_TYPE INTEGER 4
20 CHAR_CUST_ELEMENT1 CHARACTER VARYING(40) 40
21 CHAR_CUST_ELEMENT2 CHARACTER VARYING(40) 40
22 CHAR_CUST_ELEMENT3 CHARACTER VARYING(40) 40
23 CHAR_CUST_ELEMENT4 CHARACTER VARYING(40) 40
24 CHAR_CUST_ELEMENT5 CHARACTER VARYING(40) 40
25 NUM_CUST_ELEMENT1 NUMERIC(25,8) 19
26 NUM_CUST_ELEMENT2 NUMERIC(25,8) 19
27 NUM_CUST_ELEMENT3 NUMERIC(25,8) 19
28 NUM_CUST_ELEMENT4 NUMERIC(25,8) 19
29 NUM_CUST_ELEMENT5 NUMERIC(25,8) 19
30 LAST_MODIFIED CHARACTER VARYING(1) 1
31 MODIFIED_BY CHARACTER VARYING(255) 255