DIM_CUST_H_PRODUCT
Description
Synonyms
SDSNZP02_BANK..ATOCRS_DIM_CUST_H_PRODUCT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PRDT_ID | NUMERIC(22,0) | 19 |
| 2 | PRDT_SYS_CODE | CHARACTER VARYING(10) | 10 |
| 3 | PRDT_TYP_CODE | CHARACTER VARYING(20) | 20 |
| 4 | PRDT_GRP_CODE | CHARACTER VARYING(20) | 20 |
| 5 | PRDT_SEGMENT_GRP_ID | CHARACTER VARYING(20) | 20 |
| 6 | PRDT_SEGMENT_GRP_CODE | CHARACTER VARYING(20) | 20 |
| 7 | SRC_SYS_ID | CHARACTER VARYING(5) | 5 |
| 8 | PRDT_PTS | CHARACTER VARYING(10) | 10 |
| 9 | PRDT_DESC | CHARACTER VARYING(100) | 100 |
| 10 | PRDT_APPROVED | CHARACTER VARYING(1) | 1 |
| 12 | EFF_STRT_DATE | TIMESTAMP | 8 |
| 13 | EFF_END_DATE | TIMESTAMP | 8 |
| 14 | IS_RECORD_CURRENT | CHARACTER VARYING(3) | 3 |
| 15 | IS_RECORD_DELETED | CHARACTER VARYING(3) | 3 |
| 16 | SNPSHT_DATE | TIMESTAMP | 8 |