CCJOBINVOICESCHEME
|
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 scheme 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. |
|
SCHEME_CODE |
VARCHAR2 |
20 |
Job-invoice scheme's scheme code. Part of the table's business key. |
|
SCHEME_LAB_CODE |
VARCHAR2 |
20 |
The associated scheme's laboratory scope. Part of the table's business key. |
|
SCHEME_VERSION_NUMBER |
NUMBER |
0 |
The associated scheme's version number. Part of the table's business key. |
|
SEQUENCE_NUMBER |
NUMBER |
0 |
The sort order of the schemes within the job invoice. Numbers are not guaranteed to be consecutive. |
