FCT_BNK_EFS_IBA_NEGATIVE_BALANCE_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORTING_MONTH DATE 4
2 CUSTOMER_NR NATIONAL CHARACTER VARYING(30) 30
3 CUSTOMER_LEGAL_NAME NATIONAL CHARACTER VARYING(128) 128
4 INTERCOMPANY NATIONAL CHARACTER VARYING(2) 2
5 INDUSTRY_CODE NATIONAL CHARACTER VARYING(30) 30
6 SESCA NATIONAL CHARACTER VARYING(30) 30
7 ANZIC_CODE NATIONAL CHARACTER VARYING(20) 20
8 DEAL_ID NATIONAL CHARACTER VARYING(40) 40
9 DEAL_TYPE NATIONAL CHARACTER VARYING(30) 30
10 DEAL_SUBTYPE NATIONAL CHARACTER VARYING(30) 30
11 AMOUNT NUMERIC(25,8) 19
12 VALUE_DATE DATE 4
13 PRODUCT_CODE NATIONAL CHARACTER VARYING(40) 40
14 ACCOUNT_CODE NATIONAL CHARACTER VARYING(40) 40
15 VALUATION_TYPE NATIONAL CHARACTER VARYING(115) 115
16 OVERDRAFT_DTM_IDENTIFIER NATIONAL CHARACTER VARYING(3) 3
17 INTEREST_RATE NUMERIC(15,8) 19
18 FUNDING_RATE NUMERIC(15,8) 19
19 MATURITY_DATE DATE 4
20 RATE_VARIABILITY NATIONAL CHARACTER VARYING(40) 40