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