WebSphere Commerce database table: EDPREFINST

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
EDPREFINST_ID BIGINT NOT NULL Reserved for IBM internal use.
EDPRMA_ID BIGINT Reserved for IBM internal use.
AMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
SEQUENCENUMBER INTEGER NOT NULL Reserved for IBM internal use.
PRIORITY INTEGER NOT NULL Reserved for IBM internal use.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
DEPRECATED INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
DIRTY INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
PENDING INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
PAYMENTSYSTEM VARCHAR(64) NOT NULL Reserved for IBM internal use.
REFUNDMETHOD VARCHAR(64) NOT NULL Reserved for IBM internal use.
BACKENDRIID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031223480 EDPREFINST_ID Primary Key
I0000849 EDPRMA_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1099 EDPRMA_ID EDPRMA EDPRMA_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1100 EDPREFINST_ID EDPATMREF EDPREFINST_ID Cascade

Feedback