Skip Headers
Oracle® Retail Data Model Reference
Release 11.3.2

Part Number E20361-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Logical Data Model of Oracle Retail Data Model

The logical data model defines the business entities and their relationships to provide a clear understanding of the business and data requirements for the data warehouse.

This chapter includes the following sections:

Overview of Retail Data Model Entity Types

Entity types correspond to table types in Oracle Retail Data Model. Figure 2-1 shows different table types and table population steps in Oracle Retail Data Model.

Figure 2-1 Entity Types and Populating Oracle Retail Data Model Tables

Description of Figure 2-1 follows
Description of "Figure 2-1 Entity Types and Populating Oracle Retail Data Model Tables"

Note:

Figure 2-1 shows a "generic" Oracle Industry Data Model data flow. In contrast to the data flow shown Figure 2-1, Oracle Retail Data Model has all aggregate tables defined from "derived" tables and "reference" tables (dimensions). However, if you customize Oracle Retail Data Model to create a new aggregate table, for which a derived table does exist, then the new table could be defined from the base, reference, lookup, or possibly from external tables as shown in Figure 2-1. For more information on Oracle Retail Data Model customization, see Oracle Retail Data Model Implementation and Operations Guide.

Reference Entities

Reference Entities define the entities within, and associated with the retail organization for which data would be recorded and analyzed. Reference entities record the structure of the retail organization and all people, products, and organizations associated with it.

Lookup Entities

Lookup entities hold the descriptions for frequently used attributes. Using lookup entities saves space, as the referring fact table holds only a small key or code and foreign key, and Oracle Retail Data Model stores the space consuming description in a lookup entity table and does not repeat the description in each transaction row in which it is referenced.

Base Entities

Base entities contain atomic level transaction data. Base entities could be leveraged as an Operational Data Store (ODS) and as a system of record. Data in the base entities support the derived and aggregate layers to facilitate Star and population, and act as a source for Data Mining for advanced analysis.

Derived Entities

Derived entities contain information drawn from one or more base entities, and can contain denormalized and/or transposed data. Granularity is partially aggregated, typically at day level, but in some cases at quarter hour level or partially aggregated transactional data from the base entities.

Aggregate Entities

Aggregate entities hold data rolled up from the Base or Derived entities at different levels across different dimensional hierarchies.

Logical Data Model Business Areas and Subject Areas

Table 2-1 lists the Oracle Retail Data Model Business Areas and the Subject Areas that are components of each Business Area.

Table 2-1 Logical Data Model Business Area to Subject Area Mapping

Business Area Subject Area Components of Business Area

Call Center

Call Center, Call Center Agent, Customer, Customer Service Request, Organization Business Unit, Touchpoint

Customer Management

Account, Address Location, Calendar, Call Center, Customer Contract, Customer, Loyalty, Party, Party Interaction

Customer Orders

Customer Order, Customer, Invoice, Organization Business Unit, Retail Transaction

E-Commerce

Calendar, Clickstream, Organization Business Unit

Financial Management

Address Location, Calendar, Cost, Financial Ledger, Invoice, Revenue Center

Fueling Business Service (Forecourt Transactions)

Calendar, Point of Service (POS), Retail Sales, Retail Transaction, Time

Manufacturer

Invoice, Organization Business Unit, Manufacturer Organization, Manufacturer SKU Item

Marketing

Address Location, Calendar, Customer, Loyalty, Promotion / Campaign

Merchandise Management

Calendar, Competitor, Item, Invoice, Organization Business Unit, SKU Item, Supply Chain, Vendor Item

Point of Service

Calendar, Call Center, Call Center Agent, Control Transaction, Organization Business Unit, Retail Sales, Retail Transaction, Sales Audit, Time, Tender Control, Tender Repository, Touchpoint

Restaurant

Address Location, Call Center, Catalog Menu, Food Service, Organization Business Unit, Retail Transaction, SKU Item Recipe, Workforce Management

Retail Inventory

Financial Ledger, Inventory, Inventory Control, Invoice, Supply Chain

Store Operations

Calendar, Certificate Voucher, Control Transaction, Inventory, Inventory Control, Organization Business Unit, Planogram, Supply Chain, Tender Control, Tender Repository, Touchpoint, Vendor, Workstation and Till

Vendor Management

Address Location, Calendar, Deal, Invoice, Supply Chain, Vendor, Vendor Item

Workforce

Calendar, Control Transaction, Organization Business Unit, Retail Transaction, Tender Control, Workforce Management


Logical Data Model Subject Area Entity Lists

Table 2-2 lists the Oracle Retail Data Model Subject Areas.

Business Unit

Table 2-5 lists the Business Unit entities.

Call Center Agent

Table 2-8 lists the Call Center Agent entities.

Table 2-8 Call Center Agent Subject Area Entities

Call Center Agent Entity List

CALL CENTER

CALL CENTER AGENT

CALL CENTER AGENT TYPE

EMPLOYEE

PARTY INTERACTION CALL EVENT

PARTY INTERACTION THREAD


Contract

Table 2-14 lists the Contract entities.

Customer Contract

Table 2-18 lists the Customer Contract entities.

Customer Service Request

Table 2-20 lists the Customer Service Request entities.

Planogram

Table 2-38 lists the Planogram entities.

SKU Item Recipe

Table 2-41 lists the SKU Item Recipe entities.

Revenue Center

Table 2-44 lists the Revenue Center entities.

Sales Audit

Table 2-45 lists the Sales Audit entities.

Subscription

Table 2-47 lists the Supply Chain entities.

Table 2-47 Subscription Subject Area Entities

Subscription Entity List

CONTRACT

CUSTOMER CONTRACT

SERIALIZED ITEM

SKU ITEM

SUBSCRIPTION


Time

Table 2-51 lists the Time entities.

Table 2-51 Time Subject Area Entities

Time Entity List

HALF HOUR

HOUR

MINUTE

QUARTER HOUR

SECOND


Vendor Item

Table 2-54 lists the Vendor Item entities.

Logical Data Model Entity Dictionary

Table 2-57, Table 2-58, Table 2-59, and Table 2-60 list the logical data model entities, in alphabetical order.

Table 2-57 A-F Entity Descriptions

Entity Name Type Description

ACCOUNT PAYABLE DAY DERIVED

Derived

Daily Payables balance by business unit, PARTY, EXPENSE TYPE, and GL ACCOUNT.

ACCOUNT PAYABLE MONTH AGGR

Aggregate

Monthly Payables summary by business unit, PARTY, EXPENSE TYPE, and GL ACCOUNT.

ACCOUNT RECEIVABLE DAY DERIVED

Derived

Daily Receivables balance by business unit, PARTY, EXPENSE TYPE, and GL ACCOUNT.

ACCOUNT RECEIVABLE MONTH AGGR

Aggregate

Monthly Receivables summary by business unit, PARTY, EXPENSE TYPE, and GL ACCOUNT.

ACCOUNT TYPE

Lookup

Lookup for account type. For example:

  • Installment Payment Account

  • Charge Account

  • Trade Account

  • Layaway Account

  • Rental Account

ACTIVITY REQUEST DAY DERIVED

Derived

Daily summary of service requests. Summarizes Service Request type of interaction thread between EMPLOYEEs and CUSTOMER party.

ACTIVITY REQUEST MONTH AGGR

Aggregate

Monthly summary of Activity Requests.

ACTIVITY REQUEST TYPE

Lookup

Lookup for distinct occurrences of activity request types. For example:

  • Where Is My Order

  • General

  • Gift certificate lookup

ADDRESS LOCATION

Reference

An ordinary postal address for the PARTY or SITE. From the Location Geography.

ADDRESS LOCATION STATUS HISTORY

Base

History of the names and addresses associated with an ORGANIZATION BUSINESS UNIT, VENDOR, PROSPECT, or CUSTOMER.

ADDRESS LOCATION TYPE

Lookup

Lookup for location types of a given site. For example:

  • Free-standing (Isolated retail location not connected to other retailers)

  • Central Business District (CBD) (Corner location, Center location)

  • Secondary Business District (SBD)-Street (Corner location, Center location)

  • Neighborhood Business District (NBD)-Street (Corner location, Center location)

  • Shopping Center (Strip centers, Malls)

  • Other (Airport, Hotel, Hospital, Resort, Store-within-store, Entertainment or Recreation)

ADDRESS RELATED

Reference

Associates one addresses with other addresses. For example:

  • Alternate address

  • Locations with multiple addresses

ADDRESS TELEPHONE

Reference

Phone numbers associated with a specific address.

ADDRESS TYPE

Lookup

Lookup for address type. For example:

  • Home

  • Mailing

  • Shipping

ADDRESS VERIFICATION TYPE

Lookup

Lookup for methods in which an address may be verified.

ADJUSTMENT TYPE

Lookup

Lookup for RETAIL TRANSACTION adjustment types.

ADMINISTRATION CENTER

Reference

Subtype of ORGANIZATION BUSINESS UNIT where administrative activities occur.

ADVANCED SHIP NOTICE DOCUMENT

Base

An electronic document sent to a store by a VENDOR that defines the shipment date, expected delivery date, carrier, shipped items, and ORDER DOCUMENT reference. The Advanced Ship Notice Document is sent out in advance of the shipment to enable the retailer to plan workload and receipt processing.

ADVANCED SHIP NOTICE DOCUMENT LINE ITEM

Base

Details line in ADVANCED SHIP NOTICE DOCUMENT.

ADVERTISING PERIOD

Reference

Period level in the advertising calendar.

ADVERTISING QUARTER

Reference

Quarter level in the advertising calendar.

ADVERTISING WEEK

Reference

Week level in the advertising calendar.

ADVERTISING YEAR

Reference

Year level in the advertising calendar.

AGE GROUP

Lookup

Age bands for grouping customers or EMPLOYEEs into age related groups. For example:

  • 0 to 20 years

  • 20 to 30 years

  • 40 to 50 years

  • 50 to 60 years

  • 60 and over years

AGE RESTRICTION RULE

Reference

Defines a rule that restricts the sale of an ITEM to CUSTOMERs who must be of a minimum age and also the minimum age of an employee to perform a task, such as selling alcohol.

AGENT

Reference

A software program which acts for and assists a user or other program in opening a session.

AGGREGATE SKU

Reference

Sub-type of SKU that is an aggregation of one or more constituent SKUs. The constituent items could also be sold individually.

ALTERNATIVE ITEM

Reference

A cross-reference of items that might be substituted or offered for another item.

ANALYSIS DURATION

Reference

Specifies a period that can extend over two or more days. Valid values:

  • Analysis On Week Basis

  • Analysis On Month Basis

  • Analysis On Year Basis

APPAREL ITEM

Reference

A dress, skirt, blouse, pair of trousers or any other item of clothing that can be related to other Apparel Items by way of SIZE, COLOR or SKU ITEM STYLE.

APPOINTMENT CALENDAR

Reference

Appointment calendar for a VENDOR with the retail ORGANIZATION BUSINESS UNIT.

APPOINTMENT MEETING TYPE

Lookup

Types of vendor meetings.

APPOINTMENT TYPE

Lookup

Lookup for appointment types. For example:

  • Delivery

  • RTV Pickup

  • Service

ASSETS DAY DERIVED

Derived

Daily Balance of Financial and other Assets.

ASSETS MONTH AGGR

Aggregate

Monthly Summary of Financial and other Assets.

ASSETS TYPE

Lookup

Types of Financial and other Assets.

AUTHORIZATION METHOD

Lookup

Lookup for methods to authorize tender. For example:

  • By electronic query

  • By sales employee

  • Visual inspection of customer card and ID

BANK

Reference

Bank or other Financial Institution.

BASE DAY

Reference

Represents a DAY within a specific hierarchy of Time. Base Day is a normalized form of the DAY entity. DAY represents the lowest denormalized common level of all Time Hierarchies.

BLENDER

Reference

A connection between a NOZZLE and one or more LOCATIONs each containing a single BULK ITEM which are blended by the NOZZLE when performing a FUELING TRANSACTION.

BRAND

Reference

Selling and promotional name to identify a product for advertising and name recognition purposes.

BULK ITEM

Reference

A sub-type of SKU ITEM that is purchased in bulk and is measured and sold by weight, volume, or linear measure.

BUMP BAR EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a bump bar connected to a STORE WORKSTATION.

BUSINESS ENTITY SELLING RULE

Reference

Identifies the selling rules associated with an ITEM at a particular ORGANIZATION BUSINESS ENTITY which could include one or more ORGANIZATION BUSINESS UNITs.

BUSINESS ENTITY TENDER RESTRICTION RULE

Reference

An association between ITEM TENDER RESTRICTION GROUP and TENDER which constrains the use of a specific type of TENDER in the settlement of a sale for a specific ITEM at a given ORGANIZATION BUSINESS ENTITY.

BUSINESS HALF MONTH

Reference

Half-month as defined in the Business calendar.

BUSINESS HALF YEAR

Reference

Half-year as defined in the Business calendar.

BUSINESS LEGAL STATUS

Lookup

Lookup for the legal status of the company. For example:

  • Public Company

  • Private Company

BUSINESS MONTH

Reference

Months as defined in the Business calendar.

BUSINESS QUARTER

Reference

Quarter as defined in the Business calendar.

BUSINESS UNIT CALENDAR

Reference

Operating Calendar for the ORGANIZATION BUSINESS UNIT, allocated for each day of the year.

BUSINESS UNIT JOB ROLE

Reference

Job roles within the retail organization. This entity identifies various shifts, job roles, and number of employees required across stores. Associates JOB ROLES, Organization Business Physical Site, and Organization Site Shifts.

BUSINESS UNIT SHIFT

Reference

Work shift associated with the ORGANIZATION BUSINESS UNIT, associated with Employee job roles for the allocation for these shifts.

BUSINESS UNIT TYPE

Lookup

Lookup for ORGANIZATION BUSINESS UNIT types.

Lookup for unique retailer assigned identifier for an ORGANIZATION STORE, ORGANIZATION DISTRIBUTION CENTER, or ADMINISTRATION CENTER that performed the transaction. For example:

  • Store

  • Warehouse

  • Catalog

BUSINESS UNIT USAGE TYPE

Lookup

Lookup for the type of ORGANIZATION BUSINESS UNIT. For example:

  • Store

  • Store within a Store (Quick Serve, Dry Cleaning, Bank, ATM, Hair Salon, Parcel Service, Wireless Provider)

  • Department (Pharmacy, Film, Optician, Nursery, Cosmetics, Gift Registry, Customer Service, Returns counter, Pickup Counter, Drive-through)

  • Kiosk (Cart, Video, Stationary)

  • Vending machine Warehouse

  • Distribution Center

  • Call Center

  • Administrative

BUSINESS WEEK

Reference

Weeks as defined in the Business calendar.

BUSINESS YEAR

Reference

Years as defined in the Business calendar.

CALENDAR

Reference

Calendar names and descriptions.

CALENDAR HALF MONTH

Reference

Half-month level in the normal CALENDAR.

CALENDAR HALF YEAR

Reference

Half-year level in the normal CALENDAR.

CALENDAR MONTH

Reference

Month level in the normal CALENDAR.

CALENDAR QUARTER

Reference

Quarter level in the normal CALENDAR.

CALENDAR TYPE

Lookup

Type of calendar used by a BASE DAY.

CALENDAR WEEK

Reference

Week level in the normal CALENDAR.

CALENDAR YEAR

Reference

Year level in the normal CALENDAR.

CALL CENTER

Reference

Subtype of ORGANIZATION BUSINESS UNIT that handles telephone sales, services, or both.

CALL CENTER AGENT

Reference

Subtype of TOUCHPOINT. Employee or worker who handles queries to a CALL CENTER.

CALL CENTER AGENT TYPE

Lookup

Lookup for call center agent types. For example:

  • Employee

  • IVR

CALL CENTER CASE SUB TYPE

Lookup

Lookup to further characterize the type of cases from the call center. The case subtype helps to split a given case type into various subtypes. For example, for the case type of "Srv: Service Request", the sub-type could be further classified as "Package Upgrade", "Package Downgrade", or "Simple contract Renewal".

CALL CENTER CASE TITLE

Reference

In order to serve the customer properly a call center has an organized approach. Customer complaints called in to the call center are classified using three level classification structures. All the cases are broadly classified into CALL CENTER CASE TYPE. CALL CENTER CASE TYPE are divided into case sub types and case sub types are further classified into case titles.

Whenever a new case is assigned it will be assigned a case id. Each case id is associated with a case title, subtype and a type. Information of the registered cases will be analyzed on these attributes.

Sub categories in Case sub types are case titles. The case sub type level contains all these values and will help in analyzing data on Titles.

CALL CENTER CASE TYPE

Lookup

Lookup for type of call center cases. For example:

  • Cmpl: Complaint

  • Inqry: Inquiry

  • Srv: Service Request

CAMPAIGN

Reference

Entire communication strategy for a specific marketing communications program. The marketing communications program is frequently in support of promotional events and individual promotions but can be standalone.

Retailers execute several different types of campaigns, including advertising, direct marketing and in-store marketing. There are several sub-types within each category as well. Advertising includes:

  • Traditional broadcast

  • Direct response

  • Online

Direct marketing includes:

  • Individually tracked

  • Summary tracking

In-store includes:

  • Broadcast

  • 1:1. The 1:1 is usually performed in call centers or on websites.

Each campaign consists of 1 to n communications, which is the lowest level of a campaign.

CAMPAIGN COST

Base

Costs associated with a CAMPAIGN.

CAMPAIGN CUSTOMER ASSIGNMENT

Reference

Assignment entity among CAMPAIGN EXECUTION MESSAGE, CUSTOMER, CAMPAIGN MESSAGE RENDERING.

CAMPAIGN EXECUTION MESSAGE

Reference

Information regarding the message costs for a media campaign.

CAMPAIGN MEDIA

Reference

Advertising MEDIA associated with a CAMPAIGN.

CAMPAIGN MEDIA LAUNCH

Reference

Details about how a CAMPAIGN is carried out.

CAMPAIGN MEDIA SELLING ITEM

Reference

Items presented to customer or public as part of the CAMPAIGN.

CAMPAIGN MESSAGE DEPICTION

Reference

Information regarding the depiction of a campaign message within the media.

CAMPAIGN MESSAGE RENDERING

Reference

Details about how the campaign message was rendered, broadcast, distributed in the media and associated costs.

  • Cost: Cost of Media

  • Target: Anticipated recipients of the campaign message

CAMPAIGN MESSAGE RENDERING COST

Base

Costs associated with a CAMPAIGN MESSAGE RENDERING.

CAMPAIGN TARGET

Reference

Sub entity of CAMPAIGN CUSTOMER ASSIGNMENT indicating the target audience for a campaign.

CARD HOLDER VERIFICATION TYPE

Lookup

Lookup for type of verification performed to ensure the purchaser was the valid Card Holder.

CARD TYPE

Lookup

Lookup for codes denoting which kind of card was accepted. For example:

  • Amex

  • Diners

  • Disc

  • JCB

  • MC

  • Visa

CARRIER

Reference

An external party that transports merchandise or supply items from their source to the ORGANIZATION STORE and from the ORGANIZATION STORE back to their source.

CARRIER COMPLIANCE DAY DERIVED

Derived

Record of delivery performance for a CARRIER during a given day.

CARRIER COMPLIANCE WEEK AGGR

Aggregate

Record of delivery performance for a CARRIER during a given week. Delivery performance is measured by how many times the CARRIER was late, early or on-time, and how late or early they were in hours, or days.

CASH DRAWER EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a cash drawer connected to a STORE WORKSTATION.

