Entity Definition

Logical Name : CustomerOrderAccount
Physical Name : LE_CT_ORD_ACNT

A type of CustomerAccount established when a customer places an order with the retailer and chooses to persist their contact information and a method of payment. This type of account does NOT extend credit it simply provides a pre-established collection of customer data to make ordering easier. It also provides the basis for tracking multiple orders for a customer

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
DefaultShipTo (FK) A token identifier for a PartyContactMethod entity type instance. ID_PRTY_CNCT_MTH Identity integer PartyContactMethod(CO_MTH_CNCT_PTY)


Parent Entity Verb Phrase Child Entity
PartyContactMethod is default for CustomerOrderAccount
CustomerOrderAccount places CustomerOrder
CustomerOrderAccount is billed by CustomerAccountInvoice

Logical Views containing CustomerOrderAccount

Logical View
Logical 07010 - Customer Account Information Extended