CCPEINVWIPVIEW
|
Column name |
Data type |
Char length |
Comment |
|---|---|---|---|
|
AGGREGATE |
CHAR |
1 |
The price schedule's aggregate flag. |
|
ANALYTE_CODE |
VARCHAR2 |
20 |
The associated analyte code, for analyte-based pricing items. |
|
ANALYTE_COUNT |
NUMBER |
0 |
The number of analytes involved; or 0 when analyte count is irrelevant. |
|
ANALYTE_COUNT_DISPLAY |
NUMBER |
0 |
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. |
|
ANALYTE_LAB_CODE |
VARCHAR2 |
20 |
The associated analyte's laboratory scope. Redundant column; the value is always the same as JOB_LAB_CODE. |
|
ANALYTE_WORKFLOW_STATUS |
VARCHAR2 |
20 |
The associated sample scheme analyte's workflow status, for analyte-based pricing items. |
|
BASE_PRICE |
FLOAT |
0 |
The price schedule's base price, or 0 for block price items. |
|
BLOCK_SIZE |
FLOAT |
0 |
The price schedule item's block size. |
|
CLIENT_CODE |
VARCHAR2 |
40 |
The associated client code. |
|
CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated client's laboratory scope. |
|
CURRENCY |
CHAR |
3 |
The price book's currency. |
|
DESCRIPTION |
VARCHAR2 |
200 |
The price code's description. |
|
INVOICE_NO |
VARCHAR2 |
20 |
The associated invoice number. |
|
IS_BASE_PRICE |
CHAR |
1 |
Line item type. It is 'B' for base price items, and 'I' for block price items. |
|
JOB_CODE |
VARCHAR2 |
20 |
The associated job code, or blank for combined-pricing invoices. |
|
JOB_INVOICE_SEQUENCE |
NUMBER |
0 |
The sequence number for job-invoices within a job. Part of the table's business key. |
|
JOB_LAB_CODE |
VARCHAR2 |
20 |
The associated job's laboratory scope. |
|
JS_NUMBER_OF_UNITS |
NUMBER |
0 |
The associated job scheme's number of units. |
|
LAB_CODE |
VARCHAR2 |
20 |
Laboratory scope. |
|
LOOKUP |
NUMBER |
0 |
An internal value used to match against UP_TO. |
|
NOTE |
VARCHAR2 |
200 |
The price schedule's base item or block item notes (specific to client's locale, defaulting to English). |
|
NOTES |
VARCHAR2 |
200 |
As per NOTE. Redundant column. |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. |
|
PRECISION |
CHAR |
1 |
The currency's precision. |
|
PRICE |
FLOAT |
0 |
The price schedule item's block price or job scheme's fixed block price, or 0 for base price items. |
|
PRICE_BOOK_LAB_CODE |
VARCHAR2 |
20 |
The associated price book's laboratory scope. |
|
PRICE_BOOK_SEQUENCE |
NUMBER |
0 |
The associated price book's sequence within its price catalogue. |
|
PRICE_CAT_CODE |
VARCHAR2 |
20 |
The associated price catalogue. |
|
PRICE_CODE |
VARCHAR2 |
50 |
The associated price code. |
|
PRICE_CODE_LAB_CODE |
VARCHAR2 |
20 |
The associated price code's laboratory scope. |
|
PRICE_TYPE |
CHAR |
1 |
The associated scheme's price type, of type PriceType enumeration; or blank for package-pricing. |
|
QUALIFIER |
VARCHAR2 |
60 |
Used internally for disambiguation purposes only. |
|
QUOTE_CODE |
VARCHAR2 |
20 |
The associated quote code. |
|
QUOTE_DISCOUNT |
NUMBER |
0 |
Either the quote's scheme/analyte discount, the quote's generic discount, or the job invoice's generic discount. |
|
QUOTE_LAB_CODE |
VARCHAR2 |
20 |
The associated quote's laboratory scope. |
|
SAMPLE_COUNT |
NUMBER |
0 |
The number of samples involved. |
|
SCALE_PRICE |
NUMBER |
0 |
A calculated price based on the price schedule item that is used to determine the line item total. |
|
SCHEME_CODE |
VARCHAR2 |
20 |
The associated scheme code; or blank for package-pricing. |
|
SCHEME_LAB_CODE |
VARCHAR2 |
20 |
The associated scheme's laboratory scope; or blank for package-pricing. |
|
SCHEME_PRICE_TYPE |
CHAR |
1 |
The associated scheme's price type, of type PriceType enumeration; or blank for package-pricing. |
|
SCHEME_TYPE |
CHAR |
1 |
The associated scheme's type, of type SchemeType enumeration. |
|
SEQUENCE |
NUMBER |
0 |
Always 0. Legacy column. |
|
SPLIT_CODE |
VARCHAR2 |
20 |
The associated split code. |
|
SPLIT_LAB_CODE |
VARCHAR2 |
20 |
The associated split code's laboratory scope. |
|
SPLIT_PERCENT |
FLOAT |
0 |
The associated split's percentage adjustment. |
|
TOTAL |
NUMBER |
0 |
The line item's total, with any applicable discounts, splits, min/max prices applied. |
|
UNIT_COUNT |
NUMBER |
0 |
The number of chargeable units/items involved. This is usually the number of involved samples or 1, depending on the price type. |
|
UNIT_PRICE |
NUMBER |
0 |
The calculated price per unit/item, calculated from the relevant price schedule. |
|
UP_TO |
FLOAT |
0 |
The upper boundary or range of the chargeable samples, analytes, or units for each line item. |
