This table stores the invoice XML generated for the order release. An order release is represented by a row in the ORDRELEASE table.
Column Descriptions
| Column Name
| Column Type
| Description |
| INVOICE_ID
| BIGINT NOT NULL
| Generated unique key for this row. Also used as the invoice number.
|
| ORDERS_ID
| BIGINT NOT NULL
| The ID of the order. The ORDERS_ID and the order release number together are the primary key to the row in the ORDRELEASE table.
|
| ORDRELEASENUM
| INTEGER NOT NULL
| Order release number. The ORDERS_ID and the order release number together are the primary key to the row in the ORDRELEASE table.
|
| INVOICEXML
| CLOB
| The invoice XML for this order release.
|
| STATUS
| CHAR(4)
| Reserved for IBM internal use.
|
| TIMECREATED
| TIMESTAMP
| Time the invoice XML is generated.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|