FCT_BNK_DV_FLOW_OF_FUNDS_SSS_DEP_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID INTEGER 4
2 TIME_PERIOD DATE 4
3 CATEGORY CHARACTER VARYING(256) 256
4 FLOW CHARACTER VARYING(256) 256
5 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
6 SOURCE_PRODUCT_L2 CHARACTER VARYING(100) 100
7 SOURCE_PRODUCT_L3_DESC CHARACTER VARYING(100) 100
8 SOURCE_PRODUCT_L4_DESC CHARACTER VARYING(100) 100
9 OFFER_DESC CHARACTER VARYING(120) 120
10 COST_CENTRE_NAME CHARACTER VARYING(240) 240
11 GEOGRAPHIC_STATE CHARACTER VARYING(3) 3
12 REGION CHARACTER VARYING(240) 240
13 CHANNEL CHARACTER VARYING(50) 50
14 MEASURE DOUBLE PRECISION 8
15 TRANSFER_IN DOUBLE PRECISION 8
16 TRANSFER_OUT DOUBLE PRECISION 8
17 FEES DOUBLE PRECISION 8
18 DEPOSIT DOUBLE PRECISION 8
19 WITHDRAWAL DOUBLE PRECISION 8
20 INTEREST DOUBLE PRECISION 8
21 NET_TRANSFER DOUBLE PRECISION 8
22 INFLOW DOUBLE PRECISION 8
23 OUTFLOW DOUBLE PRECISION 8
24 OPENING_BALANCE DOUBLE PRECISION 8
25 CLOSING_BALANCE DOUBLE PRECISION 8
26 MOVEMENT DOUBLE PRECISION 8