OBP24_FLX_IN_TD_ACCRUAL_LOGITEM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_IN_TD_ACCRUAL_LOGITEM

Columns
# Name Data Type Length
1 LOG_ID CHARACTER VARYING(300) 300
2 TRANSACTION_REFERENCE_NUMBER CHARACTER VARYING(100) 100
3 UNROUNDED_PRETAX_AMT DOUBLE PRECISION 8
4 ROUNDED_PRETAX_AMT DOUBLE PRECISION 8
5 ROUNDED_POSTTAX_AMT DOUBLE PRECISION 8
6 TAX_AMOUNT DOUBLE PRECISION 8
7 ARRANGEMENT_NUMBER CHARACTER VARYING(45) 45
8 INTEREST_RULE_ID CHARACTER VARYING(10) 10
9 PRODUCT_CLASS CHARACTER VARYING(50) 50
10 INT_CLASS_CODE CHARACTER VARYING(50) 50
11 INT_DIVISION_CODE CHARACTER VARYING(50) 50
12 RULE_VERSION NUMERIC(10,3) 19
13 PROCESS_DATE TIMESTAMP 8
14 EVENT_DATE TIMESTAMP 8
15 BEGIN_DATE TIMESTAMP 8
16 END_DATE TIMESTAMP 8
17 TRANSACTION_DESCRIPTION CHARACTER VARYING(250) 250
18 INTEREST_CCY CHARACTER VARYING(10) 10
19 AMT_TILL_DATE DOUBLE PRECISION 8
20 AMT_MTD DOUBLE PRECISION 8
21 AMT_YTD DOUBLE PRECISION 8
22 LAST_RFRSH_DATE TIMESTAMP 8
23 INTEREST_ACCRUED_LST_DTE_AMT DOUBLE PRECISION 8
24 PRE_TAX_INT_ACCD_LST_DTE_AMT DOUBLE PRECISION 8
25 IS_SUSP_ACCT CHARACTER VARYING(1) 1
26 SUSP_INT_AMT DOUBLE PRECISION 8
27 IS_ACCT_IN_EXC_STATUS CHARACTER VARYING(1) 1
28 PENALTY_AMT DOUBLE PRECISION 8
29 REFUNDED_TAX_AMOUNT DOUBLE PRECISION 8
30 RECOVERED_ADMIN_FEE DOUBLE PRECISION 8
31 RECOVERED_ECONOMIC_COST DOUBLE PRECISION 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8