XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for GeoAddrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
address_alias |
varchar2120 |
0 |
1 |
Contains the alias for this address
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
address_1 |
varchar2240 |
1 |
1 |
Contains Address Line 1.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
address_2 |
varchar2240 |
0 |
1 |
Contains Address Line 2.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
address_3 |
varchar2240 |
0 |
1 |
Contains Address Line 3.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
address_4 |
varchar2240 |
0 |
1 |
Contains Address Line 4.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
address_5 |
varchar2240 |
0 |
1 |
Contains Address Line 5.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
city |
varchar2120 |
0 |
1 |
Contains the city where the address is located.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
county |
varchar2250 |
0 |
1 |
County where this address is located
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
state_code |
varchar23 |
0 |
1 |
Contains the postal abbreviation for the state, province or territory in which the address is located.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
state_name |
varchar2120 |
0 |
1 |
Indicates the state, province or territory name.
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
country_code |
varchar23 |
0 |
1 |
Contains the postal abbreviation of the country in which the address is located
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
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 or/and RSL |
Fill column length. |
Yes |
Fill this description. |
postal_code |
varchar230 |
0 |
1 |
Contains the postal code for the address
|
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
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 or/and RSL |
Fill column length. |
Yes |
Fill this description. |