OBP24_HST_CI_PTP

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_CI_PTP

Columns
# Name Data Type Length
1 PTP_ID CHARACTER(10) 10
2 PP_TYPE_CD CHARACTER(12) 12
3 USER_ID CHARACTER(255) 255
4 ACCT_ID CHARACTER(10) 10
5 PAYOR_ACCT_ID CHARACTER(10) 10
6 THRD_PTY_SW CHARACTER(1) 1
7 THRD_PTY_PAYOR_CD CHARACTER(12) 12
8 START_DT TIMESTAMP 8
9 PAY_METH_CD CHARACTER(10) 10
10 PP_CAN_RSN_FLG CHARACTER(2) 2
11 LAST_STAT_DTTM TIMESTAMP 8
12 LAST_STAT_USER_ID CHARACTER(255) 255
13 COMMENTS CHARACTER VARYING(254) 254
14 VERSION INTEGER 4
15 CRE_DTTM TIMESTAMP 8
16 SA_ID CHARACTER(10) 10
17 CAN_RSN_CD CHARACTER(4) 4
18 APPROVER_ID CHARACTER(255) 255
19 APPROVE_DTTM TIMESTAMP 8
20 INCLUDE_REPAYMENT_SW CHARACTER(1) 1
21 BUS_OBJ_CD CHARACTER(30) 30
22 BO_STATUS_CD CHARACTER(12) 12
23 BO_DATA_AREA CHARACTER VARYING(2000) 2000
24 STATUS_UPD_DTTM TIMESTAMP 8
25 PP_STAT_FLG CHARACTER(2) 2
26 CASE_ID CHARACTER(10) 10
27 PTP_GEN_DTTM TIMESTAMP 8
28 CC_ID CHARACTER(10) 10
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8