CCPEINVTAXESTVIEW
|
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. |
|
DESCRIPTION |
VARCHAR2 |
100 |
The associated tax's description (specific to client's locale, defaulting to English). |
|
INVOICE_CURRENCY |
CHAR |
3 |
The job invoice's currency. |
|
INVOICE_NO |
VARCHAR2 |
20 |
The associated invoice number. |
|
IS_BASE_PRICE |
CHAR |
1 |
Always 'T'. Internally used item type. |
|
JOB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
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 tax's invoice note (specific to client's locale, defaulting to English). |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. |
|
PRECISION |
VARCHAR2 |
4000 |
The currency's precision. |
|
PRICE |
NUMBER |
0 |
Always 0. Legacy column. |
|
PRICE_BOOK_LAB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_BOOK_SEQUENCE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_CAT_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_CODE |
VARCHAR2 |
20 |
The associated tax code. |
|
PRICE_CODE_LAB_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
PRICE_TYPE |
CHAR |
1 |
Always blank. Legacy column. |
|
QUALIFIER |
CHAR |
1 |
Always blank. Legacy column. |
|
QUOTE_CODE |
CHAR |
1 |
Always blank. Legacy column. |
|
QUOTE_DISCOUNT |
FLOAT |
0 |
The associated tax rate/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 tax's sequence number within the job invoice. |
|
TOTAL |
NUMBER |
0 |
The tax amount. |
|
UNIT_COUNT |
NUMBER |
0 |
Always 1. Legacy column. |
|
UNIT_PRICE |
NUMBER |
0 |
The tax amount, same as TOTAL. |
|
UP_TO |
NUMBER |
0 |
Always 0. Legacy column. |
