OBP24_HST_FLX_PI_SP_BUS_GRP_STS_DTLS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PARTY_ID CHARACTER VARYING(40) 40
2 ROLE_ID CHARACTER VARYING(30) 30
3 BUSINESS_GROUP_ID CHARACTER VARYING(30) 30
4 DETERMINANT_VALUE CHARACTER VARYING(56) 56
5 EFFECTIVE_DATE TIMESTAMP 8
6 SPID CHARACTER VARYING(40) 40
7 STATUS_TYPE CHARACTER VARYING(50) 50
8 OLD_STATUS_TYPE CHARACTER VARYING(50) 50
9 REASON_CODE CHARACTER VARYING(50) 50
10 COMMENTS CHARACTER VARYING(255) 255
11 CREATED_BY CHARACTER VARYING(254) 254
12 CREATION_DATE TIMESTAMP 8
13 LAST_UPDATED_BY CHARACTER VARYING(254) 254
14 LAST_UPDATE_DATE TIMESTAMP 8
15 OBJECT_VERSION_NUMBER INTEGER 4
16 OBJECT_STATUS CHARACTER(1) 1
17 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8