Store

Contains the number which uniquely identifies the store.

Contains the name of the store which, along with the store number, identifies the store.

Contains a ten character abbreviation of the store name.

Contains a three character abbreviation of the store name.

Secondary name of the store. Oracle Retail target column STORE_NAME_SECONDARY on STORE.

Contains the code letter indicating the class of which the store is a member. Valid values are A through E.

Contains the name of the store manager.

Contains the date on which the store opened.

Contains the date on which the store closed.

Contains the date on which the store was acquired.

Contains the date on which the store was last remodeled.

Contains the fax number for the store.

Contains the phone number for the store.

Holds the email address for the location

Contains the total square footage of the store.

Contains the total square footage of the stores selling area.

Holds the total merchandisable space of the location.

Contains the number of the Value Added Tax region in which this store is contained.

Indicates whether or not Value Added Tax will be included in the retail prices for the store. Valid values are Y or N.

This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Y.

In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table.

Contains the number indicating the format of the store. Valid values are found on the store format table.

Contains the name of the mall in which the store is located.

Contains the number of the district in which the store is a member.

Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table.

Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment.

Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined.

Contains the number of days before the store_open_date that the store will begin accepting orders.

This field contains the currency code under which the store operates.

This column identifies the language to be used for the given store.

Contains the level at which unique POS transaction numbers are generated. If the store has one sequence number that is used for all registers, then the value in this column will be S (Store). Otherwise the store has unique sequence numbers for each register and the value in this column will be R (Register). These values are defined on the codes table with a code type of UNQT.

Indicates whether or not the POS system at the Store is integrated.

holds the original currency of a store after its adopted the Euro as its main operating currency

This field holds the Dun and Bradstreet number to identify the store.

This field holds the Dun and Bradstreet number to identify the location

This field will hold a store number which will be used to relate the current store to the historical data of an existing store.

Foregin key to the TSF_ENTITY table

Column will contain the organizational unit ID value.

This column will indicate whether the client is allowing automatic receipt for the store. Valid Values are Y (Yes), N (No), D (System Default). Default value should be D.

Identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS.

This will indicate whether a particular store is a franchise or company store.

Numeric Id of the customer. Oracle Retail target column WF_CUSTOMER_ID on STORE.

Indicates the time zone of the store. For example, 'America/New_York'.

This column indicates if the location is a customer order location or not. A value of Yes (Y) indicates the location is a customer order location and can be used by OMS for sourcing, fulfillment or both. A value of No (N) indicates the location is not a customer order location. Only company stores or stock-holding franchise stores can be customer order locations. This column will always be No (N) for non- stockholding franchise stores.

This column holds the User id of the user who created the record.

This column holds the record creation date.

The location from which pricing records will be copied.

This column will indicate if the location will support shipping to a customer for customer orders.

This column will indicate if the location will support gift wrapping.

Contains the unique tax identification number of the store.

This indicates that the store is an online store.

User who last updated the record.

Date time when record was last updated.

This column will hold the ID of legal entity associated with the store. The legal entity if specified will directly be used in the integration with Accounts Payable.