Sent

Remember a Sent is a subclass of AdEvent so it inherit all the fields from is super class (see AdEvent)

• tel

  if the coupon/mesage has been sent contains the "To"

  Alphanumeric

  255 characters max

• message

  textual bastract of the message sent (can be the full message for Sms)

  Alphanumeric

  255 characters max

• media

  Media use for sending (empty if no sending was completed)

  Alphanumeric

  20 characters max

• trackCode

  unique number used to query the coupon

  the number is constructed as following : 2 year digits, 3 digits for day of year, 3+2 random digits, 8 digits as a serial number, 3 digits for CRC

  do not change the value

• idProvider

  identify which provider send the message

  do not change the value

• providerTrackCode

  if the provider issue his own number it is stored there

  do not change the value

• campaign

  Campaign from which the message/coupon pertains

  see Campaign

• dateSent

  when it was sent

  datetime

• dateSchedule

  when it was scheduled for

  datetime