Commissions Table Reference- SatTracker-satellite commission and customer management Overview

Commissions Table Reference

SatTracker stores the following information about Commissions (Please note, for the best reference on this table check the dish network web site):

RefNum: The dish network reference number, e.g. 80100606.
PayDate: The date Dish network pays the dish vendor.
PayMeth: How you are paid; e.g. EFT = Electronic Fund Transfer.
PayType: A classification of what you are being paid for, e.g. RESIDUAL.
InvoiceNum: A concatenation of several fields, e.g. E51 2190 RESIDUAL 31-JUL-99.
InvoiceDate: A date that always seems to be in the neighborhood of the Pay Date.
SerialNum: This field identifies the receiver, it's the equivalent of Receiver Serial.
CANum: This field identifies the receiver, it's the equivalent of Receiver ID..
SubscriberAccnt: Perhaps this number can be used when calling up Dish Network for information. A typical value is: 8255909442072465
dontcare01: A field that is always 0.
Activated: The date dish network activated the customer account.
Qualified: The date dish network qualified the customer. It tends to be the same date as Activated.
Disqualified: The date the customer was disqualified. It is left blank if the customer has not been disqualified.
Paid: The amount paid (or debited) for residuals, commissions, bonuses, disqualifies, deactivations, etc..
Description: An elaboration on the PayType field, with more information.
PeriodEnd: The date of the weekly pay period.
dontcare02: A field that is always 0.
dontcare03: A field that is always 0.
Freq: How often the commission or residual is paid.
St: The customer's state. Presumably to aid in customer identification.
Zip: The customer's zip code. Presumably to aid in customer identification.
Processed: An internal field, not currently used.