ORDPAYMTHD

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

Column Descriptions:

Name	Type	Description
PAYMETHOD	CHAR (5) NOT NULL	Reserved for HCL internal use.
ORDERS_ID	BIGINT NOT NULL	Reserved for HCL internal use.
PAYDEVICE	BINARY NOT NULL	Reserved for HCL internal use.
STARTDATE	TIMESTAMP	Reserved for HCL internal use.
REFUNDNUMBER	BIGINT NOT NULL DEFAULT 0	Reserved for HCL internal use.
TRADING_ID	BIGINT	Reserved for HCL internal use.
ACCOUNT_ID	BIGINT	Reserved for HCL internal use.
RMA_ID	BIGINT	Reserved for HCL internal use.
POLICY_ID	BIGINT	Reserved for HCL internal use.
PAYSUMMARY_ID	BIGINT	Reserved for HCL internal use.
ENDDATE	TIMESTAMP	Reserved for HCL internal use.
BUYERPO_ID	BIGINT	Reserved for HCL internal use.
MAXAMOUNT	DECIMAL (20,5)	Reserved for HCL internal use.
CREDITLINE_ID	BIGINT	Reserved for HCL internal use.
ACTUALAMOUNT	DECIMAL (20,5)	Reserved for HCL internal use.
CHARGEAMOUNT	DECIMAL (20,5)	Reserved for HCL internal use.
CHARGETIME	TIMESTAMP	Reserved for HCL internal use.
CHARGEAMTCURR	CHAR (3)	Reserved for HCL internal use.
XMLDATA	CLOB (1000000)	Reserved for HCL internal use.
STRINGFIELD1	VARCHAR (254)	Reserved for HCL internal use.
STRINGFIELD2	VARCHAR (254)	Reserved for HCL internal use.
STRINGFIELD3	VARCHAR (254)	Reserved for HCL internal use.
STRINGFIELD4	VARCHAR (254)	Reserved for HCL internal use.
STATUS	INTEGER DEFAULT 0	Reserved for HCL internal use.
BIGINTFIELD1	BIGINT	Reserved for HCL internal use.
BIGINTFIELD2	BIGINT	Reserved for HCL internal use.
BIGINTFIELD3	BIGINT	Reserved for HCL internal use.
DECIMALFIELD1	DECIMAL (20,5)	Reserved for HCL internal use.
DECIMALFIELD2	DECIMAL (20,5)	Reserved for HCL internal use.
DECIMALFIELD3	DECIMAL (20,5)	Reserved for HCL internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for HCL internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDERS_ID+PAYMETHOD+PAYDEVICE+REFUNDNUMBER	Primary Key
I0000664	CREDITLINE_ID	Non-Unique Index
I0000665	TRADING_ID	Non-Unique Index
I0000666	BUYERPO_ID	Non-Unique Index
I0000667	PAYSUMMARY_ID	Non-Unique Index
I0000668	POLICY_ID	Non-Unique Index
I0000669	RMA_ID	Non-Unique Index
I0000670	ACCOUNT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_535	RMA_ID	RMA	RMA_ID	Cascade
F_536	POLICY_ID	POLICY	POLICY_ID	Cascade
F_537	PAYSUMMARY_ID	PAYSUMMARY	PAYSUMMARY_ID	Cascade
F_538	BUYERPO_ID	BUYERPO	BUYERPO_ID	Cascade
F_539	TRADING_ID	TRADING	TRADING_ID	Cascade
F_540	CREDITLINE_ID	CREDITLINE	CREDITLINE_ID	Cascade
F_541	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade
F_542	ORDERS_ID	ORDERS	ORDERS_ID	Cascade