OBP24_HST_FLX_LN_FIN_STMT_LOGS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TXN_REF_NO CHARACTER VARYING(50) 50
2 SUB_SEQ_NO DOUBLE PRECISION 8
3 ACCOUNT_CODE CHARACTER VARYING(50) 50
4 TXN_CHANNEL CHARACTER VARYING(50) 50
5 TXN_BRANCH CHARACTER VARYING(10) 10
6 TXN_DESC CHARACTER VARYING(500) 500
7 SERVICE_ID CHARACTER VARYING(50) 50
8 EVENT_ID CHARACTER VARYING(50) 50
9 USER_REF_NO CHARACTER VARYING(50) 50
10 USER_NO CHARACTER VARYING(50) 50
11 AUTHORIZER_CODE CHARACTER VARYING(50) 50
12 CHEQUE_NO CHARACTER VARYING(50) 50
13 MSG_TYPE CHARACTER VARYING(50) 50
14 TXN_TYPE CHARACTER VARYING(50) 50
15 TXN_AMOUNT_TCY DOUBLE PRECISION 8
16 TCY_CODE CHARACTER VARYING(3) 3
17 TXN_AMOUNT_ACY DOUBLE PRECISION 8
18 ACY_CODE CHARACTER VARYING(3) 3
19 POSTING_DATE TIMESTAMP 8
20 VALUE_DATE TIMESTAMP 8
21 TRANSACTION_DATE TIMESTAMP 8
22 PRICING_TICKET_NO CHARACTER VARYING(50) 50
23 SETTLEMENT_REF_ID CHARACTER VARYING(40) 40
24 CHEQUE_DEPOSIT_DATE TIMESTAMP 8
25 CHEQUE_VALUE_DATE TIMESTAMP 8
26 NARRATION CHARACTER VARYING(500) 500
27 END_POINT_SEGMENT_ID CHARACTER VARYING(100) 100
28 PRICING_DEF_ID CHARACTER VARYING(50) 50
29 ATM_NARRATION CHARACTER VARYING(40) 40
30 TXN_LITERAL CHARACTER VARYING(100) 100
31 SEARCH_SUMMARY CHARACTER VARYING(500) 500
32 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
33 PROCESS_DATE TIMESTAMP 8
34 PARTY_ID CHARACTER VARYING(40) 40
35 PARTY_NAME CHARACTER VARYING(100) 100
36 ACCOUNT_TITLE CHARACTER VARYING(120) 120
37 SANCTIONED_AMT DOUBLE PRECISION 8
38 SANCTIONED_TERM_MONTHS BIGINT 8
39 TOTAL_DISBURSED_AMT DOUBLE PRECISION 8
40 OUTSTANDING_PRINCIPAL_BAL DOUBLE PRECISION 8
41 STATEMENT_PERIOD_START_DATE TIMESTAMP 8
42 STATEMENT_PERIOD_END_DATE TIMESTAMP 8
43 TRANSACTION_TIME TIMESTAMP 8
44 TRANSACTION_KEYWORD CHARACTER VARYING(40) 40
45 TOTAL_OUTSTANDING_BAL DOUBLE PRECISION 8
46 RUNNING_BAL DOUBLE PRECISION 8
47 PAYMENT_DETAILS CHARACTER VARYING(120) 120
48 RPA_OR_ALL_ARREAR_AMT DOUBLE PRECISION 8
49 CHEQUE_DATE TIMESTAMP 8
50 CARD_REF_NO CHARACTER VARYING(50) 50
51 FX_RATE DOUBLE PRECISION 8
52 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
53 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
54 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
55 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8