BUSINESS_GROUP_ID NUMBER(15) Y
Business Group ID associated with location.
DESCRIPTION
VARCHAR2(240)Y
Brief description of the location.
SHIP_TO_LOCATION_ID NUMBER(15) Y
Ship-to location foreign key.
SHIP_TO_SITE_FLAG VARCHAR2(30) Y
Indicates whether items can be shipped to this location.
RECEIVING_SITE_FLAG VARCHAR2(30) Y
Indicates whether this location can be used as a receiving site.
BILL_TO_SITE_FLAG VARCHAR2(30) Y
Indicates whether you can bill items to this location.
IN_ORGANIZATION_FLAGVARCHAR2(30) Y
Indicates whether this location is an internal site.
OFFICE_SITE_FLAG
VARCHAR2(30) Y
Indicates whether this location can be used as an office site.
DESIGNATED_RECEIVER_IDNUMBER(15) Y
Person foreign key - the contact person for this location.
INVENTORY_ORGANIZATION_ID NUMBER(15) Y
Inventory organization foreign key.
TAX_NAME
VARCHAR2(15) Y
Default tax code for this location.
INACTIVE_DATE
DATE
Y
Date after which this location is no longer valid.
STYLE
VARCHAR2(30) Y
Address style - foreign key to FND_TERRITORIES.
ADDRESS_LINE_1
VARCHAR2(240)Y
1st line of location address.
ADDRESS_LINE_2
VARCHAR2(240)Y
2nd line of location address.
ADDRESS_LINE_3
VARCHAR2(240)Y
3rd line of location address.
TOWN_OR_CITY
VARCHAR2(30) Y
Town or city.
COUNTRY
VARCHAR2(60) Y
Country.
POSTAL_CODE
VARCHAR2(30) Y
Postal code.
REGION_1
VARCHAR2(120)Y
County (US, UK); Province (CA).
REGION_2
VARCHAR2(120)Y
State (US); Province of work (CA).
REGION_3
VARCHAR2(120)Y
Additional address segment - not used by seeded address structures.
TELEPHONE_NUMBER_1VARCHAR2(60) Y
Telephone number.
TELEPHONE_NUMBER_2VARCHAR2(60) Y
Telephone number.
TELEPHONE_NUMBER_3VARCHAR2(60) Y
Telephone number.
LAST_UPDATE_LOGIN NUMBER(15) Y
Standard Who column.
CREATED_BY
NUMBER(15) Y
Standard Who column.
CREATION_DATE
DATE
Y
Standard Who column.
ENTERED_BY
NUMBER(15)
Applications user who created this location; same as CREATED_BY.
TP_HEADER_ID
NUMBER
Y
Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
ECE_TP_LOCATION_CODEVARCHAR2(35) Y
Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
OBJECT_VERSION_NUMBER NUMBER(9)
Y
System-generated version of row. Increments by one with each update.
GEOMETRY
MDSYS.SDO_GEOMETRY Y
