|
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
|