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