SDW_TSDMD_DEAL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDMD_DEAL

Columns
# Name Data Type Length
1 DEAL_DIM_ID BIGINT 8
2 DEAL_NUMBER CHARACTER VARYING(24) 24
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
4 PRODUCT_TYPE_CODE CHARACTER VARYING(6) 6
5 PRODUCT_CODE CHARACTER VARYING(6) 6
6 BUSINESS_LOAD_DATE TIMESTAMP 8
7 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
8 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
9 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
10 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8