Entity Definition

Logical Name : ServiceItemProvider
Physical Name : PA_PVR_SV_ITM

The association between a SERVICE ITEM sold by a retail store and the third party SERVICE PROVIDER who actually performs the service.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ServiceProviderID (FK)(PK) A unique system assigned identifier for the Service Provider. ID_PVR_SV Identity integer ServiceProvider(PA_PVR_SV)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) ServiceItem(AS_ITM_SV)
UnitOfServiceCode A code to denote the type of service provided by the SUPPLIER. LU_UN_OF_SV_PVR Code2 char(2)
UnitOfServiceAmount The retail amount of each unit of service offered by the service provider. MO_UN_OF_SV_PVR MoneyShortRetail decimal(7,2)


Parent Entity Verb Phrase Child Entity
ServiceItem is performed by ServiceItemProvider
ServiceProvider performs ServiceItemProvider

Logical Views containing ServiceItemProvider

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01500 - Item Supplier View