CommsRequestTargetDetail

Field Name Type Nullable? Comment
CommsRequestID (PK/FK)     Autogenerated
CommsDeliveryMethodCode (FK)   Non Null  
CustomerReference      
CustomerLevel Enumeration CHAR  
  • A - Account
  • M - Agreeement
  • C - Corporate
  • G - Group
  • S - Subscription
ExcludedUntilDateTime TIMESTAMP Nullable  
TargetRequestStatus Enumeration CHAR(1) Non Null
  • N - Normal
  • E - Error
PrimarySerialNumber VARCHAR (25) Nullable  
ToEmail VARCHAR(90) Nullable  
ErrorEventNumber Numeric(9) Nullable  
AuditProcess      
AuditTimeStamp DateTime    
AuditUser      
LanguageDTC (FK) CHAR(3) Non Null  
LanguageDTG (FK) CHAR(3) Non Null  
CommsExternalTargetDTC CHAR(20) Nullable  
CommsExternalTargetDTG CHAR(20) Nullable  
CustomerCommsProfileCustomerLevel (FK) Enumeration CHAR  
  • A - Account
  • M - Agreeement
  • C - Corporate
  • G - Group
  • S - Subscription
CustomerCommsProfileCustomerReference (FK)      
DeliveryAddressNumber