REFUNDMTHD

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
RMA_IDBIGINT NOT NULLReserved for IBM internal use.
ORDERS_IDBIGINT NOT NULLReserved for IBM internal use.
TRADING_IDBIGINTReserved for IBM internal use.
SETCCURRCHAR (3)Reserved for IBM internal use.
ACCOUNT_IDBIGINTReserved for IBM internal use.
CREDITLINE_IDBIGINTReserved for IBM internal use.
POLICY_IDBIGINT NOT NULLReserved for IBM internal use.
PAYSUMMARY_IDBIGINTReserved for IBM internal use.
REFUNDAMOUNTDECIMAL (20,5) NOT NULLReserved for IBM internal use.
RETURNXMLVARCHAR (4000)Reserved for IBM internal use.
TIMECREATEDTIMESTAMPReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMA_ID+ORDERS_IDPrimary Key
I0000718ORDERS_IDNon-Unique Index
I0000719TRADING_IDNon-Unique Index
I0000720CREDITLINE_IDNon-Unique Index
I0000721POLICY_IDNon-Unique Index
I0000722PAYSUMMARY_IDNon-Unique Index
I0000723ACCOUNT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_666ACCOUNT_IDTRADINGTRADING_IDCascade
F_667SETCCURRSETCURRSETCCURRCascade
F_668PAYSUMMARY_IDPAYSUMMARYPAYSUMMARY_IDCascade
F_669POLICY_IDPOLICYPOLICY_IDCascade
F_670CREDITLINE_IDCREDITLINECREDITLINE_IDCascade
F_671TRADING_IDACCOUNTACCOUNT_IDCascade
F_672ORDERS_IDORDERSORDERS_IDCascade
F_673RMA_IDRMARMA_IDCascade