CustomerCommsPreference

Field Name Type Nullable? Comment
CustomerReference (PK) VARCHAR(20)    
CommsPreferenceCode (PK) VARCHAR    
CustomerLevel(PK) Enumeration CHAR  
  • A - Account
  • M - Agreeement
  • C - Corporate
  • G - Group
  • S - Subscription
IsOptedIn CHAR(1) Non Null Whether the customer has opted in to receive this type of communication.
AuditTimeStamp DateTime    
AuditUser      
AuditProcess