Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PPCPAYMENT

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

Column Name Column Type Description
PPCPAYMENT_ID BIGINT NOT NULL The generated payment identifier
PPCPAYINST_ID BIGINT NOT NULL The identifier of the payment instruction under which this payment is created. This column represents the CMR relationship with PPCPAYINST
PPCPAYTRAN_ID BIGINT The identifier of the approve transaction which is issued against this payment. Null when the Payment is just created and without the approve transaction. This column represents the CMR relationship with PPCPAYTRAN
AVSCOMMONCODE SMALLINT NOT NULL DEFAULT 0 Address Verification Service Code:
-1: AVS_UNKNOWN
0: AVS_COMPLETE_MATCH
1: AVS_STREET_ADDRES_MATCH
2: AVS_POSTALCODE_MATCH
3: AVS_NO_MATCH
4: AVS_OTHER_RESPONSE
EXPECTEDAMOUNT DECIMAL (20,5) NOT NULL The expected amount that will be used to approve under this payment, the actual approve amount must be less than or equal to this amount.
APPROVINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The amount of the pending approve transaction under this payment
APPROVEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The approved amount of the approve transaction under this payment
DEPOSITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the pending deposit transactions under this payment
DEPOSITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the deposited transactions under this payment
CREDITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the dependent credits with pending credit transactions under this payment
CREDITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the dependent credits with credited transactions under this payment
RVRSNGAPRVEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the pending reverse approval transactions under this payment
RVRSNGDPSTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the pending reverse deposite transactions under this payment
RVRSNGCRDTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all the dependent credits with pending reverse credit transacions
STATE SMALLINT NOT NULL The state of this payment:
0: STATE_NEW
1: STATE_APPROVING
2: STATE_APPROVED
3: STATE_FAILED
4: STATE_CANCELED
5: STATE_EXPIRED
TIMEEXPIRED TIMESTAMP The time in which this Payment will expire and can no longer process additional transaction under it. null if this payment never expire
TIMECREATED TIMESTAMP NOT NULL The time when the payment was created
TIMEUPDATED TIMESTAMP NOT NULL The time when the payment 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
SQL100520030412680 PPCPAYMENT_ID Primary Key
I0000920 PPCPAYINST_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1168 PPCPAYINST_ID PPCPAYINST PPCPAYINST_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1171 PPCPAYMENT_ID PPCCREDIT PPCPAYMENT_ID Cascade
F_1172 PPCPAYMENT_ID PPCPAYTRAN PPCPAYMENT_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search