CERTIFICATE

Reference

A certificate with a face monetary value issued by a store for subsequent exchange for merchandise.

CERTIFICATE ACTIVITY DAY AGGR

Aggregate

Daily summary of issued and redeemed CERTIFICATE or vouchers.

CERTIFICATE ACTIVITY TRANSACTION DERIVED

Derived

Describes the RETAIL TRANSACTION LINE ITEM sub type certificates for issue and the RETAIL TENDER LINE ITEM type certificate tender for redemption.

CERTIFICATE AGE BAND

Reference

Categorize CERTIFICATEs based on age. Each age band is a client-defined range of age in days. The age of a CERTIFICATE determines the age band into which it falls.

CERTIFICATE ESCHEATED DAY

Base

The date and count of escheated vouchers.

CERTIFICATE LINE ITEM

Base

A type of RETAIL TENDER LINE ITEM that records the sale of redeemable form of tender for a predetermined monetary value of sellable merchandise in the store. Creates a liability for the retailer in the amount denoted on the face value of the certificate.

CERTIFICATE TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records the specifics about a CERTIFICATE redeemed as part of settling a transaction.

CERTIFICATE TYPE

Lookup

Lookup for certificate types. For example:

  • Gift Certificate

  • Store Credit

CHANNEL TYPE

Lookup

Lookup for channel types. For example:

  • Selling

  • Distribution

CHECK TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records the specifics about a check received from a customer in settling a transaction.

CLASS

Lookup

Classification of the RETAILER relationship with a VENDOR.

CLIENT

Reference

One of the levels of the Agent Client Software, identifying client software agent:

  • Internet Explorer

  • Netscape

  • Internet Explorer Crawler

  • Lycos Spider

CLIENT HOST

Reference

One of the levels of the Total - Identifying of the client host level. DNS hostname or IP address of the client as it appears in the access logs. For Example: user29-dms.us.oracle.com

CLIENT TYPE

Lookup

One of the levels of the Agent Client Software, identifying type of client software agent:

  • Graphical Browser

  • Web Crawler

  • Text Browser

  • Other

  • Unknown

CLIENT VERSION

Reference

One of the levels of the Agent Client Software identifying version of the client software agent:

  • IE_4.0

  • NETSCAPE_4.X

  • LYCOS_SPIDER_3.0

COATING

Lookup

The coating attribute of SKU ITEM.

COLOR

Lookup

A standard store reference for APPAREL ITEM color. Certain apparel retailers record data at this level, specifically for replenishment.

COLOR LIST AGENCY

Lookup

A third party that provides COLOR and COLOR PALETTE definitions to the retail enterprise.

COLOR PALETTE

Lookup

A grouping of similar colors to classify merchandise for analysis. For example:

  • Earth Tones

  • Space Colors

  • Spring Greens

COMMUNICATION TYPE

Lookup

Lookup for type of communication. This entity holds the name of communication and the format along with the communication code. For example:

  • Telephone

  • Paper

  • E-mail

COMPETITOR

Reference

A retailer with a product range and customer base similar to those for the store.

COMPETITOR LOCATION

Reference

An external retail entity at which a CUSTOMER may shop and purchase items instead of the RETAILER.

COMPETITOR LOCATION ASSIGNMENT

Reference

The associative relationship between competitor locations and ORGANIZATION BUSINESS UNIT locations. For example:

  • A competitor grocery store may contain a bank, a florist, and a pharmacy

  • Competitors can be either primary or secondary

COMPETITOR MANUFACTURER SKU ITEM

Reference

A MANUFACTURER SKU ITEM which is stocked by a COMPETITOR and is perceived by the customer to have no discernible difference in terms of form, fit or function, but may be sold at a different retail price.

COMPETITOR RETAIL ITEM

Reference

An SKU ITEM that a COMPETITOR stocks that has, to the consumer, no apparent difference in form, fit, or function, but may be sold at a different retail price.

CONTRACT

Reference

Legal agreement between two parties, it could be VENDOR CONTRACT or CUSTOMER CONTRACT.

CONTRACT STATUS

Reference

The status history of the CONTRACT. For example:

  • Terminated

  • Normal

  • Expired

CONTRACT STATUS REASON

Lookup

Lookup for description of the contract status change. For example:

  • Customer originated Product upgrade

  • Provider originated: Bad payment (leading to suspension)

  • Customer originated: Debt paid (leading to reactivation)

  • Customer originated: Complaint

CONTRACT STATUS TYPE

Lookup

Lookup for all possible types of CONTRACT STATUS. For example:

  • Newly created for new account

  • Renewed automatically

  • Naturally expired or terminated

CONTRACT TERM TYPE

Lookup

Lookup for all possible terms which may be attached to a CONTRACT. For example:

  • Monetary amount

  • Period

  • Premium

  • Initial points

  • Cancellation policy

  • Subsidy

CONTRACT TERM VALUE

Reference

The value of terms attached to the CONTRACT. For example:

  • Monetary amount

  • Period

  • Premium

  • Initial points

The value can vary at different time period of the CONTRACT. For example, the monthly fee might be 100 for the first six months and 80 for the last six months. A penalty calculation can also be based on the months left in the contract.

CONTRACT TYPE

Lookup

Lookup for CONTRACT types.

CONTROL TRANSACTION

Base

A type of Transaction that records non-financial activity that tracks changes in the status of a point of sale terminal, terminal access by retail enterprise employees and their supervisors and other activities and events related to the administration and management of the point of sale system.

CONTROL TRANSACTION TYPE

Lookup

Lookup for types of CONTROL TRANSACTIONs.

COST

Base

Expenses incurred by the COST CENTER.

COST CENTER

Reference

A functional area of the ORGANIZATION, such as Accounting, Facilities, Shipping, and so on at which level costs are incurred and tracked.

COST CENTER BUDGET

Base

Expenses budgeted by the COST CENTER.

COST DAY DERIVED

Derived

Daily costs by COST TYPE and ORGANIZATION BUSINESS UNIT.

COST MONTH AGGR

Aggregate

Monthly costs by COST TYPE and ORGANIZATION BUSINESS UNIT.

COST PER UNIT TYPE

Lookup

Defines the unit type the owned attribute costs are assigned to for an item. For example:

  • Sale unit

  • Pack unit

  • Ship unit

This lookup entity is used for INVENTORY CONTROL DOCUMENT LINE ITEM entity.

COST REASON

Lookup

Lookup for all possible reasons why the COST occurred. For example:

  • Natural disaster

  • Operator error

COST SUBTYPE

Lookup

Lookup to further classify COST TYPEs. For example:

  • Acquisition cost

  • Retention cost

  • Salary

  • Damaged

  • Repair fee

COST TYPE

Lookup

Lookup for types of COSTs.

COST VALUATION LEDGER ACCOUNT HISTORY

Base

History of Cost Valuation portion of the GL ACCOUNT figures.

COUPON SCAN

Lookup

Specifies the barcode on a store or manufacturer coupon. The coupon scan code comprises two parts:

  • The first is a fixed 12 character code that contains the manufacturer identification, family code, and coupon value.

  • The second is based on Code 128 and comprises up to 20 characters which specify the manufacturers number system character, the offer code, and end of offer code.The supplementary Code 128 was introduced as a guideline in 1997.

    These codes are included: Primary Label, Secondary Label, Coupon ID.

COUPON TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records the use of a coupon which must be validated against an item in the Transaction, to tender part (or all) of a the Transaction.

COUPON TYPE

Lookup

Lookup for Type of coupon used in the COUPON TENDER LINE ITEM.

CREATIVES

Reference

Information about the creative content of the message and location of associated depiction file. Points to a file location where the creatives are stored. For example:

  • Photos

  • Writing

  • Drawings

  • Recordings

CREDIT-DEBIT CARD TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records the specifics about a credit or debit card used to settle a transaction.

CURRENCY

Lookup

National designation and quantitative value of monetary media used as tender in the processing of the Tender Line Item. For example:

  • US Dollar

  • Indian Rupee

  • Japanese Yen

CURRENCY CONFIGURATION

Config

Lookup for values for the base and three reporting currencies. The Base Currency (code: BASE) is the default currency of the implementation. The Reporting Currencies (code: RPT/RPT2/RPT3) are the currencies available for Reporting the Base Amount figures. Multiple Currency based reporting must be enabled in the reporting front-end tool (OBIEE). Data Conversion from Base to Reporting currencies is done at the time of the ETL loads. Multiple Currency Functionality requires, that is depends on data in, the Exchange Rate Currency Day Derived table (EXCHANGE RATE CURRENCY DAY).

CUSTOMER

Reference

An individual or organization that purchases, may purchase, or did purchase goods and or services from an ORGANIZATION STORE.

CUSTOMER ACCOUNT

Reference

A charge account or other accounting relationship a customer has with the store or organization. An account exists to allow the store to record a series of transactions with the same customer and keep an ongoing record of monies owed by the customer and monies due to the customer.

CUSTOMER ACCOUNT CARD

Reference

An card or other device used in association with an account.

CUSTOMER ACCOUNT CARD ASSIGNMENT

Reference

A record of the period which a CUSTOMER ACCOUNT CARD was assigned to a particular CUSTOMER ACCOUNT.

CUSTOMER ACCOUNT TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM whereby the RETAIL TRANSACTION is tendered against a CUSTOMER ACCOUNT CARD or CUSTOMER ACCOUNT.

CUSTOMER ADDRESS

Reference

Associative entity assigning a CUSTOMER to one or more ADDRESS LOCATION.

CUSTOMER AFFILIATION

Reference

Associates a CUSTOMER with a CUSTOMER GROUP.

CUSTOMER AUTHENTICATION GROUP

Reference

Authentication Groups to which a CUSTOMER may be assigned.

CUSTOMER CLUSTER

Reference

Identifies the Cluster that the CUSTOMER falls into, based on buying behavior.

CUSTOMER CLUSTER ITEM ASSIGNMENT

Reference

Identifies ITEMs associated with a CUSTOMER CLUSTER, based on buying behavior.

CUSTOMER CLUSTER TYPE

Reference

Define types of CUSTOMER CLUSTER.

CUSTOMER CONTRACT

Reference

Legal agreement between a retailer and a CUSTOMER.

CUSTOMER COST

Base

Subtype of COST which applies to a CUSTOMER. For example, the cost of a gift that is sent to a CUSTOMER.

CUSTOMER EMPLOYEE RELATIONSHIP DAY DERIVED

Derived

Cross-reference of EMPLOYEE transactions by CUSTOMER. Day level snapshot of transactions between a CUSTOMER and EMPLOYEE.

CUSTOMER EMPLOYEE RELATIONSHIP MONTH AGGR

Aggregate

Monthly cross-reference of EMPLOYEE transactions by CUSTOMER. Monthly aggregate of transactions between a CUSTOMER and EMPLOYEE.

CUSTOMER EMPLOYEE SALE RETURN MONTH AGGR

Aggregate

Month Aggregation of CUSTOMER SKU SALE RETURN DAY DERIVED.

CUSTOMER GROUP

Reference

A group of CUSTOMERs based on specific demographic and marketing attributes and properties. For example:

  • Senior customers (over 65 years old)

  • Students

  • Unions

  • Other associations

CUSTOMER GROUP ITEM

Reference

An association of ITEM and CUSTOMER GROUP, the data for this may come from external source.

CUSTOMER INDIVIDUAL

Reference

Subtype of CUSTOMER (and PARTY), which contains details of individuals as opposed to organizations.

CUSTOMER INFORMATION LINE ITEM

Base

Provides a specific data element level description and value for customer information line item. This modifier provides a flexible, dictionary driven method for specifying the kind of data captured about a CUSTOMER.

CUSTOMER INVOICE

Base

A summarized list of charges, including payment terms, invoice item information, and other information that is sent to a CUSTOMER for payment.

CUSTOMER INVOICE ITEM

Base

A single line of an invoice.

CUSTOMER OCCASION

Reference

Events celebrated or observed by a CUSTOMER. For example:

  • Mother's Day

  • Thanksgiving

CUSTOMER OCCASION TYPE

Lookup

Lookup for categorizations of CUSTOMER OCCASION. For example:

  • Wedding

  • High School Graduation

  • Birthday

  • Golden Wedding Anniversary

CUSTOMER ORDER

Base

ORDER placed by a CUSTOMER for merchandise or services to be provided at some future date and time.

CUSTOMER ORDER CONTROL TRANSACTION

Base

A type of RETAIL TRANSACTION recording the creation or alteration of a CUSTOMER ORDER, by a particular Operator.

CUSTOMER ORDER CONTROL TRANSACTION LINE ITEM

Base

A component of a CUSTOMER ORDER CONTROL TRANSACTION, recording a change in state for a particular ORDER LINE ITEM by an Operator.

CUSTOMER ORDER LINE ITEM

Base

A line item component of a CUSTOMER placed ORDER.

CUSTOMER ORDER LINE ITEM STATE

Base

Describes the state of fulfillment of a CUSTOMER ORDER LINE ITEM.

CUSTOMER ORDER LINE ITEM STATE DERIVED

Derived

Denormalization of CUSTOMER ORDER LINE ITEM STATE.

CUSTOMER ORDER STATE

Base

Retailer defined state for an ORDER. Possible values include:

  • Pending

  • Partially Delivered

  • Complete

  • Canceled

CUSTOMER ORDER TAX EXEMPTION MODIFIER

Base

A line item component of a CUSTOMER placed ORDER, recording any Tax exemptions that the ordering CUSTOMER may receive.

CUSTOMER ORDER TAX LINE ITEM

Base

A line item component of a CUSTOMER placed ORDER, recording the Tax liability that the entire order is incurring.

CUSTOMER ORDER TAX OVERRIDE MODIFIER

Base

A line item component of a CUSTOMER placed ORDER, recording any Tax rate overrides that the ordering CUSTOMER may receive.

CUSTOMER ORDER TENDER PRE AUTHORIZATION

Base

A line item component of a CUSTOMER placed ORDER, recording any Credit or Debit Card pre-authorization that is performed at the time the order is taken.

CUSTOMER ORGANIZATION

Reference

Subtype of CUSTOMER (and PARTY), which contains details of organizations as opposed to individuals. An organization can also consist of one individual only (for example: independent).

CUSTOMER PAYMENT

Base

Amount disbursed to RETAILER by CUSTOMER in response to a CUSTOMER INVOICE.

CUSTOMER PICKUP TYPE

Lookup

Lookup for where and how a CUSTOMER may pickup an item. For example, a refrigerator may have to be picked up at the shipping dock or at a warehouse of the retailer.

CUSTOMER PREFERENCE

Reference

Merchandise preferences of a Key Customer, for classes of items or other general categories.

CUSTOMER QUICK FACTS

Reference

Collection of CUSTOMER related measures.

CUSTOMER RELATIONSHIP

Reference

Association between CUSTOMERs. Information regarding the CUSTOMER or PROSPECT that is restricted to comply with privacy and other laws.

This table is encrypted.

For example: associating the Husband-Wife relationship.

CUSTOMER RELATIONSHIP TYPE

Lookup

Lookup for types of relationships that may exist between CUSTOMERs. For example:

  • Married

  • Employee-employer

  • Parent-child

CUSTOMER RENTAL ACCOUNT

Reference

A sub-type of CUSTOMER ACCOUNT that records details of the CUSTOMER as a renter of RENTAL SERVICE items.

CUSTOMER RENTAL ACCOUNT HISTORY

Base

A summary of all rentals made against the CUSTOMER RENTAL ACCOUNT during a period.

CUSTOMER RESTRICTED INFO

Reference

Detail information about a CUSTOMER that may be deemed private.

CUSTOMER RFMP SCORE

Derived

Recency, Frequency, Monetary, and Profitability Value Score of a CUSTOMER, by ORGANIZATION BUSINESS UNIT.

CUSTOMER SKU SALE RETURN DAY DERIVED

Derived

SKU ITEM purchases and returns by CUSTOMER for an ORGANIZATION BUSINESS UNIT.

CUSTOMER STATUS

Base

CUSTOMER or PROSPECT status.

CUSTOMER TRADE ACCOUNT

Reference

A type of CUSTOMER ACCOUNT established for builders, plumbers, electricians, and other trade businesses that purchase merchandise, usually at a preferential discount, from the store.

CUSTOMER TYPE

Lookup

Lookup to classification of CUSTOMER as a CUSTOMER INDIVIDUAL or ORGANIZATION or any other classification.

CUSTOMER TYPE ORDER DEPARTMENT MONTH AGGR

Aggregate

BUSINESS MONTH level aggregate of ITEM DEPARTMENT sales by CUSTOMER TYPE.

CUSTOMER TYPE ORDER ITEM DAY DERIVED

Derived

BUSINESS DAY level sales of ITEMs by CUSTOMER TYPE.

CUSTOMER TYPE ORDER SUBCLASS WEEK AGGR

Aggregate

BUSINESS WEEK level sales by ITEM SUBCLASS and CUSTOMER TYPE.

DAY

Reference

Day level in the normal calendar.

DAY ACTUAL CONDITION

Reference

User defined condition describing phenomenon that may have affected sales on a particular DAY at an ORGANIZATION BUSINESS UNIT. Phenomenon could include strike, construction, rain, or snow.

DAY TODATE TRANSFORMATION

Reference

Cumulative time transformations at the DAY level.

Documents how to date transformation can be implemented at DAY level.

DAY TRANSFORMATION

Reference

Transformation for a DAY, for example: this day last year, this day last month.

DEAL

Reference

Special offer from a VENDOR to the retail organization. The deal generally provides allowances, discounts, special favorable terms of payment or other incentives to motivate the retail organization to purchase more products or services from a supplier.

DEAL VENDOR ITEM ASSIGNMENT

Base

Identifies a specific VENDOR ITEM offered as part of a DEAL to the retail organization and defines how the deal cost is to be handled.

DEAL VENDOR ITEM COST BREAK

Base

Deal-related cost breaks offered to a ORGANIZATION STORE by a VENDOR. Cost breaks represent stepped cost reductions based on the number of units acquired by the store.

DEMOGRAPHY ATTRIBUTE

Reference

A sub-level group or category further qualifying a set of data (Profile Group) collected about a CUSTOMER to assist in marketing efforts. For example:

  • NC - Number of Children

  • EDL - Education Level

DEMOGRAPHY GROUP

Reference

The domain of classifications used to group profile information about a PARTY. For example:

  • CH - Credit History

  • ED- Education

  • EM - Employment

  • EQ- Equipment

  • HB - Hobbies

  • HH - Household

  • OR - Organization

  • Other relevant demographics and psychographics

DENOMINATION

Lookup

Specifies the quantitative value of the referenced CURRENCY media. For example:

  • Ten dollars (as in 10 dollar bill)

  • Fifty pounds (fifty pound note)

  • 25 cents

DEPOSIT REDEMPTION LINE ITEM

Base

Subtype of RETAIL TRANSACTION LINE ITEM. A deposit is a monetary amount that is paid to secure an ITEM. The deposit can be redeemed against the eventual purchase or returned to the CUSTOMER when the ITEM is returned. For example a bottle or can. DEPOSIT REDEMPTION LINE ITEMs are common in some grocery stores where a deposit is paid for the container at the time of purchase and a redemption payment made when returned at a future visit.

DEPOSIT REDEMPTION TYPE

Lookup

Lookup for valid DEPOSIT REDEMPTION LINE ITEM types.

DEPOSIT RULE

Reference

An association of a SKU ITEM and a Return Agent that defines the rules governing the deposit payment that must be paid by the customer at the time the item is purchased and the refund that must be made to the customer upon return of the item package or container. The rule is most often related to bottles, aluminum cans, crates, and other containers, which must be returned for reuse or recycling.

