FuelItemPrice

Entity Definition

Logical Name : FuelItemPrice
Physical Name : CO_PRC_ITM

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

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemPriceID (PK) A unique identifier for the ItemPrice. ID_PRC_ITM Identity integer
ServiceLevelID (FK) A unique identifier for the service level for which this FuelItemPrice is valid ID_LV_SV Identity integer FuelServiceLevel(CO_LV_SV)
PriceLevelID (FK) A unique identifier for the price level for which this FuelItemPrice is valid ID_LV_PRC Identity integer FuelPriceLevel(CO_LV_PRC)
TimeGroupID (FK) A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
Name A descriptive short name that people use to identify the ItemPrice NM_PRC_ITM Name varchar(40)
StatusCode The current status of the ItemPrice entry. Possible values include Active, InActive and Pending. SC_ITM_PRC Code2Status char(2)
EffectiveDateTime The calendar day this ItemPrice becomes active EF_PRC_ITM EffectiveDateTime datetime
ExpirationDateTime The calendar day this ItemPrice becomes inactive EP_PRC_ITM ExpirationDateTime datetime
RetailPrice The price per unit for this FuelItem when all the other parameters have been satisfied. MO_PRC_ITM MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
FuelServiceLevel uses FuelItemPrice
FuelPriceLevel uses FuelItemPrice
Item has price defined by FuelItemPrice
TimeGroup uses FuelItemPrice
FuelItemPrice is assigned to DevicePrice
FuelItemPrice is used by FuelingTransaction

Logical Views containing FuelItemPrice

Logical View
Logical 06500 - Time Groups View
Logical 20000 - Forecourt Macro View
Logical 20020 - Forecourt Pricing View
Logical 20030 - Forecourt Transaction View