billid

Unique ID

billamount

How much to bill each interval

billnextbilldate

The date to start the billing

billcustomer

Customer’s name

billemail

E-mail address of the customer

billdescription

The description of what the bill is for such as the product or service

billinstallments

A number representing the number of installments. For example 12 will mean that this customer should be billed 12 times.

billinstallmenttype

One of the following words: Day, week, Month, Year

For example if Month is in this field, the person will be billed once per month for 12 months.

billinterval

A number, which is the interval between bills in the same units as above.

billcreationdate

Date you are creating this billing record

billenddate

Optional. The last date for which a bill should be sent out. If not supplied VPCart stops sending bills when the installments are completed.

billorderid

It is the original order that caused this billing record to be created

billlastmaildate

The date the last bill was sent out

billsentcount

The number of e-mail bills that have been sent to the customer

billcanceled

If True, then the merchant has decided to stop sending bills to the customer

billcompleted

If true, it means that this billing record is no longer used since all installment e-mails have been sent. It is normally set by VPCART automatically after the last installment is sent

billcreationdate

The date this billing record itself was created.

billorderitemid

The record number in the oitems table for the original order that created the billing record

billenddate

Used to stop billing at a certain date regardless of whether the number of installments has been reached. Normally this field would not be used

billtemplate

Optional. Used to specific a unique mailing template for bills generated from this billing record

billother1

Unused

billother2

Unused