This table stores the information of the value
object container Credit for credit-related transactions in the
payments subsystem.
Column Descriptions:
| Name | Type | Description |
| PPCCREDIT_ID | BIGINT NOT NULL | The generated credit identifier |
| PPCPAYINST_ID | BIGINT NOT NULL | The identifier of the payment instruction in the
payments subsystem under which this credit is created. This column
stores the CMR relationship with PPCPAYINST. |
| PPCPAYMENT_ID | BIGINT | The identifier of the payment in the payments
subsystem to which this dependent credit is associated.
NULL when this credit is an independent credit. This column
stores the CMR relationship with PPCPAYMENT |
| EXPECTEDAMOUNT | DECIMAL (20,5) NOT NULL | The expected amount that will be credited under
this credit, the actual credited amount must be less than or equal
to this amount |
| CREDITINGAMOUNT | DECIMAL (20,5) NOT NULL DEFAULT 0.00000 | The amount of the pending credit transaction
under this credit |
| CREDITEDAMOUNT | DECIMAL (20,5) NOT NULL DEFAULT 0.00000 | The credited amount of the credit transaction
under this credit |
| RVRSNGCRDTEDAMNT | DECIMAL (20,5) NOT NULL DEFAULT 0.00000 | The cumulative amount of all the pending reverse
credit transactions under this credit |
| STATE | SMALLINT NOT NULL | The state of this credit:
0: STATE_NEW
1: STATE_CREDITING
2: STATE_CREDITED
3: STATE_FAILED
4: STATE_CANCELED |
| TIMECREATED | TIMESTAMP NOT NULL | The time when the credit was created |
| TIMEUPDATED | TIMESTAMP NOT NULL | The time when the credit 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. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PPCCREDIT_ID | Primary Key |
| I0000922 | PPCPAYINST_ID | Non-Unique Index |
| I0000923 | PPCPAYMENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1170 | PPCPAYINST_ID | PPCPAYINST | PPCPAYINST_ID | Cascade |
| F_1171 | PPCPAYMENT_ID | PPCPAYMENT | PPCPAYMENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1173 | PPCCREDIT_ID | PPCPAYTRAN | PPCCREDIT_ID | Cascade |