| 1 |
efs_party_dim_id |
character varying |
129 |
| 2 |
source_system_customer_id |
character varying |
120 |
| 3 |
source_system_code |
character varying |
9 |
| 4 |
address_type |
character varying |
30 |
| 5 |
address_line1 |
character varying |
360 |
| 6 |
address_line2 |
character varying |
360 |
| 7 |
address_line3 |
character varying |
360 |
| 8 |
city_twn_suburb |
character varying |
150 |
| 9 |
postcode |
character varying |
90 |
| 10 |
state |
character varying |
90 |
| 11 |
country_code |
character varying |
6 |
| 12 |
effective_start_date |
timestamp without time zone |
|
| 13 |
effective_end_date |
timestamp without time zone |
|
| 14 |
is_current |
character varying |
3 |