FCT_BNK_OSX_T_TFI_MASTER_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TFI_ID NATIONAL CHARACTER VARYING(255) 255
2 ISSUE_DATE DATE 4
3 TFI_NAME NATIONAL CHARACTER VARYING(128) 128
4 TFI_DESC NATIONAL CHARACTER VARYING(1024) 1024
5 HOME_MARKET NATIONAL CHARACTER VARYING(255) 255
6 ISSUER NATIONAL CHARACTER VARYING(30) 30
7 TFI_CFI_CODE NATIONAL CHARACTER VARYING(6) 6
8 TFI_TYPE NATIONAL CHARACTER VARYING(30) 30
9 TFI_SUBTYPE NATIONAL CHARACTER VARYING(30) 30
10 ISSUE_CURRENCY NATIONAL CHARACTER VARYING(3) 3
11 ELIGIBLE_CENTRAL_BANK_SET_ID INTEGER 4
12 CHAR_CUST_ELEMENT1 NATIONAL CHARACTER VARYING(30) 30
13 CHAR_CUST_ELEMENT2 NATIONAL CHARACTER VARYING(30) 30
14 CHAR_CUST_ELEMENT3 NATIONAL CHARACTER VARYING(30) 30
15 CHAR_CUST_ELEMENT4 NATIONAL CHARACTER VARYING(30) 30
16 CHAR_CUST_ELEMENT5 NATIONAL CHARACTER VARYING(30) 30
17 NUM_CUST_ELEMENT1 NUMERIC(9,4) 19
18 NUM_CUST_ELEMENT2 NUMERIC(9,4) 19
19 NUM_CUST_ELEMENT3 NUMERIC(9,4) 19
20 NUM_CUST_ELEMENT4 NUMERIC(9,4) 19
21 NUM_CUST_ELEMENT5 NUMERIC(9,4) 19
22 LAST_MODIFIED DATE 4
23 MODIFIED_BY NATIONAL CHARACTER VARYING(255) 255