DERIVED VALUE

Reference

Derived value of the CUSTOMER as defined by the user.

DESTINATION TYPE

Lookup

Lookup for the types of destinations. For example:

  • National

  • International

  • Particular continent

DEVICE EVENT

Base

An event collected from a device such as a printer, scanner, reader, and so on.

DISBURSEMENT FUNDS RECEIPT REASON

Lookup

The reason why a petty cash disbursement has been made or funds receipt received.

DISBURSEMENT TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the disbursement of TENDER from a Till; (with an offsetting miscellaneous expense).

DISCOUNT LINE ITEM

Base

Subtype of RETAIL TRANSACTION LINE ITEM detailing the amount of an applied Discount.

DISCOUNT TYPE

Lookup

Lookup for the various types of discount. For example:

  • Percentage

  • Amount

DISCOUNT TYPE GROUP

Lookup

Classification of DISCOUNT TYPE. For example:

  • Senior

  • Employee

  • Coupon

  • Store

  • Quantity

DISCREPANCY TOLERANCE RULE

Reference

Defines permissible variance between the total inventory control document cost (based on the suppliers cost) and the stores receiving total (based on the stores record of supplier item cost). Any variance that exceeds the discrepancy threshold triggers an invoice or item-level reconciliation.

DISPLAY UNIT ITEM

Reference

A sub-type of ITEM for shelf, rack, or other display unit that is used by the store to display merchandise. Particularly used for racks and shelves custom designed for a particular item. A display unit item is not normally for sale.

DISPOSITION TYPE

Lookup

Denotes what disposition a returned ITEM was in. For example:

  • Return to vendor

  • Return to stock

  • Write off

DOMAIN

Reference

Internet DOMAIN associated with a CLIENT HOST and GEOGRAPHY COUNTRY.

DOMAIN TYPE

Lookup

Type of domain. For example:

  • Company

  • Education

  • Network

  • Organization

DRIVE OFF TRANSACTION

Base

A type of transaction that records the clearing of a FUELING TRANSACTION without accepting payment because the customer simply drove off without paying. Operator may record some details about the vehicle that has driven off.

DYE

Lookup

The dye attribute of SKU ITEM.

EDUCATION

Lookup

Demographic education levels that may be assigned to customers.

EMAIL ADDRESS

Reference

E-mail address associated with a LOCATION.

EMPLOYEE

Reference

An individual who works for the retail organization, accepts direction from the retail store management and satisfies the statutory criteria requiring that payroll taxes and benefit contributions be paid by the retailer.

EMPLOYEE ACTUAL LABOR DETAIL

Base

Details of hours worked and wage rates for a given period.

EMPLOYEE ACTUAL LABOR HOURLY

Base

Subtype of EMPLOYEE ACTUAL LABOR DETAIL detailing shift hours worked on a business DAY by an hourly EMPLOYEE.

EMPLOYEE ACTUAL LABOR SALARIED

Base

Subtype of EMPLOYEE ACTUAL LABOR DETAIL detailing the period timespan during which the labor was performed by a salaried EMPLOYEE.

EMPLOYEE ADDRESS

Reference

Maps EMPLOYEE with ADDRESS LOCATION. May include multiple addresses of an EMPLOYEE and type of address. For example:

  • Permanent address

  • Temporary address

  • Rented

EMPLOYEE AVAILABILITY

Reference

Identifies EMPLOYEEs available to work at a specific ORGANIZATION BUSINESS UNIT for a given BUSINESS UNIT SHIFT.

EMPLOYEE CERTIFICATE

Reference

Certificate verifying that the EMPLOYEE has attended training and or passed a qualifying exam.

EMPLOYEE CERTIFICATION ISSUING BODY

Reference

Issuing body of an EMPLOYEE CERTIFICATE.

EMPLOYEE CERTIFICATION TYPE

Lookup

Type of EMPLOYEE CERTIFICATE.

EMPLOYEE CLASS

Reference

Classification of EMPLOYEE roles based on pay type, commission eligibility, and so on.

EMPLOYEE CLASS ASSIGNMENT

Reference

Association entity assigning an EMPLOYEE to an EMPLOYEE CLASS.

EMPLOYEE COMMISSION PLAN

Reference

Compensation Plans for Commission eligible EMPLOYEEs and the associated GL ACCOUNT.

EMPLOYEE COST

Base

Subtype of COST which applies to EMPLOYEE. For example, salary and bonus for EMPLOYEE.

EMPLOYEE DESIGNATION

Reference

Designation (job title) of an EMPLOYEE.

EMPLOYEE DISCOUNT GROUP

Reference

Employee discount eligibility classifications.

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

Reference

Association between an EMPLOYEE and an EMPLOYEE DISCOUNT GROUP, which makes the EMPLOYEE eligible for the price reductions available to the discount group.

EMPLOYEE DISCOUNTED SALES HISTORY

Base

History of DISCOUNT LINE ITEM where discount type is "EMPLOYEE".

EMPLOYEE JOB ROLE ASSIGNMENT

Base

Cross-references of the job roles present in the organization with the employees assigned to the job roles. EMPLOYEEs may have multiple roles.

EMPLOYEE LABOR DERIVED

Derived

Summary of employee labor in a day.

EMPLOYEE POSITION ASSIGNMENT

Base

Cross-references of the POSITIONs present in the ORGANIZATION with the EMPLOYEE assigned to the POSITION.

EMPLOYEE PUNCH

Base

Employee Schedule and Actual In and Out Times.

EMPLOYEE RESTRICTED INFORMATION

Reference

Confidential information regarding the EMPLOYEEs. For example:

  • Date of birth

  • National identifier

This information is encrypted.

EMPLOYEE SCHEDULE

Reference

Planned schedule for an EMPLOYEE, including the store, BUSINESS UNIT JOB ROLE, and shift for which the EMPLOYEE is scheduled to work.

EMPLOYEE SERVER ASSIGNMENT

Base

Association entity designating an EMPLOYEE as a SERVER.

EMPLOYEE TIME ACCRUAL HISTORY

Base

Work hours accrued during a given time period.

EMPLOYEE TIME ACCRUAL TYPE

Lookup

Lookup for work hour types.

EMPLOYEE TIME PUNCH ENTRY

Base

A record of a Worker commencing or completing a particular BUSINESS UNIT JOB ROLE or TASK.

EMPLOYEE TRAINING RECORD

Base

Record that a particular EMPLOYEE has been trained in performing a particular task or skill.

EMPLOYEE TYPE

Lookup

Lookup for types of EMPLOYEE. For example:

  • Part Time

  • Contractual

  • Full Time

EMPLOYEE WAGE PAYMENT DAY DERIVED

Derived

Daily summary of EMPLOYEE wage payment.

ENTRY METHOD

Lookup

Method used of entering transaction data. For example:

  • Entry Through Key

  • Entry Through Magnetic Ink Character Recognition

  • Entry Through MSR

  • Entry Through Scanning

  • Entry Through Smart Card

ENVIRONMENT TYPE

Lookup

Defines the temperature, relative humidity, lighting, and other physical or climatic environmental requirements for storing and displaying the item.

EQUIPMENT

Reference

A device that is used to conduct retail store operations. For example:

  • Workstation

  • FuelPump

  • TankGauge

  • TankProbe

EQUIPMENT ASSIGNMENT

Reference

Association entity between two instances of EQUIPMENT.

EQUIPMENT CLASS

Reference

A class of device used as an as interface to any store business function. All instances of the class have a common manufacturer, service provider and supplier. Class instances are currently:

  • Workstation

  • FuelPump

  • TankGauge

  • TankProbe

EQUIPMENT STATISTICS READING

Supertype

A set of performance statistics that have been taken from a piece of EQUIPMENT connected to a STORE WORKSTATION.

EQUIPMENT TYPE

Lookup

Lookup for types of EQUIPMENT.

EVENT

Base

Events provide retailer's with an umbrella to consolidate and coordinate related marketing and promotion tactics into a cohesive strategy. Events vary by retail segment, with store sales popular in apparel while weekly discounts (or TPR's) are more common in grocery. The event ensures that the costs and results of disparate marketing and promotional activity can be analyzed and compared against other event strategies as a single entity. Events are comprised of promotions and are communicated using campaigns.

EVENT COST

Base

Subtype of COST, which is specifically related to a given EVENT. This cost is usually for a non-network event such as an interaction with a customer. For example, for on-site maintenance after a service issue or a break-down.

EVENT PARTY INTERACTION PARTICIPATION

Base

Tracks multiple employees who participate in the same interaction with a CUSTOMER or a VENDOR.

EVENT TYPE

Lookup

Type of event in an Impression.

EXCHANGE RATE CURRENCY DAY

Base

Daily exchange rates for specific currencies in different locations.

EXPENSE TYPE

Lookup

Lookup for types of Expenses.

EXTERNAL DEPOSITORY

Reference

A bank or other institution that accepts periodic deposits of TENDER from the ORGANIZATION STORE.

EXTERNAL DEPOSITORY SETTLEMENT TRANSACTION

Base

A subtype of CONTROL TRANSACTION that records the closing balances for the TILL TENDER HISTORY. This is associated with the cash count of the deposit made to an external repository.

EXTERNAL DEPOSITORY TENDER HISTORY

Base

A record of the CONTROL TRANSACTIONs that lists the deposit of TENDER in the EXTERNAL DEPOSITORY by the store.

FABRIC

Lookup

The fabric attribute of SKU ITEM.

FACTOR COMPANY

Reference

Information about the factor company.

FIBER

Lookup

The fiber attribute of SKU ITEM.

FISCAL HALF MONTH

Reference

Half-month level in the fiscal calendar.

FISCAL HALF YEAR

Reference

Half-year level in the fiscal calendar.

FISCAL MONTH

Reference

Month level in the fiscal calendar.

FISCAL PRINTER EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a fiscal printer connected to a STORE WORKSTATION.

FISCAL QUARTER

Reference

Quarter level in the fiscal calendar.

FISCAL WEEK

Reference

Week level in the fiscal calendar.

FISCAL YEAR

Reference

Year level in the fiscal calendar.

FLEET MANAGEMENT

Base

Vehicle, Driver and other fleet management data that is collected as part of the process of tendering a transaction, that includes the sale of a FUEL ITEM, with a CUSTOMER ACCOUNT.

FOOD SERVICE LINE ITEM

Base

A sub-type of RETAIL SALE RETURN LINE ITEM recording how the Item being sold is to be processed in the food services environment.

FOOD SERVICE TABLE

Reference

Physical tables in a food service area.

FOOD SERVICE TRANSACTION

Base

A sub-type of RETAIL TRANSACTION specifically for the food service segment of the retail industry. Use to record FOOD SERVICE TABLE, SERVER, and so on.

FOOD STAMPS TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records details of TENDER CLASS food stamps that were tendered as part of the transaction.

FORECOURT SETTLEMENT TRANSACTION

Base

A special kind of forecourt transaction that causes the system to do the following:

  1. Perform an automatic PHYSICAL COUNT DOCUMENT of the tank Locations using TANK LEVEL GAUGE equipment.

  2. Take a set of Sales or TANK READINGs.

  3. Close-off the set of open NOZZLE HISTORY records.

FORECOURT TRANSACTION

Base

A type of transaction that records the clearing of FUELING TRANSACTIONs without accepting money for them by an operator at a workstation.

FRANCHISEE

Reference

A Person or separate legal entity which conducts retail operations for the retail enterprise in some geographical location. Such operations are governed by a franchise agreement.

FREIGHT DOCUMENT

Base

A carrier-originated document that lists the number of containers, for example, pallets, cartons, and so on, that were delivered to the store. The freight bill does not reference the inner contents of a shipment.

FUEL ITEM

Reference

A sub-type of SKU ITEM for Petroleum products such as Petrol, Gas, Diesel and Kerosene. A fuel item is purchased in bulk and blended, measured, and dispensed by a FUELING POINT.

FUEL ITEM PRICE

Base

A sparse array allowing combinations of Time, Service Type, Price Type and FUELING POINT affect the current retail price of an ITEM. The available set of valid prices for all ITEMs dispensed by a FUELING POINT are downloaded into theFUELING POINT, this entity provides a mapping from all the parameters to the set of available prices.

FUEL PUMP

Reference

The piece of EQUIPMENT on the forecourt that houses one or more FUELING POINTs.

FUEL SALE STATUS

Lookup

Lookup for status codes that may be applied to a FUEL SALES LINE ITEM.

FUEL SALES LINE ITEM

Base

A sub-type of RETAIL SALE RETURN LINE ITEM recording the collection of money in return for the fuel dispensed by a FUELING TRANSACTION.

FUELING POINT

Reference

A device that delivers fuel.

FUELING TRANSACTION

Base

An auditing event, recording a particular NOZZLE completing a delivery of fuel.

FULFILLMENT ACKNOWLEDGMENT LINE ITEM

Base

A component of a FULFILLMENT ACKNOWLEDGMENT TRANSACTION recording the fact that the CUSTOMER has received a particular SKU ITEM that was to be delivered or picked up.

FULFILLMENT ACKNOWLEDGMENT TRANSACTION

Base

A type of INVENTORY CONTROL DOCUMENT that records the fact that the CUSTOMER has received the merchandise that was to be delivered or picked up.

FUNCTION CODE

Lookup

Lookup for INVENTORY LOCATION function codes.

FUND RECEIPT TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the receipt of TENDER into a Till (with an offsetting miscellaneous income).


Table 2-58 G-N Entity Descriptions

Entity Name Type Description

GENDER

Lookup

Lookup for gender.

GEOGRAPHY CITY

Reference

Cities defined in a Geography.

GEOGRAPHY COUNTRY

Reference

Countries defined in a Geography.

GEOGRAPHY COUNTY

Reference

Counties defined in a Geography.

GEOGRAPHY DEMOGRAPHIC GROUP

Reference

User defined classifications for Demographic attributes, such as:

  • Race

  • Age

  • Income

GEOGRAPHY DEMOGRAPHY ATTRIBUTES

Reference

User defined classifications for a demographic profile group. For example:

  • Percent White

  • Percent Black

  • Average Age

  • Average Income

  • Population

  • Population Age 0-12

GEOGRAPHY DEMOGRAPHY VALUE

Reference

Values associated with a geographic location as defined by the GEOGRAPHY DEMOGRAPHY ATTRIBUTES.

GEOGRAPHY ENTITY

Reference

Geographic entities to define the location of an address. For example:

  • Region

  • North

  • State

  • Country

  • City

  • Geography

  • EMEA

  • Americas

GEOGRAPHY HIERARCHY

Reference

Type of geographic hierarchy. For example:

  • Sales Hierarchy

  • Organization Location Hierarchy

GEOGRAPHY HIERARCHY LEVEL

Reference

Associative entity for GEOGRAPHY HIERARCHY and GEOGRAPHY LEVEL, mapping levels to hierarchies.

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

Reference

Assignment of a GEOGRAPHY HIERARCHY LEVEL to a GEOGRAPHY ENTITY; assigns geography values to hierarchy levels.

GEOGRAPHY HIERARCHY VERSION

Reference

Version table for the hierarchies.

GEOGRAPHY LEVEL

Reference

User defined Hierarchical levels for the GEOGRAPHY HIERARCHYs.

GEOGRAPHY LEVEL ATTRIBUTE VALUE

Reference

Values as defined by geography level attributes for a GEOGRAPHY HIERARCHY LEVEL.

GEOGRAPHY LEVEL ATTRIBUTES

Reference

User defined attributes associated with a specific GEOGRAPHY LEVEL.

GEOGRAPHY REGION

Reference

Defines a region in a Geography.

GEOGRAPHY STATE

Reference

Defines a state in a Geography.

GEOGRAPHY SUB REGION

Reference

Defines a subregion in a Geography.

GEOGRAPHY WORLD

Reference

Top level of Geography.

GIFT CERTIFICATE CLASS

Reference

Defines a class of gift certificates and establishes the business rules governing their issuance and redemption.

GIFT CERTIFICATE TYPE

Lookup

Lookups to Identify a gift certificate types.

GL ACCOUNT

Reference

Financial Ledger Account.

GL ACCOUNT ASSIGNMENT

Reference

Defines the relationship between two GL ACCOUNT to form an Account Hierarchy. The GL Account Assignment stores lists of the detail accounts associated with each summary account.

GL ACCOUNT ASSIGNMENT TYPE

Lookup

Association classification of types of GL ACCOUNT. For example:

  • Parent

  • Child

GL ACCOUNT TYPE

Lookup

GL ACCOUNT type. For example:

  • Asset

  • Liability

  • Equity

GL BALANCE

Base

The GL Balance stores actual, budget, and encumbrance balances for detail and summary accounts.

GL COST CENTER SEGMENT

Reference

Account Segment representing a COST CENTER.

GL JE LINE SUBLEDGER ASSIGNMENT

Base

Assignment entity between a Journal Entry Header and Subledger header.

GL JOURNAL ENTRY

Base

Financial Ledger Journal Entry.

GL JOURNAL ENTRY BATCH

Base

A method used to group journal entries according to your set of books and accounting period.

GL JOURNAL ENTRY CATEGORY

Reference

A category that indicates the purpose or nature of your journal entry.

GL JOURNAL ENTRY LINE

Base

Each journal entry header contains one or more journal entry lines. The lines are the actual journal entries that your general ledger posts to update account balances.

GL LEDGER

Reference

The accounting system which tracks the journal entries that affect each account.

GL LEDGER ACCOUNT ASSIGNMENT

Reference

Assign the GL ACCOUNTs to Ledgers to form the Chart Of Account (COA).

GL ORG BSNS UNIT SEGMENT

Reference

Account Segment representing an ORGANIZATION BUSINESS UNIT.

GL PERIOD

Reference

The GL period stores information about the accounting periods. Each row includes the start date and end date of the period, the period type, the fiscal year, the period number, and other information.

GL PRODUCT SEGMENT

Reference

Account segment representing a product.

GL PROJECT SEGMENT

Reference

Account segment representing a project.

GL SEGMENT

Reference

Each GL ACCOUNT consists of a few independent segments, which are determined by Financial System setup.

Each GL ACCOUNT may be linked (rolled up) to a specific business entity (Concept), such as ORGANIZATION BUSINESS UNIT, PROJECT, and so on, through the subentities of GL Segment.

GL SEGMENT TYPE

Lookup

Type of GL SEGMENT. For example:

  • Project

  • Account

GL SUBLEDGER

Reference

Stores information that depend on the application. It includes a row for each application, who may feed financial journal entries into GL application.

GL SUBLEDGER JOURNAL ENTRY

Base

Stores subledger journal entries.

GL SUBLEDGER JOURNAL ENTRY LINE

Base

Each GL SUBLEDGER JOURNAL ENTRY contains one or more line items.

GROUP SELECT

Reference

SKU ITEM that is part of a group of SKU ITEMs, only one of which is sold. The choice of which item is made by the customer at the time of purchase.

HALF HOUR

Reference

Half hour as defined in TIME OF DAY.

HALF MONTH TODATE TRANSFORMATION

Reference

Cumulative time transformations at the half-month level.

HALF MONTH TRANSFORMATION

Reference

Transformation for a half month such as this half month last year or this year last half month.

HALF YEAR TODATE TRANSFORMATION

Reference

Cumulative time transformations at the half-year level.

HALF YEAR TRANSFORMATION

Reference

Time transformations at the half-year level.

HAZARDOUS MATERIAL TYPE

Lookup

Defines the relevant hazardous material handling properties of the item. The code is provided for oil products, pesticides, swimming pool suppliers, or fertilizers (especially bomb grade).

