FCT_BNK_DEPOSIT_TRANSACTIONS_WEEKLY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 WEEK_ENDING_PERIOD NUMERIC(38,0) 19
2 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
3 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
4 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
5 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
6 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
7 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
8 ORACLE_GL_COST_CENTRE CHARACTER VARYING(150) 150
9 PRODUCT_2_DESC CHARACTER VARYING(100) 100
10 PRODUCT_3_DESC CHARACTER VARYING(100) 100
11 PRODUCT_4_DESC CHARACTER VARYING(100) 100
12 TXN_FLOW NATIONAL CHARACTER VARYING(250) 250
13 TXN_CATEGORY NATIONAL CHARACTER VARYING(250) 250
14 TXN_CLASSIFICATION NATIONAL CHARACTER VARYING(250) 250
15 TXN_CLASS_TYPE NATIONAL CHARACTER VARYING(250) 250
16 SOURCE CHARACTER VARYING(3) 3
17 NBR_TRANSACTING_ACCTS BIGINT 8
18 NBR_TXNS BIGINT 8
19 TRANSACTION_AMT DOUBLE PRECISION 8