CCINVOICE

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.

CREATION_DATE

CHAR

8

Record's creation date as a string in YYMMDD format.

CREATION_TIME

CHAR

6

Record's creation time as a string in HHMMSS format.

CREATION_USER

VARCHAR2

255

Record was created by this user.

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.

DESCRIPTION

CHAR

100

Description of this invoice.

DISCOUNT

NUMBER

0

An invoice discount percentage that is applied to the pricing items, initially inherited from the job invoice.

EMAIL_TO

VARCHAR2

1000

Defaults to the email address of the invoice's contact at the time of invoice creation.

EXCHANGE_RATE

FLOAT

0

Defaults to the exchange rate between the invoice's currency and the laboratory's currency at the time of invoice creation.

EXTERNAL_ID

VARCHAR2

40

Holds a customer-defined identification value for use by external systems.

INVOICE_NO

VARCHAR2

20

The generated invoice number.

INVOICE_TEMPLATE_CODE

CHAR

20

Defaults to one of the laboratory's configured templates at the time of invoice creation, depending on the invoice type.

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. Can only be set on an initial or draft invoice.

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.

LAB_CODE

VARCHAR2

20

Laboratory scope. Part of the table's business key.

LAST_MOD_DATE

CHAR

8

Record's last modification date as a string in YYMMDD format.

LAST_MOD_TIME

CHAR

6

Record's last modification time as a string in HHMMSS format.

LAST_MOD_USER

VARCHAR2

255

Record was last modified by this user.

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. Part of the table's business key.

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.

PRICING_MODE

CHAR

1

For merged invoices, this is the pricing mode that was used, of type MergeInvoicingPricingMode enumeration.

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.

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.