Location feed layout definition

System of Record Name

sor_name

(Required) Name of the system that is the authoritative data source for a record. 

char(100)

Source Location Id

source_location_id

(Required)

This field is the natural primary key.

Uniquely identifies a Location in the source system (location can be a store or website).

This field is used in aggregate calculations.

char(100)

Business Unit Code

business_unit_code

Identifies the structure of brands within an organizational entity. It is the way in which the brands within a company’s portfolio are related to, and differentiated from, one another.

Values are defined as part of on-boarding, in BUSINESS_UNIT_LOOKUP; NULL values will default to enterprise. Refer to Business unit for details.

char(50)

Location Name

location_name

Location name.

char(300)

Location Type Code

location_type_code

(Required) Defines the type of location. Examples below (could have more types):

• B&M (brick and mortar store)

• WEB (website)

• Warehouse

• Headquarters

This field is used in aggregate calculations.

Values are defined as part of on-boarding, in LOCATION_TYPE_LOOKUP. Refer to Location type for details.

char(50)

Location Status Code

location_status_code

(Required) Defines the status of the location, such as closed, open, opening soon.

This field is used in aggregate calculations.

Values are defined as part of on-boarding, in LOCATION_STATUS_LOOKUP. Refer to Location status for details.

char(50)

Division Code

division_code

A code that identifies business subdivisions.

char(50)

Division Description

division_desc

Description of the division code.

char(100)

Region Code

region_code

A code that identifies the principal subdivisions (e.g., provinces or states) of all countries.

char(50)

Region Name

region_name

Region name.

char(60)

District Code

district_code

A code that identifies the districts.

char(50)

District Name

district_name

District name.

char(60)

Employee Quantity

employee_qty

The number of employees at the location.

integer

Vanity Name

vanity_name

Name of the center that the location is part of (e.g., Ridge Plaza, City Center, etc.).

char(300)

Geography Code

geography_code

A code that identifies country subdivisions and places.

char(50)

Geography Name

geography_name

The name of the geography code that identifies country subdivisions and places.

char(60)

Main Page Address

main_page_address

Main web page address of a web store. Example: amazon.com, lowes.com, etc.

char(255)

Manager Name

manager_name

The name of location's manager.

char(200)

Manager Email Address

manager_email_address

The email address of location's manager.

char(320)

Location Email Address

location_email_address

Location's email address.

char(320)

Address 1

address_1

Location's address line 1.

char(128)

Address 2

address_2

Location's address line 2.

char(128)

Address 3

address_3

Location's address line 3.

char(128)

Address 4

address_4

Location's address line 4.

char(128)

City

city

Location’s city.

char(64)

State Province

state_province

Location's state code.

char(64)

Postal Code 1

postal_code_1

Location's postal code.

char(16)

Country Code

country_code

ISO 3166 (alpha-2) 2-character country code.

char(2)

Phone Country Code

phone_country_code

ISO 3166 (alpha-2) 2-character country code for location's phone number.

char(2)

Phone Number

phone_num

Location's phone number.

char(32)

Open Date

open_date

Store Open Date:
YYYY-MM-DD.

This field is used in aggregate calculations.

date

Close Date

close_date

Store Close Date:
YYYY-MM-DD.

This field is used in aggregate calculations.

date

Location Cluster Indicator

location_cluster_ind

Indicates if there are multiple sub-locations within location (for example, in a retail store: men's, women's, kids; in a health-care facility: pharmacy, lab, urgent care, etc.).

Valid values: y /n / null.

char(1)

Currency Code

currency_code

Location's primary currency code (EUR - E.U. Euro, GBP - British Pound, USD - U.S. Dollar).

Values listed in CURRENCY_LOOKUP.

char(3)

Display URL

display_url

Display URL is the URL of each store to display in emails. 

char(4000)

Visit Us Line Text

visit_us_line_text

PFS visit us is a line of copy included in emails for each store.

char(300)

Latitude

latitude

Latitude.

This field is used in aggregate calculations.

decimal(10,7)

Longitude

longitude

Longitude.

This field is used in aggregate calculations.

decimal(10,7)

Sunday Open Time

sun_open_time

Time when the store opens on Sunday in 24-hour clock format 24HH:mm (10:00).

char(20)

Sunday Close Time

sun_close_time

Time when the store closes on Sunday in 24-hour clock format 24HH:mm (18:00).

char(20)

 Monday Open Time

mon_open_time

Time when the store opens on Monday in 24-hour clock format 24HH:mm (09:00).

char(20)

 Monday Close Time

mon_close_time

Time when the store closes on Monday in 24-hour clock format 24HH:mm (20:00).

char(20)

Tuesday Open Time

tue_open_time

Time when the store opens on Tuesday in 24-hour clock format 24HH:mm (09:00).

char(20)

Tuesday Close Time

tue_close_time

Time when the store closes  on Tuesday in 24-hour clock format 24HH:mm (20:00).

char(20)

Wednesday Open Time

wed_open_time

Time when the store opens on Wednesday in 24-hour clock format 24HH:mm (09:00).

char(20)

Wednesday Close Time

wed_close_time

Time when the store closes on Wednesday in 24-hour clock format 24HH:mm (20:00).

char(20)

Thursday Open Time

thu_open_time

Time when the store opens on Thursday in 24-hour clock format 24HH:mm (09:00).

char(20)

Thursday Close Time

thu_close_time

Time when the store closes on Thursday in 24-hour clock format 24HH:mm (20:00).

char(20)

Friday Open Time

fri_open_time

Time when the store opens on Friday in 24-hour clock format 24HH:mm (09:00).

char(20)

Friday Close Time

fri_close_time

Time when the store closes on Friday in 24-hour clock format 24HH:mm (20:00).

char(20)

Saturday Open Time

sat_open_time

Time when the store opens on Saturday in 24-hour clock format 24HH:mm (10:00).

char(20)

Saturday Close Time

sat_close_time

Time when the store closes on Saturday in 24-hour clock format 24HH:mm (20:00).

char(20)