DIM_CLM_EFS_ACCOUNT_CUSTOMER_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
6 EFS_PARTY_DIM_ID CHARACTER VARYING(60) 60
7 RELATIONSHIP_TYPE CHARACTER VARYING(3) 3
9 PARTY_TYPE CHARACTER VARYING(1) 1
10 BORROWER_ENTITY_TYPE_FLAG CHARACTER VARYING(3) 3
11 BORROWER_AGAINST_ACCOUNT NUMERIC(19,0) 19
12 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(4) 4
13 PRODUCT_SYSTEM_CUSTOMER_NUMBER CHARACTER VARYING(50) 50
14 IS_PRIMARY_PARTY_ID CHARACTER VARYING(1) 1
15 GCIS_PARTY_ID CHARACTER VARYING(9) 9
16 GCIS_PARTY_TYPE CHARACTER VARYING(1) 1
17 GCIS_RELATIONSHIP_TYPE_DESCR CHARACTER VARYING(60) 60
18 EFFECTIVE_START_DATE TIMESTAMP 8
19 EFFECTIVE_END_DATE TIMESTAMP 8