Entity Definition

Logical Name : CustomerAffiliation
Physical Name : CO_CTAF

Associates a customer with a customer group.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerGroupID (FK)(PK) A unique identification number assigned to a customer group ID_GP_ID Identity integer CustomerGroup(PA_GP_CT)
CustomerID (FK)(PK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer KeyCustomer(PA_KY_CT)
IdentityVerifyRequiredFlag A flag to denote whether the CUSTOMER's identity has been verified as belonging to the CUSTOMER AFFILIATION scheme. FL_IDN_CTAF_VR_RQ Flag integer
EffectiveDate Date this CustomerAffiliation is active DC_EF EffectiveDate date
ExpirationDate Date this CustomerAffiliation is inactive DC_EP ExpirationDate date
StatusCode Current status of this CustomerAffiliation. Values: I = Inactive A = Active CD_STS Code2Status char(2)


Parent Entity Verb Phrase Child Entity
KeyCustomer is a member of CustomerAffiliation
CustomerGroup is composed of CustomerAffiliation

Logical Views containing CustomerAffiliation

Logical View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 06310 - Party - Role View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended