id

X

X

X

 invoice_date

X

X

X

 due_date

X

X

X

 reminder_date_1

X

X

X

 reminder_date_2

X

X

X

 payed_date

X

X

X

 payed

X

X

X

 number

X

X

X

 client_id

X

X

 credit_of_id

X

X

 status

X

1 = Open

2 = To be invoiced

8 = Has been invoiced

9 = Deleted

X

X

 ocr

X

X

 total

X

X

X

 net_amount

X

X

X

 vat_amount

X

X

X

 discount

X

X

X

 discount_vat

X

X

X

 invoicefee_amount

X

X

 type

X

X

X

 deleted

X

X

X

 address

X

X

X

 city

X

X

X

 coaddress

X

X

 clientname

X

X

X

 reference

X

X

 reference_name

X

X

 iscompany

X

X

 company_name

X

X

X

 company_address

X

X

 company_postalcode

X

X

 company_city

X

X

 company_phone

X

X

 company_email

X

X

 company_www

X

X

 company_bg

X

X

 company_pg

X

X

 company_orgnbr

X

X

X

 ruttext

X

X

 rottext

X

X

 workarea_name

 (Area connected to invoice address)

X

X

 hourpot_balance

X

X

 hourpot_change

X

X

 credited

X

X

X

 penny_margin

X

X

 payment_type

X

X

X

 payment_terms

X

X

X

 taxreduction

X

X

 invoicetext

X

X

 clientaddress_id

X

X

X

 postal_code

X

X

X

 client_number

X

X

X