XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for AddrDesc in RXM application. |
RXM's Table Name | RXM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RXM's Column Length | Is Column Required in RXM's API? | RXM'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. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
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. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
primary_addr_type_ind | varchar21 | 0 | 1 | Description is not available. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
primary_addr_ind | varchar21 | 1 | 1 | Indicates whether this address is the primary address for this address type | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
add_1 | varchar2240 | 1 | 1 | Contains the first line of the address | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
add_2 | varchar2240 | 0 | 1 | Contains the second line of the address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
add_3 | varchar2240 | 0 | 1 | Contains the thirdline of the address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
city | varchar2120 | 1 | 1 | Contains the name of the city that is associated with the address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
state | varchar23 | 0 | 1 | Contains the postal abbreviation for the state in which the warehouse is located. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
country_id | varchar23 | 1 | 1 | Contains the country where the address exists. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
post | varchar230 | 0 | 1 | Contains the zip code for the address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
contact_name | varchar2120 | 0 | 1 | Contains the name of the contact for the supplier at this address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
contact_phone | varchar220 | 0 | 1 | Contains the phone number of the contact person at this address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
contact_telex | varchar220 | 0 | 1 | Contains the telex number of the partner or suppliers representative contact. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
contact_fax | varchar220 | 0 | 1 | Contains the fax number of the contact person at this address. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
contact_email | varchar2100 | 0 | 1 | Contains the email address of the partner or suppliers representative contact. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
oracle_vendor_site_id | number15 | 0 | 1 | The unique identifier of this address in the Oracle Financials systems, if used. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
county | varchar2250 | 0 | 1 | Contains the county name for the location. | Fill application table name. | Fill table column name. | RIB or/and RSB | Fill column length. | Yes | Fill this description. |
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. |