Entity Definition

Logical Name : CustomerRentalAccount
Physical Name : LE_ACNT_CT_RNT

A sub-type of CustomerAccount that records details of the customer as a rentor of RentalService items. It is important to keep in mind that this entity is only intended to support retailer rentals of items on a short term basis. It is not designed to handle real estate rentals or long-term equipment rentals. Both of these kinds of rentals are deemed non-retail businesses.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
RentalDepositAmount A deposit amount paid by the customer as part of setting up a rental account. The RentalDepositAmount is typically used to offset the total rent due upon return of the rented item. MO_RNT_DS_AMT Money decimal(16,5)
RentalPeriodStartDateTime The date and time a rental period begins. For some items (e.g. suba gear, specialty auto tools, etc.) a rental period may be hours and minutes. For other kinds of rented items the period might be days or weeks. DT_RNT_PRD_SRT_DT_TM DateTime datetime
LateReturnFeePerPeriodAmount The late fee charged per rental period when an item is returned late. MO_LT_RTN_FE_PR_PRD_AMT Money decimal(16,5)
MinimumLateReturnFeeAmount A minimum flat late return fee. MO_MNM_LT_RTN_FE_AMT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
CustomerRentalAccount activity is summarized in CustomerRentalAccountHistory
CustomerRentalAccount is renter of RetailTransactionRentalModifier
CustomerAccount can be a CustomerRentalAccount

Logical Views containing CustomerRentalAccount

Logical View
Logical 02370 - Retail Transaction - Rental View
Logical 07010 - Customer Account Information Extended