FCT_OBP_BLOCKS_TD_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_BLOCKS_TD

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 DEPOSIT_ID DOUBLE PRECISION 8
3 SERIAL_NUMBER DOUBLE PRECISION 8
4 BLOCK_REASON_CODE CHARACTER VARYING(10) 10
5 BLOCK_REASON_DESCRIPTION CHARACTER VARYING(120) 120
6 UNBLOCK_REASON_CODE CHARACTER VARYING(10) 10
7 UNBLOCK_REASON_DESCRIPTION CHARACTER VARYING(120) 120
8 ACTIVE_FLAG CHARACTER(1) 1
9 ADDITION_DATE TIMESTAMP 8
10 REMOVAL_DATE TIMESTAMP 8
11 COMMENT_TXT CHARACTER VARYING(120) 120
12 WARNING_INDICATOR_ID CHARACTER VARYING(50) 50
13 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
14 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
18 IS_CURRENT CHARACTER VARYING(1) 1