Entity Definition

Logical Name : DevicePrice
Physical Name : CO_PRC_DVC

The current mapping between the system ItemPrice and a FuelingPoint device specific identifier used to identify a retail unit price.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer FuelingPoint(AS_PNT_FUEL)
FuelingPointID (FK)(PK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer FuelingPoint(AS_PNT_FUEL)
DevicePriceID (PK) The devicePriceID used by the FuelingPoint to identifiy the retail price. ID_PRC_DVC Identity integer
ItemPriceID (FK) A unique identifier for the ItemPrice. ID_PRC_ITM Identity integer FuelItemPrice(CO_PRC_ITM)


Parent Entity Verb Phrase Child Entity
FuelingPoint has price set by DevicePrice
FuelItemPrice is assigned to DevicePrice

Logical Views containing DevicePrice

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20020 - Forecourt Pricing View