CCJOBINVOICEPRICEADJUSTMENT
|
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 associated job invoice sequence number. 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. |
|
PRICE_ADJUSTMENT_CODE |
VARCHAR2 |
20 |
The associated surcharge code or rebate code. Part of the table's business key. |
|
PRICE_ADJUSTMENT_LAB_CODE |
VARCHAR2 |
20 |
The associated surcharge's or rebate's laboratory scope. Part of the table's business key. |
|
SEQUENCE_NUMBER |
NUMBER |
0 |
The sort order of surcharges or rebates (surcharges and rebates are numbered separately). |
