OBP24_FLX_OR_SUBMISSIONS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_OR_SUBMISSIONS

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 SUBMISSION_STATUS CHARACTER VARYING(50) 50
3 INBD_DOC_CHECKLIST_ID CHARACTER VARYING(40) 40
4 REQUESTED_BY CHARACTER VARYING(10) 10
5 WITHDRAW_DATE TIMESTAMP 8
6 WITHDRAW_COMMENT CHARACTER VARYING(240) 240
7 HEADER_ID CHARACTER VARYING(50) 50
8 APPLICATION_BRANCH CHARACTER VARYING(10) 10
9 DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
10 SUBMISSION_DATE TIMESTAMP 8
11 COLL_PERFECTION_STATUS CHARACTER VARYING(50) 50
12 SUBMISSION_TYPE CHARACTER VARYING(50) 50
13 SUBMISSION_REQ_TYPE CHARACTER VARYING(50) 50
14 PRICING_TKT_NO CHARACTER VARYING(40) 40
15 EXPIRY_DATE TIMESTAMP 8
16 CREATED_BY CHARACTER VARYING(254) 254
17 CREATION_DATE TIMESTAMP 8
18 LAST_UPDATED_BY CHARACTER VARYING(254) 254
19 LAST_UPDATE_DATE TIMESTAMP 8
20 OBJECT_VERSION_NUMBER INTEGER 4
21 OBJECT_STATUS CHARACTER(1) 1
22 COMPLETION_DATE TIMESTAMP 8
23 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
24 LINKED_SUBMISSION_ID CHARACTER VARYING(50) 50
25 PROCESS_OUTPUT_INDICATOR CHARACTER VARYING(1) 1
26 ORDER_NUMBER CHARACTER VARYING(50) 50
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
31 ECID CHARACTER VARYING(100) 100
32 SUBMISSION_TIME TIMESTAMP 8