System information

The following fields are defined:
ID: autoincrement database primary key
Type:
0=All or Recreate (technical)
1=Report
2=Proform
3=Advance
4=Invoice
5= CreditNote
6=Storno
7=Correction
8=Payment (technical: payment received)
Copynum: printed copies
CompanyID: emmitent company ID (tb_billsources)
UserID: costumer ID from tb_users (if any)
User_name: costumer name or company name
User_address: costumer address
User_regnum: costumer registration number
User_euregnum: costumer eu registration number
User_bank: consumer bankdetails (cont and address)
Payment_type: mode of the payment (Ex: bank-transfer)
Datum: record date-time
Invoicenum: the number of the invoice
Invoiceid: deprecated
Invoicefrom: billing period begin time
Invoiceuntill: billing period endtime
Invoicegenerated: invoice print time (optional)
Invoicesent: invoice sent time (optional)
Completitiondate: completition date
Duedate: payment due date
Language: invoice language
Vat: VAT percent
VatValue: sum of VAT
InvoicePrice_Net: final net price
InvoicePrice: final price
PaymentReceived: date-time of the payment
Debt: sum of all debt
Pending: all sum before due date
Comment: invoice comment
InvoiceImage: saved ivoice file