CCINVOICEITEMSAMPLE
|
Column name |
Data type |
Char length |
Comment |
|---|---|---|---|
|
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. |
|
INVOICE_ITEM_NO |
NUMBER |
0 |
The associated invoice item number. Part of the table's business key. |
|
INVOICE_NO |
VARCHAR2 |
20 |
The associated invoice number. Part of the table's business key. |
|
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. |
|
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. |
|
ORG_CODE |
VARCHAR2 |
20 |
Organisation scope. Part of the table's business key. |
|
SAMPLE_CODE |
VARCHAR2 |
20 |
The associated sample code. Part of the table's business key. |
|
UP_TO |
FLOAT |
0 |
The up-to value of the associated invoice item. Part of the table's business key. |
