CustomerCommsProfile

Field Name Type Nullable? Comment
CustomerLevel (PK) VARCHAR(20)    
CustomerReference (PK) VARCHAR(30)    
TimeExclusionStart DateTime    
TimeExclusionEnd DateTime    
LangaugeDTC (FK) CHAR(3) Non Null  
LanguageDTG (FK) CHAR(3) Non Null  
CommsDeliveryMethodCode (FK) Enumeration VARCHAR(10)  
  • LETTER
  • EMAIL
  • PUSH
  • SMS
  • EXTERNAL
  • ONLINE

 

AuditTimeStamp DateTime    
AuditUser      
AuditProcess      
ParticularRequirementDTC (FK)      
ParticularRequirementDTG (FK)