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, such as payment, payment instruction, credit, or refund instructions.
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