WebSphere Commerce database table: EDPREFINST

WebSphere Commerce database table: EDPREFINST

This table stores the information of the value object container Refund Instruction in Payment Rules.
Column Descriptions
Column Name Column 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 WebSphere Commerce Payments
OPTCOUNTER SMALLINT Reserved for IBM internal use.
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

Indexes
Index Name Indexed Column Names Index Type
SQL060903235153320 EDPREFINST_ID Primary Key
I0000849 EDPRMA_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1099 EDPRMA_ID EDPRMA EDPRMA_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1100 EDPREFINST_ID EDPATMREF EDPREFINST_ID Cascade

Column Name	Column 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 WebSphere Commerce Payments
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
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

Index Name	Indexed Column Names	Index Type
SQL060903235153320	EDPREFINST_ID	Primary Key
I0000849	EDPRMA_ID	Non-Unique Index