Entity Definition

Logical Name : CustomerServiceWorkOrderAccount
Physical Name : LE_CT_SV_WRK_ORD_ACNT

A customer account type created to track initial deposit, payment, refund and other financial actions related to delivering a service to a customer. For example customer A purchases a garage door from retailer X. The customer pays for the garage door. In addition the customer pays a deposit of $100 for installation service ( work order) . Upon completion of the installation the customer pays the remaining balance for the service of $200. This entity captures the initial deposit and susbequent payment. It also links them to a work order (or potentially a PO if the installer is an outside firm.)

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
ServiceProviderID (FK) A unique system assigned identifier for the Service Provider. ID_PVR_SV Identity integer ServiceProvider(PA_PVR_SV)
WorkOrderNumber A unique number used to identify the work order document associated with this CustomerServiceWorkOrder,. AI_WRK_ORD IdentityAlphaNumeric varchar(20)
WorkOrderDepositAmount The amount of money a customer pays to secure a service. It is typically a prepayment and is subtracted from the final invoice amount for the service provided MO_WRK_ORD_DS_AMT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
ServiceProvider charges services to CustomerServiceWorkOrderAccount

Logical Views containing CustomerServiceWorkOrderAccount

Logical View
Logical 07010 - Customer Account Information Extended