Database Table: INVOICE

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034947550 INVOICE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_397 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable