Entity Definition

Logical Name : PartyAffiliationType
Physical Name : CO_TYP_PRTY_AFLN

A type code defining a potential relationship between two Partys that has some meaning to the retailer. The value list is determined by the retailer. PartyAffiliationType may include a wide range of associations like: HOUSEHOLD-CUSTOMER FAMILY-INDIVIDUAL EMPLOYEE-EMPLOYER ONLINE COMMUNITY-PARTICIPANT PATIENT-DOCTOR UNION-MEMBER CHARITY-DONOR PROCESSOR and lots more.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PartyAffiliationTypeCode (PK) A unique retailer assigned code denoting the type of affiliation between two Partys. CD_TYP_PRTY_AFLN Code varchar(20)
Description A human readable description of the Party Affiliation reason. DE_TYP_PRTY_AFLN DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
PartyAffiliationType categorizes PartyAffiliation

Logical Views containing PartyAffiliationType

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics