DIM_CUST_H_SOURCE_CUST_PHONE
Description
Synonyms
SDSNZP02_BANK..ATOCRS_DIM_CUST_H_SOURCE_CUST_PHONE
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 10 | PH_NUM | CHARACTER VARYING(20) | 20 |
| 11 | PH_TYP_CODE | CHARACTER VARYING(4) | 4 |
| 12 | PH_TYP_ID | BIGINT | 8 |
| 13 | PH_LNE_TYP_CODE | CHARACTER VARYING(4) | 4 |
| 14 | PH_LNE_TYP_ID | BIGINT | 8 |
| 15 | PH_CMNT | CHARACTER VARYING(50) | 50 |
| 16 | SRC_SYS_ID | CHARACTER VARYING(5) | 5 |
| 17 | LST_CUST_PHONE_DATE | TIMESTAMP | 8 |
| 18 | PH_CNTCT_FAIL_FLG | CHARACTER VARYING(4) | 4 |
| 19 | PH_CNTCT_FAIL_DATE | TIMESTAMP | 8 |
| 21 | EFF_STRT_DATE | TIMESTAMP | 8 |
| 22 | EFF_END_DATE | TIMESTAMP | 8 |
| 23 | IS_RECORD_CURRENT | CHARACTER VARYING(3) | 3 |
| 24 | IS_RECORD_DELETED | CHARACTER VARYING(3) | 3 |
| 25 | SNPSHT_DATE | TIMESTAMP | 8 |