ORDPAYMTHD
Deprecated. Provided for backward compatibility only.
Column Descriptions:
Name Type Description PAYMETHOD CHAR (5) NOT NULL Reserved for IBM internal use. ORDERS_ID BIGINT NOT NULL Reserved for IBM internal use. PAYDEVICE BINARY NOT NULL Reserved for IBM internal use. STARTDATE TIMESTAMP Reserved for IBM internal use. REFUNDNUMBER BIGINT NOT NULL DEFAULT 0 Reserved for IBM internal use. TRADING_ID BIGINT Reserved for IBM internal use. ACCOUNT_ID BIGINT Reserved for IBM internal use. RMA_ID BIGINT Reserved for IBM internal use. POLICY_ID BIGINT Reserved for IBM internal use. PAYSUMMARY_ID BIGINT Reserved for IBM internal use. ENDDATE TIMESTAMP Reserved for IBM internal use. BUYERPO_ID BIGINT Reserved for IBM internal use. MAXAMOUNT DECIMAL (20,5) Reserved for IBM internal use. CREDITLINE_ID BIGINT Reserved for IBM internal use. ACTUALAMOUNT DECIMAL (20,5) Reserved for IBM internal use. CHARGEAMOUNT DECIMAL (20,5) Reserved for IBM internal use. CHARGETIME TIMESTAMP Reserved for IBM internal use. CHARGEAMTCURR CHAR (3) Reserved for IBM internal use. XMLDATA CLOB (1000000) Reserved for IBM internal use. STRINGFIELD1 VARCHAR (254) Reserved for IBM internal use. STRINGFIELD2 VARCHAR (254) Reserved for IBM internal use. STRINGFIELD3 VARCHAR (254) Reserved for IBM internal use. STRINGFIELD4 VARCHAR (254) Reserved for IBM internal use. STATUS INTEGER DEFAULT 0 Reserved for IBM internal use. BIGINTFIELD1 BIGINT Reserved for IBM internal use. BIGINTFIELD2 BIGINT Reserved for IBM internal use. BIGINTFIELD3 BIGINT Reserved for IBM internal use. DECIMALFIELD1 DECIMAL (20,5) Reserved for IBM internal use. DECIMALFIELD2 DECIMAL (20,5) Reserved for IBM internal use. DECIMALFIELD3 DECIMAL (20,5) Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM 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
Related reference
Order data model