HOUR

Reference

Hour as defined in TIME OF DAY.

HOURS TYPE

Lookup

Lookup for types of work time detailed in EMPLOYEE ACTUAL LABOR DETAIL. For example:

  • Regular

  • Overtime

HOUSEHOLD

Reference

Household statistics and demographic information.

ICD ALLOWANCE LINE ITEM

Base

A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records allowances applicable to the whole INVENTORY CONTROL DOCUMENT.

ICD ASSIGNMENT REASON

Lookup

Lookup for valid INVENTORY CONTROL DOCUMENT ASSIGNMENT reasons.

ICD ASSIGNMENT TYPE

Lookup

Lookup for valid INVENTORY CONTROL DOCUMENT ASSIGNMENT types.

ICD CHARGE LINE ITEM

Base

A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records charges applicable to the whole INVENTORY CONTROL DOCUMENT.

ICD FREIGHT LINE ITEM

Base

A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records the type and amount of freight cost incurred on an INVENTORY CONTROL DOCUMENT.

ICD LINE ITEM ASSIGNMENT

Base

Associative entity between two INVENTORY CONTROL DOCUMENT LINE ITEMs.

ICD MERCHANDISE LINE ITEM MODIFIER

Base

A modifier that applies an allowance or a charge to a single line item on an INVENTORY CONTROL DOCUMENT LINE ITEM of type 'MERCHANDISE'.

ICD MERCHANDISE TAX LINE ITEM

Base

A Line Item to record taxation implications of a single INVENTORY CONTROL DOCUMENT LINE ITEM rather than an entire INVENTORY CONTROL DOCUMENT.

ICD TAX EXEMPTION MODIFIER

Base

A line item modifier to the ICD TAX LINE ITEM that provides supplementary data regarding tax exemptions that have been applied.

ICD TAX LINE ITEM

Base

A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records sales, use, and value added taxes applicable to the whole INVENTORY CONTROL DOCUMENT.

IMPRESSION

Base

Details collected when a user access a web page.

IMPRESSION EVENT TYPE

Lookup

Lookup for types of details collected when a user accesses a web page.

INDIVIDUAL DEMOGRAPHY VALUE

Reference

The demographic values for individual customer and customer household.

INGREDIENT

Reference

A raw material component of a RECIPE.

INGREDIENT OPTION

Reference

Alternate raw materials that may be used for an INGREDIENT in a RECIPE.

INTERACTION CHANNEL

Lookup

Channel used during a PARTY INTERACTION EVENT.

INTERACTION CHANNEL TYPE

Lookup

Lookup for available INTERACTION CHANNELs. For example:

  • Call center

  • Store

  • Website

INTERACTION DIRECTION

Lookup

Lookup for available directions for initiatives. For example:

  • Inbound

  • Outbound

INTERACTION REASON

Lookup

Lookup for interaction reasons. For example:

  • Debt collection

  • Service call

  • Inbound marketing

  • Outbound marketing

  • Customer complaints

INTERACTION RESULT TYPE

Lookup

Lookup for possible responses to customer interaction. For example:

  • Showed interest without decision

  • Offer accepted

  • Never call again

INTERACTION STATUS

Lookup

Lookup for available interaction status. For example:

  • Planned

  • In-progress

  • Executed

  • Closed

INTERACTION THREAD STATUS

Lookup

The Status of PARTY INTERACTION THREAD. For example:

  • Closed

  • Waiting for Material

  • Processing

INTERACTION TYPE

Lookup

Lookup for types of PARTY INTERACTION EVENTs. For example:

  • Inquiry

  • Complaint

  • Catalog Request

INVENTORY ACCOUNTING METHOD

Lookup

Lookup for the inventory accounting method to be used for the item. For example:

  • Retail method

  • Cost method

INVENTORY ADJUSTMENT DOCUMENT

Base

A document that captures an increment or decrement to an item's unit on hand count and or financial valuation.

INVENTORY ADJUSTMENT DOCUMENT LINE ITEM

Base

The detail line item on the INVENTORY ADJUSTMENT DOCUMENT which applies an increment or decrement to the ITEM's unit on hand and or the financial valuation.

INVENTORY ADJUSTMENT ITEM DAY DERIVED

Derived

Inventory adjustment information at the item, ORGANIZATION BUSINESS UNIT, day-reason level.

INVENTORY CONDITION

Lookup

A reference entity type that defines permissible inventory conditions. For example:

  • Damaged

  • Shorted

An inventory condition applies to inbound, stored and outbound merchandise and is important in establishing the value of that merchandise.

INVENTORY CONTROL DOCUMENT

Base

A written or printed paper, or digital equivalent, that evidences the movement of merchandise or supply SKU ITEMs.

INVENTORY CONTROL DOCUMENT ASSIGNMENT

Base

Assignment entity between INVENTORY CONTROL DOCUMENTs.

INVENTORY CONTROL DOCUMENT LINE ITEM

Base

Detail line on an INVENTORY CONTROL DOCUMENT that identifies the SKU ITEM, and unit of measure exchanged, or the freight, charges, taxes, and allowances applicable to a particular inventory control event and action.

INVENTORY CONTROL DOCUMENT LINE ITEM TYPE

Lookup

Lookup for INVENTORY CONTROL DOCUMENT LINE ITEM types.

INVENTORY DOCUMENT TYPE

Lookup

Lookup for INVENTORY CONTROL DOCUMENT types.

INVENTORY ITEM STATE

Base

Location of SKU ITEMs in inventory by ORGANIZATION BUSINESS UNIT, SELLING LOCATION, INVENTORY LOCATION, by date.

INVENTORY LOCATION

Reference

Physical location where the retailer stores merchandise. INVENTORY LOCATION may be colocated at a SITE with ORGANIZATION STORE, ORGANIZATION DISTRIBUTION CENTER, or ADMINISTRATION CENTER and does not include containers, ships and trucks that are in transit.

INVENTORY LOCATION TYPE

Lookup

Lookup for code that describes what business activities and functions are performed in a specific location. For example, for an INVENTORY LOCATION:

  • DISPLY for display

  • CUSTSVC for customer service

  • RETADJ for returns and adjustments

  • STOCKPT for stock point

  • RECV for receiving

INVENTORY POSITION DEPT DAY AGGR

Aggregate

Daily status and value of Inventory. For example:

INVENTORY POSITION ITEM DAY DERIVED

Derived

Status and value of Inventory. For example:

INVENTORY POSITION SUBCLASS MONTH AGGR

Aggregate

Daily status and value of Inventory. For example:

INVENTORY RECEIPT ITEM DAY DERIVED

Derived

Daily record of inventory receipts by ITEM and ORGANIZATION BUSINESS UNIT.

INVENTORY RECEIPT SUBCLASS WEEK AGGR

Aggregate

Weekly record of inventory receipts by subclass and ORGANIZATION BUSINESS UNIT.

INVENTORY SPACE ALLOCATION

Base

Allocation of INVENTORY LOCATION for SKU ITEMs during a given time frame. Allocation does not indicate inventory levels or existence of SKU ITEMs in the INVENTORY LOCATION.

INVENTORY STATE

Lookup

Defines a state that SKU ITEMs are kept in the retail enterprise item inventory records. For example:

  • On Hand

  • On Order

  • On Layaway

  • Damaged

  • To Be Returned

INVENTORY STATUS

Lookup

Status of the inventory. For example:

  • Work-in-progress

  • Manufactured

  • Finished

INVENTORY TRANSFER ITEM DAY DERIVED

Derived

Daily summary of transfer in and transfer out document statistics. Provides a daily summary of inventory transfers at the ITEM, to ORGANIZATION BUSINESS UNIT, from ORGANIZATION BUSINESS UNIT, and transfer type.

Daily summary of transfer in and transfer out document statistics summary of transfer in and transfer out document statistics.

INVENTORY TYPE

Lookup

Type of Inventory. For example:

  • Damaged

  • Customer Order

INVENTORY UNAVAILABLE ITEM DAY DERIVED

Derived

SKU ITEMs in inventory that are not available to sell during the given time period. This could be due to damage, spoilage, or because the items are reserved for a future PROMOTION or to fulfill a CUSTOMER ORDER.

INVENTORY VENDOR COMPLIANCE DAY DERIVED

Derived

Daily summary of Vendors' Inventory Compliance.

ISSUE TYPE

Lookup

How the certificate or voucher was issued by the ORGANIZATION BUSINESS UNIT. For example: Embossed and Printed.

A code to denote how the ORGANIZATION STORE issues CERTIFICATEs, for example, embossed or printed at the point of sale.

ITEM

Reference

A level in a product hierarchy frequently used for business analysis. An item can be a group of Stock Keeping Units (SKU)s where each SKU is the same item but varies in size, weight, color, or other attributes. Item is sometimes referred to as Article.

Product, article or bundle of SKUs. For example, Item could be Acme shirt, with associated SKUs for each color and size of the shirt.

ITEM CLASS

Reference

Fifth level in item hierarchy below ITEM DEPARTMENT. Item class consists of one or more item subclasses.

ITEM CLUSTER

Reference

Grouping of items based on common characteristics.

ITEM CLUSTER CUSTOMER ASSIGNMENT

Reference

Association entity of CUSTOMER to ITEM CLUSTER based on CUSTOMER buying patterns.

ITEM CLUSTER TYPE

Lookup

Lookup for Types of ITEM CLUSTERs.

ITEM COMPANY

Reference

Top level of the ITEM merchandise hierarchy.

ITEM DEPARTMENT

Reference

Fourth level in item hierarchy below ITEM GROUP. Item department consists of one or more item classes.

ITEM DIVISION

Reference

Second level in item hierarchy below ITEM COMPANY. Item Division consists of one or more ITEM GROUPs.

ITEM ELECTRONIC LABEL

Reference

A type of ITEM LABEL that defines the properties of the electronic shelf labels used to present the current retail price to customers. Electronic labels are small liquid crystal screens, attached to the front of the display shelf or unit, which convey the current selling price and other information regarding the SKU ITEM to the CUSTOMER or EMPLOYEE. These labels are electronically linked to the store processor. In this way any amendments to the ITEM can be transmitted to the shelf label at the same time they take effect. This facility ensures that ITEM details and prices on the shelf and store processor are synchronized.

ITEM GROUP

Reference

Third level in item hierarchy, below ITEM DIVISION. Item Group consists of one or more ITEM DEPARTMENTs.

ITEM HIERARCHY

Reference

Names and descriptions for the user defined item hierarchy.

ITEM HIERARCHY LEVEL

Reference

User defined. Hierarchy level name and description.

ITEM HIERARCHY LEVEL ASSIGNMENT

Reference

Associative entity for PRODUCT ENTITY and ITEM HIERARCHY LEVEL; maps parents to children in a hierarchy.

ITEM HIERARCHY VERSION

Reference

Version of the hierarchy.

ITEM INVENTORY JOURNAL ENTRY

Base

The record of a change in an Item Inventory holding that is applied to an Item Inventory account.

ITEM LABEL

Reference

A means of conveying information about an SKU ITEM to the CUSTOMER and or EMPLOYEE. This information is available on or adjacent to the ITEM. The item label may be in the form of an item tag or paper or electronic shelf label.

ITEM LEVEL

Reference

Name and description for User Defined Item Levels.

ITEM LEVEL ATTRIBUTE

Reference

User Defined Attributes associated with an ITEM HIERARCHY LEVEL.

ITEM LEVEL ATTRIBUTE VALUE

Reference

Values for User Defined Attributes of an ITEM LEVEL in the user defined hierarchy.

ITEM LOOKUP METHOD

Lookup

Method by which the SKU ITEM SELLING PRICE was retrieved and entered into the Point of Sale system during a RETAIL SALE RETURN LINE ITEM transaction.

ITEM MARKET DATA

Reference

List of Market Items. Market items refer to the flow of goods through distribution channels authorized by the manufacturer or producer.

Item in Market with descriptive information that may be purchased through external entities.

ITEM PRICE DERIVATION RULE

Reference

A type of PRICE DERIVATION RULE that modifies the retail sale unit price amount for an item as read from the PLU and results in a new retail sale unit price that is presented to the customer and or used as the new base for compounding price changes. This rule affects prices of the items that triggered the eligibility.

ITEM SALES PROHIBITION PERIOD RULE

Reference

A rule that identifies specific days of the week and or special dates and time periods during which the sale of an ITEM is prohibited.

ITEM SEASON

Reference

Associative entity for ITEM, SEASON, and PHASE.

ITEM SELLING RULE

Reference

A set of commonly used selling rules for ITEMs. The entity is typically in a one-to-one relationship with ITEM, unless each combination of size, color, and style of a particular piece of merchandise is individually assigned to a SKU for inventory recording purposes, but all sizes, colors, and styles of that item have the same selling rules.

ITEM SHELF LABEL

Reference

A type of ITEM LABEL that provides a means of conveying information about a SKU ITEM to the CUSTOMER, EMPLOYEE, or both. The label is sited adjacent to the item, usually in front of the merchandise where the customer can easily see it. Subtype of ITEM LABEL.

ITEM SPIFF RULE

Reference

Rule or condition associated with an ITEM applied when a Sales Performance Incentive Factor Formula (SPIFF) is awarded to a salesperson.

ITEM STATE

Lookup

Lookup for the state of the item. This code defines the current state of an item within the ORGANIZATION STORE. The item state limits what actions may be taken on an item in terms of ordering, receiving, selling, returns, transfers, and counting. For example:

  • Sent to Quality Checked

  • Item Return from Quality Checked

  • Item Passed Quality Checked

  • Damaged Item

  • Active

  • Inactive

  • Discontinued

  • Pending

ITEM SUBCLASS

Reference

The sixth level in item hierarchy, below ITEM CLASS. Item Subclass consists of one or more ITEMs.

ITEM SUBDEPARTMENT

Reference

Item SubDepartment within a Department in the Product hierarchy at a given of time.

ITEM TENDER RESTRICTION GROUP

Reference

A collection of ITEMs which share a common restriction on the which tenders may be used to pay for them at a store.

ITEM TENDER RESTRICTION RULE

Reference

An association between ITEM TENDER RESTRICTION GROUP and TENDER which constrains the use of a specific type of tender in the settlement of a sale for a specific ITEM.

ITEM TICKET

Reference

A type of ITEM LABEL that provides a means of conveying information about an SKU ITEM to the CUSTOMER or EMPLOYEE. The item ticket typically takes the form of either as an adhesive ticket or hanging tag.

JOB ALLOCATION

Base

The allotment of Jobs that have been approved for a specific WORK LOCATION (ORGANIZATION STORE, ADMINISTRATION CENTER, ORGANIZATION DISTRIBUTION CENTER, SELLING LOCATION, SITE).

JOB ROLES

Lookup

Job roles within the retail organization.

JOB TASK SET

Reference

An association grouping a particular TASK SET to a particular JOB ROLES.

KEY LOCK EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a key lock connected to a STORE WORKSTATION.

KNOWN SOURCE TYPE

Lookup

Lookup for known sources from which a food service RESERVATION could by made.

LABEL TYPE

Lookup

Lookup for ITEM LABEL types.

LANGUAGE

Lookup

Languages spoken or written within the company or in interactions with CUSTOMERs.

LETTER TYPE

Lookup

Lookup for available types of letters that may be sent to CUSTOMERs. For example:

  • Direct marketing

  • Legal letter

  • Contract confirmation letter (Welcome)

LIABILITY DAY DERIVED

Derived

Summary Liability by Day.

LIABILITY MONTH AGGR

Aggregate

Summary Liability by Month.

LIABILITY TYPE

Lookup

Lookup for Liability Types.

LICENSE SALES RESTRICTION

Reference

A restriction or limitation on the sales of a class of items based on the profession or license or other certification of the purchaser.

LIFECYCLE TYPE

Lookup

Type codes for CUSTOMER lifecycle.

LINE DISPLAY EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a line display connected to a STORE WORKSTATION.

LOCAL AUTHORITY TYPE

Lookup

Lookup for type of Local Authority. For example:

  • City

  • State

  • County

LOCAL TAX AUTHORITY

Reference

Government authority that levies sales taxes or imposes rules or statutory compliance.

LOCATION

Super (no table)

A physical place the retailer conducts business. It may be any or all of the defined sub-types: WORK LOCATION, SELLING LOCATION, INVENTORY LOCATION.

LOCATION TYPE

Lookup

Lookup for type of LOCATION. For example:

  • Work location

  • Inventory location

  • Selling location

LOYALTY AWARD

Reference

Identifies a reward that a customer received for meeting the requirements of a promotion. For example: a premium gift when a customer has purchased a certain amount during a promotion.

LOYALTY PROGRAM

Reference

Loyalty programs available to which customers may be members of.

LOYALTY REWARD LINE ITEM

Base

A RETAIL TRANSACTION LINE ITEM sub-type that records the crediting of a MEMBERSHIP ACCOUNT (customer loyalty account) with points, or the gifting of an Item or CERTIFICATE to a to that account because of some PROMOTION.

MANUFACTURER

Reference

The PARTY that manufactures the ITEM.

MANUFACTURER BRAND

Reference

An associative (many-to-many) entity that links MANUFACTURER and BRAND. Brands, such as private label merchandise, can be produced by different MANUFACTURERs and a MANUFACTURER can produce different BRANDs.

MANUFACTURER COST

Base

Subtype of COST indicating a MANUFACTURER COST.

MANUFACTURER COUPON FAMILY

Reference

Defines code assigned by the manufacturer to classify product for promotion purposes. A unique code assigned by the manufacturer to classify product for promotion purposes. In the ARTS model it is used to validate manufacturers' coupons. For example:

  • Raincheck Coupon

  • Manufacturer Coupon

  • Electronic Coupon

MANUFACTURER INVENTORY ITEM STATE

Base

Manufacturer entity: Location of SKU ITEMs in inventory by ORGANIZATION BUSINESS UNIT, SELLING LOCATION, INVENTORY LOCATION, by date. In this entity, there could be multiple retail organizations and within them multiple inventory locations, or the Location could be in the Manufacturer's facility.

MANUFACTURER ITEM CLASS

Reference

Manufacturer entity: Fourth level in manufacturer item hierarchy below MANUFACTURER ITEM GROUP. Item class consists of one or more MANUFACTURER ITEM SUBCLASSes.

MANUFACTURER ITEM COMPANY

Reference

Manufacturer entity: Top level of the manufacturer item hierarchy.

MANUFACTURER ITEM DIVISION

Reference

Manufacturer entity: Second level in manufacturer item hierarchy below MANUFACTURER ITEM COMPANY. Item class consists of one or more MANUFACTURER ITEM GROUPs.

MANUFACTURER ITEM GROUP

Reference

Manufacturer entity: Third in manufacturer item hierarchy below MANUFACTURER ITEM DIVISION. Item class consists of one or more MANUFACTURER ITEM CLASSes.

MANUFACTURER ITEM RETAILER ASSIGNMENT

Reference

Manufacturer entity: Assignment entity between MANUFACTURER and RETAILER Organization Business Unit with pack unit count breakdown.

MANUFACTURER ITEM SUBCLASS

Reference

Manufacturer entity: First level in manufacturer item hierarchy below MANUFACTURER ITEM CLASS. Item class consists of one or more MANUFACTURER SKU ITEMs.

MANUFACTURER ORGANIZATION COMPETITOR ASSIGNMENT

Reference

Manufacturer entity: Assignment entity between MANUFACTURER and COMPETITOR.

MANUFACTURER RETAILER ITEM ASSIGNMENT

Reference

