CCJOBINVOICETAX
|
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. |
|
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. |
|
SEQUENCE_NUMBER |
NUMBER |
0 |
The sort order of the taxes within the job invoice. Numbers are not guaranteed to be consecutive. |
|
TAX_CODE |
VARCHAR2 |
20 |
The associated tax code. Part of the table's business key. |
|
TAX_LAB_CODE |
VARCHAR2 |
20 |
The associated tax code's laboratory scope. Part of the table's business key. |
