OBP24_HST_FLX_PL_SYSACT_PRD_BAL_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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