OBP24_HST_FLX_PL_LEDG_VAL_BAL_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEDGER_CODE CHARACTER VARYING(20) 20
2 VALUE_DATE TIMESTAMP 8
3 BANK_CODE CHARACTER VARYING(10) 10
4 BRANCH_CODE CHARACTER VARYING(10) 10
5 GAAP_CODE CHARACTER VARYING(2) 2
6 CCY_CODE CHARACTER VARYING(3) 3
7 LOCAL_CCY_CODE CHARACTER VARYING(3) 3
8 OPN_CR_BAL_AMT DOUBLE PRECISION 8
9 OPN_DR_BAL_AMT DOUBLE PRECISION 8
10 OPN_CR_BAL_LCY_AMT DOUBLE PRECISION 8
11 OPN_DR_BAL_LCY_AMT DOUBLE PRECISION 8
12 CR_BAL_AMT DOUBLE PRECISION 8
13 DR_BAL_AMT DOUBLE PRECISION 8
14 CR_BAL_LCY_AMT DOUBLE PRECISION 8
15 DR_BAL_LCY_AMT DOUBLE PRECISION 8
16 CR_MOV_AMT DOUBLE PRECISION 8
17 DR_MOV_AMT DOUBLE PRECISION 8
18 CR_MOV_LCY_AMT DOUBLE PRECISION 8
19 DR_MOV_LCY_AMT DOUBLE PRECISION 8
20 LEDGER_LEVEL_TYP CHARACTER VARYING(3) 3
21 LEDGER_CATEGORY_TYPE CHARACTER VARYING(3) 3
22 TURN_OVER_FLAG CHARACTER VARYING(1) 1
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8