WebSphere Commerce database table: EDPATMPAY

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
EDPATMPAY_ID BIGINT NOT NULL Reserved for IBM internal use.
EDPPAYINST_ID BIGINT Reserved for IBM internal use.
TOTALAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
VALIDATIONAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
RESERVATIONAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
FINALIZATIONAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
VALIDATINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
RESERVINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
FINALIZINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
BACKENDPAYMENTID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031222790 EDPATMPAY_ID Primary Key
I0000846 EDPPAYINST_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1097 EDPPAYINST_ID EDPPAYINST EDPPAYINST_ID Cascade

Feedback