WebSphere Commerce database table: PPCPAYMENT

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
PPCPAYMENT_ID BIGINT NOT NULL Reserved for IBM internal use.
PPCPAYINST_ID BIGINT NOT NULL Reserved for IBM internal use.
PPCPAYTRAN_ID BIGINT Reserved for IBM internal use.
AVSCOMMONCODE SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
EXPECTEDAMOUNT DECIMAL (20,5) NOT NULL Reserved for IBM internal use.
APPROVINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
APPROVEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
DEPOSITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
DEPOSITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
CREDITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
CREDITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
RVRSNGAPRVEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
RVRSNGDPSTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
RVRSNGCRDTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
STATE SMALLINT NOT NULL Reserved for IBM internal use.
TIMEEXPIRED TIMESTAMP Reserved for IBM internal use.
TIMECREATED TIMESTAMP NOT NULL Reserved for IBM internal use.
TIMEUPDATED TIMESTAMP NOT NULL Reserved for IBM internal use.
MARKFORDELETE 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
SQL050212031257710 PPCPAYMENT_ID Primary Key
I0000920 PPCPAYINST_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1168 PPCPAYINST_ID PPCPAYINST PPCPAYINST_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1171 PPCPAYMENT_ID PPCCREDIT PPCPAYMENT_ID Cascade
F_1172 PPCPAYMENT_ID PPCPAYTRAN PPCPAYMENT_ID Cascade

Feedback