Entity Definition

Logical Name : RentalUnit
Physical Name : ID_UN_RNT

A SerializedUnit that is rented out by the retailer for customers to use, It is NOT part of a retailer's inventory but is considered a kind of fixed asset. Rental revenue is service income.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SerialNumber (FK)(PK) A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. ID_NMB_SRZ Name varchar(40) SerializedUnit(AS_UN_SRZ)
SerializedUnitItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_SRZ IdentityUUID char(32) SerializedUnit(AS_UN_SRZ)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) RentalServiceTerms(AS_SV_RNT)
RentalStandardContractID (FK)(PK) Identifies an instance of a RentalStandardContract ID_RNT_STD_CNTRT Identity integer RentalServiceTerms(AS_SV_RNT)
InServiceDate The date a RentalUnit is available to be rented to customers. DC_IN_SV_DT DateCalendar date
OutOfServiceDate The date a RentalUnit is taken out of service and may no longer be rented to customers DC_OT_OF_SV_DT DateCalendar date
StatusCode A code that designates the current state of a RentalUnit instance. A = Available for rent R = Rented (rented out unvail) D = Damaged (damaged unavail) L = Lost (stolen, damaged beyond repair, unavail) There may be additional codes required for particular retail rental scenarios. CD_STS Code2Status char(2)
EstimatedLifetimeRentalCount The estimated lifetime number of times this RentalUnit can be rented to customers before it has to be taken out of circulation due to wear, obsolescence, safety problems, etc. QU_ESTM_RNT_CNT QuantityInteger integer
ActualRentalCount The actual lifetime count of the number of times this RentalUnit has been rented out. This is important since some RentalUnits ( like VCR media, DVD's, garden equipment, tooling, etc.) may have finite usage count before they become unserviceable for rental purposes. QU_ACT_RNT_CNT QuantityInteger integer


Parent Entity Verb Phrase Child Entity
RentalServiceTerms applies to RentalUnit
SerializedUnit is a RentalUnit
RentalUnit is rented through RentalModifier

Logical Views containing RentalUnit

Logical View
Logical 01040 - Item Description - Rental View
Logical 02370 - Retail Transaction - Rental View
Logical 21000 - Fresh Item Management Macro View