FCT_BNK_NROD_ALL_TRANSACTION_RECON_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_BNK_NROD_ALL_TRANSACTION_RECON

Columns
# Name Data Type Length
1 DATA_DATE DATE 4
2 SOURCE_SYSTEM CHARACTER VARYING(5) 5
3 PRODUCT CHARACTER VARYING(5) 5
4 SOURCE_COUNT BIGINT 8
5 SOURCE_AMOUNT NUMERIC(38,2) 19
6 NROD_COUNT BIGINT 8
7 NROD_AMOUNT NUMERIC(38,2) 19
8 VALID_EXCLUSION_FEE_COUNT BIGINT 8
9 VALID_EXCLUSION_FEE_AMOUNT DOUBLE PRECISION 8
10 VALID_EXCLUSION_NO_AMOUNT_COUNT BIGINT 8
11 VALID_EXCLUSION_NO_AMOUNT DOUBLE PRECISION 8
12 VALID_EXCLUSION_NON_FINANCIAL_COUNT BIGINT 8
13 VALID_EXCLUSION_NON_FINANCIAL_AMOUNT NUMERIC(38,2) 19
14 VALID_EXCLUSION_OBP_MIGRATION_USER_COUNT BIGINT 8
15 VALID_EXCLUSION_OBP_MIGRATION_USER_AMOUNT DOUBLE PRECISION 8
16 VALID_EXCLUSION_COUNT BIGINT 8
17 VALID_EXCLUSION_AMOUNT DOUBLE PRECISION 8
18 DET_TXN_EXCEPTION_COUNT BIGINT 8
19 DET_TXN_EXCEPTION_AMOUNT NUMERIC(38,2) 19
20 UNKNOWN_TXN_COUNT BIGINT 8
21 UNKNOWN_TXN_AMOUNT INTEGER 4