OBP24_FLX_LM_ACCT_UTIL_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCT_CODE CHARACTER VARYING(40) 40
2 COMPONENT CHARACTER VARYING(50) 50
3 UTIL_SEQUENCE CHARACTER VARYING(20) 20
4 UTIL_BRANCH CHARACTER VARYING(10) 10
5 ACCT_PRODUCT_CODE CHARACTER VARYING(30) 30
6 ACCT_PARTY_CODE CHARACTER VARYING(40) 40
7 ACCT_MODULE_TYPE CHARACTER VARYING(3) 3
8 CREDIT_FACILITY_ID CHARACTER VARYING(40) 40
9 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
10 CR_FACILITY_UTILIZED_AMT DOUBLE PRECISION 8
11 DUES_AMT DOUBLE PRECISION 8
12 CR_FACILITY_CCY_CODE CHARACTER VARYING(3) 3
13 CR_FACILITY_REPAID_AMT DOUBLE PRECISION 8
14 ACCT_CCY_CR_FACILITY_UTIL_AMT DOUBLE PRECISION 8
15 ACCT_CCY_CR_FACILITY_REP_AMT DOUBLE PRECISION 8
16 ACCT_CCY_DUES_AMT DOUBLE PRECISION 8
17 UTIL_CCY_CODE CHARACTER VARYING(3) 3
18 UNCLEARED_UTILIZED_AMT DOUBLE PRECISION 8
19 TEMP_EXCESS_UTILIZED_AMT DOUBLE PRECISION 8
20 TEMP_OVERLINE_AMT DOUBLE PRECISION 8
21 ACCT_BLOCKED_AMT DOUBLE PRECISION 8
22 POSITIVE_ACCT_BAL_AMT DOUBLE PRECISION 8
23 NET_ACCT_BAL_AMT DOUBLE PRECISION 8
24 BORROWING_ENTITY_AMT_UTILIZED DOUBLE PRECISION 8
25 BORR_ENTITY_CCY_CODE CHARACTER VARYING(3) 3
26 LAST_UTIL_DATE TIMESTAMP 8
27 LAST_TRN_DATE TIMESTAMP 8
28 CR_FACILITY_REVAL_RATE DOUBLE PRECISION 8
29 BORROWING_ENTITY_REVAL_RATE DOUBLE PRECISION 8
30 REVAL_DATE TIMESTAMP 8
31 LAST_OL_DATE TIMESTAMP 8
32 OFFER_ID CHARACTER VARYING(30) 30
33 NETTING_UTILIZED_AMT DOUBLE PRECISION 8
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