Entity Definition

Logical Name : ServiceItem
Physical Name : AS_ITM_SV

A type of ITEM that provides a detailed identifier and description for a service offered for sale to a customer in the retail store. This entity also identifies and describes rental items and other tangible items that are used by a customer for a contracted period of time but not purchased.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32)
FinancialLedgerAccountID (FK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)
ServiceTermsCode (FK) A retailer assigned uniquecide for the set of terms and conditions governing the sale or rental of the ServiceItem LU_TRM_SV Code2 char(2) ServiceTermsAndConditions(CO_TRMCD_SV)
TypeCode A code to denote the type of SERVICE ITEM. TY_ITM_SV Code2 char(2)
BaseCostAmount The base cost amount of the SERVICE ITEM. This cost excludes all promotional allowances. CP_BS_SV_ITM Money decimal(16,5)
NetCostAmount The net cost price of the SERVCE ITEM. this cost includes all promotional allowances. CP_NT_SV_ITM Money decimal(16,5)
CostsEstablishedDate The effective date of the current cost price for the SERVICE ITEM. DC_CST_EST_SV_ITM DateCalendar date


Parent Entity Verb Phrase Child Entity
ServiceTermsAndConditions governs ServiceItem
FinancialLedgerAccount defines accounting disposition of ServiceItem
ServiceItem is performed by ServiceItemProvider
ServiceItem is extended for rental by RentalServiceTerms
Item can be a ServiceItem
ServiceItem can be a RentalServiceTerms
ServiceItem can be a MiscellaneousFee

Logical Views containing ServiceItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01020 - Item Description - Enterprise View
Logical 01040 - Item Description - Rental View
Logical 01100 - Item Selling Rules - Macro View
Logical 01500 - Item Supplier View
Logical 01501 - Item Unit of Measure Types
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02370 - Retail Transaction - Rental View
Logical 05300 - Taxation - Inventory Control Document View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View
Logical 21000 - Fresh Item Management Macro View