EDPATMPAY

This table stores the value object Payment Instruction in HCL Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the payments subsystem intends to consume collectively.

Column Descriptions:

NameTypeDescription
EDPATMPAY_IDBIGINT NOT NULLAtomic Payment unique identifier (generated)
EDPPAYINST_IDBIGINTidentifier of the payment instruction in Payment Rules this Atomic Payment object associates to. CMR relationship with PaymentInstruction
TOTALAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000total amount of the Atomic Payment
VALIDATIONAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000total amount of the Atomic Payment that has been processed during the call to primePayment
RESERVATIONAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Atomic Payment that has been processed during reservePayment calls
FINALIZATIONAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Atomic Payment that has been processed during finalizePayment calls
VALIDATINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Atomic Payment that is being processed by primePayment backend payment thread or that is not ready yet due to pending actions
RESERVINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Atomic Payment that is being processed by reservePayment backend payment thread or is not ready yet due to pending actions
FINALIZINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Atomic Payment that is being processed by finalizePayment backend payment thread or is not ready yet due to pending actions
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
BACKENDPAYMENTIDVARCHAR (64)identifier of the associated backend payment object
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.
FIELD1DECIMAL (20,5)Customizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPATMPAY_IDPrimary Key
I0000846EDPPAYINST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1097EDPPAYINST_IDEDPPAYINSTEDPPAYINST_IDCascade