CCJOBINVOICE

The associated client code. Part of the table's business key.

The associated client's laboratory scope. Part of the table's business key.

The associated contact code.

Record's creation date as a string in YYMMDD format.

Record's creation time as a string in HHMMSS format.

Record was created by this user.

Job invoice's description.

An invoice discount percentage that is applied to the pricing items, initially inherited from either the client or the project.

A discount percentage that is applied to the whole invoice, on top of any line item discount.

The currency to use.

The associated invoice's laboratory scope. Legacy column; please use JOB_LAB_CODE instead.

The generated invoice number.

A boolean flag to indicate whether a job invoice is active or not.

A boolean flag to mark a job invoice as the primary job invoice within an invoice. Primarily used for merged invoices.

The associated job code. Part of the table's business key.

An incrementing number for job invoices within a job. Part of the table's business key.

The associated job's laboratory scope. Part of the table's business key.

Record's last modification date as a string in YYMMDD format.

Record's last modification time as a string in HHMMSS format.

Record was last modified by this user.

Organisation scope. Part of the table's business key.

The associated price book.

The associated price book's laboratory scope.

The associated price book's sequence within its price catalogue.

The associated project code.

The associated quote code.

The associated quote's laboratory scope.

A boolean flag to indicate whether modifications to a job invoice's samples and tests should be allowed or not.

An incrementing number for job invoices within a job.

The associated split code.

The associated split code's laboratory scope.