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 Optional
State State Code - VARCHAR2 30 Optional
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