FCT_BNK_OSX_T_PROVISION

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ENTITY NATIONAL CHARACTER VARYING(12) 12
2 PROVISION_ID NATIONAL CHARACTER VARYING(40) 40
3 START_VALIDITY_DATE DATE 4
4 END_VALIDITY_DATE DATE 4
5 DESCRIPTION NATIONAL CHARACTER VARYING(1024) 1024
6 PROVISION_TYPE INTEGER 4
7 OBJECT_ORIGIN NATIONAL CHARACTER VARYING(20) 20
8 OBJECT_KEY_TYPE NATIONAL CHARACTER VARYING(1) 1
9 OBJECT_KEY_VALUE NATIONAL CHARACTER VARYING(500) 500
10 PROVISION_AMOUNT NUMERIC(25,8) 19
11 PROVISION_CURRENCY NATIONAL CHARACTER VARYING(3) 3
12 EFFECTIVE_DATE DATE 4
13 LAST_REVIEW_DATE DATE 4
14 REVERSAL_DATE DATE 4
15 CREDIT_OFFICER NATIONAL CHARACTER VARYING(20) 20
16 CHAR_CUST_ELEMENT1 NATIONAL CHARACTER VARYING(40) 40
17 CHAR_CUST_ELEMENT2 NATIONAL CHARACTER VARYING(40) 40
18 CHAR_CUST_ELEMENT3 NATIONAL CHARACTER VARYING(40) 40
19 CHAR_CUST_ELEMENT4 NATIONAL CHARACTER VARYING(40) 40
20 CHAR_CUST_ELEMENT5 NATIONAL CHARACTER VARYING(40) 40
21 NUM_CUST_ELEMENT1 NUMERIC(25,8) 19
22 NUM_CUST_ELEMENT2 NUMERIC(25,8) 19
23 NUM_CUST_ELEMENT3 NUMERIC(25,8) 19
24 NUM_CUST_ELEMENT4 NUMERIC(25,8) 19
25 NUM_CUST_ELEMENT5 NUMERIC(25,8) 19
26 LAST_MODIFIED DATE 4
27 MODIFIED_BY NATIONAL CHARACTER VARYING(255) 255