OBP24_HST_CZ_SC_LM_PPSR_REG_INFO_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_REQ_MSG_ID CHARACTER VARYING(60) 60
2 REG_SEQ_NO DOUBLE PRECISION 8
3 CHANGE_NO DOUBLE PRECISION 8
4 REG_NO CHARACTER VARYING(60) 60
5 PPSR_TRAN_ID DOUBLE PRECISION 8
6 REG_START_DATE TIMESTAMP 8
7 REG_END_DATE TIMESTAMP 8
8 IS_REG_END_DATE_CHANGE CHARACTER(1) 1
9 REG_CHANGE_TIME TIMESTAMP 8
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8