This table keeps the payment activity history for all committed operations on payment instructions and financial transactions.

Column Descriptions:

EDPPAYHIST_IDBIGINT NOT NULLPayment Activity Record unique identifier (generated)
ORDER_IDBIGINTthe order identifier (if present)
RMA_IDBIGINTthe rma identifier (if present)
STORE_IDINTEGERthe store identifier
HISTTIMESTAMPTIMESTAMP NOT NULLthe timestamp of the operation
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000the amount of the operation
OPERATIONNAMEVARCHAR (64) NOT NULLthe operation attempted
OPERATIONRESULTVARCHAR (64) NOT NULLthe machine-readable operation result
READABLESTATUSVARCHAR (64) NOT NULLthe human-readable operation result
RECORDTYPEVARCHAR (64) NOT NULLThe type of this payment activity, which maybe payment,payment instruction, creidt, or refund instruction
BACKENDPIIDVARCHAR (64)The payment instruction id in the payments subsystem.
BACKENDPAYMENTIDVARCHAR (64)the id of the backend payment or credit object in the payments subsystem.
ACCOUNTVARCHAR (64)the masked account number associated to the operation
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.
EDPPAYINST_IDBIGINTThe foreign key to the Payment Instruction in Payment Rules.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.


NameColumn NamesType
I0000850ORDER_ID+STORE_IDNon-Unique Index
I0000910EDPPAYINST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType