Orders Table Reference
CustomerId:
This number is used to link Orders to Customer Records. It is set
automatically when an order is created, whether explicitly (by pressing the
'New' button on the
Orders Form
or by adding a receiver, program subscription, product or service, or a
payment to the customer. This information is stored as a long integer.
SalesPerson:
The name of the person taking the order. This information is stored as a
text field of up to 50 characters.
Technicians:
The name of the installers. This information is stored as a text field of up
to 50 characters.
OrderDate:
The date of the order. See
How do I take an order
for more information. This information is stored as a date.
PurchaseOrderNumber:
For your use, if you choose to utilize purchase orders. This information is
stored as a text field of up to 20 characters.
SalesTaxRate:
This number is determined by comparing the company state (from
settings
) to
State2
of the customer (the billing address); if State2 is blank then State1 is used.
If the customer state matches the company state, then the sales tax rate from
the settings is used, otherwise the sales tax is 0. Secondly, if the
SalesTaxExemptionNumber (in the Misc. Tab in the
CustomerForm
) is non blank, then the sales tax rate is 0.
NOTE
: you can override the calculated sales tax by entering a value in this field.
Further note that sales tax must be entered either as a decimal number; e.g.
.05 = 5%, or as a number followed by the percent sign, e.g. 8.25% = .0825.
This value is recalculated whenever you edit the state in the customer form.
This field is stored as a double precision floating point number.
DateCompleted:
The date the order was actually carried out. SatTracker does not use this
information, it is for your records. This information is stored as a date.
ServiceRequest:
What the customer wants. This information is stored as a memo field of
unlimited length.
Service:
This is for your records; it indicates a service/only order. This information
is stored as a yes/no field.
DatePromised:
This is for your records, and for prioritizing service calls. This
information is stored as a date.
ServicePerformed:
What the customer got. This information is stored as a memo field of
unlimited length.
DepositCheckNumber:
For your records; if the customer left a deposit you can record the check
number. This information is stored as a text field of up to 20 characters.
DepositDate:
For your records; the date the deposit was made. This information is stored
as a date.
DepositAmount:
The amount of the deposit. This value is used in calculating the Amount Due
in the order; it is presumed you keep the deposit check. If you don't cash the
check, remember to clear this amount in the order. This information is stored
as a double precision floating point number.
Discount:
Any discount you elect to give the customer. This value is used in
calculating the OrderTotal. It is NOT a discount percentage. This information
is stored as a double precision floating point number.
TaxableTotal:
The total value of all taxable items in the order. This is the sum of the
costs of all Service, Receiver, and Programming records whose CustomerID and
OrderDate match the order being calculated, and are taxable. You mark an item
as taxable or not taxable by opening the
Service Form
and double clicking on "what". This brings up the 'products' form, which
contains the product name, it's cost, and if it is taxable. This field is
calculated and may not be changed by the user. This information is stored as a
double precision floating point number.
NotTaxableTotal:
The total value of all non-taxable items in the order. This is the sum of
the costs of all Service, Receiver, and Programming records whose CustomerID
and OrderDate match the order being calculated, and are non-taxable. This
field is calculated and may not be changed by the user. This information is
stored as a double precision floating point number.
SalesTax:
The
Taxable Total
multiplied by the
Sales Tax Rate
. This field is calculated and may not be changed by the user. This
information is stored as a double precision floating point number.
OrderTotal:
TaxableTotal
+
NotTaxableTotal
+
Discount
. This field is calculated and may not be changed by the user. This
information is stored as a double precision floating point number.
Payments:
The sum of all
payments
for the specified customer for the order date of this order. This field is
calculated and may not be changed by the user. This information is stored as
a double precision floating point number.
AmountDue:
The OrderTotal - Payments - Deposit - Discount. This field is calculated
and may not be changed by the user. This information is stored as a double
precision floating point number.
OrderHas:
When an order is recalculated, this field is updated to show the components
of the order. An order with programming, receivers, and service would contain
"Rcv, Pgm, Svc" in OrderHas. When you double click "OrderHas" in the
Order Summary Form
, the forms corresponding to these abbreviations are opened. This information
is stored as a text field of up to 20 characters.
OldPayType:
not used. This information is stored as a text field of up to 50 characters.
ReferenceCount:
This is the sum of all Receiver, Service, Programming and Payment records
matching whose customer id's and order dates match this order. It is used to
determine if an order table entry should be deleted. If the reference count is
zero, and the ServiceRequest and Service fields are blank, the order is deleted.
Have Questions? Email Us !
Copyright Mathes Future Products, 2000, all rights reserved
Page last updated: Wednesday, July 19, 2000