CCPEINVREBINVVIEW
|
Column name |
Data type |
Char length |
Comment |
|---|---|---|---|
|
AGGREGATE |
CHAR |
1 |
Always 'N'. Legacy column. |
|
ANALYTE_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
ANALYTE_COUNT |
NUMBER |
0 |
Always 0. Legacy column. |
|
ANALYTE_LAB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
ANALYTE_WORKFLOW_STATUS |
CHAR |
1 |
Always blank. Legacy column. |
|
BASE_PRICE |
NUMBER |
0 |
Always 0. Legacy column. |
|
BLOCK_SIZE |
NUMBER |
0 |
Always 0. Legacy column. |
|
CLIENT_CODE |
VARCHAR2 |
40 |
The associated client code. |
|
CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated client's laboratory scope. |
|
CURRENCY |
CHAR |
3 |
The job invoice's currency. |
|
DESCRIPTION |
VARCHAR2 |
100 |
The associated price adjustment's description (specific to client's locale, defaulting to English). |
|
INVOICE_NO |
VARCHAR2 |
20 |
The associated invoice number. |
|
IS_BASE_PRICE |
CHAR |
1 |
Either 'S' for surcharges, or 'R' for rebates. Internally used item type. |
|
JI_SEQUENCE |
NUMBER |
0 |
The associated job invoice's sequence number within the job. |
|
JOB_CODE |
VARCHAR2 |
20 |
The associated job code. |
|
JOB_INVOICE_SEQUENCE |
NUMBER |
0 |
Always 0. Legacy column. |
|
JOB_LAB_CODE |
VARCHAR2 |
20 |
The associated job's laboratory scope. |
|
JS_NUMBER_OF_UNITS |
NUMBER |
0 |
Always 0. Legacy column. |
|
LOOKUP |
NUMBER |
0 |
Always 0. Legacy column. |
|
NOTE |
VARCHAR2 |
200 |
The associated price adjustment's invoice note (specific to client's locale, defaulting to English). |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. |
|
PRECISION |
NUMBER |
0 |
The currency's precision. |
|
PRICE |
NUMBER |
0 |
Always 0. Legacy column. |
|
PRICE_BOOK_LAB_CODE |
VARCHAR2 |
20 |
The associated price adjustment's laboratory scope. |
|
PRICE_BOOK_SEQUENCE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_CAT_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_CODE |
VARCHAR2 |
20 |
The associated price adjustment code (i.e. either surcharge code or rebate code). |
|
PRICE_CODE_LAB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_TYPE |
CHAR |
1 |
The associated price adjustment's type, of type PriceAdjustmentType enumeration. |
|
QUALIFIER |
VARCHAR2 |
20 |
Used internally for disambiguation purposes only. |
|
QUOTE_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
QUOTE_DISCOUNT |
FLOAT |
0 |
The surcharge or rebate percentage. |
|
SAMPLE_COUNT |
NUMBER |
0 |
Always 0. Legacy column. |
|
SCALE_PRICE |
NUMBER |
0 |
Always 0. Legacy column. |
|
SCHEME_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
SCHEME_LAB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
SCHEME_TYPE |
CHAR |
1 |
Always blank. Legacy column. |
|
SEQUENCE |
NUMBER |
0 |
The associated price adjustment's sequence number within the job invoice. |
|
TOTAL |
NUMBER |
0 |
The surcharge or rebate amount. |
|
UNIT_COUNT |
NUMBER |
0 |
Always 1. Legacy column. |
|
UNIT_PRICE |
NUMBER |
0 |
The surcharge or rebate amount, same as TOTAL. |
|
UP_TO |
NUMBER |
0 |
Always 0. Legacy column. |
