Provider Table Reference

---

SatTracker stores the following information about Providers:

• CustomerId: The number that uniquely identifies a customer. This number is used to link Program Provider records to Customer records. Stored as a long integer.
  
  
• OrderDate: This field is used to tie the Program Provide record to an order. It is automatically set to the latest order date of the customer; if there is no such date then today's date is used. If no order is found containing the order date and the customer id, a new order is automatically created. Stored as a date.
  
  
• ProviderName: The name of the program provider. Stored as a text field of up to 80 characters.
  
  
• ProviderPackage: The name of the programming package. Stored as a text field with up to 50 characters.
  
  
• ProviderWasPaid: The amount the program provider was paid for the programming package. Stored as a Currency field.
  
  
• ProviderPaidOn: The date the provider was paid on. This date, and the duration specification (below) are used in the Provider Renewal Report.
  
  
• Duration: The period until the programming expires. Enter this value as a number followed by either something starting with 'M' or something starting with 'Y'.
  • 1 mo
  • 1m 3 y
  • 3 yr 15 m
  • this would NOT work: y3 4m.
  
  The duration field is used in the Provider Renewal Report. Stored a Text field of up to 16 characters.