OBP24_HST_FLX_PL_LEDG_PRD_BAL_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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