WebSphere Commerce database table: REFUNDMTHD

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
RMA_ID BIGINT NOT NULL Reserved for IBM internal use.
ORDERS_ID BIGINT NOT NULL Reserved for IBM internal use.
TRADING_ID BIGINT Reserved for IBM internal use.
SETCCURR CHAR(3) Reserved for IBM internal use.
ACCOUNT_ID BIGINT Reserved for IBM internal use.
CREDITLINE_ID BIGINT Reserved for IBM internal use.
POLICY_ID BIGINT NOT NULL Reserved for IBM internal use.
PAYSUMMARY_ID BIGINT Reserved for IBM internal use.
REFUNDAMOUNT DECIMAL (20,5) NOT NULL Reserved for IBM internal use.
RETURNXML VARCHAR(4000) Reserved for IBM internal use.
TIMECREATED TIMESTAMP Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031304230 RMA_ID+ORDERS_ID Primary Key
I0000718 ORDERS_ID Non-Unique Index
I0000719 TRADING_ID Non-Unique Index
I0000720 CREDITLINE_ID Non-Unique Index
I0000721 POLICY_ID Non-Unique Index
I0000722 PAYSUMMARY_ID Non-Unique Index
I0000723 ACCOUNT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_671 TRADING_ID ACCOUNT ACCOUNT_ID Cascade
F_670 CREDITLINE_ID CREDITLINE CREDITLINE_ID Cascade
F_672 ORDERS_ID ORDERS ORDERS_ID Cascade
F_668 PAYSUMMARY_ID PAYSUMMARY PAYSUMMARY_ID Cascade
F_669 POLICY_ID POLICY POLICY_ID Cascade
F_673 RMA_ID RMA RMA_ID Cascade
F_667 SETCCURR SETCURR SETCCURR Cascade
F_666 ACCOUNT_ID TRADING TRADING_ID Cascade

Feedback