WebSphere Commerce database table: PPCPAYINST

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
PPCPAYINST_ID BIGINT NOT NULL Reserved for IBM internal use.
ORDER_ID BIGINT Reserved for IBM internal use.
RMA_ID BIGINT Reserved for IBM internal use.
STORE_ID INTEGER NOT NULL Reserved for IBM internal use.
AMOUNT 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.
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.
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.
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.
TIMECREATED TIMESTAMP NOT NULL Reserved for IBM internal use.
TIMEUPDATED TIMESTAMP NOT NULL Reserved for IBM internal use.
CURRENCY CHAR(3) NOT NULL Reserved for IBM internal use.
STATE SMALLINT NOT NULL DEFAULT 0 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.
PLUGINNAME VARCHAR(64) NOT NULL Reserved for IBM internal use.
PAYMENTSYSTEMNAME VARCHAR(64) NOT NULL Reserved for IBM internal use.
ACCOUNTNUMBER VARCHAR(64) Reserved for IBM internal use.
PAYCONFIGID VARCHAR(64) NOT NULL Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031257570 PPCPAYINST_ID Primary Key
I0000918 ORDER_ID+MARKFORDELETE Non-Unique Index
I0000919 RMA_ID+MARKFORDELETE Non-Unique Index

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1170 PPCPAYINST_ID PPCCREDIT PPCPAYINST_ID Cascade
F_1174 PPCPAYINST_ID PPCEXTDATA PPCPAYINST_ID Cascade
F_1168 PPCPAYINST_ID PPCPAYMENT PPCPAYINST_ID Cascade

Feedback