OBP24_HST_FLX_LN_EVENT_SIMULATION_QUOTES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 QUOTE_REFERENCE_NO CHARACTER VARYING(40) 40
3 QUOTE_GENERATION_DATE TIMESTAMP 8
4 SIMULATION_EVENT_TYPE CHARACTER VARYING(20) 20
5 ECONOMIC_COST_AMOUNT DOUBLE PRECISION 8
6 CURRENCY_CODE CHARACTER VARYING(3) 3
7 EXPECTED_PPF_AMOUNT DOUBLE PRECISION 8
8 EXPECTED_EFS_AMOUNT DOUBLE PRECISION 8
9 PPF_AMOUNT DOUBLE PRECISION 8
10 UNBILLED_INTEREST DOUBLE PRECISION 8
11 UNBILLED_PENALTY DOUBLE PRECISION 8
12 TOTAL_UNBILLED_DUE DOUBLE PRECISION 8
13 NEW_RATE DOUBLE PRECISION 8
14 EFFECTIVE_DATE TIMESTAMP 8
15 OBJECT_STATUS CHARACTER(1) 1
16 CREATED_BY CHARACTER VARYING(254) 254
17 LAST_UPDATED_BY CHARACTER VARYING(254) 254
18 LAST_UPDATED_DATE TIMESTAMP 8
19 CREATION_DATE TIMESTAMP 8
20 OBJECT_VERSION_NUMBER BIGINT 8
21 UDM_VARIABLE_RATE DOUBLE PRECISION 8
22 UDM_FIXED_RATE DOUBLE PRECISION 8
23 QUOTE_STATUS CHARACTER VARYING(15) 15
24 PRINCIPAL_OUTSTANDING_AMOUNT DOUBLE PRECISION 8
25 EFS_FEES_AMOUNT DOUBLE PRECISION 8
26 PENDING_PERIODIC_FEE_AMOUNT DOUBLE PRECISION 8
27 THRESHOLD_EFS_AMOUNT DOUBLE PRECISION 8
28 ADVANCE_FUNDS DOUBLE PRECISION 8
29 PREMIUM_REFUND_AMOUNT DOUBLE PRECISION 8
30 PENDING_ORI_FEE_AMOUNT DOUBLE PRECISION 8
31 PENDING_FACILITY_FEE_AMOUNT DOUBLE PRECISION 8
32 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
33 INSURANCE_OUTSTANDING_AMOUNT DOUBLE PRECISION 8
34 INSURANCE_ARREARS DOUBLE PRECISION 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8