CCINVOICEALLLABVIEW

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 laboratory'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_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_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.

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 laboratory's currency. This number is shown on the CCINV search page results.

TOTAL_INC

NUMBER

0

The invoice total, including tax, in the laboratory'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 laboratory's currency. This number is shown on the CCINV search page results.