ORDPAYMTHD

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

Column Descriptions:

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