Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For AddrDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
addr |
number6 |
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 |
ExtOfAddrDesc:ExtOfAddrDesc
|
*
|
0
|
1
|
Provide an extension hook to
customize AddrDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|