Reference > Database > WebSphere Commerce database tables > E


WebSphere Commerce database table: EDPPAYHIST

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

Column Name Column 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, which maybe payment,payment instruction, creidt, or refund instruction
BACKENDPIID VARCHAR(64) The payment instruction id in WebSphere Commerce Payments.
BACKENDPAYMENTID VARCHAR(64) the id of the backend payment or credit object in WebSphere Commerce Payments
ACCOUNT VARCHAR(64) the masked account number associated to the operation
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
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
Index Name Indexed Column Names Index Type
SQL100520030330150 EDPPAYHIST_ID Primary Key
I0000850 ORDER_ID+STORE_ID Non-Unique Index
I0000910 EDPPAYINST_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1159 EDPPAYINST_ID EDPPAYINST EDPPAYINST_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1101 EDPPAYHIST_ID EDPRELHIST EDPPAYHIST_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search