XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for AddrRBO in RFM application. |
RFM's Table Name | RFM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RFM's Column Length | Is Column Required in RFM's API? | RFM's API Description |
city_id | varchar210 | 0 | 1 | Indicates the City Id or Code. | country_tax_jurisdiction | jurisdiction_code | varchar2 | 10 | Yes | Contains the city's jurisdiction code used for tax calculation. |
state_name | varchar2120 | 0 | 1 | Indicates the State name. | Fill application table name. | Fill table column name. | varchar2 | Fill column length. | Yes | No mapping in RMS. Default to NULL. |
country_name | varchar2120 | 0 | 1 | Indicates the Country Name. For e.g Brazil,United States | COUNTRY | COUNTRY_DESC | varchar2 | 120 | Yes | Contains the name of the country. |
addr | number11 | 1 | 1 | Description is not available. | Fill application table name. | Fill table column name. | varchar2 | Fill column length. | Yes | No mapping in RMS. Default to NULL. |
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 | Contains the address type. Valid address types are defined in ADD_TYPE table in RMS. |
primary_addr_type_ind | varchar21 | 1 | 1 | Description is not available. | Fill application table name. | Fill table column name. | varchar2 | Fill column length. | Yes | No mapping in RMS. Default to '1'. |
primary_addr_ind | varchar21 | 1 | 1 | Indicates whether this address is the primary address for this address type | ADDR | PRIMARY_ADDR_IND | varchar2 | 1 | No | Indicates if the address is a primary address. |
add_1 | varchar2240 | 1 | 1 | Description is not available. | ADDR | ADD_1 | varchar2 | 240 | Yes | Contains the first line of the address. |
add_2 | varchar2240 | 0 | 1 | Description is not available. | Fill application table name. | Fill table column name. | varchar2 | Fill column length. | Yes | No mapping in RMS. Default to NULL. |
add_3 | varchar2240 | 0 | 1 | Description is not available. | Fill application table name. | Fill table column name. | varchar2 | Fill column length. | Yes | No mapping in RMS. Default to NULL. |
city | varchar2120 | 1 | 1 | Description is not available. | country_tax_jurisdiction | JURISDICTION_DESC | varchar2 | 120 | Yes | Contains the name of the city or name of the tax jurisdiction for tax calculation. |
state | varchar23 | 0 | 1 | Contains the postal abbreviation for the state in which the warehouse is located. | ADDR | STATE | varchar2 | 3 | No | Constains the postal abbreviation for the state. |
country_id | varchar23 | 1 | 1 | Description is not available. | ADDR | country_id | varchar2 | 3 | Yes | Contains the country code of the address. |