PPCPAYMENT

This table stores the information of the value object container Payment for payment-related transactions in the payments subsystem.

Column Descriptions:

NameTypeDescription
PPCPAYMENT_IDBIGINT NOT NULLThe generated payment identifier
PPCPAYINST_IDBIGINT NOT NULLThe identifier of the payment instruction under which this payment is created. This column represents the CMR relationship with PPCPAYINST
PPCPAYTRAN_IDBIGINTThe 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
AVSCOMMONCODESMALLINT NOT NULL DEFAULT 0Address 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
EXPECTEDAMOUNTDECIMAL (20,5) NOT NULLThe expected amount that will be used to approve under this payment, the actual approve amount must be less than or equal to this amount.
APPROVINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000The amount of the pending approve transaction under this payment
APPROVEDAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000The approved amount of the approve transaction under this payment
DEPOSITINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the pending deposit transactions under this payment
DEPOSITEDAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the deposited transactions under this payment
CREDITINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the dependent credits with pending credit transactions under this payment
CREDITEDAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the dependent credits with credited transactions under this payment
RVRSNGAPRVEDAMNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the pending reverse approval transactions under this payment
RVRSNGDPSTEDAMNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the pending reverse deposited transactions under this payment
RVRSNGCRDTEDAMNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000This is a cumulative value of all the dependent credits with pending reverse credit transactions.
STATESMALLINT NOT NULLThe state of this payment: 0: STATE_NEW 1: STATE_APPROVING 2: STATE_APPROVED 3: STATE_FAILED 4: STATE_CANCELED 5: STATE_EXPIRED
TIMEEXPIREDTIMESTAMPThe time in which this Payment will expire and can no longer process additional transaction under it. null if this payment never expire
TIMECREATEDTIMESTAMP NOT NULLThe time when the payment was created
TIMEUPDATEDTIMESTAMP NOT NULLThe time when the payment was updated
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PPCPAYMENT_IDPrimary Key
I0000920PPCPAYINST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1168PPCPAYINST_IDPPCPAYINSTPPCPAYINST_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1171PPCPAYMENT_IDPPCCREDITPPCPAYMENT_IDCascade
F_1172PPCPAYMENT_IDPPCPAYTRANPPCPAYMENT_IDCascade