INVOICE Table
Contains invoices.
Field | Data Type | Description |
---|---|---|
LABCODE |
Variable string (10) |
Laboratory code. |
INVOICENO |
Variable string (20) |
Code for the invoice. |
INVOICED |
Date-time |
Date-time of invoice creation. |
NOSAMPLES |
Integer |
Number of samples invoiced. |
AMOUNT |
Real |
Total amount invoiced, in the base currency. |
AMOUNTDISC |
Real |
Total amount of discount given on this invoice. |
DISCOUNT |
Real |
Percentage discount applied to the invoice. |
CREDITNO |
Variable string (20) |
Associated credit number. Only applicable where a credit note is raised on the invoice. |
CONV_CODE |
Variable string (20) |
Conversion code of the invoice, where the invoice is in a currency different to the laboratory's base currency. |
FACTOR |
Real |
Conversion rate from the base currency. |
CONVDATE |
Date-time |
Date-time the conversion rate was set. |
TAXAMOUNT |
Real |
Amount of tax on the invoice. |
SUMMARISED |
Boolean |
Indicates whether the invoice was created with grand totals only. |
TRANSMITTED |
Date-time |
Date-time the invoice was printed or transmitted. |
NOTESFILE |
Variable string (80) |
URL of a file containing notes on the invoice. |
CINV_LABCODE |
Variable string (10) |
Code of the invoiced client's laboratory, from the CLIENT table. |
CLI_INV |
Variable string (40) |
Code of the invoiced client, from the CLIENT table. |
INVAMOUNT |
Real |
Total invoiced amount. |
Primary key
LABCODE + INVOICENO