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 Description(s):
Column NameColumn TypeDescription
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.
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031234190 INVOICE_ID Primary Key
I0000596 ORDERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_397 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback