AUCTION

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

Column Descriptions:

Name	Type	Description
AUCT_ID	BIGINT NOT NULL	Reserved for HCL internal use.
REFCODE	CHAR (36) NOT NULL	Reserved for HCL internal use.
AUCPAYINFO_ID	BIGINT	Reserved for HCL internal use.
OWNER_ID	BIGINT NOT NULL	Reserved for HCL internal use.
CATENTRY_ID	BIGINT NOT NULL	Reserved for HCL internal use.
ADMIN_ID	BIGINT	Reserved for HCL internal use.
FFMCENTER_ID	INTEGER	Reserved for HCL internal use.
AUTYPE	CHAR (4) NOT NULL	Reserved for HCL internal use.
AUSTATUS	CHAR (4) NOT NULL	Reserved for HCL internal use.
AUQUANT	DOUBLE NOT NULL	Reserved for HCL internal use.
BIDRULE_ID	BIGINT	Reserved for HCL internal use.
QUANTSCALE	INTEGER	Reserved for HCL internal use.
RESRVPRICE	DECIMAL (20,5)	Reserved for HCL internal use.
OPENPRICE	DECIMAL (20,5)	Reserved for HCL internal use.
CURRPRICE	DECIMAL (20,5)	Reserved for HCL internal use.
CURRQUANT	DOUBLE	Reserved for HCL internal use.
CLOSEPR	CHAR (4)	Reserved for HCL internal use.
CURRENCY	CHAR (4)	Reserved for HCL internal use.
PAYMETHODS	CHAR (254)	Reserved for HCL internal use.
CLOSETYPE	INTEGER	Reserved for HCL internal use.
RULEPAGE	VARCHAR (254)	Reserved for HCL internal use.
STARTTIME	TIMESTAMP	Reserved for HCL internal use.
ENDTIME	TIMESTAMP	Reserved for HCL internal use.
REALENDTIME	TIMESTAMP	Reserved for HCL internal use.
DURATION	TIMESTAMP	Reserved for HCL internal use.
DEPOSIT	DECIMAL (20,5)	Reserved for HCL internal use.
BESTBID_ID	BIGINT	Reserved for HCL internal use.
HIGHBID_ID	BIGINT	Reserved for HCL internal use.
LOCKFLAG	INTEGER	Reserved for HCL internal use.
UPDATETIME	TIMESTAMP	Reserved for HCL internal use.
LASTBKTIME	TIMESTAMP	Reserved for HCL internal use.
PRECEDENCE	INTEGER	Reserved for HCL internal use.
FIELD1	BIGINT	Reserved for HCL internal use.
FIELD2	BIGINT	Reserved for HCL internal use.
RETRACT_BID	INTEGER	Reserved for HCL internal use.
FIELD3	DECIMAL (20,5)	Reserved for HCL internal use.
FIELD4	DECIMAL (20,5)	Reserved for HCL internal use.
FIELD5	VARCHAR (254)	Reserved for HCL internal use.
MBRGRP_ID	BIGINT	Reserved for HCL internal use.
FIELD6	VARCHAR (254)	Reserved for HCL internal use.
SUPPLIER_ID	BIGINT	Reserved for HCL internal use.
DURDAYS	INTEGER	Reserved for HCL internal use.
REFPRICE	DECIMAL (20,5)	Reserved for HCL internal use.
STATE	INTEGER	Reserved for HCL internal use.
INVRSRVID	BIGINT	Reserved for HCL internal use.
AUCMODE	CHAR (4)	Reserved for HCL internal use.
PRICELIMIT	DECIMAL (20,5)	Reserved for HCL internal use.
QUANTLIMIT	DOUBLE	Reserved for HCL internal use.
DURLENGTH	INTEGER	Reserved for HCL internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for HCL internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	AUCT_ID	Primary Key
I0000022	REFCODE	Unique Index
I0000023	ENDTIME	Non-Unique Index
I0000024	REFPRICE	Non-Unique Index
I0000025	STATE	Non-Unique Index
I0000026	AUTYPE	Non-Unique Index
I0000027	AUSTATUS	Non-Unique Index
I0000028	LOCKFLAG	Non-Unique Index
I0000029	UPDATETIME	Non-Unique Index
I0000030	LASTBKTIME	Non-Unique Index
I0000031	STARTTIME	Non-Unique Index
I0000455	BIDRULE_ID	Non-Unique Index
I0000456	ADMIN_ID	Non-Unique Index
I0000457	OWNER_ID	Non-Unique Index
I0000458	FFMCENTER_ID	Non-Unique Index
I0000459	CATENTRY_ID	Non-Unique Index
I0000460	MBRGRP_ID	Non-Unique Index
I0001237	AUCPAYINFO_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_80	AUCPAYINFO_ID	AUCPAYINFO	AUCPAYINFO_ID	Cascade
F_81	BIDRULE_ID	CONTRLRULE	RULE_ID	Cascade
F_82	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade
F_83	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_84	FFMCENTER_ID	FFMCENTER	FFMCENTER_ID	Cascade
F_85	OWNER_ID	MEMBER	MEMBER_ID	Cascade
F_86	ADMIN_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_112	AUCT_ID	BID	AUCT_ID	Cascade
F_457	AUCT_ID	MEMBRAUCT	AUCT_ID	Cascade
F_78	AUCT_ID	AUCTDESC	AUCT_ID	Cascade
F_92	AUCT_ID	AUCTSTRREL	AUCT_ID	Cascade
F_98	AUCT_ID	AUTOBID	AUCT_ID	Cascade