WebSphere Commerce database table: PPCCREDIT

Reference > Database > WebSphere Commerce database tables > P

WebSphere Commerce database table: PPCCREDIT

This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.

Column Name Column Type Description
PPCCREDIT_ID BIGINT NOT NULL The generated credit identifier
PPCPAYINST_ID BIGINT NOT NULL The identifier of the payment instruction in WebSphere Commerce Payments under which this credit is created. This column stores the CMR relationship with PPCPAYINST.
PPCPAYMENT_ID BIGINT The identifier of the payment in WebSphere Commerce Payments to which this dependent credit is associated.
NULL when this credit is an independent credit. This column stores the CMR relationship with PPCPAYMENT
EXPECTEDAMOUNT DECIMAL (20,5) NOT NULL The expected amount that will be credited under this credit, the actual credited amount must be less than or equal to this amount
CREDITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The amount of the pending credit transaction under this credit
CREDITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The credited amount of the credit transaction under this credit
RVRSNGCRDTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The cumulative amount of all the pending reverse credit transactions under this credit
STATE SMALLINT NOT NULL The state of this credit:
0: STATE_NEW
1: STATE_CREDITING
2: STATE_CREDITED
3: STATE_FAILED
4: STATE_CANCELED
TIMECREATED TIMESTAMP NOT NULL The time when the credit was created
TIMEUPDATED TIMESTAMP NOT NULL The time when the credit was updated
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 The flag indicates whether this object has been marked for deletion.
0: not marked for deletion
1: marked for deletion
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030412200 PPCCREDIT_ID Primary Key
I0000922 PPCPAYINST_ID Non-Unique Index
I0000923 PPCPAYMENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1170 PPCPAYINST_ID PPCPAYINST PPCPAYINST_ID Cascade
F_1171 PPCPAYMENT_ID PPCPAYMENT PPCPAYMENT_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1173 PPCCREDIT_ID PPCPAYTRAN PPCCREDIT_ID Cascade
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
PPCCREDIT_ID	BIGINT NOT NULL	The generated credit identifier
PPCPAYINST_ID	BIGINT NOT NULL	The identifier of the payment instruction in WebSphere Commerce Payments under which this credit is created. This column stores the CMR relationship with PPCPAYINST.
PPCPAYMENT_ID	BIGINT	The identifier of the payment in WebSphere Commerce Payments to which this dependent credit is associated. NULL when this credit is an independent credit. This column stores the CMR relationship with PPCPAYMENT
EXPECTEDAMOUNT	DECIMAL (20,5) NOT NULL	The expected amount that will be credited under this credit, the actual credited amount must be less than or equal to this amount
CREDITINGAMOUNT	DECIMAL (20,5) NOT NULL DEFAULT 0.00000	The amount of the pending credit transaction under this credit
CREDITEDAMOUNT	DECIMAL (20,5) NOT NULL DEFAULT 0.00000	The credited amount of the credit transaction under this credit
RVRSNGCRDTEDAMNT	DECIMAL (20,5) NOT NULL DEFAULT 0.00000	The cumulative amount of all the pending reverse credit transactions under this credit
STATE	SMALLINT NOT NULL	The state of this credit: 0: STATE_NEW 1: STATE_CREDITING 2: STATE_CREDITED 3: STATE_FAILED 4: STATE_CANCELED
TIMECREATED	TIMESTAMP NOT NULL	The time when the credit was created
TIMEUPDATED	TIMESTAMP NOT NULL	The time when the credit was updated
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL100520030412200	PPCCREDIT_ID	Primary Key
I0000922	PPCPAYINST_ID	Non-Unique Index
I0000923	PPCPAYMENT_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1170	PPCPAYINST_ID	PPCPAYINST	PPCPAYINST_ID	Cascade
F_1171	PPCPAYMENT_ID	PPCPAYMENT	PPCPAYMENT_ID	Cascade