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