Customer Table Reference SatTracker-satellite commission and customer management Overview

Customer Table Reference

SatTracker stores the following information about customers:

CustomerId: The number that uniquely identifies a customer. This is an 'auto number' field, meaning it is automatically set when you create a new customer record. You cannot change this field.
LastName: The Last Name of the customer. Stored as a text field containing up to 40 characters.
FirstName: The First Name of the customer. Stored as a text field containing up to 60 characters.
Street1: The customer home (or shipping) address. Stored as a text field containing up to 80 characters.
Street2: The customer billing address. Stored as a text field containing up to 80 characters.
City1: The customer home (or shipping) city. Stored as a text field containing up to 40 characters.
City2: The customer billing city. Stored as a text field containing up to 40 characters.
State1: The customer home (or shipping) state. You really should use the two character state abbreviation. Stored as a text field containing up to 4 characters. NOTE: if State2 is blank, this state is used to determine if sales tax is applicable.
State2: The customer billing state. You really should use the two character state abbreviation. Stored as a text field containing up to 4 characters. NOTE: this is the first state chosen when determining if sales tax is applicable. If blank, State1 is used.
Zip1: The customer home (or shipping) zip code. Stored as a text field containing up to 12 characters.
Zip2: The customer billing zip code. Stored as a text field containing up to 12 characters.
Phone1: One of two phone numbers you can track. Stored as a text field containing up to 32 characters.
Phone2: A second phone number. You can put any additional phone numbers in the comments or alerts fields. Stored as a text field containing up to 32 characters.
CardType: The default credit card type for the customer. When a payment record is entered, and credit card information is left blank, this information is automatically inserted into the payment record. A list of credit card types, and input masks for the credit card number, are kept in the CreditCardTypes table, which you can view using the Credit Card Form. Stored as text field containing up to 10 characters.
CreditCard: The default credit card number for the customer. When a payment record is entered, and credit card information is left blank, this information is automatically inserted into the payment record. Stored as a text field containing up to 20 characters.
Exp: The default credit card expiration date for the customer. When a payment record is entered, and credit card information is blank, this information is automatically inserted into the payment record. Stored as a text field containing up to 10 characters.
Directions: How to get to the customer. This information is displayed on work orders, which you can print from the Orders and the Order Summaries forms. Stored as a memo field, meaning you can type about as much as humanly possible and never hit the limit.
Comments: Any comments you may wish to make. Stored as a memo field, meaning you can type about as much as humanly possible and never hit the limit.
FileId: If you utilize our "Convert Ascii data into a SatTracker database" service, we keep the original data in a set of files. These files are named in the "ImportedFiles" table. This is an index into that table. It is used when you press the Orig button in the customer form. See StartIndex and EndIndex following. Stored as a byte (a number between 0 and 255).
StartIndex: The starting location of the saved ascii customer information in the file. Stored as a long integer.
EndIndex: The ending location of the saved ascii customer information in the file. Stored as a long integer.
OurSystem: Used to indicate that it is your customer, as opposed to a service-only type situation. Stored as a yes/no field.
Active: Not currently used. Stored as a yes/no field.
DateCreated: The date the customer record was created. Stored as a date.
Alerts: Any special alerts you may have for the customer. It is displayed in red on the customer form. Stored as a memo field, meaning you can type about as much as humanly possible and never hit the limit.
SalesTaxExemptionNumber: If this field is non-blank, no sales tax is applied to orders, even if the customer is in the same state you are. Stored as a text field containing up to 20 characters.
ClaimNumber: A telemarketing related field, containing the number Dish network gives you to indicate a potential lead has been approved. Stored as a text field containing up to 80 characters.
LeadNotes: A telemarketing related field, containing any notes pertaining to the lead. Stored as a memo field, meaning you can type about as much as humanly possible and never hit the limit.
LeadSource: A telemarketing related field, indicating where the lead was generated. A list of Lead Sources is stored in the "LeadSources" table. Example lead sources are "Trade Show", "Cold Call", and "Walk-In". Stored as a text field containing up to 80 characters.
Telemarketer: A telemarketing related field, containing the name of the telemarketer. A list of Telemarketer names is stored in the Telemarketers table. Stored as a text field containing up to 80 characters.
SocialSecurityNo: The social security number of the customer. Stored as a text field of up to 20 characters.
ContactDate: A telemarketing related field, containing the date contact was made with the lead. Stored as a date.
Prospect: A telemarketing related field, indicates if the customer has not yet been approved. Stored as a yes/no field.
LeadPaidDate: A telemarketing related field, containing the date the telemarketer was paid. Stored as a date.