EDPREFINST

This table stores the information of the value object container Refund Instruction in Payment Rules.

Column Descriptions:

NameTypeDescription
EDPREFINST_IDBIGINT NOT NULLunique Refund Instruction identifier
EDPRMA_IDBIGINTCMR relationship with Refund
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000the total amount of the Refund Instruction
SEQUENCENUMBERINTEGER NOT NULLthe positional order of this Refund Instruction when to be used with other RIs; sequence number is the ultimate sorter of RIs.
PRIORITYINTEGER NOT NULLthe rank of the priority against other Refund Instructions; this information is copied from the configuration when the RI is created
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
DEPRECATEDINTEGER NOT NULL DEFAULT 0indicates whether this object has been deprecated; canceled objects should not be deleted
DIRTYINTEGER NOT NULL DEFAULT 0indicates if this Refund Instruction needs to be edited before it can be used again
PENDINGINTEGER NOT NULL DEFAULT 0indicates if a background payment thread is still working on this Refund Instruction; if the flag is false, the RI cannot be used
PAYMENTSYSTEMVARCHAR (64) NOT NULLthe 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
REFUNDMETHODVARCHAR (64) NOT NULLthe refund method of the Refund Instruction; for example, Visa, MasterCard, GiftCertificate
BACKENDRIIDVARCHAR (64)The associated backend refund instruction (payment instruction) object in the payments subsystem.
POLICY_IDBIGINT NOT NULLthe refund policy ID used by this refund instruction object
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINTThe 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>EDPREFINST_IDPrimary Key
I0000849EDPRMA_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1099EDPRMA_IDEDPRMAEDPRMA_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1100EDPREFINST_IDEDPATMREFEDPREFINST_IDCascade