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 Descriptions:

NameTypeDescription
INVOICE_IDBIGINT NOT NULLGenerated unique key for this row. Also used as the invoice number.
ORDERS_IDBIGINT NOT NULLThe ID of the order. The ORDERS_ID and the order release number together are the primary key to the row in the ORDRELEASE table.
ORDRELEASENUMINTEGER NOT NULLOrder release number. The ORDERS_ID and the order release number together are the primary key to the row in the ORDRELEASE table.
INVOICEXMLCLOB (1000000)The invoice XML for this order release.
STATUSCHAR (4)Reserved for IBM internal use.
TIMECREATEDTIMESTAMPTime the invoice XML is generated.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INVOICE_IDPrimary Key
I0000596ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_397ORDERS_IDORDERSORDERS_IDCascade