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
|