| Code |
Meaning |
Description |
| ADDRESS |
All Address Lines |
All Address Lines Concatenated |
| ADDRESS1 |
Address Line 1 |
First line of address |
| ADDRESS2 |
Address Line 2 |
Second line of address |
| ADDRESS3 |
Address Line 3 |
Third line of address |
| ADDRESS4 |
Address Line 4 |
Fourth line of address |
| ADDRESS_EFFECTIVE_DATE |
Address Effective Date |
Date when the location is valid |
| ADDRESS_EXPIRATION_DATE |
Address Expiration Date |
Date when the location is no longer valid |
| ADDRESS_LINES_PHONETIC |
Address Phonetic Representation |
Japanese Kana, or phonetic representation of the address line |
| ADDR_SOURCE_SYSTEM_REF |
Address Source Details |
Address Source Details |
| CITY |
City |
City |
| CLLI_CODE |
CLLI Code |
Common Language Location Identifier (CLLi) code |
| CONTENT_SOURCE_TYPE |
Content Source Type |
Source of data content |
| COUNTRY |
Country |
Country code from the TERRITORY_CODE column in the FND_TERRITORY table |
| COUNTY |
County |
County |
| CUSTOM_ATTRIBUTE1 |
CUSTOM ATTRIBUTE 1 |
CUSTOM ATTRIBUTE 1 |
| CUSTOM_ATTRIBUTE10 |
CUSTOM ATTRIBUTE 10 |
CUSTOM ATTRIBUTE 10 |
| CUSTOM_ATTRIBUTE11 |
CUSTOM ATTRIBUTE 11 |
CUSTOM ATTRIBUTE 11 |
| CUSTOM_ATTRIBUTE12 |
CUSTOM ATTRIBUTE 12 |
CUSTOM ATTRIBUTE 12 |
| CUSTOM_ATTRIBUTE13 |
CUSTOM ATTRIBUTE 13 |
CUSTOM ATTRIBUTE 13 |
| CUSTOM_ATTRIBUTE14 |
CUSTOM ATTRIBUTE 14 |
CUSTOM ATTRIBUTE 14 |
| CUSTOM_ATTRIBUTE15 |
CUSTOM ATTRIBUTE 15 |
CUSTOM ATTRIBUTE 15 |
| CUSTOM_ATTRIBUTE16 |
CUSTOM ATTRIBUTE 16 |
CUSTOM ATTRIBUTE 16 |
| CUSTOM_ATTRIBUTE17 |
CUSTOM ATTRIBUTE 17 |
CUSTOM ATTRIBUTE 17 |
| CUSTOM_ATTRIBUTE18 |
CUSTOM ATTRIBUTE 18 |
CUSTOM ATTRIBUTE 18 |
| CUSTOM_ATTRIBUTE19 |
CUSTOM ATTRIBUTE 19 |
CUSTOM ATTRIBUTE 19 |
| CUSTOM_ATTRIBUTE2 |
CUSTOM ATTRIBUTE 2 |
CUSTOM ATTRIBUTE 2 |
| CUSTOM_ATTRIBUTE20 |
CUSTOM ATTRIBUTE 20 |
CUSTOM ATTRIBUTE 20 |
| CUSTOM_ATTRIBUTE21 |
CUSTOM ATTRIBUTE 21 |
CUSTOM ATTRIBUTE 21 |
| CUSTOM_ATTRIBUTE22 |
CUSTOM ATTRIBUTE 22 |
CUSTOM ATTRIBUTE 22 |
| CUSTOM_ATTRIBUTE23 |
CUSTOM ATTRIBUTE 23 |
CUSTOM ATTRIBUTE 23 |
| CUSTOM_ATTRIBUTE24 |
CUSTOM ATTRIBUTE 24 |
CUSTOM ATTRIBUTE 24 |
| CUSTOM_ATTRIBUTE25 |
CUSTOM ATTRIBUTE 25 |
CUSTOM ATTRIBUTE 25 |
| CUSTOM_ATTRIBUTE26 |
CUSTOM ATTRIBUTE 26 |
CUSTOM ATTRIBUTE 26 |
| CUSTOM_ATTRIBUTE27 |
CUSTOM ATTRIBUTE 27 |
CUSTOM ATTRIBUTE 27 |
| CUSTOM_ATTRIBUTE28 |
CUSTOM ATTRIBUTE 28 |
CUSTOM ATTRIBUTE 28 |
| CUSTOM_ATTRIBUTE29 |
CUSTOM ATTRIBUTE 29 |
CUSTOM ATTRIBUTE 29 |
| CUSTOM_ATTRIBUTE3 |
CUSTOM ATTRIBUTE 3 |
CUSTOM ATTRIBUTE 3 |
| CUSTOM_ATTRIBUTE30 |
CUSTOM ATTRIBUTE 30 |
CUSTOM ATTRIBUTE 30 |
| CUSTOM_ATTRIBUTE4 |
CUSTOM ATTRIBUTE 4 |
CUSTOM ATTRIBUTE 4 |
| CUSTOM_ATTRIBUTE5 |
CUSTOM ATTRIBUTE 5 |
CUSTOM ATTRIBUTE 5 |
| CUSTOM_ATTRIBUTE6 |
CUSTOM ATTRIBUTE 6 |
CUSTOM ATTRIBUTE 6 |
| CUSTOM_ATTRIBUTE7 |
CUSTOM ATTRIBUTE 7 |
CUSTOM ATTRIBUTE 7 |
| CUSTOM_ATTRIBUTE8 |
CUSTOM ATTRIBUTE 8 |
CUSTOM ATTRIBUTE 8 |
| CUSTOM_ATTRIBUTE9 |
CUSTOM ATTRIBUTE 9 |
CUSTOM ATTRIBUTE 9 |
| FLOOR |
Floor |
A number or name assigned to a level within a building or within an address line |
| HOUSE_NUMBER |
House Number |
Address number for a house |
| IDENTIFYING_ADDRESS_FLAG |
Identifying Address Flag |
Indicates if this is the identifying address for the party (Y/N) |
| LANGUAGE |
Language |
Operating language of the location (foreign key to FND_LANGUAGES table) |
| MAILSTOP |
Mailstop |
User-defined code to indicate a mail drop point within the party |
| PARTY_SITE_NAME |
Party Site Name |
Name of Party Site |
| PARTY_SITE_NUMBER |
Party Site Number |
Number of Party Site |
| POSITION |
Position |
The primary direction such as North or East that is used to access the location |
| POSTAL_CODE |
Postal Code |
Postal Code |
| POSTAL_PLUS4_CODE |
Postal Code Extension |
Four digit extension to the U.S. Postal Code |
| PO_BOX_NUMBER |
P.O. Box Number |
Post Office box number |
| PROVINCE |
Province |
Province |
| SALES_TAX_GEOCODE |
Sales Tax Geocode |
U.S. State and Local Tax Jurisdiction code (Vertex Geocode or Taxware Geocode value for the Point of Order Origin) |
| SALES_TAX_INSIDE_CITY_LIMITS |
Sales Tax Inside City Limits |
Indicates if a location is inside the boundary of a city, based on the associated Geocode |
| STATE |
State |
State |
| STATUS |
Party Site Status |
Party Site Status |
| STREET |
Street |
The name of the street in the address |
| STREET_NUMBER |
Street Number |
A number assigned to an entire building within an address |
| STREET_SUFFIX |
Street Suffix |
The street name suffix wuch as road, avenue, or street |
| SUITE |
Suite |
A number or name given to a group of rooms occupied as a unit |
| VALIDATED_FLAG |
Validated Flag |
Indicates if the location was validated (Y/N) |
[Home] [Help]