Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EDPREFINST
This table stores the information of the value object container Refund Instruction in Payment Rules.
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 SQL100520030330470 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1100 EDPREFINST_ID EDPATMREF EDPREFINST_ID Cascade _vcc_freeselect_bottom_