EDPPAYINST

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

Column Descriptions:

NameTypeDescription
EDPPAYINST_IDBIGINT NOT NULLunique Payment Instruction identifier
EDPORDER_IDBIGINTCMR relationship with EDPOrder
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000the total amount of the payment instruction
SEQUENCENUMBERINTEGER NOT NULLthe rank of the payment instruction against the other payment instructions in the EDPOrder.
PRIORITYINTEGER NOT NULLthe rank of the priority against other types of payment instructions; this information is copied from the configuration when the payment instruction is created
HUMANEDITABLEINTEGER NOT NULLif this payment instruction can have its amount changed by a customer request; this information is copied from the configuration when the payment instruction is created
SYSTEMEDITABLEINTEGER NOT NULLif this payment instruction can have its amount changed by the system without checking with the customer; this information is copied from the configuration when the payment instruction is created
MAXAMOUNTDECIMAL (20,5) NOT NULL DEFAULT -1.00000the maximum amount that can be used from this payment instruction(if editable, this threshold cannot be crossed); this information is copied from the configuration when the payment instruction is created
MINAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000the minimum amount that can be used from this payment instruction (if editable, this threshold cannot be crossed); this information is copied from the configuration when the payment instruction 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 Payment Instruction needs to be edited before it can be used again
REFUNDALLOWEDINTEGER NOT NULL DEFAULT 1indicates if a Refund can be executed against an order that uses this Payment Instruction; if the flag is false, refunds are not allowed for the order; this information is copied from the configuration when the Payment Instruction is created
PENDINGINTEGER NOT NULL DEFAULT 0indicates if a background payment thread is still working on this Payment Instruction; if the flag is true, the payment instruction cannot be used
PAYMENTRULEVARCHAR (64) NOT NULLthe name of the rule configuration of the associated payment method; this information is copied from the configuration when the PI is created
PAYMENTMETHODVARCHAR (64) NOT NULLthe payment method of the payment instruction; for example, Visa, MasterCard, GiftCertificate
PAYMENTSYSTEMVARCHAR (64) NOT NULLthe payment system that is to be used to process payment actions related to this payment instruction; for example, VisaNet, PaymentTech; this information is copied from the configuration when the PI is created
BACKENDPIIDVARCHAR (64)the associated backend payment instruction object in the payments subsystem.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
PAYCONFIGGROUPVARCHAR (64) NOT NULLThe payment configuration group used by this payment instruction object
POLICY_IDBIGINT NOT NULLThe payment policy ID of the payment method used by this object.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPPAYINST_IDPrimary Key
I0000844EDPORDER_IDNon-Unique Index
I0000845BACKENDPIIDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1096EDPORDER_IDEDPORDEREDPORDER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1097EDPPAYINST_IDEDPATMPAYEDPPAYINST_IDCascade
F_1159EDPPAYINST_IDEDPPAYHISTEDPPAYINST_IDCascade