Entity Definition

Logical Name : RetailStoreCustomer
Physical Name : PA_CLNT_RTL_STR

A record of which RetailStores a particular Customer has used.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
CustomerID (FK)(PK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
ClienteleID An alternate ID assigned to a clienteling customer. ID_CLNT_RTL Identity integer


Parent Entity Verb Phrase Child Entity
Customer has used RetailStoreCustomer
RetailStore has clients of RetailStoreCustomer

Logical Views containing RetailStoreCustomer

Logical View
Logical 07010 - Customer Account Information Extended