Manufacturer entity: An optional relationship between MANUFACTURER and MANUFACTURER SKU ITEM, and RETAILER and Business Unit (ORGANIZATION BUSINESS UNIT) and Retailer SKU ITEM.

MANUFACTURER SKU ITEM

Reference

Manufacturer entity: Stock Keeping Unit or unit identification, typically the UPC or GTIN, that tracks manufacturer inventory and sales. Each SKU is associated with an item, variant, product line, bundle, service, fee, or attachment.

MANUFACTURER SKU ITEM BUSINESS UNIT ASSIGNMENT

Reference

Manufacturer entity: Assignment entity to assign MANUFACTURER SKU ITEMs to RETAILER business units that carry the items.

MANUFACTURER SKU ITEM COLLECTION

Reference

Manufacturer entity: An optional relationship between a MANUFACTURER SKU ITEM and its components and affiliates where the components consist of other MANUFACTURER SKU ITEMs.

MANUFACTURER SKU ITEM SELLING PRICE

Reference

Manufacturer entity: The set of prices that are applied to an MANUFACTURER SKU ITEM.

MANUFACTURER SKU ITEM SELLING PRICE HISTORY

Base

Manufacturer entity: Historical archive of the manufacturer selling unit price at which a given MANUFACTURER SKU ITEM was actually sold at POS, net of markdowns, markups and other changes that modify the cumulative mark on for an MANUFACTURER SKU ITEM.

MANUFACTURER SKU ITEM SHELF ATTRIBUTES

Reference

Manufacturer entity: Shelf requirements for an SKU ITEM.

MANUFACTURER SKU ITEM VARIETY ASSIGNMENT

Reference

Manufacturer entity: Assignment entity between MANUFACTURER SKU ITEM and MANUFACTURER VARIETY.

MANUFACTURER STOCK

Reference

Manufacturer entity: Subtype of MANUFACTURER SKU ITEM. Unit of merchandise sold to a RETAILER. For example:

  • Display Unit Item

  • Shelf Item

  • Apparel Item

  • Bulk Item

MANUFACTURER TYPE

Lookup

Manufacturer entity: Lookup for type of MANUFACTURER.

MANUFACTURER VARIETY

Reference

User Defined MANUFACTURER SKU ITEM attributes other than size, weight, and style, such as color, associated with the MANUFACTURER SKU ITEM. Can have multiple varieties for an MANUFACTURER SKU ITEM.

MARITAL STATUS

Lookup

Lookup for marital status that may be assigned to an individual.

MARKET AREA

Reference

A geographic area for which resident geographic data is available. Market Area may or may not contain a store.

MARKET AREA LEVEL

Reference

Level of classification inside the market areas based on, Community, Geography or user defined criteria.

MARKET ITEM DEPARTMENT

Reference

A department or category grouping of items in the market.

MARKET ITEM DEPARTMENT ASSIGNMENT

Reference

Associative entity mapping item department with market item department.

MARKET SALES ITEM WEEK

Base

Sales information for market items obtained from external source.

MEDIA

Reference

Mass communication medium. PROMOTIONs are communicated through Media. For example:

  • New York Times

  • Boston Globe

  • CNN

  • BBC

MEDIA COST

Base

Subtype of the COST that collects all costs related to a specific media (Newspaper, Television spots, Fliers, and so on).

MEDIA DEPICTION ITEM ASSIGNMENT

Reference

Associative entity linking CAMPAIGN MESSAGE DEPICTION with PROMOTION SELLING ITEM.

MEDIA TYPE

Lookup

Lookup for the media type used to communicate with the CUSTOMER. For example:

  • Catalog

  • Internet

  • Postcard

  • TV

  • Radio

  • Newspaper

  • List

MEMBERSHIP ACCOUNT

Reference

A CUSTOMER ACCOUNT in a membership program such as a loyalty program.

MEMBERSHIP TYPE

Lookup

Lookup for types of MEMBERSHIP ACCOUNTs.

MICR EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a Magnetic Ink Character Reader (MICR) connected to a STORE WORKSTATION.

MINUTE

Reference

Minute level in Time of Day.

MISCELLANEOUS FEE LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records a fee added to the transaction net total and reflects a non-item income or reimbursable expense to the retailer.

MISCELLANEOUS LINE ITEM TYPE

Lookup

Type of miscellaneous line item. For example:

  • Customer Line item

  • Miscellaneous fees

MISSED SCHEDULE

Base

Daily record of VENDOR or CARRIER missed or incorrect deliveries.

MIX AND MATCH PRICE DERIVATION ITEM

Reference

Specifies matching items that may be used to trigger a MIX AND MATCH PRICE DERIVATION RULE. In situations like Buy item A and get items B, C or D at 50% off, items B, C and D would be the matching items. Item A would be the trigger item scanned in at the point of sale.

MIX AND MATCH PRICE DERIVATION RULE

Reference

A type of PRICE DERIVATION RULE that defines combinations of items and item counts that when purchased together result in a price revision (generally a reduction). A mix and match price derivation rule affects prices of items other than those that triggered the eligibility.

MONTH TODATE TRANSFORMATION

Reference

Cumulative time transformations at the month level. Defines related calendar elements for performing to-date time transformations.

MONTH TRANSFORMATION

Reference

Time transformations at the month level.

MOTION SENSOR EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a motion sensor (or traffic counter) connected to a STORE WORKSTATION.

MULTIPLE TENDER CLASS

Lookup

Lookup for multiple tender combinations. For example:

  • Cash and credit card

  • Cash and coupon

NATIONALITY

Lookup

Lookup for available nationalities.

NOZZLE

Reference

That part of the FUELING POINT that blends and measures the volume of fuel dispensed during a FUELING TRANSACTION.

NOZZLE HISTORY

Base

The total number, volume and monetary value of all FUELING TRANSACTIONs performed on a particular NOZZLE during a time period bounded by two consecutive FORECOURT SETTLEMENT TRANSACTION. Totals are separated by Prepay and Postpay FUELING TRANSACTION.


Table 2-59 O-S Entity Descriptions

Entity Name Type Description

OPERATING COST

Base

Subtype of COST indicating an operating cost.

OPERATING SYSTEM

Reference

Computer Operating System used by an AGENT.

ORDER

Base

Manufacturer entity: Order placed by a RETAILER for MANUFACTURER SKU ITEMs.

ORDER CATEGORY TYPE

Lookup

Lookup for types of CUSTOMER ORDER, PURCHASE ORDER, or ORDER.

ORDER DOCUMENT

Base

A type of INVENTORY CONTROL DOCUMENT that is a record of agreement made with a VENDOR that includes a detailed list of SKU ITEMs, cost discount terms, method of shipping, delivery dates, delivery location and other pertinent terms and conditions governing the acquisition.

ORDER LINE ITEM

Base

A line item component of an ORDER.

ORDER LINE ITEM STATE

Base

Describes the state of fulfillment of an ORDER LINE ITEM.

ORDER LINE ITEM STATE TYPE

Lookup

Lookup for types of ORDER LINE ITEM STATE.

ORDER LINE ITEM TYPE

Lookup

Lookup for types of ORDER LINE ITEMs.

ORDER SOURCE TYPE

Lookup

Description of the source for a CUSTOMER ORDER, PURCHASE ORDER, or ORDER. For example:

  • Call center

  • Workstation

  • Store

ORDER STATE

Lookup

Lookup for retailer assigned code denoting a potential state for a CUSTOMER ORDER, PURCHASE ORDER, or ORDER. For example:

  • Create

  • Delete Item

  • Add Item

  • Change Item

  • Partial Delivery

  • Delivery Complete

  • Partial Pickup

  • Pickup Complete

  • Allocated

  • Billed Complete

  • Booked Complete

  • Backorder

ORDER STATUS

Lookup

Lookup for the Order Status. For example:

  • Already Shipped

  • Delivered / Processed

  • Processing

  • Partially Delivered

ORDER STATUS TYPE

Lookup

Lookup to categorize ORDER STATUS into ORDER, PURCHASE ORDER, CUSTOMER ORDER status types.

ORDER TYPE

Lookup

A unique retailer assigned code denoting a type of CUSTOMER ORDER, PURCHASE ORDER, or ORDER. For example:

  • Layaway

  • Order for Delivery

  • Order for Pickup

ORG BSNS UNIT SUB REGION ASSIGNMENT

Reference

Assignment entity associating an ORGANIZATION BUSINESS UNIT to a geographical REGION and SUB REGION.

ORGANIZATION

Reference

A company, association, institution, or other enterprise of interest to a ORGANIZATION STORE including retail enterprise, or the retail organization itself.

ORGANIZATION AREA

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION CHAIN. The Organization Area entity is the parent of one or more ORGANIZATION REGION.

ORGANIZATION BANNER

Reference

The name of a retail company's subsidiary that is recognizable to the consumer or the name of the store as it appears on the catalog, web channel or brick and mortar store.

ORGANIZATION BUSINESS ENTITY

Reference

Any logical entity that is a part of the enterprise for Business Analysis and Transactions. Classification for a Business Entity can include company, operation unit, store, or warehouse.

ORGANIZATION BUSINESS UNIT

Reference

A business unit of the organization that sells, stores, or distributes merchandises and services through either a physical location (store), catalog, web page or other channel, distribution center, or warehouse.

Business unit at the lowest level of the retail organization where business is conducted. For example:

  • Organization Store: Fixed location from where goods and merchandise are sold for personal or household consumption.

  • Organization Warehouse: A place in which goods or merchandise are stored; a storehouse.

  • Organization Distribution Center: A distribution center for a set of products is a warehouse or other specialized building with refrigeration or air conditioning that are supplied by transport, such as aircraft, truck, rail or ship, and then re-distributed to stores or warehouses.

  • Organization Catalog: A publication, such as a book or pamphlet, containing list or itemized display of titles, or articles for exhibition or sale, usually including descriptive information or illustrations. For example, a catalog of fall fashions, or a seed catalog.

ORGANIZATION BUSINESS UNIT HOLIDAY

Reference

DAYs for which the ORGANIZATION BUSINESS UNIT considers holidays.

ORGANIZATION BUSINESS UNIT HOURS DAY DERIVED

Derived

Open, closing and cumulative open hours for an ORGANIZATION BUSINESS UNIT.

ORGANIZATION BUSINESS UNIT TRAFFIC

Base

Customer traffic details.

ORGANIZATION BUSINESS UNIT TRAFFIC DAY DERIVED

Derived

Daily summary of customer traffic information in an ORGANIZATION BUSINESS UNIT (customer traffic in count and customer traffic out count).

ORGANIZATION CATALOG

Reference

Publication, such as a book or pamphlet, containing list or itemized display of titles, or articles for exhibition or sale, usually including descriptive information or illustrations. For example, a catalog of fall fashions; a seed catalog.

ORGANIZATION CHAIN

Reference

Chain is the 2nd highest level within the organization hierarchy below company. A chain consists of one or more areas.

ORGANIZATION COMPANY

Reference

A level within an ORGANIZATION HIERARCHY LEVEL. Organization Company entity is the parent of one or more ORGANIZATION CHAINs.

ORGANIZATION COST

Base

Subtype of COST in which costs are attributed to an ORGANIZATION BUSINESS UNIT.

ORGANIZATION DEMOGRAPHY VALUE

Reference

Stores the Demographic information associated with the ORGANIZATION BUSINESS UNIT, as defined by the user defined demography groups and attributes. Examples:

  • Start date of Organization

  • Revenue band-Profit band

  • Product or Service Category

  • Head count

  • Number of offices or sites

ORGANIZATION DEPARTMENT

Reference

A specialized section within a ORGANIZATION BUSINESS UNIT.

ORGANIZATION DISTRIBUTION CENTER

Reference

A distribution center for a set of products or a warehouse or other specialized building with refrigeration or air conditioning, which are supplied by transport, such as aircraft, truck, rail or ship, and then re-distributed to retailers or wholesalers.

ORGANIZATION DISTRICT

Reference

District is the 5th highest attribute within the organization hierarchy, below Region. A district consists of one or ORGANIZATION BUSINESS UNITs.

ORGANIZATION DIVISION

Reference

An ORGANIZATION HIERARCHY LEVEL within ORGANIZATION COMPANY.

ORGANIZATION HIERARCHY

Reference

User defined. Master list of all of the hierarchies in an organization.

ORGANIZATION HIERARCHY LEVEL

Reference

Association table for the hierarchies and levels.

ORGANIZATION HIERARCHY VERSION

Reference

Version table for hierarchies.

ORGANIZATION LEVEL

Reference

List of all the business levels within an organization.

ORGANIZATION LEVEL ATTRIBUTE VALUE

Reference

Values for the user defined attributes associated with an organization hierarchy level.

ORGANIZATION LEVEL ATTRIBUTES

Reference

User defined. Attributes applicable only to the corresponding level in the organization. For example: Regional Language

ORGANIZATION LEVEL TYPE

Lookup

Lookup for type of ORGANIZATION LEVEL.

ORGANIZATION MARKET DATA

Reference

Publicly available and statistical information regarding the customer organizations, such as DUNS number and number of employees.

ORGANIZATION RECIPE ASSIGNMENT

Reference

Associates a RECIPE to an ORGANIZATION BUSINESS UNIT.

ORGANIZATION REGION

Reference

Region is the fourth highest attribute within the ORGANIZATION HIERARCHY, below ORGANIZATION AREA.

ORGANIZATION STORE

Reference

Business Unit with the retail organization from where goods and merchandise are sold for personal or household consumption.

Fixed location from where goods and merchandise are sold for personal or household consumption.

ORGANIZATION TYPE

Lookup

Defines the types of ORGANIZATION. For example:

  • Retailer

  • Manufacturer

ORGANIZATION WAREHOUSE

Reference

Location in which goods or merchandise are stored but not sold.

ORGANIZATION WEB STORE

Reference

A website owned or commissioned by the organization from where goods and merchandise are sold for personal or household consumption.

OTHER INDIVIDUAL

Reference

Individual associated with a PARTY organization, other than those defined such as CUSTOMER or EMPLOYEE.

PACKING SLIP

Base

A document that identifies the merchandise items a supplier claims to be shipping to the store against one or more PURCHASE ORDERs.

PAGE

Reference

Web page.

PAGE CATEGORY

Reference

Categorization of a PAGE.

PAGE CATEGORY LEVEL

Reference

Lookup for types of PAGE CATEGORY.

PARTY

Reference

A party is a real person, organization, branch, subsidiary, legal entity, holding company, or some other entity. Any real thing that you would want to name is a party. The attributes of a party are universal. In other words, they are independent of your selling, or ultimately buying relationship with the party.

A party is not necessarily a CUSTOMER. A party can represent PROSPECTs and parts of an ORGANIZATION HIERARCHY, including branches, head offices, corporate conglomerates that may not necessarily have a billing relationship with the company.

Any party that has an active account can be considered a CUSTOMER.

Historical information concerning the party is available in the Parties History.

PARTY ASSIGNMENT

Reference

Association of a PARTY with one or more other Parties. The relationships may include relationships between customers.

PARTY ASSIGNMENT REASON

Lookup

Lookup for valid reasons parties may be associated with each other. For example:

  • Cooptation (customer brings in a new customer)

  • Financial Responsibility

  • Hierarchical relationship in the organization

  • Contractual agreement

PARTY ASSIGNMENT TYPE

Lookup

Lookup for the type of the PARTY relationship. For example:

  • Father and son

  • Organizational hierarchy, subsidiary

  • Customer referral

PARTY CONTACT INFORMATION

Reference

Contact information for a PARTY.

PARTY CONTACT INFORMATION TYPE

Lookup

Lookup for the type of contact information. For example:

  • Email

  • Home telephone number

  • Office telephone number

  • Cell phone number

  • Pager number

PARTY DEMOGRAPHIC GROUP

Reference

A demographic profile for a PARTY.

PARTY DEMOGRAPHY ATTRIBUTE

Reference

A classification for a Party Profile Group. For example, for the profile group RACE:

  • Percent White

  • Percent Black

  • Percent Native American

  • Percent Pacific Islander/Asian

  • Percent Persons Of Hispanic Origin

  • Percent Asian Indian

  • Percent Japanese

  • Percent Chinese

  • Percent Filipino

  • Percent Korean

  • Percent Vietnamese

  • Percent Hawaiian

PARTY DEMOGRAPHY VALUE

Reference

Values corresponding to the DEMOGRAPHY ATTRIBUTE.

PARTY INTERACTION CALL EVENT

Base

Subtype of PARTY INTERACTION EVENT which represents all phone call interactions with the party with detailed information including:

PARTY INTERACTION EMAIL EVENT

Base

Subtype of PARTY INTERACTION EVENT which represents email interaction from the PARTY.

PARTY INTERACTION EVENT

Supertype (no physical table)

Records of interactions or communications with the CUSTOMER, VENDOR, or other contractor or other PARTY. The interactions include:

  • Direct mail, SMS, email

  • Service calls

  • Complaints

PARTY INTERACTION LETTER EVENT

Base

Subtype of PARTY INTERACTION EVENT which represents the interaction with the PARTY through letters.

PARTY INTERACTION THREAD

Base

Grouping of related contact events with a PARTY into a single thread.

PARTY INTERACTION THREAD EVENT ASSIGNMENT

Base

Assignment entity between PARTY INTERACTION THREADs.

PARTY INTERACTION THREAD STATUS HISTORY

Base

History of INTERACTION THREAD STATUS changes.

PARTY INTERACTION THREAD TYPE

Lookup

Lookup for the type of PARTY INTERACTION THREAD. For example:

  • Debt Collection

  • Retention Program

PARTY INTERACTION VISIT EVENT

Base

Subtype of PARTY INTERACTION EVENT which represents visits to a store by a PARTY.

PARTY STATUS CATEGORY

Lookup

Higher level of Party Status. For example:

  • Financial Status

  • Credit Status

  • Payment Status

  • Personal Status

  • Legal Status

PARTY STATUS CODE

Lookup

Lookup for available status codes that could be assigned to a PARTY.

PARTY STATUS HISTORY

Base

Defines current PARTY status history regarding what Operator may be interested.

Historical information captured for all lifetime of the CUSTOMER or dealer. This information may be calculated from internal data; for example, from a payment, or this information may be obtained from an external source such as a credit rating agency.

PARTY STATUS TYPE

Lookup

Lookup for types of PARTY STATUS CATEGORY.

PARTY TYPE

Lookup

Lookup for status type of the PARTY. For example:

  • Active

  • Inactive

  • Defaulted

  • New customer

  • VIP, Loyalty Program, customer

  • Black listed

Credit Class is used to rank Customer Credit. For example, the entity value can be:

  • Good

  • Fair

  • Bad

Or the customer may be defined as:

  • Gold

  • Silver

  • Bronze

The party's credit is based on the underlying accounts held by the PARTY.

PAY CATEGORY

Lookup

Lookup for pay categories present in the retail organization.

PAY DETAIL

Base

Payouts from payroll. For example:

  • Compensation amount to an employee under a payroll category and type

  • Contribution from the company toward the employee under the payroll category and type

PAY TYPE

Lookup

Further classification of PAY CATEGORY.

PAYABLE INVOICE

Base

Records invoices for payment.

PAYABLE INVOICE ITEM

Base

Details of the PAYABLE INVOICE including SKU ITEMs and prices.

PAYMENT ON ACCOUNT LINE ITEM

Base

Subtype of RETAIL TRANSACTION LINE ITEM in which TENDER is received from a CUSTOMER as payment on a CUSTOMER ACCOUNT.

PENALTY METHOD

Lookup

Lookup for applicable PENALTY METHODs that may be applied to a SERVICE SKU.

