ORDPAYMTHD

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

Column Descriptions:

NameTypeDescription
PAYMETHODCHAR (5) NOT NULLReserved for IBM internal use.
ORDERS_IDBIGINT NOT NULLReserved for IBM internal use.
PAYDEVICEBINARY NOT NULLReserved for IBM internal use.
STARTDATETIMESTAMPReserved for IBM internal use.
REFUNDNUMBERBIGINT NOT NULL DEFAULT 0Reserved for IBM internal use.
TRADING_IDBIGINTReserved for IBM internal use.
ACCOUNT_IDBIGINTReserved for IBM internal use.
RMA_IDBIGINTReserved for IBM internal use.
POLICY_IDBIGINTReserved for IBM internal use.
PAYSUMMARY_IDBIGINTReserved for IBM internal use.
ENDDATETIMESTAMPReserved for IBM internal use.
BUYERPO_IDBIGINTReserved for IBM internal use.
MAXAMOUNTDECIMAL (20,5)Reserved for IBM internal use.
CREDITLINE_IDBIGINTReserved for IBM internal use.
ACTUALAMOUNTDECIMAL (20,5)Reserved for IBM internal use.
CHARGEAMOUNTDECIMAL (20,5)Reserved for IBM internal use.
CHARGETIMETIMESTAMPReserved for IBM internal use.
CHARGEAMTCURRCHAR (3)Reserved for IBM internal use.
XMLDATACLOB (1000000)Reserved for IBM internal use.
STRINGFIELD1VARCHAR (254)Reserved for IBM internal use.
STRINGFIELD2VARCHAR (254)Reserved for IBM internal use.
STRINGFIELD3VARCHAR (254)Reserved for IBM internal use.
STRINGFIELD4VARCHAR (254)Reserved for IBM internal use.
STATUSINTEGER DEFAULT 0Reserved for IBM internal use.
BIGINTFIELD1BIGINTReserved for IBM internal use.
BIGINTFIELD2BIGINTReserved for IBM internal use.
BIGINTFIELD3BIGINTReserved for IBM internal use.
DECIMALFIELD1DECIMAL (20,5)Reserved for IBM internal use.
DECIMALFIELD2DECIMAL (20,5)Reserved for IBM internal use.
DECIMALFIELD3DECIMAL (20,5)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_ID+PAYMETHOD+PAYDEVICE+REFUNDNUMBERPrimary Key
I0000664CREDITLINE_IDNon-Unique Index
I0000665TRADING_IDNon-Unique Index
I0000666BUYERPO_IDNon-Unique Index
I0000667PAYSUMMARY_IDNon-Unique Index
I0000668POLICY_IDNon-Unique Index
I0000669RMA_IDNon-Unique Index
I0000670ACCOUNT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_535RMA_IDRMARMA_IDCascade
F_536POLICY_IDPOLICYPOLICY_IDCascade
F_537PAYSUMMARY_IDPAYSUMMARYPAYSUMMARY_IDCascade
F_538BUYERPO_IDBUYERPOBUYERPO_IDCascade
F_539TRADING_IDTRADINGTRADING_IDCascade
F_540CREDITLINE_IDCREDITLINECREDITLINE_IDCascade
F_541ACCOUNT_IDACCOUNTACCOUNT_IDCascade
F_542ORDERS_IDORDERSORDERS_IDCascade