CLIENT Table

Laboratory code.

Code for the client.

Full name of the client.

Client’s address.

Client’s state or district.

Client’s postal code.

Client’s country.

Client’s telephone number.

Client’s fax number.

Client’s email address.

Default priority for client’s work.

Default discount given to this client.

Notes for placing on client’s job profiles.

Invoice client's laboratory code, from the CLIENT table.

Code of the client to whom invoices are raised, from the CLIENT table.

Number of days for prompt payment discount to be applicable.

Addition percentage discount available to this client if the account is paid within the CLI_PPNUM number of days.

Indicates whether the client is currently active.

Currency conversion code from the INVCONVERSION table, used to generate invoices in other currencies for this client.

Cost code from COSTCENTRE table to which this work is allocated.

A user-defined accounting code. This may link to external accounting systems.

Name of the alternative CCLAS directory structure for invoice pricing.

The method of applying taxation for the client:

• NIL - No tax added
• SCH - Scheme based tax, where the tax is calculated per scheme, as per the SCHEME_TAX table
• CLI - Client based tax, where the tax is calculated for each tax specified for the client.

URL of a file containing notes on the client.

URL of a file containing an image of the client.

Manager of the accounting section within the client’s company.

Date-time that this client was used for job profiling.

Date-time of last visit to this client.

Date-time of last contact with this client.

URL of a file containing a report template for the client.

URL of a file containing data that is used with the report file to produce a report for the client.

+Client’s password for accessing CCLAS results, etc. from over the internet, for example.

Default terms of an invoice for this client.

Indicates whether the record is disabled, that is, whether it appears in selection lists, etc.

Line of business code for this client.