DIM_CAD_H_CARD_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..DIM_CAD_H_CARD

Columns
# Name Data Type Length
1 CARD_NUMBER CHARACTER VARYING(76) 76
2 CAD_ACCOUNT_NUMBER BIGINT 8
4 CAD_CUSTOMER_NUMBER CHARACTER VARYING(48) 48
5 EMBOSS_NAME CHARACTER VARYING(104) 104
6 EXPIRY_DATE DATE 4
7 VALID_FROM DATE 4
8 ISSUE_DATE DATE 4
9 ISSUE_REASON CHARACTER VARYING(4) 4
10 CANCEL_CODE CHARACTER VARYING(4) 4
11 PROFILE_CODE SMALLINT 2
12 PROFILE_DESC CHARACTER VARYING(80) 80
13 CODE_VALUE CHARACTER VARYING(4) 4