OBP24_HST_FLX_IN_ADJUSTMENT_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 ARRANGEMENT_NUMBER CHARACTER VARYING(40) 40
4 INTEREST_RULE_ID CHARACTER VARYING(10) 10
5 PRODUCT_CLASS CHARACTER VARYING(50) 50
6 INT_CLASS_CODE CHARACTER VARYING(50) 50
7 INT_DIVISION_CODE CHARACTER VARYING(50) 50
8 RULE_VERSION NUMERIC(10,3) 19
9 PROCESS_DATE TIMESTAMP 8
10 EVENT_DATE TIMESTAMP 8
11 BEGIN_DATE TIMESTAMP 8
12 END_DATE TIMESTAMP 8
13 TRANSACTION_DESCRIPTION CHARACTER VARYING(250) 250
14 INTEREST_CCY CHARACTER VARYING(10) 10
15 ADJUSTMENT_TYPE CHARACTER VARYING(50) 50
16 ADJUSTMENT_AMOUNT_TYPE CHARACTER VARYING(50) 50
17 ADJUSTMENT_AMOUNT DOUBLE PRECISION 8
18 PARTY_ID CHARACTER VARYING(50) 50
19 PRODUCT_ID CHARACTER VARYING(50) 50
20 TAX_AMOUNT DOUBLE PRECISION 8
21 UNROUNDED_PRETAX_AMT DOUBLE PRECISION 8
22 ROUNDED_PRETAX_AMT DOUBLE PRECISION 8
23 ROUNDED_POSTTAX_AMT DOUBLE PRECISION 8
24 AMT_TILL_DATE DOUBLE PRECISION 8
25 AMT_MTD DOUBLE PRECISION 8
26 AMT_YTD DOUBLE PRECISION 8
27 LAST_RFRSH_DATE TIMESTAMP 8
28 ADJUSTMENT_TIME TIMESTAMP 8
29 FIN_YEAR_CODE CHARACTER VARYING(10) 10
30 REASON CHARACTER VARYING(300) 300
31 ORIGINAL_DATES CHARACTER VARYING(100) 100
32 POST_ADJUSTED_INTEREST_AMT DOUBLE PRECISION 8
33 IS_SUSP_ACCT CHARACTER VARYING(1) 1
34 ENTITY_STATUS CHARACTER VARYING(1) 1
35 CLOSURE_DATE TIMESTAMP 8
36 INTIATOR_ID CHARACTER VARYING(254) 254
37 INITIATOR_NAME CHARACTER VARYING(100) 100
38 APPROVER_ID CHARACTER VARYING(254) 254
39 APPROVER_NAME CHARACTER VARYING(100) 100
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8