DIM_CUST_H_SOURCE_CUST_ADDR
Description
Synonyms
SDSNZP02_BANK..ATOCRS_DIM_CUST_H_SOURCE_CUST_ADDR
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 10 | ADDR_TYP_CODE | CHARACTER VARYING(20) | 20 |
| 11 | ADDR_TYP_ID | BIGINT | 8 |
| 12 | ADDR_LNE_1 | CHARACTER VARYING(50) | 50 |
| 13 | ADDR_LNE_2 | CHARACTER VARYING(50) | 50 |
| 14 | ADDR_LNE_3 | CHARACTER VARYING(50) | 50 |
| 15 | SBRB_CODE | CHARACTER VARYING(50) | 50 |
| 16 | PCODE | CHARACTER VARYING(20) | 20 |
| 17 | STATE_DESC | CHARACTER VARYING(50) | 50 |
| 18 | CNTRY_CODE | CHARACTER VARYING(20) | 20 |
| 19 | CNTRY_ID | BIGINT | 8 |
| 20 | DPID | CHARACTER VARYING(20) | 20 |
| 21 | DPID_TYP_CODE | CHARACTER VARYING(4) | 4 |
| 22 | DPID_TYP_ID | BIGINT | 8 |
| 23 | RTRN_MAIL_FLG | CHARACTER VARYING(3) | 3 |
| 24 | POSTAL_ADDR_TYP_CODE | CHARACTER VARYING(20) | 20 |
| 25 | POSTAL_ADDR_TYP_ID | BIGINT | 8 |
| 26 | ADDR_STD_CODE | CHARACTER VARYING(10) | 10 |
| 27 | ADDR_STD_ID | BIGINT | 8 |
| 28 | SRC_SYS_ID | CHARACTER VARYING(5) | 5 |
| 29 | LST_CUST_ADDR_DATE | TIMESTAMP | 8 |
| 30 | RTRN_MAIL_DATE | TIMESTAMP | 8 |
| 32 | EFF_STRT_DATE | TIMESTAMP | 8 |
| 33 | EFF_END_DATE | TIMESTAMP | 8 |
| 34 | IS_RECORD_CURRENT | CHARACTER VARYING(3) | 3 |
| 35 | IS_RECORD_DELETED | CHARACTER VARYING(3) | 3 |
| 36 | SNPSHT_DATE | TIMESTAMP | 8 |