XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for AddrDesc in RPM application. |
RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description |
city_id | varchar210 | 0 | 1 | Indicates the City Id or Code. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
state_name | varchar2120 | 0 | 1 | Indicates the State name. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
country_name | varchar2120 | 0 | 1 | Indicates the Country Name. For e.g Brazil,United States | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
addr | varchar232 | 1 | 1 | This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. | * | * | number | 6 | * | * |
addr_type | varchar22 | 1 | 1 | Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. | * | * | varchar2 | 2 | * | * |
primary_addr_type_ind | varchar21 | 0 | 1 | Description is not available. | * | * | varchar2 | 1 | * | * |
primary_addr_ind | varchar21 | 1 | 1 | Indicates whether this address is the primary address for this address type | * | * | varchar2 | 1 | * | * |
add_1 | varchar2240 | 1 | 1 | Contains the first line of the address | * | * | varchar2 | 240 | * | * |
add_2 | varchar2240 | 0 | 1 | Contains the second line of the address. | * | * | varchar2 | 240 | * | * |
add_3 | varchar2240 | 0 | 1 | Contains the thirdline of the address. | * | * | varchar2 | 240 | * | * |
city | varchar2120 | 1 | 1 | Contains the name of the city that is associated with the address. | * | * | varchar2 | 120 | * | * |
state | varchar23 | 0 | 1 | Contains the postal abbreviation for the state in which the warehouse is located. | * | * | varchar2 | 3 | * | * |
country_id | varchar23 | 1 | 1 | Contains the country where the address exists. | * | * | varchar2 | 3 | * | * |
post | varchar230 | 0 | 1 | Contains the zip code for the address. | * | * | varchar2 | 30 | * | * |
contact_name | varchar2120 | 0 | 1 | Contains the name of the contact for the supplier at this address. | * | * | varchar2 | 120 | * | * |
contact_phone | varchar220 | 0 | 1 | Contains the phone number of the contact person at this address. | * | * | varchar2 | 20 | * | * |
contact_telex | varchar220 | 0 | 1 | Contains the telex number of the partner or suppliers representative contact. | * | * | varchar2 | 20 | * | * |
contact_fax | varchar220 | 0 | 1 | Contains the fax number of the contact person at this address. | * | * | varchar2 | 20 | * | * |
contact_email | varchar2100 | 0 | 1 | Contains the email address of the partner or suppliers representative contact. | * | * | varchar2 | 100 | * | * |
oracle_vendor_site_id | number15 | 0 | 1 | The unique identifier of this address in the Oracle Financials systems, if used. | * | * | number | 15 | * | * |
county | varchar2250 | 0 | 1 | Contains the county name for the location. | * | * | varchar2 | 250 | * | * |
jurisdiction_code | varchar210 | 0 | 1 | ID associated to the tax jurisdiction of the country-state relationship. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |