Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce 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 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030346220 INVOICE_ID Primary Key I0000596 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_397 ORDERS_ID ORDERS ORDERS_ID Cascade _vcc_freeselect_bottom_