PERIOD CLOSE TRANSACTION

Base

Subtype of CONTROL TRANSACTION that declares the beginning of a Reporting Period at the ORGANIZATION BUSINESS UNIT where it is conducted. Reporting periods include Day Part, Shift, Business Day, Week, Month, Quarter and Year.

PERIOD OPEN TRANSACTION

Base

Subtype of CONTROL TRANSACTION that declares the end of a Reporting Period at the ORGANIZATION BUSINESS UNIT where it is conducted. Reporting periods include DayPart, Shift, BusinessDay, Week, Month, Quarter and Year.

PERIOD TODATE TRANSFORMATION

Reference

Cumulative time transformations at the period level.

PERIOD TRANSFORMATION

Reference

Time transformations at the period level.

PERIOD TYPE

Lookup

Lookup for period type that may be applied to a RENTAL SERVICE.

PERSONAL ID REQUIRED TYPE

Lookup

Lookup for types of personal identification required to authorize a tender. For example:

  • Drivers license

  • Second credit card

  • Social security card

PHASE

Reference

Period within a SEASON.

PHYSICAL COUNT DOCUMENT

Base

The document on which the actual SKU ITEM counts are recorded on the day of the Physical Inventory. This is raw and unedited data that is captured during the Inventory.

PHYSICAL COUNT DOCUMENT LINE ITEM

Base

The line detail which records the number of units counted during the Physical Inventory. This is raw and unedited data captured and will compared to the book stock to determine the actual unit and financial discrepancy for that ITEM.

PHYSICAL INVENTORY EVENT

Base

An EVENT at which time a physical inventory will be conducted.

PINPAD EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a Personal Identification Number Pad (PINPad) connected to a Workstation.

PLAN TYPE

Lookup

Lookup for type of Sales Plan.

PLANNING PERIOD

Reference

Period level in the planning calendar.

PLANNING QUARTER

Reference

Quarter level in the planning calendar.

PLANNING SEASON

Reference

Plan season information.

PLANNING SEASON WEEK ASSIGNMENT

Reference

Plan season and respective week relationships.

PLANNING WEEK

Reference

Week level in the planning calendar.

PLANNING YEAR

Reference

Year level in the planning calendar.

PLATFORM

Reference

The hardware platform on which the OPERATING SYSTEM is installed.

POS CONTROL

Derived

Subtype of POS TRANSACTION FLOW that records statistics of CONTROL TRANSACTIONs for a given time period.

POS DEPARTMENT

Reference

Point of Sale (POS) grouping of items with similar point of sale control and processing attributes. The entity type may also be used to control sales that are not properly identified at the item level.

POS IDENTITY

Reference

A simple cross-reference between the barcode, point of sale scan code or other keyed identifying number used at POS and the internal stock keeping Item ID for the item. The POS Item ID will generally be filled with the GTIN (UPC, EAN, and so on) for an item -- but it is not mandatory.

POS IDENTITY TYPE

Lookup

Lookup for type of identifier used in POS IDENTITY.

POS KEYBOARD EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a POS keyboard connected to a Workstation.

POS LOCK TRANSACTION

Base

Subtype of CONTROL TRANSACTION which secures the Workstation while the EMPLOYEE is absent from the Workstation. The STORE WORKSTATION cannot be operated unless the EMPLOYEE enters the relevant AccessPassword. The AccessPassword is different from SIGN OFF TRANSACTION in that the Session in progress is not terminated.

POS NO SALE TRANSACTION

Base

Subtype of CONTROL TRANSACTION that conducts no business, but causes the till drawer to open.

POS PRINTER EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a POS printer connected to a Workstation.

POS RETAIL

Derived

Subtype of POS TRANSACTION FLOW that records statistics of RETAIL TRANSACTIONs for a given time period.

POS RETAIL EMPLOYEE MONTH AGGR

Aggregate

Month level aggregate of POS transactions by EMPLOYEE and TOUCHPOINT.

POS STORE FINANCIAL

Derived

Subtype of POS TRANSACTION FLOW that records statistics of TENDER CONTROL TRANSACTIONs for a given time period.

POS TENDER FLOW

Derived

Point of Sale (POS) Tender transactions by minute and tender type for a workstation in an ORGANIZATION BUSINESS UNIT.

POS TRANSACTION FLOW

Supertype (no physical table)

Point of Sale (POS) RETAIL TRANSACTIONs by minute and tender type for a workstation in an ORGANIZATION BUSINESS UNIT.

POS UNLOCK TRANSACTION

Base

A type of non-sales Transaction that changes the state of a Workstation from an inaccessible (locked) state to an accessible (unlocked) state for entering transactions.

POSITION

Reference

A collection of Jobs that are performed at a particular WORK LOCATION and is filled by particular Workers.

POSITION HIERARCHY

Reference

The reporting structure of the POSITION.

POSITION WORK SCHEDULE

Reference

A shift schedule for a POSITION.

POST CODE

Reference

Postal codes and associative demographic information of interest to the retail organization.

POSTAL SERVICE TYPE

Lookup

Lookup for type of postal service type available to the carrier. For example:

  • First-Class Mail

  • Registered Mail

  • Regular Mail

  • Postal Card

PREFERENCE TYPE

Lookup

The type of preference relevant to consumers or customers (for example, color preference).

PREPARED

Reference

Sub-type of SKU ITEM for which the final product is manufactured (or prepared) for sale by the retailer according to a pre-defined RECIPE.

PRICE DERIVATION RULE

Reference

Specification of a method to be used to transform the current sale unit retail amount into the retail price actually paid by a member of the employee discount group at the point of sale.

PRICE DERIVATION RULE ELIGIBILITY

Reference

The specification of a method to be used to transform the current sell unit retail amount to the price charged to account based on a discount group.

PRICE LINE

Base

Price Lines with High and Low amounts to define item pricing categorizations and corresponding prices.

PRICE LIST

Lookup

Lookup for the basic published or advertised price, often subject to discount. For example:

  • Standard

  • Discounted

  • Negotiated

PRICE MODIFICATION LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records the granting of a reduction or increase of price on all ITEMs in the Transaction.

PRICE TYPE

Lookup

Lookup for Type Price of a FUEL ITEM PRICE.

PRODUCT

Reference

A product as defined by a GL ACCOUNT and GL PRODUCT SEGMENT and mapped to a REVENUE CENTER.

PRODUCT COST

Base

Sub-table of the COST TYPE table, to associate a specific cost to a given product.

PRODUCT ENTITY

Reference

Any logical entity that is recognized as a product or item for Business Analysis and Transactions.

PRODUCTION ITEM CONVEYABLE TYPE

Lookup

Lookup for type of conveyability possible for the ITEM.

PROFILE INDIVIDUAL

Reference

Subtype of CUSTOMER in which the CUSTOMER is an individual person.

PROFILE ORGANIZATION

Reference

Subtype of CUSTOMER in which the CUSTOMER is an organization.

PROFILE SOURCE

Reference

The source from which a GEOGRAPHY DEMOGRAPHY VALUE is acquired or populated. For example, a mailing list provider.

PROJECT

Reference

The business activities (TASKs) that may be categorized into a specific Project according to their common purpose and for which budgets and costs are tracked in a GL ACCOUNT.

PROMOTION

Reference

The promotion reflects the tactics a retailer undertakes to generate increased incremental sales volume for specific item-store combinations within a promotional event. Promotions are frequently communicated as part of a marketing campaign to ensure that awareness is generated with the target audience. A collection of eligibility and price derivation rules, during a specific time.

PROMOTION COST

Base

Subtype of the COST, which is used to associate a specific cost uniquely associated to a given promotion. For example, the cost of the promotion price markdowns.

PROMOTION HISTORY

Base

Cross-reference of PROMOTIONs at an ORGANIZATION STORE and STORE WORKSTATION on a given DAY.

PROMOTION ITEM

Reference

Associative entity connecting any level of the item hierarchy and organization hierarchy, and optionally a VENDOR, with the promotion.

PROMOTION MEDIA COST

Base

Plan and forecast costs and sales for a campaign media.

PROMOTION PLAN

Reference

Plan for PROMOTION ITEMs and Prices effective during a PROMOTION.

PROMOTION PRICE DERIVATION

Reference

Associates a PRICE DERIVATION RULE ELIGIBILITY and a PRICE DERIVATION RULE with a valid Time Group to be part of a PROMOTION.

PROMOTION PRODUCT TYPE

Lookup

A code that indicates the type of Promotional Product that is being given away with the promotion. Possible values include: GIFT CERTIFICATE CLASS, SKU ITEM, Frequent Shopper Points.

PROMOTION PROMOTION TYPE

Reference

An associative entity resolving the many-to-many relationship between PROMOTION and PROMOTION TYPE. This allows PROMOTION to be grouped for reporting purposes.

PROMOTION SELLING ITEM

Reference

Associative entity linking promotion item and campaign media selling item, and the prices which may be used for the item during the promotional period.

PROMOTION TYPE

Lookup

An entity defining types of PROMOTION which allows PROMOTION to be grouped for reporting purposes.

PROSPECT

Reference

An individual, collection of individuals, company, or public institution that does not currently purchase merchandise or services, but who may in the future. A prospect may also be a CUSTOMER of one PRODUCT (already purchased) that does not currently purchase another PRODUCT (may purchase).

A prospect has no recorded relationship with the provider.

PROSPECT INDIVIDUAL

Reference

Attributes of an individual PROSPECT, one who is not an organization.

PROSPECT ORGANIZATION

Reference

Attributes of a prospect organization.

PROSPECT QUICK FACTS

Reference

Information regarding the latest CAMPAIGN sent to the PROSPECT.

PROSPECT RESTRICTED INFO

Reference

Describes confidential information regarding the PROSPECT, such as the date of birth or national identifier of a CUSTOMER.

PURCHASE ORDER

Base

Order from an ORGANIZATION BUSINESS UNIT to purchase inventory, supplies, or services from a VENDOR.

PURCHASE ORDER DEPARTMENT MONTH AGGR

Aggregate

Monthly summary of PURCHASE ORDERs by ITEM DEPARTMENT.

PURCHASE ORDER LINE ITEM

Base

Items, quantities and amounts included in a PURCHASE ORDER.

PURCHASE ORDER LINE ITEM DAY AGGR

Aggregate

Daily summary of PURCHASE ORDER LINE ITEMs by DAY, VENDOR, VENDOR SITE, ORGANIZATION BUSINESS UNIT, SKU ITEM.

PURCHASE ORDER LINE ITEM MONTH AGGR

Aggregate

Monthly summary of PURCHASE ORDER LINE ITEMs by Business Month, VENDOR, VENDOR SITE, ORGANIZATION BUSINESS UNIT, SKU ITEM.

PURCHASE ORDER LINE ITEM STATE

Base

State of a PURCHASE ORDER LINE ITEM for a given period.

PURCHASE ORDER LINE ITEM STATE DERIVED

Derived

Denormalization of PURCHASE ORDER LINE ITEM STATE.

PURCHASE ORDER STATE

Base

State of a PURCHASE ORDER for a given period.

PURCHASE ORDER STATE DERIVED

Derived

Denormalization of PURCHASE ORDER STATE.

PURCHASE ORDER SUBCLASS DAY AGGR

Aggregate

Summary of PURCHASE ORDER LINE ITEMs by DAY, VENDOR, VENDOR SITE, ORGANIZATION BUSINESS UNIT, ITEM SUBCLASS.

QUARTER HOUR

Reference

Quarter Hour level in Time of Day.

QUARTER TODATE TRANSFORMATION

Reference

Cumulative time transformations at the quarter level.

QUARTER TRANSFORMATION

Reference

Time transformations at the quarter level.

REASON

Lookup

Lookup for Reason Codes. Reason codes are grouped into REASON CATEGORYs based on where they are referenced.

REASON CATEGORY

Lookup

Lookup for Reason Category for grouping of Reason Codes. For example:

  • RETURN TO VENDOR

  • TIME PUNCH CORRECTION

  • INVENTORY ADJUSTMENT

RECEIVING DOCUMENT

Base

Subtype of INVENTORY CONTROL DOCUMENT that is used by a store to record its acceptance of items shipped to it by a VENDOR against a PURCHASE ORDER and the VENDOR packing slip.

RECIPE

Reference

The Recipe or Bill of Materials that is used to assemble a PREPARED item from other items (usually BULK ITEMs). A recursive relationship "variations produce" allows recipe variations to be recorded.

RECIPE INGREDIENT ASSIGNMENT

Reference

Associative entity in which INGREDIENTs are linked to a RECIPE.

REFERRING CATEGORY

Reference

User-defined referrer category.

REFERRING CATEGORY LEVEL

Reference

User-defined referrer category level.

REFERRING SITE

Reference

Web page containing the referring link.

REFERRING URL

Reference

URL of the REFERRING SITE.

REGION

Reference

Region level of the GEOGRAPHY HIERARCHY.

RELATED ITEM ASSOCIATION

Reference

An association between two items for a specific purpose such as substitution, upselling, cross selling, and so on. For each association between related items, transaction and sales summaries may be calculated to analyze how frequently they are purchased together in a sale and how frequently they are purchased separately.

RELATED ITEM ASSOCIATION TYPE

Lookup

A retailer assigned code defining a type of association between two items that are generally sold together.

RELIGIOUS AFFILIATION

Lookup

Lookup for religious affiliations.

RENTAL SERVICE

Reference

Subtype of SERVICE SKU. The terms and conditions that apply to the rental of a RENTAL SERVICE item.

RENTAL UNIT

Reference

An associative entity denoting which SERIALIZED ITEMs may be rented through a particular SERVICE SKU.

REQUEST FOR DEBIT CREDIT DOCUMENT

Base

A type of INVENTORY CONTROL DOCUMENT initiated by the store advising the VENDOR of a discrepancy in one or both of:

  • The number of items delivered versus the number indicated in a packing slip.

  • The confirmed PURCHASE ORDER price versus the invoiced price. This document requests an adjustment to the store's account

REQUEST ORIGIN TYPE

Lookup

Lookup for available types of PARTY INTERACTION EVENT originators.

REQUISITION DOCUMENT

Base

A type of INVENTORY CONTROL DOCUMENT recording a request for SKU ITEMs to be sent from a ORGANIZATION DISTRIBUTION CENTER to a ORGANIZATION STORE.

RESERVATION

Base

Food Service entity involving the reservation of a FOOD SERVICE TABLE by a CUSTOMER.

RESTRICTION VALIDATION QUESTION

Reference

Standard question asked to a CUSTOMER as part of the process of negotiating a SALES RESTRICTION that has been placed upon a class of items.

RETAIL MARKDOWN ITEM DAY DERIVED

Derived

 

RETAIL SALE LINE ITEM AUDIT

Base

Audited Sales and Returns.

RETAIL SALE RETURN DEPARTMENT DAY AGGR

Aggregate

Daily summary of sales and returns by department, optionally by promotional campaign.

RETAIL SALE RETURN ITEM DAY DERIVED

Derived

Summary of SKU ITEM sales and returns by day, ORGANIZATION BUSINESS UNIT, and optionally by promotional campaign.

RETAIL SALE RETURN LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records the exchange in ownership of a merchandise item (for example, a sale or return) or the sale or refund related to a service.

RETAIL SALE RETURN SUBCLASS MONTH AGGR

Aggregate

Monthly summary of sales and returns for an ORGANIZATION BUSINESS UNIT by item subclass, optionally by promotional campaign.

RETAIL TENDER HISTORY DERIVED

Derived

History of a RETAIL TRANSACTION that records the settlement of transactions with an offsetting, valid tender type.

RETAIL TENDER LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records the settlement of that transaction with an offsetting, valid tender type.

RETAIL TENDER LINE ITEM AUDIT

Base

Audited RETAIL TENDER LINE ITEMs.

RETAIL TRANSACTION

Base

A type of transaction that records the business conducted between the retail enterprise and another party involving the exchange in ownership or accountability, or both, for merchandise or tender, or both, or involving the exchange of tender for services.

RETAIL TRANSACTION ASSOCIATE ASSIGNMENT

Base

Employee Associate involved in serving the CUSTOMER who purchased the merchandise or services identified in the RETAIL TRANSACTION.

RETAIL TRANSACTION DELIVERY PREFERENCE

Reference

The record of the CUSTOMER's preferences for the delivery of the goods purchased in a particular RETAIL TRANSACTION.

RETAIL TRANSACTION DELIVERY PREFERENCE ITEM

Reference

A associative entity that relates a particular item sale to a record of the CUSTOMER's delivery preferences for the items purchased.

RETAIL TRANSACTION DISCOUNT LINE ITEM AUDIT

Base

Audited DISCOUNT LINE ITEMs.

RETAIL TRANSACTION EMP WORKSTATION DAY DERIVED

Derived

Days summary of EMPLOYEEs activities at a STORE WORKSTATION. For example:

  • Gross positive

  • Tender loans

  • Tender pickups

  • Returns

RETAIL TRANSACTION LINE ITEM

Base

A detail line item of a RETAIL TRANSACTION that records the business conducted between the ORGANIZATION STORE and another party involving the exchange in ownership or accountability, or both, for merchandise or tender, or both, or involving the exchange of tender for services.

RETAIL TRANSACTION LINE ITEM ASSIGNMENT

Base

Associative entity recording relationships between line items within the same RETAIL TRANSACTION. Examples of usage of this entity include:

  • Associating an original sales line item to a return line item.

  • Associating an original sales line item to an exchange line item.

  • Associating a sales line item to a fee line item.

RETAIL TRANSACTION LINE ITEM ASSIGNMENT TYPE

Lookup

A retailer assigned code denoting the relationship between the two items within the same RETAIL TRANSACTION.

RETAIL TRANSACTION LINE ITEM GROUP

Base

A group of line items within a RETAIL TRANSACTION that are processed together. For example, individual meal trays at a restaurant.

RETAIL TRANSACTION LINE ITEM GROUP TYPE

Lookup

A code that describes a categorization of groups of line items in a RETAIL TRANSACTION. For example (in food service),

  • Delivery

  • Pickup

  • Tray

RETAIL TRANSACTION LINE ITEM TYPE

Lookup

A specific action that occurs as part of a RETAIL TRANSACTION.

RETAIL TRANSACTION MISC LINE ITEM

Base

A detail line item of a miscellaneous RETAIL TRANSACTION.

RETAIL TRANSACTION SHIPMENT

Base

The record of a shipment which was made to deliver the goods purchased in a particular RETAIL TRANSACTION to the customer's shipping address(es).

RETAIL TRANSACTION SHIPMENT ITEM

Base

A associative entity that relates a particular item sale to a the Shipment that was used to deliver the merchandise to the CUSTOMER's shipping address(es).

RETAIL TYPE

Lookup

Lookup for types of retail processing. For example:

  • Regular

  • Promotion

  • Clearance

RETAIL VALUATION LEDGER ACCOUNT HISTORY

Base

History of Retail Valuation portion of the GL ACCOUNT figures.

RETAILER

Reference

Subtype of ORGANIZATION indicating a retailer.

RETAILER ASSIGNMENT

Reference

Associative entity relating a VENDOR and CARRIER to an ORGANIZATION BUSINESS UNIT.

RETAILER BRAND

Reference

Subtype of BRAND indicating the BRAND belongs to a RETAILER.

RETAILER CLUSTER

Reference

MANUFACTURER entity: Retail clusters are the grouping of similar retailers at the organization level. For example, you may create retail clusters named Department Store, Drug Store, and so on.

RETAILER CLUSTER ITEM ASSIGNMENT

Reference

