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 deposited 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 transactions. |
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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |