Tag Name | Type | Min Occurs | Max Occurs | Description | sim Mapping For AddrDesc |
Table Name | Column Name | API Type | Column Length | API Required | API Description |
city_id | varchar210 | 0 | 1 | Indicates the City Id or Code. | NA | NA | NA | NA | NA | NA |
state_name | varchar2120 | 0 | 1 | Indicates the State name. | NA | NA | NA | NA | NA | NA |
country_name | varchar2120 | 0 | 1 | Indicates the Country Name. For e.g Brazil,United States | NA | NA | NA | NA | NA | NA |
addr | number11 | 1 | 1 | Description is not available. | | null | null | null | null | 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. | | null | null | null | null | null |
primary_addr_type_ind | varchar21 | 1 | 1 | Description is not available. | | null | null | null | null | null |
primary_addr_ind | varchar21 | 1 | 1 | Indicates whether this address is the primary address for this address type | | null | null | null | null | null |
add_1 | varchar2240 | 1 | 1 | Description is not available. | | null | varchar2 | 240 | null | null |
add_2 | varchar2240 | 0 | 1 | Description is not available. | | null | varchar2 | 240 | null | null |
add_3 | varchar2240 | 0 | 1 | Description is not available. | | null | varchar2 | 240 | null | null |
city | varchar2120 | 1 | 1 | Description is not available. | | null | null | null | null | null |
state | varchar23 | 0 | 1 | Contains the postal abbreviation for the state in which the warehouse is located. | | null | null | null | null | null |
country_id | varchar23 | 1 | 1 | Description is not available. | | null | null | null | null | null |
post | varchar230 | 0 | 1 | Description is not available. | | null | null | null | null | null |
contact_name | varchar2120 | 0 | 1 | Description is not available. | | null | null | null | null | null |
contact_phone | varchar220 | 0 | 1 | Description is not available. | | null | null | null | null | null |
contact_telex | varchar220 | 0 | 1 | Contains the telex number of the partner or suppliers representative contact. | | null | null | null | null | null |
contact_fax | varchar220 | 0 | 1 | Description is not available. | | null | null | null | null | null |
contact_email | varchar2100 | 0 | 1 | Contains the email address of the partner or suppliers representative contact. | | null | null | null | null | null |
oracle_vendor_site_id | number15 | 0 | 1 | The unique identifier of this address in the Oracle Financials systems, if used. | | null | null | null | null | null |
county | varchar220 | 0 | 1 | Description is not available. | | null | null | null | null | null |
jurisdiction_code | varchar210 | 0 | 1 | ID associated to the tax jurisdiction of the country-state relationship. | NA | NA | NA | NA | NA | NA |
ExtOfAddrDesc:ExtOfAddrDesc | * | 0 | 1 | Provide an extension hook to customize AddrDesc. | NA | NA | NA | NA | NA | NA |
LocOfAddrDesc:LocOfAddrDesc | * | 0 | 1 | Provide an extension hook to localize AddrDesc. | NA | NA | NA | NA | NA | NA |