This table stores the invoice XML generated for the order release. An order release is represented by a row in the ORDRELEASE table.
Column Name | Column Type | Column Description |
---|---|---|
INVOICEXML | LONG VARCHAR NULL |
The invoice XML for this order release. |
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 is 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 is the primary key to the row in the ORDRELEASE table. |
STATUS | CHARACTER (4) NULL |
Reserved for IBM internal use. |
TIMECREATED | TIMESTAMP NULL |
Time the invoice XML is generated. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034947550 | INVOICE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_397 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|