FCT_BNK_BF_TM1_SWAP_DEALS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 DEALNO CHARACTER VARYING(8) 8
2 PRODUCT CHARACTER VARYING(6) 6
3 INTSTRTDTE TIMESTAMP 8
4 INTENDDTE TIMESTAMP 8
5 ARRANGEMENT_TYPE CHARACTER VARYING(2) 2
6 RATECODE CHARACTER VARYING(7) 7
7 STARTDATE TIMESTAMP 8
8 MATDATE TIMESTAMP 8
9 PRIN NUMERIC(21,4) 19
10 BASERATE NUMERIC(20,8) 19
11 SPREADRATE NUMERIC(20,8) 19
12 TOTALRATE CHARACTER VARYING(400) 400
13 INTAMT NUMERIC(21,4) 19
14 SPREADAMT NUMERIC(21,4) 19
15 FIXEDINTAMT NUMERIC(21,4) 19
16 COST CHARACTER VARYING(10) 10