Table: vTargetMail

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   vTargetMail 
 Friendly name   vTargetMail 
 Table name   dbo_vTargetMail 
 Table type   View 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


No relationships exist

Collapse image Child relations


No relationships exist

Collapse image Columns


Name  Type  Computed column expression 
CustomerKey System.Int32  
GeographyKey System.Int32  
CustomerAlternateKey System.String  
Title System.String  
FirstName System.String  
MiddleName System.String  
LastName System.String  
NameStyle System.Boolean  
BirthDate System.DateTime  
MaritalStatus System.String  
Suffix System.String  
Gender System.String  
EmailAddress System.String  
YearlyIncome System.Decimal  
TotalChildren System.Byte  
NumberChildrenAtHome System.Byte  
EnglishEducation System.String  
SpanishEducation System.String  
FrenchEducation System.String  
EnglishOccupation System.String  
SpanishOccupation System.String  
FrenchOccupation System.String  
HouseOwnerFlag System.String  
NumberCarsOwned System.Byte  
AddressLine1 System.String  
AddressLine2 System.String  
Phone System.String  
DateFirstPurchase System.DateTime  
CommuteDistance System.String  
Region System.String  
Age System.Int32  
BikeBuyer System.Int32  
Total: 32 column(s)

Collapse image See also


About this documentation