CCJOBINVOICESAMPLE
|
Column name |
Data type |
Char length |
Comment |
|---|---|---|---|
|
CLIENT_CODE |
VARCHAR2 |
40 |
The associated client code. Part of the table's business key. |
|
CLIENT_LAB_CODE |
VARCHAR2 |
20 |
The associated client's laboratory scope. Part of the table's business key. |
|
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. |
|
IS_INVOICED |
CHAR |
1 |
A boolean flag to indicate whether this sample should be invoiced. |
|
JOB_CODE |
VARCHAR2 |
20 |
The associated job code. Part of the table's business key. |
|
JOB_INVOICE_SEQUENCE |
NUMBER |
0 |
The sequence number for job-invoices within a job. Part of the table's business key. |
|
JOB_LAB_CODE |
VARCHAR2 |
20 |
The associated job's 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. |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. Part of the table's business key. |
|
SAMPLE_CODE |
VARCHAR2 |
20 |
Job-invoice sample's sample code. Part of the table's business key. |
|
SAMPLE_LAB_CODE |
VARCHAR2 |
20 |
The associated sample's laboratory scope. Redundant column; the value is always the same as JOB_LAB_CODE. Part of the table's business key. |
|
USE_PACKAGE_PRICE |
CHAR |
1 |
A boolean flag to indicate whether this sample uses package pricing. |
