WebSphere Commerce database table: PPCCREDIT

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
PPCCREDIT_ID BIGINT NOT NULL Reserved for IBM internal use.
PPCPAYINST_ID BIGINT NOT NULL Reserved for IBM internal use.
PPCPAYMENT_ID BIGINT Reserved for IBM internal use.
EXPECTEDAMOUNT DECIMAL (20,5) NOT NULL 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.
RVRSNGCRDTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use.
STATE SMALLINT NOT NULL 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
SQL050212031257260 PPCCREDIT_ID Primary Key
I0000922 PPCPAYINST_ID Non-Unique Index
I0000923 PPCPAYMENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1170 PPCPAYINST_ID PPCPAYINST PPCPAYINST_ID Cascade
F_1171 PPCPAYMENT_ID PPCPAYMENT PPCPAYMENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1173 PPCCREDIT_ID PPCPAYTRAN PPCCREDIT_ID Cascade

Feedback