OBP24_FLX_PL_SYSACT_DET_VAL_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 VALUE_DATE TIMESTAMP 8
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 ACCOUNT_ID CHARACTER VARYING(30) 30
9 PARTY_ID CHARACTER VARYING(30) 30
10 PRODUCT_ID CHARACTER VARYING(30) 30
11 LOCAL_CCY_CODE CHARACTER VARYING(3) 3
12 OPN_CR_BAL_AMT DOUBLE PRECISION 8
13 OPN_DR_BAL_AMT DOUBLE PRECISION 8
14 OPN_CR_BAL_LCY_AMT DOUBLE PRECISION 8
15 OPN_DR_BAL_LCY_AMT DOUBLE PRECISION 8
16 CR_BAL_AMT DOUBLE PRECISION 8
17 DR_BAL_AMT DOUBLE PRECISION 8
18 CR_BAL_LCY_AMT DOUBLE PRECISION 8
19 DR_BAL_LCY_AMT DOUBLE PRECISION 8
20 CR_MOV_AMT DOUBLE PRECISION 8
21 DR_MOV_AMT DOUBLE PRECISION 8
22 CR_MOV_LCY_AMT DOUBLE PRECISION 8
23 DR_MOV_LCY_AMT DOUBLE PRECISION 8
24 LEDGER_LEVEL_TYP CHARACTER VARYING(3) 3
25 LEDGER_CATEGORY_TYPE CHARACTER VARYING(3) 3
26 TURN_OVER_FLAG CHARACTER VARYING(1) 1
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8