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_RESPONSEEXPECTEDAMOUNT 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_EXPIREDTIMEEXPIRED 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 deletionOPTCOUNTER 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_