INT_BNK_OSX_LOAN_PROP_1_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 DEAL_ID NATIONAL CHARACTER VARYING(40) 40
2 ENTITY NATIONAL CHARACTER VARYING(12) 12
3 PROPERTY_NAME NATIONAL CHARACTER VARYING(128) 128
4 START_VALIDITY_DATE TIMESTAMP 8
5 END_VALIDITY_DATE TIMESTAMP 8
6 PROPERTY_VALUE NATIONAL CHARACTER VARYING(255) 255
7 CHAR_CUST_ELEMENT1 NATIONAL CHARACTER VARYING(40) 40
8 CHAR_CUST_ELEMENT2 NATIONAL CHARACTER VARYING(40) 40
9 CHAR_CUST_ELEMENT3 NATIONAL CHARACTER VARYING(40) 40
10 CHAR_CUST_ELEMENT4 NATIONAL CHARACTER VARYING(40) 40
11 CHAR_CUST_ELEMENT5 NATIONAL CHARACTER VARYING(40) 40
12 NUM_CUST_ELEMENT1 NUMERIC(25,8) 19
13 NUM_CUST_ELEMENT2 NUMERIC(25,8) 19
14 NUM_CUST_ELEMENT3 NUMERIC(25,8) 19
15 NUM_CUST_ELEMENT4 NUMERIC(25,8) 19
16 NUM_CUST_ELEMENT5 NUMERIC(25,8) 19
17 PROCESS_FLAG1 INTEGER 4
18 PROCESS_FLAG2 INTEGER 4
19 PROCESS_FLAG3 INTEGER 4
20 PROCESS_FLAG4 INTEGER 4
21 PROCESS_FLAG5 INTEGER 4
22 LAST_MODIFIED TIMESTAMP 8
23 MODIFIED_BY NATIONAL CHARACTER VARYING(255) 255