CCINVOICEVIEW
| Column name | Data type | Char length | Comment |
|---|---|---|---|
|
ACCEPTED_BY |
VARCHAR2 |
255 |
Invoice was marked as accepted by this user. |
|
ACCEPTED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as accepted at this point in time. |
|
AUTHORISED_BY |
VARCHAR2 |
255 |
Invoice was marked as authorised by this user. |
|
AUTHORISED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as authorised at this point in time. |
|
BOOKED_BY |
VARCHAR2 |
255 |
Invoice was marked as booked by this user. |
|
BOOKED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as booked at this point in time. |
|
CANCELLED_BY |
VARCHAR2 |
255 |
Invoice was marked as cancelled by this user. |
|
CANCELLED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as cancelled at this point in time. |
|
CLIENT_CODE |
VARCHAR2 |
40 |
The associated client code. |
|
CLIENT_CURRENCY |
CHAR |
3 |
Primary job invoice's currency. |
|
CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated client's laboratory scope. |
|
CREDITED_BY |
VARCHAR2 |
255 |
Invoice was marked as credited by this user. |
|
CREDITED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as credited at this point in time. |
|
DISCOUNT |
NUMBER |
0 |
The invoice's discount percentage. |
|
DISCOUNT_TOTAL |
NUMBER |
0 |
Always 0. Legacy column. |
|
EMAIL_TO |
VARCHAR2 |
1000 |
The associated contact's email address from the invoice. |
|
EST_TOTAL |
NUMBER |
0 |
The estimated total price, including price adjustments and discounts. |
|
EXCHANGE_RATE |
FLOAT |
0 |
Exchange rate between the invoice's currency and the laboratory's currency, at the time of invoice creation or the last exchange rate update. |
|
EXTERNAL_ID |
VARCHAR2 |
40 |
The invoice's external ID. |
|
INVOICE_NO |
VARCHAR2 |
20 |
The generated invoice number. |
|
INVOICE_TEMPLATE_CODE |
CHAR |
20 |
The invoice's template code. |
|
INVOICE_TYPE |
CHAR |
2 |
Invoice type, of type InvoiceType enumeration. |
|
INV_TOTAL |
NUMBER |
0 |
The invoice total of the line items. |
|
IS_MERGED |
CHAR |
1 |
A boolean flag indicating whether the invoice is a merged invoice or not. |
|
JOB_CODE |
VARCHAR2 |
20 |
The associated job code of the primary job invoice. |
|
LAB_CODE |
VARCHAR2 |
20 |
Laboratory scope. |
|
LAB_CURRENCY |
CHAR |
3 |
The laboratory's currency. |
|
LAB_DISCOUNT_TOTAL |
NUMBER |
0 |
Always 0. Legacy column. |
|
LAB_EST_TOTAL |
NUMBER |
0 |
The EST_TOTAL multiplied by the EXCHANGE_RATE. |
|
LAB_INV_TOTAL |
NUMBER |
0 |
The INV_TOTAL multiplied by the EXCHANGE_RATE. |
|
LAB_TAX_TOTAL |
NUMBER |
0 |
Always 0. Legacy column. |
|
LAB_WIP_TOTAL |
NUMBER |
0 |
The WIP_TOTAL multiplied by the EXCHANGE_RATE. |
|
LINKED_INV_LAB_CODE |
VARCHAR2 |
20 |
For credit notes, this laboratory scope refers to the original invoice's laboratory scope. |
|
LINKED_INV_NO |
VARCHAR2 |
20 |
For credit notes, this invoice number refers to the original invoice. |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. |
|
PAID_BY |
VARCHAR2 |
255 |
Invoice was marked as paid by this user. |
|
PAID_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as paid at this point in time. |
|
PRECISION |
CHAR |
1 |
The currency's precision. |
|
REJECTED_BY |
VARCHAR2 |
255 |
Invoice was marked as rejected by this user. |
|
REJECTED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as rejected at this point in time. |
|
RELEASED_BY |
VARCHAR2 |
255 |
Invoice was marked as released by this user. |
|
RELEASED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as released at this point in time. |
|
SENT_BY |
VARCHAR2 |
255 |
Invoice was marked as sent by this user. |
|
SENT_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as sent at this point in time. |
|
STATUS |
CHAR |
2 |
Invoice status, of type InvoiceStatus enumeration. |
|
TAX_TOTAL |
NUMBER |
0 |
Always 0. Legacy column. |
|
TRANSMITTED_BY |
VARCHAR2 |
255 |
Invoice was marked as transmitted by this user. |
|
TRANSMITTED_DATE |
TIMESTAMP(6) |
0 |
Invoice was marked as transmitted at this point in time. |
|
WIP_TOTAL |
NUMBER |
0 |
The work-in-progress total price, including price adjustments and discounts. |
