OBP24_HST_FLX_DD_ACCT_BALANCES_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 BALANCE_CCY_CODE CHARACTER VARYING(10) 10
3 EFFECTIVE_DATE TIMESTAMP 8
4 CLEAR_AMT DOUBLE PRECISION 8
5 UNCLEAR_AMT DOUBLE PRECISION 8
6 UTIL_OD_LIMIT_AMT DOUBLE PRECISION 8
7 OVERLINE_AMT DOUBLE PRECISION 8
8 TOD_AMT DOUBLE PRECISION 8
9 UTIL_AUF_LIMIT_AMT DOUBLE PRECISION 8
10 USER_HOLD_AMT DOUBLE PRECISION 8
11 SYS_HOLD_AMT DOUBLE PRECISION 8
12 AUF_LIMIT_AMT DOUBLE PRECISION 8
13 AUF_LENDABLE_PERCENTAGE DOUBLE PRECISION 8
14 TE_AMT DOUBLE PRECISION 8
15 IS_CREDIT CHARACTER(1) 1
16 PERIODIC_FEE_AMT DOUBLE PRECISION 8
17 OD_START_DATE TIMESTAMP 8
18 AUF_START_DATE TIMESTAMP 8
19 TE_START_DATE TIMESTAMP 8
20 TOTAL_OFFSET_CLEAR_AMT DOUBLE PRECISION 8
21 TOTAL_OFFSET_UNCLEAR_AMT DOUBLE PRECISION 8
22 IS_OFFSET_ACCOUNT CHARACTER(1) 1
23 OD_FACILITY_ID CHARACTER VARYING(40) 40
24 AUF_FACILITY_ID CHARACTER VARYING(40) 40
25 TE_FACILITY_ID CHARACTER VARYING(40) 40
26 OD_LIMIT_AMT DOUBLE PRECISION 8
27 TE_LIMIT_AMT DOUBLE PRECISION 8
28 AUF_SANTIONED_LIMIT_AMT DOUBLE PRECISION 8
29 TE_SANTIONED_LIMIT_AMT DOUBLE PRECISION 8
30 OD_SANTIONED_LIMIT_AMT DOUBLE PRECISION 8
31 UTILIZED_OFFSET_CLEAR_AMT DOUBLE PRECISION 8
32 UTILIZED_OFFSET_UNCLEAR_AMT DOUBLE PRECISION 8
33 STOP_CREDIT_INTEREST CHARACTER(1) 1
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8