OBP24_HST_FLX_IN_STAT_ARCHIVE

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID CHARACTER VARYING(40) 40
2 ARRANGEMENT_NUMBER CHARACTER VARYING(45) 45
3 EFFECTIVE_DATE TIMESTAMP 8
4 INTEREST_CLASS CHARACTER VARYING(50) 50
5 INTEREST_DIVISION CHARACTER VARYING(50) 50
6 ARCHIVE_DATE TIMESTAMP 8
7 PREV_STAT_BEGIN_DATE TIMESTAMP 8
8 PREV_STAT_END_DATE TIMESTAMP 8
9 INTEREST_CCY CHARACTER VARYING(10) 10
10 SETLMNT_STAT_INT_SETLD_AMT DOUBLE PRECISION 8
11 SETLMNT_STAT_SETLMNT_DATE TIMESTAMP 8
12 SETLMNT_STAT_NEXT_SETLMNT_DATE TIMESTAMP 8
13 SETLMNT_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
14 SETLMNT_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
15 CAPTLZN_STAT_INT_CAPTLZD_AMT DOUBLE PRECISION 8
16 CAPTLZN_STAT_CAPTLZN_DATE TIMESTAMP 8
17 CAPTLZN_STAT_NXT_SCHD_DATE TIMESTAMP 8
18 CAPTLZN_STAT_NXT_PROC_DATE TIMESTAMP 8
19 CAPTLZN_STAT_NXT_DUE_DATE TIMESTAMP 8
20 CAPTLZN_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
21 CAPTLZN_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
22 SETLMNT_STAT_ADJ_INT_AMT DOUBLE PRECISION 8
23 SETLMNT_STAT_ADJ_INT_ENT_TYPE CHARACTER VARYING(50) 50
24 CAPTLZN_STAT_ADJ_INT_AMT DOUBLE PRECISION 8
25 CAPTLZN_STAT_ADJ_INT_ENT_TYPE CHARACTER VARYING(50) 50
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8