OBP24_HST_CZ_SC_OR_EXPR_REQ_MASTER

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_CZ_SC_OR_EXPR_REQ_MASTER

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(50) 50
2 SUBMISSION_ID CHARACTER VARYING(20) 20
3 APPLICATION_ID CHARACTER VARYING(20) 20
4 NUM_OF_APPLICATIONS NUMERIC(20,2) 19
5 TRIGGER_VALUE CHARACTER VARYING(4) 4
6 POSTING_DATE TIMESTAMP 8
7 INVOKE_TIMESTAMP TIMESTAMP 8
8 SPARE_S1 CHARACTER VARYING(30) 30
9 SPARE_S2 CHARACTER VARYING(30) 30
10 SPARE_S3 CHARACTER VARYING(30) 30
11 SPARE_S4 CHARACTER VARYING(30) 30
12 SPARE_S5 CHARACTER VARYING(30) 30
13 SPARE_S6 CHARACTER VARYING(30) 30
14 SPARE_S7 CHARACTER VARYING(30) 30
15 SPARE_S8 CHARACTER VARYING(30) 30
16 SPARE_S9 CHARACTER VARYING(30) 30
17 SPARE_S10 CHARACTER VARYING(30) 30
18 SPARE_F1 NUMERIC(20,2) 19
19 SPARE_F2 NUMERIC(20,2) 19
20 SPARE_F3 NUMERIC(20,2) 19
21 SPARE_F4 NUMERIC(20,2) 19
22 SPARE_F5 NUMERIC(20,2) 19
23 SPARE_F6 NUMERIC(20,2) 19
24 SPARE_F7 NUMERIC(20,2) 19
25 SPARE_F8 NUMERIC(20,2) 19
26 SPARE_F9 NUMERIC(20,2) 19
27 SPARE_F10 NUMERIC(20,2) 19
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8