Addr

This column contains a unique number used to distinguish between different addresses.

This column holds the code for the module that the address is attached to. Valid values are supplier (SUPP) and partner (PTNR).

This column contains specific ID or type that the address is attached to. If the module is Partner, then key_value_1 holds the type of Partner [BANK (BK), Freight Forwarder (FF), Factory (FA), Agent (AG), Broker (BR), and Importer (IM)], else it will hold the supplier number.

If the module is Partner (PTNR), then this field will contain the partners ID, else this field will be null.

This column indicates the sequence that addresses within the same type were entered.

This column indicates the type for the address. Valid values are: 01 - Business, 02 - Postal, 03 - Returns, 04 - Order, 05 - Invoice, 06 - Remittance

This column indicates whether the address is the primary address for the address type.

This column contains the first line of the address.

This column contains the second line of the address.

This column contains the third line of the address.

This column contains the name of the city that is associated with the address.

This column contains the state abbreviation for the address.

This column contains the country where the address exists.

This column contains the zip code for the address.

This column contains the name of the contact for the supplier at this address.

This column contains the phone number of the contact person at this address.

This column contains the telex number of the partner or suppliers representative contact.

This column contains the fax number of the contact person at this address.

This column contains the email address of the partner or suppliers representative contact.

This column will only be used for the Oracle Financial Interfaces. It holds the value of the Oracle vendor site ID for a supplier address. This Oracle vendor site ID is the unique identifier of the address on the Oracle side, it must be stored on the RMS addr table to allow updates from Oracle. This site ID can be found on the Oracle po_vendor_sites table.

This column indicates if the address has been changed. This flag is used by the EDI process.

This column holds the county name for the location.

This column indicates if the detail has been published.

Identifies the jurisdiction code for the country-state relationship.

This field holds the unique address ID from the external source system. Although the ADDR_KEY is the unique key in RMS but it is a system generated oneup number. Hence, external systems will not be aware of this number. The purpose of external_ref_id is to store external system provided identifier of the same row.

This column holds the User id of the user who created the record.

This column holds the record creation date.

User who last updated the record.

Date time when record was last updated.

This column contains the type of the phone number stored in Phone2 field. Valid values can be found under the code_type PHTP.

This column contains an additional phone number associated with the address.

This column contains the type of the phone number stored in Phone3 field. Valid values can be found under the code_type PHTP.

This column contains a second additional phone number associated with the address.

This column contains the north-south geographic coordinate of the address, represented in decimal degrees (e.g., 37.7749).

This column contains the east-west geographic coordinate of the address, represented in decimal degrees (e.g., -122.4194).

This column contains the fourth line of the address.