OBP24_FLX_DD_ACCT_STATUS_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AUDIT_TRAIL_CODE CHARACTER VARYING(40) 40
2 ACCOUNT_CODE CHARACTER VARYING(40) 40
3 STATUS_DEFINE_TYPE CHARACTER VARYING(40) 40
4 FROM_EFFECTIVE_DATE TIMESTAMP 8
5 TO_EFFECTIVE_DATE TIMESTAMP 8
6 FROM_PROCESS_DATE TIMESTAMP 8
7 TO_PROCESS_DATE TIMESTAMP 8
8 CREATED_BY CHARACTER VARYING(254) 254
9 AUTHORIZED_BY CHARACTER VARYING(254) 254
10 CREATION_DATE TIMESTAMP 8
11 AUTHORIZATION_DATE TIMESTAMP 8
12 SYS_STAT_EFFECTIVE_DATE TIMESTAMP 8
13 SYS_STAT_PROCESS_DATE TIMESTAMP 8
14 SYS_STAT_TYPE CHARACTER VARYING(40) 40
15 SYS_STAT_REASON_CODES CHARACTER VARYING(40) 40
16 TRN_REFERENCE_NO CHARACTER VARYING(50) 50
17 TRN_CODE CHARACTER VARYING(50) 50
18 TRN_LITERAL CHARACTER VARYING(50) 50
19 USER_NO CHARACTER VARYING(50) 50
20 AUTHORIZER_CODE CHARACTER VARYING(50) 50
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8