OBP24_HST_FLX_IN_LN_CAPITAL_LOGITEM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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 PRE_TAX_NET_INT_AMT DOUBLE PRECISION 8
7 TAX_AMOUNT DOUBLE PRECISION 8
8 ARRANGEMENT_NUMBER CHARACTER VARYING(45) 45
9 INTEREST_RULE_ID CHARACTER VARYING(10) 10
10 PRODUCT_CLASS CHARACTER VARYING(50) 50
11 INT_CLASS_CODE CHARACTER VARYING(50) 50
12 INT_DIVISION_CODE CHARACTER VARYING(50) 50
13 RULE_VERSION NUMERIC(10,3) 19
14 PROCESS_DATE TIMESTAMP 8
15 EVENT_DATE TIMESTAMP 8
16 BEGIN_DATE TIMESTAMP 8
17 END_DATE TIMESTAMP 8
18 TRANSACTION_DESCRIPTION CHARACTER VARYING(250) 250
19 INTEREST_CCY CHARACTER VARYING(10) 10
20 AMT_TILL_DATE DOUBLE PRECISION 8
21 PRE_TAX_AMT_TILL_DATE DOUBLE PRECISION 8
22 AMT_MTD DOUBLE PRECISION 8
23 AMT_YTD DOUBLE PRECISION 8
24 LAST_RFRSH_DATE TIMESTAMP 8
25 SUSP_INT_AMT DOUBLE PRECISION 8
26 IS_ACCT_IN_EXC_STATUS CHARACTER VARYING(1) 1
27 SCHEDULED_DATE TIMESTAMP 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8