CCINVOICEALLVIEW
| 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 primary job invoice's associated client. |
|
CLIENT_ERP_AFF_COST_CENTRE |
VARCHAR2 |
40 |
The associated client's ERP affiliated cost centre. |
|
CLIENT_ERP_CLIENT_NAME |
VARCHAR2 |
255 |
The associated client's ERP client name. |
|
CLIENT_ERP_CLIENT_NUMBER |
VARCHAR2 |
255 |
The associated client's ERP client number. |
|
CLIENT_ERP_SITE_NAME |
VARCHAR2 |
255 |
The associated client's ERP site name. |
|
CLIENT_ERP_SITE_NUMBER |
VARCHAR2 |
255 |
The associated client's ERP site number. |
|
CLIENT_ERP_VAT_NO |
VARCHAR2 |
40 |
The associated client's ERP VAT number. |
|
CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated client's laboratory scope. |
|
CLIENT_NAME |
VARCHAR2 |
200 |
The associated client's name. |
|
CONTACT_CODE |
VARCHAR2 |
20 |
The primary job invoice's associated contact. |
|
CONTACT_NAME |
VARCHAR2 |
200 |
The associated contact's name. |
|
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. |
|
CURRENCY |
CHAR |
3 |
The primary job invoice's currency. |
|
DESCRIPTION |
VARCHAR2 |
100 |
The primary job invoice's description. |
|
DISCOUNT |
NUMBER |
0 |
The invoice's discount. |
|
EMAIL_TO |
VARCHAR2 |
1000 |
The associated contact's email address from the invoice. |
|
EST_EX |
NUMBER |
0 |
The estimated total, excluding tax, in the invoice's currency. This number is shown on the CCINV search page results. |
|
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. |
|
IS_IGNORE_TAX |
CHAR |
1 |
A boolean flag to indicate whether tax is ignored for an invoice's pricing. |
|
IS_MERGED |
CHAR |
1 |
A boolean flag indicating whether the invoice is a merged invoice or not. |
|
IS_WIPEST_OUTDATED |
CHAR |
1 |
A boolean flag indicating whether an invoice's WIP or EST amounts are rendered outdated due to job or invoice updates. |
|
JOB_CLIENT_CODE |
VARCHAR2 |
40 |
The associated primary job's client. |
|
JOB_CLIENT_CONTACT_CODE |
VARCHAR2 |
20 |
The associated primary job's contact. |
|
JOB_CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated primary job's client's laboratory scope. |
|
JOB_CLIENT_NAME |
VARCHAR2 |
200 |
The associated primary job's client name. |
|
JOB_CLIENT_PROJECT_CODE |
VARCHAR2 |
40 |
The associated primary job's project. |
|
JOB_CLIENT_SUBMISSION_NUMBER |
VARCHAR2 |
60 |
The associated primary job's client submission number. |
|
JOB_CODE |
VARCHAR2 |
20 |
The associated primary job. |
|
JOB_COMPLETED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's completion date. |
|
JOB_CONTACT_NAME |
VARCHAR2 |
200 |
The associated primary job's contact name. |
|
JOB_CONTRACT |
VARCHAR2 |
40 |
The associated primary job's contract. |
|
JOB_CONTRACT_SUBMISSION_NUM |
VARCHAR2 |
60 |
The associated primary job's contract submission number. |
|
JOB_COST_CENTRE_CODE |
VARCHAR2 |
20 |
The associated primary job's cost centre. |
|
JOB_COST_CENTRE_LAB_CODE |
VARCHAR2 |
20 |
The associated primary job's cost centre's laboratory scope. |
|
JOB_COST_CENTRE_NAME |
VARCHAR2 |
200 |
The associated primary job's cost centre name. |
|
JOB_DESCRIPTION |
VARCHAR2 |
100 |
The associated primary job's description. |
|
JOB_FIRST_INVOICED_DATE |
TIMESTAMP(8) |
0 |
The associated primary job's first invoiced date. |
|
JOB_FIRST_REPORTED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's first reported date. |
|
JOB_ID |
RAW |
0 |
The associated primary job's internal id. |
|
JOB_INVOICE_SEQUENCE |
NUMBER |
0 |
The associated primary job invoice's sequence number within its job. |
|
JOB_LAST_INVOICED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's last invoiced date. |
|
JOB_LAST_REPORTED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's last reported date. |
|
JOB_NO_OF_SAMPLES |
NUMBER |
0 |
The associated primary job's number of samples. |
|
JOB_NO_OF_SCHEMES |
NUMBER |
0 |
The associated primary job's number of schemes. |
|
JOB_NO_OF_SCHEMES_COMPLETED |
NUMBER |
0 |
The associated primary job's number of completed schemes. |
|
JOB_NO_OF_SCHEMES_STARTED |
NUMBER |
0 |
The associated primary job's number of stated schemes. |
|
JOB_NO_OF_UNKNOWN_SAMPLES |
NUMBER |
0 |
The associated primary job's number of unknown samples. |
|
JOB_PROJECT_NAME |
VARCHAR2 |
200 |
The associated primary job's project name. |
|
JOB_RECEIVED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's received date. |
|
JOB_REGISTRATION_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's registration date. |
|
JOB_REQUIRED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's required date. |
|
JOB_STARTED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's start date. |
|
JOB_TYPE |
CHAR |
1 |
The associated primary job's type, of type InvoiceableJobType enumeration. |
|
JOB_VALIDATED_DATE |
TIMESTAMP(6) |
0 |
The associated primary job's validation date. |
|
JOB_WORKFLOW_STATUS |
VARCHAR2 |
20 |
The associated primary job's workflow status. |
|
LAB_CODE |
VARCHAR2 |
20 |
Laboratory scope. |
|
LAB_CURRENCY |
CHAR |
3 |
The laboratory's currency. |
|
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. |
|
NAME |
VARCHAR2 |
40 |
The associated primary job's name. |
|
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 |
VARCHAR2 |
4000 |
The invoice currency's precision. |
|
PRICING_MODE |
CHAR |
1 |
For merged invoices, this is the pricing mode that was used, of type MergeInvoicingPricingMode enumeration. |
|
PROJECT_CODE |
VARCHAR2 |
40 |
The associated primary job invoice's project. |
|
PROJECT_NAME |
VARCHAR2 |
200 |
The associated primary job invoice's project name. |
|
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. |
|
TOTAL_EX |
NUMBER |
0 |
The invoice total, excluding tax, in the invoice's currency. This number is shown on the CCINV search page results. |
|
TOTAL_INC |
NUMBER |
0 |
The invoice total, including tax, in the invoice's currency. This number is shown on the CCINV search page results. |
|
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_EX |
NUMBER |
0 |
The work-in-progress total, excluding tax, in the invoice's currency. This number is shown on the CCINV search page results. |
