WebSphere Commerce database table: EDPPAYHIST

Advanced orders Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
EDPPAYHIST_ID BIGINT NOT NULL Reserved for IBM internal use
ORDER_ID BIGINT Reserved for IBM internal use
RMA_ID BIGINT Reserved for IBM internal use
STORE_ID INTEGER Reserved for IBM internal use
HISTTIMESTAMP TIMESTAMP NOT NULL Reserved for IBM internal use
AMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 Reserved for IBM internal use
OPERATIONNAME VARCHAR(64) NOT NULL Reserved for IBM internal use
OPERATIONRESULT VARCHAR(64) NOT NULL Reserved for IBM internal use
READABLESTATUS VARCHAR(64) NOT NULL Reserved for IBM internal use
RECORDTYPE VARCHAR(64) NOT NULL Reserved for IBM internal use
BACKENDPIID VARCHAR(64) Reserved for IBM internal use
BACKENDPAYMENTID VARCHAR(64) Reserved for IBM internal use
ACCOUNT VARCHAR(64) Reserved for IBM internal use
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
EDPPAYINST_ID BIGINT Reserved for IBM internal use
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031223200 EDPPAYHIST_ID Primary Key
I0000850 ORDER_ID+STORE_ID Non-Unique Index
I0000910 EDPPAYINST_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1159 EDPPAYINST_ID EDPPAYINST EDPPAYINST_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1101 EDPPAYHIST_ID EDPRELHIST EDPPAYHIST_ID Cascade

Feedback