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. |
