WebSphere Commerce database table: EDPPAYINST

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
EDPPAYINST_ID BIGINT NOT NULL Reserved for IBM internal use.
EDPORDER_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.
HUMANEDITABLE INTEGER NOT NULL Reserved for IBM internal use.
SYSTEMEDITABLE INTEGER NOT NULL Reserved for IBM internal use.
MAXAMOUNT DECIMAL (20,5) NOT NULL DEFAULT -1.00000 Reserved for IBM internal use.
MINAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 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.
REFUNDALLOWED INTEGER NOT NULL DEFAULT 1 Reserved for IBM internal use.
PENDING INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
PAYMENTRULE VARCHAR(64) NOT NULL Reserved for IBM internal use.
PAYMENTMETHOD VARCHAR(64) NOT NULL Reserved for IBM internal use.
PAYMENTSYSTEM VARCHAR(64) NOT NULL Reserved for IBM internal use.
BACKENDPIID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
PAYCONFIGGROUP VARCHAR(64) NOT NULL Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031223350 EDPPAYINST_ID Primary Key
I0000844 EDPORDER_ID Non-Unique Index
I0000845 BACKENDPIID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1096 EDPORDER_ID EDPORDER EDPORDER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1097 EDPPAYINST_ID EDPATMPAY EDPPAYINST_ID Cascade
F_1159 EDPPAYINST_ID EDPPAYHIST EDPPAYINST_ID Cascade

Feedback