EDPPAYHIST

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

Column Descriptions:

Name	Type	Description
EDPPAYHIST_ID	BIGINT NOT NULL	Payment Activity Record unique identifier (generated)
ORDER_ID	BIGINT	The order identifier (if present).
RMA_ID	BIGINT	The RMA identifier (if present).
STORE_ID	INTEGER	The store identifier.
HISTTIMESTAMP	TIMESTAMP NOT NULL	The timestamp of the operation.
AMOUNT	DECIMAL (20,5) NOT NULL DEFAULT 0.00000	The amount of the operation.
OPERATIONNAME	VARCHAR (64) NOT NULL	The operation attempted.
OPERATIONRESULT	VARCHAR (64) NOT NULL	The machine-readable operation result.
READABLESTATUS	VARCHAR (64) NOT NULL	The human-readable operation result.
RECORDTYPE	VARCHAR (64) NOT NULL	The type of this payment activity, such as payment, payment instruction, credit, or refund instructions.
BACKENDPIID	VARCHAR (64)	The payment instruction id in the payments subsystem.
BACKENDPAYMENTID	VARCHAR (64)	The ID of the backend payment or credit object in the payments subsystem.
ACCOUNT	VARCHAR (64)	The masked account number associated to the operation.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
EDPPAYINST_ID	BIGINT	The foreign key to the Payment Instruction in Payment Rules.
FIELD1	INTEGER	Customizable.
FIELD2	VARCHAR (254)	Customizable.
FIELD3	VARCHAR (254)	Customizable.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EDPPAYHIST_ID	Primary Key
I0000850	ORDER_ID+STORE_ID	Non-Unique Index
I0000910	EDPPAYINST_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1159	EDPPAYINST_ID	EDPPAYINST	EDPPAYINST_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1101	EDPPAYHIST_ID	EDPRELHIST	EDPPAYHIST_ID	Cascade