This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
Column Descriptions
| 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.
|