CCPEINVESTVIEW

The price schedule's aggregate flag.

The associated analyte code, for analyte-based pricing items.

The number of analytes involved; or 0 when analyte count is irrelevant.

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 associated analyte's laboratory scope. Redundant column; the value is always the same as JOB_LAB_CODE.

The associated sample scheme analyte's workflow status, for analyte-based pricing items.

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

The price schedule item's block size.

The associated client code.

The associated client's laboratory scope.

The price book's currency.

The price code's description.

The associated invoice number.

Line item type. It is 'B' for base price items, and 'I' for block price items.

The associated job code, or blank for combined-pricing invoices.

The associated job invoice sequence, or 0 for combined-pricing invoices.

The associated job's laboratory scope.

The associated job scheme's number of units.

Laboratory scope.

An internal value used to match against UP_TO.

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

As per NOTE. Redundant column.

Organisation scope.

The currency's precision.

The price schedule item's block price or job scheme's fixed block price, or 0 for base price items.

The associated price book's laboratory scope.

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

The associated price catalogue.

The associated price code.

The associated price code's laboratory scope.

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

Used internally for disambiguation purposes only.

The associated quote code.

Either the quote's scheme/analyte discount, the quote's generic discount, or the job invoice's generic discount.

The associated quote's laboratory scope.

The number of samples involved.

A calculated price based on the price schedule item that is used to determine the line item total.

The associated scheme code; or blank for package-pricing.

The associated scheme's laboratory scope; or blank for package-pricing.

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

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

Always 0. Legacy column.

The associated split code.

The associated split code's laboratory scope.

The associated split's percentage adjustment.

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.