Assigns a level in the ITEM HIERARCHY to a RETAILER CLUSTER.

RETAILER CLUSTER RETAILER ASSIGNMENT

Reference

Assigns RETAILERs to a RETAILER CLUSTER.

RETAILER ORDER

Base

MANUFACTURER entity: Subtype of ORDER indicating ORGANIZATION STORE or ORGANIZATION DISTRIBUTION CENTER ordering from another retail unit, no manufacturer involved.

RETAILER ORDER LINE ITEM

Base

MANUFACTURER entity: Line item details of a RETAILER ORDER.

RETAILER PAYMENT

Base

MANUFACTURER entity: Payment received from a RETAILER.

RETAILER VENDOR ASSIGNED STATUS

Base

Status of relationship between ORGANIZATION BUSINESS UNIT and VENDOR.

RETURN AGENT

Reference

A unique system assigned identifier for the company to whom returns on which a deposit was paid are returned.

RETURN AUTHORIZATION REQUEST

Base

A type of INVENTORY CONTROL DOCUMENT that makes a request to a VENDOR to grant permission to return merchandise that is received and found to be unsuitable for sale or other use at the store.

RETURN DOCUMENT

Base

A type of INVENTORY CONTROL DOCUMENT that lists the merchandise items to be returned by the store to the VENDOR as a result of:

  • Errors in delivery against the store's purchase order

  • Substitutions in shipment

  • Late delivery

  • Defective materials, workmanship or fit

  • Other breaches of contract

RETURN TO VENDOR DEPARTMENT DAY AGGR

Aggregate

Daily summary of ITEMs by ITEM DEPARTMENT returned to VENDOR from an ORGANIZATION BUSINESS UNIT on a given day.

RETURN TO VENDOR ITEM DAY DERIVED

Derived

Daily summary Summary ITEMs returned to VENDOR from an ORGANIZATION BUSINESS UNIT on a given day.

RETURN TO VENDOR SUBCLASS MONTH AGGR

Aggregate

Summary of ITEMs by ITEM SUBCLASS returned to VENDOR from an ORGANIZATION BUSINESS UNIT on a given day.

RETURN TYPE

Lookup

The code to indicate the nature of the request. For example:

  • Return to vendor

  • Transfer to another store

REVENUE CENTER

Reference

A functional area of the ORGANIZATION used for Internal Control.

RFMP METHOD

Lookup

Lookup for different methods of calculating the Recency, Frequency, Monetary, and Profitability (RFMP) scores.

ROLES HIERARCHY

Reference

Hierarchy among the job roles within the retail organization.

ROUNDING LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records the Adjustment of the Transaction Total to match the available Denominations of the CURRENCY being used to tender the transaction. For example, in New Zealand, round up or down to nearest 10c, when Cash is being tendered.

SAFE TRANSFER TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the movement of TENDER from one Safe to another.

SALE OR RETURN ACTION

Lookup

A code denoting how the item is being treated in the line item. For example:

  • Layaway

  • Order For Delivery

  • Previous Layaway

  • Return Item

  • Sale Item

  • Return

  • Sale

SALE RETURN TAX OVERRIDE MODIFIER

Base

A line item modifier to the Sale Return Tax Line Item component of a RETAIL TRANSACTION that provides supplementary data regarding tax overrides (where the amount of tax collected is reduced rather than exempted).

SALE WEIGHT OR UNIT COUNT

Lookup

Indicates whether the ITEM is sold by weight or as a unit. For example:

  • Item is sold by Unit

  • Item is sold by Weight

SALES ASSOCIATE ACTION

Lookup

An action that is performed by a EMPLOYEE while assisting a CUSTOMER purchasing the merchandise or services.

SALES FORECAST ITEM ORG HIERARCHY WEEK

Base

Weekly sales forecast Information at given levels of ITEM, and organization hierarchies.

SALES METER

Reference

A mechanical or electronic meter that counts the monetary value or volume of blended ITEM dispensed during all FUELING TRANSACTIONs.

SALES METER READING

Base

The value of a SALES METER recorded at a particular time for a particular reason.

SALES ORDER

Base

MANUFACTURER entity: The order retailer purchase goods from MANUFACTURER.

SALES ORDER LINE ITEM

Base

MANUFACTURER entity: Subtype of ORDER in which RETAILER ordered from MANUFACTURER.

SALES PLAN ITEM ORG HIERARCHY WEEK

Base

Weekly sales plan including Returns, Cost of Sales, PROMOTION, Clearance, at given levels of ITEM and ORGANIZATION hierarchies.

SALES RESTRICTION

Reference

A type of limitation that restricts the sale of a particular class of item.

SCALE EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a scale connected to a Workstation.

SCANNER EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a barcode scanner connected to a Workstation.

SCHEDULE EVENT

Base

Something has been planned to take place. Scheduled Events are normally associated with business processes like markdowns, physical inventory, special promotional displays and advertising, and so on.

SEARCH

Reference

Phrases, keywords, or Boolean expressions that are part of a referral from an external search engine or part of a local search.

SEARCH CATEGORY

Reference

Lookup for identifying SEARCH categories.

SEARCH CATEGORY LEVEL

Reference

Hierarchical levels of SEARCH CATEGORYs.

SEASON

Reference

Allows the user to categorize each item according to different seasons and phases within a season. That is, a user may assign a season of “Spring” to a group of items, according to the supplier's deliveries of fashion items. Those relationships can be further broken down into the phases, such as “Spring I and Spring II.”

SECOND

Reference

Second hierarchy level as defined in Time Hierarchy.

SECURITY CLASS

Lookup

Defines the level of security required for a specific location. This is to accommodate secured merchandise such as prescription drugs, guns and ammunition, expensive sound and video equipment, and so on.

SECURITY REQUIRED TYPE

Lookup

Defines the security environment and procedures required for receiving, displaying and selling high priced merchandise like jewelry, certain prescription drugs, ordinance, fireworks.

SELLING LOCATION

Reference

An area of floor space or shelf space within the ORGANIZATION STORE to which sales can be assigned. SELLING LOCATION may be assigned to or rented by a VENDOR.

SELLING LOCATION TYPE

Lookup

Lookup for types of SELLING LOCATIONs within a store. For example:

  • Shelf

  • Floor

  • Rack

SELLING STATUS

Lookup

Lookup for the selling status of the item. For example:

  • Active

  • Discontinued

  • Seasonal

  • To be discontinued

  • Reserved

SEND CHECK TENDER LINE ITEM

Base

A sub-type of RETAIL TENDER LINE ITEM that records the intention of the retail enterprise to send a refund check to an Address nominated by the CUSTOMER.

SERIALIZED ITEM

Reference

Extra attributes for a Stock Item that can be identified by a (normally) MANUFACTURER assigned Serial Number.

SERIALIZED UNIT

Reference

A specific instance of a SERIALIZED ITEM with a unique serial number, usually allocated by the MANUFACTURER, and is used for tracking the ITEM through the supply chain.

SERIALIZED UNIT MODIFIER

Base

A record of the serial number of some item that is related to a particular Sale Item. For example, the sale of a camera and service contract may result in two RETAIL SALE RETURN LINE ITEMs each with an instance of Serialized Unit Sale Modifier one for the camera and one for the related service contract.

SERIALIZED UNIT TYPE

Lookup

A code to indicate the type of SERIALIZED ITEM. For example:

  • Television

  • Refrigerator

  • Personal Computer

SERVER

Reference

An EMPLOYEE who conducts FOOD SERVICE TRANSACTIONs.

SERVER FARM

Reference

Server farm to which the server belongs.

SERVER STATUS

Lookup

Lookup for SERVER status codes.

SERVER STATUS HISTORY

Base

History of SERVER STATUS over time.

SERVICE ITEM PROVIDER

Reference

The association between a SERVICE SKU sold by an ORGANIZATION STORE and the third party SERVICE PROVIDER who actually performs the service.

SERVICE PROVIDER

Reference

A third party that provides a service.

SERVICE SKU

Reference

A type of SKU ITEM that provides a detailed identifier and description for a service offered for sale to a customer in the ORGANIZATION STORE. This entity also identifies and describes rental items and other tangible items a customer uses for a contracted period but that are not purchased.

SERVICE TERM

Reference

The terms and conditions that apply to the provision of any services either by the retail Organization or by arrangement through a third party. The terms and conditions are normally listed in a separate document, which the customer is requested to sign as acceptance of these terms.

SERVICE TYPE

Lookup

A code to denote the type of SERVICE SKU item.

SESSION

Base

Record of activity by a visitor.

SESSION TYPE

Lookup

Lookup for user defined SESSION types.

SHIFT DIFFERENTIAL

Reference

Additional pay premiums to compensate employees for working hours and shifts other than regular weekday shifts.

SHIFT TYPE

Lookup

Types of shift. For example:

  • 2nd shift

  • 3rd shift

  • Holiday Shift

  • Weekend shift

  • Night shift

SHIPMENT METHOD

Lookup

Lookup for different types of shipment methods. For example:

  • Shipment By Air

  • Shipment By Sea

  • Shipment By Rail

SHIPMENT PRIORITY

Lookup

Lookup for different types of shipment priority. For example:

  • Primary

  • Secondary

  • Tertiary

SIGN OFF TRANSACTION

Base

Subtype of CONTROL TRANSACTION that completes a Session and prevents a Workstation from performing other types of Transactions.

SIGN ON TRANSACTION

Base

Subtype of CONTROL TRANSACTION that establishes a Session and enables a Workstation to perform other types of Transactions.

SIGNATURE EQUIPMENT CAPTURE STATISTICS READING

Base

A set of performance statistics that have been taken from a signature capture device connected to a Workstation.

SITE

Reference

A geographical location at which the enterprise's business is conducted. Contains one or more of ORGANIZATION STORE, ORGANIZATION DISTRIBUTION CENTER, INVENTORY LOCATION, and ADMINISTRATION CENTER.

SIZE

Lookup

Lookup for values of the size attribute of SKU ITEM.

SIZE TYPE

Lookup

Lookup for type of size of the SKU. The Size Type entity provides the size details of the SKU. For example:

  • Medium

  • Large

  • Small

SKU ITEM

Reference

Stock Keeping Unit or unit identification, typically the UPC, used to track store inventory and sales. Each SKU is associated with an item, variant, product line, bundle, service, fee, or attachment.

  • Aggregate SKU: Subtype of SKU that is an aggregation of one or more constituent SKU. The constituent items may be sold individually.

  • Group Select: An item, which is a group of items, only one of which is sold. The choice of which item is made by the customer at the POS.

  • Prepared: A sub-type of SKU ITEM that is manufactured (or prepared) for sale from a set of BULK ITEM with a RECIPE. A PREPARED SKU ITEM is different from a SKU ITEM because a PREPARED Item is not booked into inventory when the item is manufactured; nor is it removed from inventory when it is sold; rather the inventory for the BULK ITEM constituent parts as defined by the recipe is reduced when the Prepared Item is sold.

  • Service SKU: A type of SKU that provides a detailed identifier and description for a service offered for a sale to customer in the retail store. Service SKU also identifies and describes rental items and other tangible items that a customer uses for a contracted period, but not purchased.

  • Stock: A unit of merchandise that may be sold to a customer or used by the ORGANIZATION STORE.

SKU ITEM BUSINESS UNIT INVENTORY RULES

Reference

Associative entity for ORGANIZATION BUSINESS UNIT, SKU ITEM, and VENDOR that defines the inventory rules for the VENDOR ITEM at the ORGANIZATION BUSINESS UNIT.

SKU ITEM BUSINESS UNIT SELLING PRICE

Base

Specifies the SKU ITEM SELLING PRICE related to an ORGANIZATION BUSINESS UNIT.

SKU ITEM CHOICE

Reference

Mapping from a parent group select item to item denoting a choice that may be made by the customer at the time sale for a Group Select Sale, package deal, or bill of material, in which several items are bundled under a single price, and the customer can make substitution for some items from a list of choices for the bundle.

Example: Ski Package where the customer can choose one of several SKUs, often one of several skis, poles, binding, and boots.

SKU ITEM COLLECTION

Reference

An optional relationship between a SKU ITEM and its components and affiliates where the components consist of other SKU ITEMs.

SKU ITEM CONSTRUCTION

Reference

The terms and conditions that apply to the provision of any services either by the retail organization or by arrangement through a third party. The terms and conditions are normally listed in a separate document which the customer is requested to sign as acceptance of these terms.

SKU ITEM RECIPE ASSIGNMENT

Reference

Associative entity assigning SKU ITEMs to a RECIPE.

SKU ITEM SELLING PRICE

Base

The set of prices that are applied to an SKU ITEM.

SKU ITEM SELLING PRICE HISTORY

Base

Historical archive of the retail selling unit price at which a given SKU ITEM was actually sold at POS, net of markdowns, markups and other changes that modify the cumulative mark on for an SKU ITEM.

SKU ITEM SHELF ATTRIBUTES

Reference

Shelf requirements for a SKU ITEM.

SKU ITEM STYLE

Lookup

Identifies and describes the general appearance of SKU ITEMs.

SKU ITEM SUBSTITUTION

Reference

A 3-way join of SKU ITEM, SKU ITEM Collection and Substitute SKU ITEM indicating the Substitute SKU could have replaced a member SKU in the SKU ITEM COLLECTION, and subsequent quantity and price adjustment.

SKU ITEM TYPE

Lookup

Lookup indicating which subtype the SKU ITEM is. For example:

  • Stock Item

  • Service Item

  • Prepared Item

  • Group Select Item

  • Aggregate Item

SKU ITEM VARIETY ASSIGNMENT

Reference

User Defined SKU ITEM attributes other than size, weight, and style, such as color, associated with the SKU ITEM. Can have multiple varieties for an SKU ITEM.

SKU ITEM WEIGHT

Reference

Specifies the SKU ITEM Attribute Weight.

SOC JOB

Reference

Entity holds the most detailed level of Standard Occupational Classification (SOC) job classification. For example:

  • 15-0000 Computer and Mathematical Occupations

  • 15-1000 Computer Specialists

  • 15-1010 Computer and Information Scientists, Research

  • 15-1011 Computer and Information Scientists, Research

  • 15-1020 Computer Programmers

  • 15-1021 Computer Programmers

  • 15-1030 Computer Software Engineers

  • 15-1031 Computer Software Engineers, Applications

  • 15-1032 Computer Software Engineers, Systems Software

  • 15-1040 Computer Support Specialists

  • 15-1041 Computer Support Specialists

SOC JOB CATEGORY

Reference

Defines the categories in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy in SOC is typically: NN-MMM0. These job categories correspond to the 449 "broad occupations" or categories. For example:

  • 13-2010 Accountants and Auditors

  • 13-2020 Appraisers and Assessors of Real Estate

  • 13-2030 Budget Analysts

  • 13-2040 Credit Analysts

  • 13-2050 Financial Analysts and Advisors

  • 13-2060 Financial Examiners

SOC JOB GROUP

Reference

Defines the groups in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy of SOC is typically: NN-MM00. For example:

  • 13-1000 Business Operations Specialists

  • 13-2000 Financial Specialists

SOC JOB MAJOR GROUP

Reference

Defines the (23) major groups in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy of SOC is typically: NN-0000. For example:

  • 11-0000 Management Occupations

  • 13-0000 Business and Financial Operations Occupations

  • 15-0000 Computer and Mathematical Occupations

  • 17-0000 Architecture and Engineering Occupations

  • 19-0000 Life, Physical, and Social Science Occupations

  • 21-0000 Community and Social Services Occupations

  • 23-0000 Legal Occupations

SPACE UTILIZATION DEPARTMENT DAY AGGR

Aggregate

Daily summary of allocated space by item. Aggregate Space Utilization Department Day is the item Department Level summary of SPACE UTILIZATION ITEM DAY DERIVED.

SPACE UTILIZATION ITEM DAY DERIVED

Derived

Summary of allocated space by item. The table is updated from inventory item state. 'Max' and 'Min' are populated from the recursive SELLING LOCATION.

STATUS

Lookup

Lookup for status, such as Buy, Not Buy, Suspended, or Active.

STATUS REASON

Lookup

Lookup for the reason why a particular PARTY STATUS TYPE may be assigned to a CUSTOMER.

Reason for the vendor status. For example, if the status is "Not Buy", a reason could be government restrictions, vendor quality issues, and others.

STATUS TYPE

Lookup

Lookup for the domain of classifications tracked to the roles that a CUSTOMER is fulfilling. For example:

A - Active

I - Inactive

P - Prospective

U- Unmarketable Customer (such as, a deceased customer)

STOCK

Reference

Subtype of SKU ITEM.

Unit of merchandise sold to a customer or used by the ORGANIZATION STORE. For example:

  • Display Unit Item

  • Shelf Item

  • Apparel Item

  • Bulk Item

STOCK ITEM CONSUMER PRODUCT LABEL

Reference

Identifies and describes the stock item for presentation on a label designed to inform or warn consumers about the product.

STOCK ITEM TYPE

Lookup

Lookup code to indicate the SKU ITEM type. For example:

  • Shelf Item

  • Apparel Item

STOCK LEDGER ACCOUNT HISTORY

Base

A reporting period based record of the beginning balance and cumulative activity for a particular PRODUCT ENTITY on a given DAY. Records both raw Item numbers and a Valuation amount. The valuation figures for any particular GL ACCOUNT may be either Retail Valuation or Cost Price Valuation as required by the needs of the retail enterprise.

STOCK LEDGER JOURNAL ENTRY

Base

The record of a change in a stock holding that is applied to a Stock Ledger Account.

STOCK METER

Reference

A mechanical or electronic meter that counts the monetary value or volume of unblended BULK ITEM dispensed during all FUELING TRANSACTIONs.

STOCK METER READING

Base

The value of a STOCK METER recorded at a particular time for a particular reason.

STORE FINANCIAL LEDGER ACCOUNT

Reference

Ledger account for tracking Store financial information including CERTIFICATEs and CUSTOMER ACCOUNTs.

STORE SAFE

Reference

A repository within the enterprise for safekeeping of TENDER removed from the Till and or Tills. This includes:

  • Safe

  • LockBox

  • SecureLocation

STORE SAFE SETTLEMENT TRANSACTION

Base

A transaction that records closing of the ledger for the STORE SAFE. A new ledger will be opened with a new beginning on hand accountability, and zero incremental accumulators (pickup, loan, deposit, and so on).

STORE WORKSTATION

Reference

Device used as an Interface to any retail business function. For example, the capture and storage of RETAIL TRANSACTIONs and operational performance reporting. Usually a cash register.

SUB BRAND

Reference

A subcomponent of a BRAND. For example, if a BRAND were "Super Cola", the subbrand might be "Super Cola Light".

SUB REGION

Reference

A level in the Geography hierarchy below REGION.

SUBSCRIPTION

Reference

The record of CUSTOMER using a product or service which may be based on a contract. CUSTOMER's subscription to services is the basis of billing and network usage authorization.

SURVEY

Reference

Survey conducted by or of interest to the retailer.

SURVEY COST

Base

Subtype of COST for tracking the cost of conducting or buying survey.

SURVEY QUESTION

Reference

A question in a SURVEY.

SURVEY QUESTION OPTION

Reference

An option in a SURVEY QUESTION.

SURVEY RESPONSE DETAIL

Base

Response details to SURVEY QUESTIONs.

SURVEY RESPONSE HEADER

Base

Header to group SURVEY RESPONSE DETAILs from the same SURVEY.


Table 2-60 T-Z Entity Descriptions

Entity Name Type Description

TANK

Reference

A kind of LOCATION used to store a FUEL ITEM that is measured and dispensed by one or more FUELING POINTs.

