WebSphere Commerce database table: PPCPAYTRAN

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
PPCPAYTRAN_ID BIGINT NOT NULL Reserved for IBM internal use.
PPCPAYMENT_ID BIGINT Reserved for IBM internal use.
PPCCREDIT_ID BIGINT Reserved for IBM internal use.
TRANSACTIONTYPE SMALLINT NOT NULL Reserved for IBM internal use.
REQUESTEDAMOUNT DECIMAL (20,5) NOT NULL Reserved for IBM internal use.
PROCESSEDAMOUNT 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.
RESPONSECODE VARCHAR(25) Reserved for IBM internal use.
REASONCODE VARCHAR(25) Reserved for IBM internal use.
REFERENCENUMBER VARCHAR(64) Reserved for IBM internal use.
TRACKINGID VARCHAR(64) Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031257840 PPCPAYTRAN_ID Primary Key
I0000924 PPCPAYMENT_ID Non-Unique Index
I0000925 PPCCREDIT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1173 PPCCREDIT_ID PPCCREDIT PPCCREDIT_ID Cascade
F_1172 PPCPAYMENT_ID PPCPAYMENT PPCPAYMENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1175 PPCPAYTRAN_ID PPCEXTDATA PPCPAYTRAN_ID Cascade

Feedback