CCINVOICEITEM

The related analyte code for analyte-based pricing. Part of the table's business key.

The number of analytes involved; or 0 when analyte count is irrelevant. Part of the table's business key.

The value displayed in the number of analytes column. This could either display the actual number of analytes, or the job scheme's number of units.

The price schedule's base price, or 0 for block price items.

The price schedule item's block size.

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

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

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.

The price book's currency.

Footer notes for a line item, for invoices from edited status onwards.

Header notes for a line item, for invoices from edited status onwards.

A generated sequence number. Part of the table's business key.

The associated invoice number. Part of the table's business key.

A boolean flag to indicate manually-added line items.

Line item type. It is 'B' for base price items, and 'I' for block price items. Other values are possible, but they are for internal use only. Part of the table's business key.

A boolean flag to indicate that the line item was added as a miscellaneous item (via the Misc tab).

The associated job code, or blank for combined-pricing invoices. Part of the table's business key.

The associated job invoice sequence, or 0 for combined-pricing invoices. Part of the table's business key.

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.

The price schedule's base item or block item notes (specific to client's locale, defaulting to English).

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

The associated split's percentage adjustment (i.e. the split percentage).

The currency's precision.

The associated price code.

The associated price code's laboratory scope.

Used internally for disambiguation purposes only. Part of the table's business key.

The number of samples involved.

The associated scheme code; or blank for package-pricing. Part of the table's business key.

The associated scheme's laboratory scope; or blank for package-pricing. Part of the table's business key.

The associated scheme's price type, of type PriceType enumeration; or blank for package-pricing.

The associated scheme's type, of type SchemeType enumeration.

The sort order of line items within the invoice. Numbers are not guaranteed to be consecutive.

The associated split code.

The line item's total, with any applicable discounts, splits, min/max prices applied.

The number of chargeable units/items involved. This is usually the number of involved samples or 1, depending on the price type.

The calculated price per unit/item, calculated from the relevant price schedule.