TANK LEVEL GAUGE

Reference

A piece of equipment that takes measurements from TANK PROBEs to report the amount of fuel in TANK.

TANK PROBE

Reference

A device that is housed in the TANK and periodically (or on demand) returns height (and/or volume) readings to the TANK LEVEL GAUGE to which it is connected.

TANK READING

Base

A reading of the height, and or volumes, of Fuel and Water measurements of the contents of a TANK.

TANK TEMPERATURE READING

Base

A reading of the temperature of the Fuel that is stored in a TANK.

TANK TEMPERATURE SENSOR

Reference

A device that is housed in the TANK and periodically (or on demand) returns temperature readings for the FUEL ITEM that is stored there.

TARE

Reference

Defines the weight of the container that must be subtracted from the gross weight to calculate net selling weight for items priced and purchased in weight UNIT OF MEASURE.

TARGET

Reference

Type of CAMPAIGN MESSAGE RENDERING containing the message target list or time slot.

TASK

Reference

An individual activity that a Worker performs for their POSITION.

TASK PREREQUISITE

Reference

A qualification or certificate that a person must hold to be allowed to perform a particular TASK.

TASK SET

Reference

A group of activities that a Worker performs for their Job.

TAX AUTHORITY

Reference

A government authority that levies sales taxes and on whose behalf the store collects these sales taxes. For example:

  • National

  • State

  • Province

  • City

  • County

  • Other

TAX EXEMPTION

Reference

An CUSTOMER ORGANIZATION whose purchases are exempt from sales tax.

TAX GROUP RULE

Reference

A rule that prescribes how a particular tax is to be applied to a group Items.

TAX LEVEL TYPE

Lookup

A categorization of tax levels that describe whether the results of the tax rule apply to the individual items, a multi-component item, or the entire transaction.

TAX LINE ITEM

Base

A line item component of a RETAIL TRANSACTION that records the charging and offsetting liability credit for sales tax on merchandise items and services sold by the store or debit for merchandise returned to the store.

TAX LINE ITEM AUDIT

Base

Audited TAX LINE ITEMs.

TAX RATE CLASS

Lookup

A classification of Tax Rates. For example:

  • Standard

  • Reduced

  • Luxury

TAX RATE RULE

Reference

A rule denoting what percentage or dollar amount of tax is applied to a particular taxable total in a RETAIL TRANSACTION.

TAX RESULT TYPE

Lookup

A classification of tax results. For example:

  • Taxable

  • Exempt

  • Zero-Rated

TAX THRESHOLD TYPE

Lookup

A categorization of how to process a tax if an when a stated threshold established for the taxable amount is reached, such as:

  • Exempt Entire Amount

  • Tax Entire Amount

  • Tax Only Amount above Threshold

TAX TYPE

Lookup

A kind of tax for which a PARTY is registered, and the retail enterprise pays to the TAX AUTHORITY on behalf of a Tax Jurisdiction. For example:

  • SalesTax

  • GST

  • PST

  • HST

  • VAT

TAXABLE GROUP

Reference

A group of ITEMs for which a TAX AUTHORITY defines TAX GROUP RULEs. For example:

  • Food items

  • Hard goods

TENDER

Reference

Tender includes all the forms of payment that are accepted by the ORGANIZATION STORE in settling sales and other transactions.

TENDER ACCOUNT APPROVAL REFERENCE

Reference

Repository of external account numbers against which an individual tender can be approved or rejected depending on the status of that account.

TENDER ADJUSTMENT TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the transformation of TENDER from one Tender Type to another within a Till.

TENDER AUTHORIZATION

Base

A request to an external agency to authorize the use of some form of TENDER to complete a RETAIL TRANSACTION. For example:

  • Checks

  • Credit and Debit Cards

  • Gift Certificates

  • Vouchers

TENDER AUTHORIZATION REVERSAL

Base

A request to an external agency to reverse a previously requested authorization of the use of some form of tender to complete a RETAIL TRANSACTION. For example:

  • Checks

  • Credit and Debit Cards

  • Gift Certificates

  • Vouchers

TENDER AUTHORIZATION TERMINAL

Reference

A piece of hardware that performs TENDER AUTHORIZATIONs on behalf of one or more Workstations.

TENDER AUTHORIZATION TERMINAL SOFTWARE VERSION

Reference

A version of software installed on equipment.

TENDER CLASS

Lookup

A type of TENDER with common characteristics.

TENDER CONTROL TRANSACTION

Base

A type of transaction that records the physical movement of tender from one TENDER REPOSITORY to another.

TENDER CONTROL TRANSACTION TENDER LINE ITEM

Base

A line item in TENDER CONTROL TRANSACTION involving tender transfers into or out of the store safe that are not part of the pickup and loan tender transfer between tills and the store safe.

TENDER DEPOSIT TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the movement of TENDER from a STORE SAFE to an EXTERNAL DEPOSITORY.

TENDER EXCHANGE TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the movement of TENDER between two Tills.

TENDER LINE ITEM DENOMINATION

Base

Records the Denominations used in a particular TenderLineItem.

TENDER LOAN TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the movement of TENDER from a STORE SAFE to a Till.

TENDER PICKUP TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the movement of TENDER from a Till to a STORE SAFE.

TENDER REPOSITORY

Reference

Describes the types of physical tender containers used in the retail enterprise. Tender repository generally includes assets like, store safe(s), tills, and so on.

TENDER REPOSITORY CLASS

Lookup

Type of TENDER REPOSITORY. For example:

  • Safe

  • Till

TENDER REPOSITORY TENDER ACCOUNT

Reference

An account held on the STORE FINANCIAL LEDGER of all TENDER movements by repository.

TERM CODE

Reference

Lookup for information about different terms like sales. For example:

  • Supplier must be notified of any shortages within three days

  • Product must be properly checked

TERMS MASTER

Base

Master data of terms of business with the VENDOR.

TEST DELIVERY

Base

A type of transaction that records the clearing of a FUELING TRANSACTION without accepting payment because the fueling transaction was for testing or calibrating the FUELING POINT. The fuel delivered may or may not have been put back into a storage TANK.

TILL DERIVED

Derived

A type of TENDER REPOSITORY that is a drawer insert, operationally associated with a Workstation and optionally an Employee. It is used to keep cash and other TENDER collected through RETAIL TRANSACTIONs and used to make change.

TILL HISTORY

Base

A collection of monetary and operational totals used to track the activity volume of a till between Till Settlement Transactions.

TILL LIMIT EXCEEDED TRANSACTION

Base

A non-sales transaction recording the fact that the calculated cash on hand in a particular Till has exceeded a pre-defined limit.

TILL LIMIT RULE

Reference

A rule defining an amount of Cash that is allowed to be held in a Till at any one time, and the action the POS Application is to take when the calculated amount of cash in exceeds the limit.

TILL LIMIT TYPE

Lookup

A mnemonic code that denotes which of the limits in the TILL LIMIT RULE have been exceeded. For example:

  • Warning

  • Lockout

TILL MOVEMENT DIRECTION

Lookup

A code denoting the direction the Till is being moved. That is, from STORE SAFE to STORE WORKSTATION, from STORE WORKSTATION to STORE SAFE, from STORE SAFE to Operator, or from Operator to STORE WORKSTATION, and so on.

TILL MOVEMENT TRANSACTION

Base

A non-sales transaction that records the physical movement of a Till (cash drawer insert) from a STORE WORKSTATION to a STORE SAFE or from a STORE SAFE to a STORE WORKSTATION.

TILL OPERATOR ASSIGNMENT TRANSACTION

Base

A non-sales transaction that records the assignment of a Till (cash drawer insert) to a specific operator.

TILL TAX HISTORY

Base

A collection of tax totals for a tax authority by till for a tender reconciliation period.

TILL TENDER HISTORY

Base

A collection of tender type accumulators by till tender accumulation period. This entity is used to support till tender accountability.

TILL TENDER LIMIT RULE ASSIGNMENT

Reference

The assignment of a particular TILL LIMIT RULE to a Till for a nominated type of TENDER during particular time periods.

TILL WORKSTATION ASSIGNMENT

Reference

A permanent or temporary assignment of a Till to a particular STORE WORKSTATION, recording where the Till was located for a particular period.

TIME PLANNING SEASON TODATE BY WEEK

Reference

Transformation for cumulative SEASONs to Date.

TIME PUNCH APPROVAL

Base

An after the fact confirmation that the TimePunch entry is valid.

TIME PUNCH CORRECTION

Base

A record of TimePunchEntry being a correction of an earlier TimePunchEntry.

TIME PUNCH TRANSACTION

Base

A non-sales transaction that records a TimePunch by a Worker.

TIME STANDARD BY DAY

Reference

Associates a DAY to a SEASON.

TIME STANDARD BY WEEK

Reference

Associates a CALENDAR WEEK to a SEASON.

TIME ZONE

Reference

Time zone relative to Greenwich Mean Time (GMT).

TIP OUT TRANSACTION

Base

A type of TENDER CONTROL TRANSACTION that records the payment of TENDER from a Till to an EMPLOYEE as a payment of Tips due to them.

TONE INDICATOR EQUIPMENT STATISTICS READING

Base

A set of performance statistics that have been taken from a tone indicator connected to a STORE WORKSTATION.

TOTAL TIME

Reference

Represents the top most level of Time. This is needed to enable Ad-Hoc Reporting involving the Time Dimension.

TOUCHPOINT

Reference

Place from where transactions take place. Meeting point for customer and retail organization. Touchpoint can be both logical and physical.

  • Call Center: A department within a retail organization or a third-party organization that handles telephone sales service.

  • Store Workstation: A device used as an as interface to any retail business function, for example, the capture and storage of TRANSACTIONS and operational performance reporting.

TRADE AREA

Reference

Geographic region from which a store draws most of its retail customers. Can be defined by distance, drive time, or other factors.

TRADE AREA COVERAGE

Reference

Demographic and accessibility data for a given trade area.

TRADE IN TENDER

Base

A sub-type of TenderLineItem for retailers who accept various goods in part-payment for merchandise. For example, retailers give one hundred dollars in credit for an old (working) appliance, when purchasing a new similar appliance.

TRANSACTION ASSIGNMENT

Base

Associative entity relating two RETAIL TRANSACTIONs.

TRANSACTION ASSIGNMENT TYPE

Lookup

Lookup for type of TRANSACTION ASSIGNMENT.

TRANSACTION CATEGORY

Lookup

A code to denote the type of transaction. For example, RETAIL TRANSACTION, CONTROL TRANSACTION, TENDER CONTROL TRANSACTION, and so on.

TRANSACTION TYPE

Lookup

Further classifications of TRANSACTION CATEGORY.

TRANSFER IN OUT DOCUMENT

Base

Transfer in: A type of INVENTORY CONTROL DOCUMENT that is completed when there is no accompanying transfer-out document with the shipment of merchandise being received from another store. It is an exception document much like a receiving document without a PURCHASE ORDER.

Transfer out: A type of INVENTORY CONTROL DOCUMENT prepared by the originating store listing the items it is sending to the receiving store.

TRANSFER TYPE

Lookup

Code to indicate type of INVENTORY TRANFER. For example:

  • Normal

  • Book

  • Inter-company

UNIT OF MEASURE

Lookup

Identifies and describes valid units of measure that are used throughout the model. For example:

  • Pound

  • Ounce

  • Gallon

  • Gram

  • Kilogram

  • Liter

UNIT OF MEASURE CONFIGURATION

Control

Indicate what are the default, system wide, UNIT OF MEASURE codes used for different UNIT OF MEASURE TYPEs.

Specified as: WEIGHT: WEIGHT_BASE_UOM_CD LB Lb LbsLENGTH: LENGTH_BASE_UOM_CD FT Ft FtAREA: AREA_BASE_UOM_CD SQFT sqft sqftTEMPERATURE: TEMPERATURE_BASE_UOM_CD DF F FDISTANCE: DISTANCE_BASE_UOM_CD KM Km Km

UNIT OF MEASURE CONVERSION

Reference

Provides the multiplication factor required to convert one UNIT OF MEASURE to another. For example: 1 inch = 2.54 cm.

UNIT OF MEASURE TYPE

Lookup

Indicates what this unit of measure entity type instance measures. For example:

  • WEIGHT

  • LENGTH

  • AREA

  • TEMPERATURE

  • DISTANCE

UNLOCK TRANSACTION

Base

A type of non-sales Transaction that changes the state of a STORE WORKSTATION from an inaccessible (locked) state to an accessible (unlocked) state for entering transactions.

USER

Reference

Associative entity for EMPLOYEE and JOB ROLES. Assigns a unique ID for each job role that an employee performs at a particular store.

VALIDATION QUESTION ASSIGNMENT

Reference

Associates RESTRICTION VALIDATION QUESTION to SALES RESTRICTION.

VALUE MEASURE

Reference

Unit of measure for the value. For example a customer or a profile can be valued in terms of monetary value or time (a customer for next three years).

VALUE TYPE

Lookup

The type of value. For example:

  • Time

  • Money

VARIETY

Reference

User Defined Item attribute other than size, weight, and style, such as color.

VARIETY TYPE

Lookup

Captures all the variety type. For example:

  • Color

  • Shape

VENDOR

Reference

External source for merchandise and goods that the ORGANIZATION STORE offers or for supplies and goods that the retail organization uses.

  • Vendor site: Vendor location.

VENDOR APPOINTMENT

Reference

Details of vendor appointments. Vendor appointments are regular visits by the vendor's representative to the ORGANIZATION STORE.

VENDOR CARRIER ASSIGNMENT

Reference

Associative entity for VENDOR and CARRIER; maps VENDORs and their CARRIERs.

VENDOR CLASS

Lookup

Lookup for classification of VENDORs. For example:

  • Primary

  • Associate

  • Direct Supply

VENDOR COMPLIANCE ITEM DAY DERIVED

Derived

Daily summary of timeliness, quantity, quality control vendor compliance information by item, ORGANIZATION BUSINESS UNIT, shipment, and PURCHASE ORDER.

VENDOR CONTRACT

Reference

Details of contract with VENDOR.

VENDOR COST

Base

Subtype of COST indicating costs tracked by VENDOR.

VENDOR FACTOR COMPANY ASSIGNMENT

Reference

Associative entity linking the factor company with the VENDOR.

VENDOR ITEM

Reference

Items supplied by the VENDOR with vendor-specific item and provides the vendor-specific attributes of the item. Provides the vendor's view of the item and uses the vendor's descriptions of item attributes.

VENDOR ITEM BUSINESS UNIT ASSIGNMENT

Reference

Defines the VENDOR ITEMs supplied to an ORGANIZATION BUSINESS UNIT.

VENDOR ITEM CATALOG BASE COST

Base

The supplier's catalog base cost, the cost before any promotions, allowances, charges, discounts, and so on, for the VENDOR ITEM.

VENDOR ITEM CATALOG BASE COST BREAK

Base

The VENDOR's quantity adjusted catalog base cost (the cost before any promotions, allowances, charges, discounts, and so on) for the VENDOR ITEM. This entity supports price breaks provided for buying larger quantities of an item.

VENDOR ITEM COST PER UNIT TYPE

Lookup

Defines the unit type the owned attribute costs are assigned to for this item. A single VENDOR ITEM may in effect have one to three associated VENDOR ITEM CATALOG BASE COST entities.

Permissible values include:

  • SU = Ship Unit

  • PU = Pack Unit

  • SLU = Selling Unit

All others are illegal.

VENDOR ITEM SKU ASSIGNMENT

Reference

Associative entity defining the relationship between VENDOR ITEM and SKU ITEM.

VENDOR MANUFACTURER BRAND

Reference

Associative entity for VENDOR, Manufacturer, and Brand.

VENDOR QUICK FACTS

Reference

Collection of vendor related measures.

VENDOR RATING

Base

Rating for a VENDOR

VENDOR RATING TYPE

Lookup

Lookup for VENDOR rating type values. For example:

  • Timeliness

  • Based on quality of goods

VENDOR SITE

Reference

Subentity of VENDOR indicating the vendor location which supplies the item.

VENDOR SITE ADDRESS

Reference

Association entity between the VENDOR SITE or VENDOR and the address location.

VENDOR SITE CARRIER ASSIGNMENT

Reference

Relationship between VENDOR SITE and CARRIER.

VENDOR SKU BUSINESS UNIT ASSIGNMENT

Reference

Relationship between SKU ITEM vendor and ORGANIZATION BUSINESS UNIT.

VENDOR SKU COST PROFIT DAY

Base

Cost change information for an SKU ITEM, VENDOR, and ORGANIZATION BUSINESS UNIT combination on a given day.

VENDOR STATUS

Base

Status of VENDOR. Indicates is the vendor is presently used, on suspension, or another status.

VISITOR

Reference

Identifies anonymous visitors using the specified method of visitor identification (with visitor cookies, for example).

VISITOR TYPE

Lookup

Lookup for type of VISITOR.

VOID TRANSACTION

Base

A non sales transaction that records the cancellation of another Transaction, either before or after that Transaction was completed.

VOIDS LINE ITEM

Base

A sub-type of RETAIL TRANSACTION LINE ITEM that records the removal of one or more of the items recorded in another RETAIL TRANSACTION LINE ITEM in the same RETAIL TRANSACTION.

WARRANTY TYPE

Lookup

Type of warranty that can be applied to a SERIALIZED UNIT.

WEAVE

Lookup

SKU ITEM Attribute Weave.

WEBSITE RESOURCE

Reference

The resource level contains a single record for each physical object hosted on a website and could include non-page resources. A resource may represent a static server object such and an HTML document or an image. A resource could also be a CGI program. Resources are assumed to be uniquely identified by the path component of a URI- that is, the non-query portion of the URI. So, a given CGI program will have only one record in the resource level regardless of the number of distinct pages generated by the program.

WEBSITE RESOURCE TYPE

Lookup

Lookup for types of WEBSITE RESOURCEs.

WEBSITE USER

Reference

Authenticated users of a site. Users may be authenticated either through the authentication mechanisms provided by the web server or through an application-specific authentication method.

WEEK TODATE TRANSFORMATION

Reference

Cumulative time transformations at the week level.

WEEK TRANSFORMATION

Reference

Time transformations at the week level.

WEEKDAY

Reference

Calendar weekdays.

WF CUSTOMER

Reference

Wholesale Franchise Customer.

WF CUSTOMER TYPE

Lookup

Lookup for Type of WF CUSTOMER.

WORK HOUR TYPE

Lookup

Lookup for types of work hours. For example:

  • Regular

  • Shift Differential

WORK LOCATION

Reference

A sub-type of LOCATION that is a place of work to which POSITIONs and Jobs are allocated. May be a cross-reference to a particular SITE or Business Unit located at a SITE.

WORKSTATION DISPLAY

Reference

Physical display for ITEMs near the workstation, usually intended for impulse purchases such as magazines, candy, gift cards, and calendars.

WORKSTATION GROUP

Reference

A set of STORE WORKSTATION with similar resource access control permissions.

WORKSTATION LOCATION ASSIGNMENT

Reference

Record of a STORE WORKSTATION assignment to a particular SELLING LOCATION within the retail enterprise.

WORKSTATION LOCATION TYPE

Lookup

Lookup for Type of WORK LOCATION.

WORKSTATION PERIOD END TRANSACTION

Base

A fiscal reporting period at a particular STORE WORKSTATION

WORKSTATION PERIOD START TRANSACTION

Base

A transaction that declares the start of a Reporting Period for the STORE WORKSTATION where it is conducted.

YEAR TRANSFORMATION

Reference

Transformations at the year level.