WebSphere Commerce database table: EDPORDER

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
EDPORDER_ID BIGINT NOT NULL Reserved for IBM internal use.
ORDER_ID BIGINT Reserved for IBM internal use.
STORE_ID INTEGER Reserved for IBM internal use.
INITIALAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
TOTALAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
CURRENCY CHAR(3) NOT NULL Reserved for IBM internal use.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
BLOCKED INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
BGJOBSTATUS INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031223070 EDPORDER_ID Primary Key
I0000843 STORE_ID+ORDER_ID Non-Unique Index

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1096 EDPORDER_ID EDPPAYINST EDPORDER_ID Cascade
F_1098 EDPORDER_ID EDPRELEASE EDPORDER_ID Cascade

Feedback