INT_ATOCRS_SOURCE_CUSTOMER_ACCOUNT_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 EXTRACT_DATE TIMESTAMP 8
2 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(12) 12
3 PRODUCT_SYSTEM_CUSTOMER_NUMBER CHARACTER VARYING(30) 30
4 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(24) 24
5 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(20) 20
6 DEAL_NUMBER CHARACTER VARYING(24) 24
7 TRSR_ACCOUNT_NUMBER CHARACTER VARYING(20) 20
8 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
9 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
10 PRDT_GRP_CODE CHARACTER VARYING(20) 20
11 PRODUCT_GROUP_CODE CHARACTER VARYING(10) 10
12 PRDT_TYP_CODE CHARACTER VARYING(20) 20
13 PRDT_DESC CHARACTER VARYING(256) 256
14 PRDT_ID INTEGER 4
15 SRC_SYS_ID CHARACTER VARYING(4) 4
16 DERIVED_ROLE_EFF_DATE TIMESTAMP 8
17 DERIVED_ROLE_EXPIRY_DATE TIMESTAMP 8