Tag Name | Type | Min Occurs | Max Occurs | Description | rms Mapping For AddrDesc |
Table Name | Column Name | API Type | Column Length | API Required | API Description |
addr | number6 | 1 | 1 | Description is not available. | addr | addr_key | null | null | Yes | Address unique identifier |
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 | null | null | 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 | 1 | 1 | Description is not available. | add_type_module | primary_ind | null | null | Yes | Y or N - indicates whether this address type is the primary address type. |
primary_addr_ind | varchar21 | 1 | 1 | Indicates whether this address is the primary address for this address type | addr | primary_addr_ind | null | null | Yes | Indicates whether this address is the primary address for this address type |
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. | addr | add_2 | varchar2 | 240 | No | Contains the second line of the address |
add_3 | varchar2240 | 0 | 1 | Description is not available. | addr | add_3 | varchar2 | 240 | No | Contains the third line of the address |
city | varchar2120 | 1 | 1 | Description is not available. | addr | city | null | null | Yes | Contains the city of this address |
state | varchar23 | 0 | 1 | Contains the postal abbreviation for the state in which the warehouse is located. | addr | state | null | null | No | Contains the postal abbreviation for the state in which the warehouse is located. |
country_id | varchar23 | 1 | 1 | Description is not available. | addr | country_id | null | null | Yes | Contains the country code for this address. |
post | varchar230 | 0 | 1 | Description is not available. | addr | post | null | null | No | Contains the zip code for the address |
contact_name | varchar2120 | 0 | 1 | Description is not available. | addr | contact_name | null | null | No | Contains the name of the contact for this address |
contact_phone | varchar220 | 0 | 1 | Description is not available. | addr | contact_phone | null | null | No | Contains the phone number of the contact for this address. |
contact_telex | varchar220 | 0 | 1 | Contains the telex number of the partner or suppliers representative contact. | addr | contact_telex | null | null | No | Contains the telex number of the contact at this address. |
contact_fax | varchar220 | 0 | 1 | Description is not available. | addr | contact_fax | null | null | No | Contains the fax number of the contact at this address. |
contact_email | varchar2100 | 0 | 1 | Contains the email address of the partner or suppliers representative contact. | addr | contact_email | null | null | No | Contains the email address of the contact at this address. |
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 | null | null | No | The unique identifier of this address in the Oracle Financials systems, if used. |
county | varchar220 | 0 | 1 | Description is not available. | addr | county | null | null | No | The county of this address. |
ExtOfAddrDesc:ExtOfAddrDesc | * | 0 | 1 | Provide an extension hook to customize AddrDesc. | NA | NA | NA | NA | NA | NA |