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_