OBP24_FLX_LN_ACCT_LEDGER_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TXN_DATE TIMESTAMP 8
2 TXN_COST_CENTRE_BRANCH_CODE CHARACTER VARYING(10) 10
3 BATCH_NUM BIGINT 8
4 AUDIT_TRAIL_NUM BIGINT 8
5 SUB_SEQUENCE_NUM BIGINT 8
6 ACCOUNT_ID CHARACTER VARYING(40) 40
7 VALUE_DATE TIMESTAMP 8
8 POSTING_DATE TIMESTAMP 8
9 PROCESS_DATE TIMESTAMP 8
10 EVENT_ID CHARACTER VARYING(120) 120
11 TRANSACTION_TYPE_CODE BIGINT 8
12 ACCOUNT_CURRENCY_TXN_AMT DOUBLE PRECISION 8
13 DEBIT_CREDIT_FLAG CHARACTER(1) 1
14 TRANSACTION_CURRENCY_CODE CHARACTER VARYING(3) 3
15 TRANSACTION_CURRENCY_TXN_AMT DOUBLE PRECISION 8
16 LOCAL_CURRENCY_TXN_AMT DOUBLE PRECISION 8
17 TXN_TO_LOCAL_CURRENCY_RATE DOUBLE PRECISION 8
18 ACCOUNT_TO_LOCAL_CURRENCY_RATE DOUBLE PRECISION 8
19 TXN_DESCRIPTION_TXT CHARACTER VARYING(500) 500
20 USER_NUM BIGINT 8
21 USER_ID CHARACTER VARYING(36) 36
22 CHECKER_ID CHARACTER VARYING(36) 36
23 TXN_REFERENCE_NUM CHARACTER VARYING(100) 100
24 USER_REFERENCE_NUM CHARACTER(50) 50
25 TXN_REFERENCE_NUM_ORG CHARACTER(50) 50
26 ORIG_USER_REFERENCE_NUM CHARACTER(50) 50
27 POSTING_FLAG CHARACTER(1) 1
28 CUSTOMER_ID CHARACTER VARYING(40) 40
29 CURRENCY_CODE CHARACTER VARYING(3) 3
30 ID NUMERIC(38,0) 19
31 RPA_OR_ALL_ARREAR_AMT DOUBLE PRECISION 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8