OBP24_FLX_IN_LN_SIM_LOG_ITEM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LOG_ID CHARACTER VARYING(100) 100
2 SIMULATION_ID CHARACTER VARYING(100) 100
3 TERM_BEGIN_DATE TIMESTAMP 8
4 TERM_END_DATE TIMESTAMP 8
5 CHARGING_BEGIN_DATE TIMESTAMP 8
6 CHARGING_END_DATE TIMESTAMP 8
7 EVENT_DATE TIMESTAMP 8
8 INTEREST_CLASS CHARACTER VARYING(10) 10
9 INTEREST_DIVISION CHARACTER VARYING(10) 10
10 PRODUCT_CLASS CHARACTER VARYING(10) 10
11 INT_CONST_TYPE CHARACTER VARYING(40) 40
12 RATE DOUBLE PRECISION 8
13 PRINCIPAL_AMT DOUBLE PRECISION 8
14 PER_DAY_COMP_FACT DOUBLE PRECISION 8
15 UNROUNDED_INT_AMT DOUBLE PRECISION 8
16 ROUNDED_INT_AMT DOUBLE PRECISION 8
17 INT_CMP_TILL_DATE DOUBLE PRECISION 8
18 INTEREST_CCY CHARACTER VARYING(10) 10
19 INTEREST_PHASE CHARACTER VARYING(15) 15
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8