Payment Table Reference
SatTracker stores the following information about Payments:
CustomerId:
The number that uniquely identifies a
customer
. This number is used to link Payment records to Customer records. Stored as a long integer.
OrderDate:
This field is used to tie the payment record to an
order
. Stored as a date.
PaymentAmount:
The amount paid by the customer.
PaymentMethod:
What the customer used to make the payment, e.g. Cash, Check, Charge.
PaymentDate:
The date the payment was made; this is almost always going to be greater than the order date.
CreditCardType:
The type of credit card used for the payment. Stored as text field containing up to 10 characters.
CreditCardNumber:
The credit card numbers used for the payment. Stored as text field containing up to 30 characters.
CreditCardExpDate:
The expiration date of the credit card used for the payment. Stored as a text field of up to 10 characters.
CardholdersName:
The owner of the credit card. Stored as a text field of up to 50 characters.
CheckNumber:
The date of the check used for the payment. Stored as a text field of up to 32 characters.
Authorization:
The credit card authorization number. Stored as a text field of up to 12 characters.