3.2.3 Party Address Details
Entity Name: ADDR
Description: This table holds party address data from product processor.
Data Sequence:
ADDR|Party Id|Address Type|Address 1|Address 2|Address 3|Address 4|City|State|Country|Zip Code|Preferred Address|Effective Date|Address ID|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50
Table 3-9 Party Address Details
Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
---|---|---|---|---|---|
Party Id | Party Id as stored in Host | - | VARCHAR2 | 30 | Required |
Address Type | Address Type Code |
HOM - Home COM - Communication WRK - Work |
VARCHAR2 | 30 | Required |
Address 1 | Address Line 1 | - | VARCHAR2 | 120 | Required |
Address 2 | Address Line 2 | - | VARCHAR2 | 120 | Optional |
Address 3 | Address line 3 | - | VARCHAR2 | 120 | Optional |
Address 4 | Address Line 4 | - | VARCHAR2 | 120 | Optional |
City | City Code | - | VARCHAR2 | 50 | Required |
State | State Code | - | VARCHAR2 | 30 | Required |
Country | Country Code | - | VARCHAR2 | 30 | Required |
Post/ Zip/ Pin Code | Zip Code | - | VARCHAR2 | 30 | Required |
Preferred Address | if Party has Multiple Addresses, flag to identify which is preferred for communication | Y/N | CHAR | 1 | Required |
Effective Date | The date since which the given Address is Effective | - | DATE | - | Optional |
Address ID | Unique ID for address | - | VARCHAR2 | 30 | Optional |
Parent topic: Party Data