This table stores the information of the value
object container Refund Instruction in Payment Rules.
Column Descriptions:
| Name | Type | Description |
| EDPREFINST_ID | BIGINT NOT NULL | unique Refund Instruction identifier |
| EDPRMA_ID | BIGINT | CMR relationship with Refund |
| AMOUNT | DECIMAL (20,5) NOT NULL DEFAULT 0.00000 | the total amount of the Refund Instruction |
| SEQUENCENUMBER | INTEGER NOT NULL | the positional order of this Refund Instruction
when to be used with other RIs; sequence number is the ultimate
sorter of RIs. |
| PRIORITY | INTEGER NOT NULL | the rank of the priority against other Refund
Instructions; this information is copied from the configuration
when the RI is created |
| 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 |
| DEPRECATED | INTEGER NOT NULL DEFAULT 0 | indicates whether this object has been
deprecated; canceled objects should not be deleted |
| DIRTY | INTEGER NOT NULL DEFAULT 0 | indicates if this Refund Instruction needs to be
edited before it can be used again |
| PENDING | INTEGER NOT NULL DEFAULT 0 | indicates if a background payment thread is still
working on this Refund Instruction; if the flag is false, the RI
cannot be used |
| PAYMENTSYSTEM | VARCHAR (64) NOT NULL | the payment system that is to be used to process
payment actions related to this Refund Instruction; for example,
VisaNet, PaymentTech; this information is copied from the
configuration when the RI is created |
| REFUNDMETHOD | VARCHAR (64) NOT NULL | the refund method of the Refund Instruction; for
example, Visa, MasterCard, GiftCertificate |
| BACKENDRIID | VARCHAR (64) | The associated backend refund instruction
(payment instruction) object in the payments subsystem. |
| POLICY_ID | BIGINT NOT NULL | the refund policy ID used by this refund
instruction object |
| FIELD1 | INTEGER | Customizable. |
| FIELD2 | VARCHAR (254) | Customizable. |
| FIELD3 | VARCHAR (254) | Customizable. |
| OPTCOUNTER | SMALLINT | 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> | EDPREFINST_ID | Primary Key |
| I0000849 | EDPRMA_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1099 | EDPRMA_ID | EDPRMA | EDPRMA_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1100 | EDPREFINST_ID | EDPATMREF | EDPREFINST_ID | Cascade |