OBP24_HST_FLX_NP_ACCT_PROVISION_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 PROVISION_ID DOUBLE PRECISION 8
3 PARTY_ID CHARACTER VARYING(40) 40
4 ACCOUNT_TYPE CHARACTER VARYING(2) 2
5 ACCOUNT_STATUS_CODE CHARACTER VARYING(5) 5
6 PROVISION_EFFECTIVE_DATE TIMESTAMP 8
7 PROVISION_CCY CHARACTER VARYING(3) 3
8 PROVISION_POST_WROFF_AMT DOUBLE PRECISION 8
9 CASH_FLOW_APPROVED_FLAG CHARACTER(1) 1
10 ERV_CASHFLOW_VALUE_AMT DOUBLE PRECISION 8
11 OBJECT_VERSION_NUMBER BIGINT 8
12 CREATED_BY CHARACTER VARYING(254) 254
13 AUTHORIZED_BY CHARACTER VARYING(254) 254
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8