OBP24_FLX_LN_ACCT_DISB_LOG

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 DISBURSEMENT_DATE TIMESTAMP 8
3 DISBURSEMENT_NUM BIGINT 8
4 DISBURSEMENT_CODE BIGINT 8
5 DISBURSED_AMT DOUBLE PRECISION 8
6 NET_DISBURSED_AMT DOUBLE PRECISION 8
7 LAST_DISBURSEMENT_DATE TIMESTAMP 8
8 TXN_DATE TIMESTAMP 8
9 BANK_CODE CHARACTER VARYING(10) 10
10 BRANCH_CODE CHARACTER VARYING(10) 10
11 USER_NUM BIGINT 8
12 TXN_STATUS_FLAG CHARACTER(1) 1
13 EVENT_ID CHARACTER VARYING(120) 120
14 DISBURSEMENT_SOURCE CHARACTER VARYING(40) 40
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8