This table keeps the payment activity history for all operations on payment instructions and financial transactions.
Column Descriptions
| 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
|