Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Name of the item
 DESCRIPTION nvarchar(255)   Default = '' Description of the item
 VALUE money   Default = 0 Value of the item
 MINIMUMBID money   Default = 0 Minimum bid for the item
 EXPIRATIONDATE datetime
 TYPECODE tinyint   Default = 0 Type (item or package) of the auction item.
 TYPE nvarchar(7) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Item' WHEN 1 THEN N'Package' END Provides a translation for the 'TYPECODE' field.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'ITEM-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifer that supports user defined values as well as system generated values.
 TRANSACTIONVALUE money   Default = 0 VALUE of the item in transaction currency.
 ORGANIZATIONVALUE money   Default = 0 VALUE of the item in organization currency.
 ORGANIZATIONMINIMUMBID money   Default = 0 MINIMUMBID of the item in organization currency.
 TRANSACTIONMINIMUMBID money   Default = 0 MINIMUMBID of the item in transaction currency.

Foreign Key Field Type Null Notes Description
 AUCTIONITEMCATEGORYID uniqueidentifier AUCTIONITEMCATEGORY.ID FK to AUCTIONITEMCATEGORY
 AUCTIONITEMSUBCATEGORYID uniqueidentifier AUCTIONITEMSUBCATEGORY.ID FK to AUCTIONITEMSUBCATEGORY
 EVENTAUCTIONID uniqueidentifier EVENTAUCTION.ID Auction
 PACKAGEID uniqueidentifier AUCTIONITEM.ID Package
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 COPIEDFROMID uniqueidentifier AUCTIONITEM.ID FK to AUCTIONITEM
 REVENUEAUCTIONDONATIONID uniqueidentifier REVENUEAUCTIONDONATION.ID Revenue record
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this auction item.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amounts.
 BASETOORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The rate used to convert the minimum bid field. The minimum bid field will only be in base currency.
 ORIGINTOORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The rate used to convert the value field.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this auction item.

Index Name Field(s) Unique Primary Clustered
 IX_AUCTIONITEM_AUCTIONITEMCATEGORYID AUCTIONITEMCATEGORYID      
 IX_AUCTIONITEM_AUCTIONITEMSUBCATEGORYID AUCTIONITEMSUBCATEGORYID      
 IX_AUCTIONITEM_BASECURRENCYID BASECURRENCYID      
 IX_AUCTIONITEM_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_AUCTIONITEM_BASETOORGANIZATIONEXCHANGERATEID BASETOORGANIZATIONEXCHANGERATEID      
 IX_AUCTIONITEM_DATEADDED DATEADDED    
 IX_AUCTIONITEM_DATECHANGED DATECHANGED      
 IX_AUCTIONITEM_EVENTAUCTIONID EVENTAUCTIONID      
 IX_AUCTIONITEM_ORIGINTOORGANIZATIONEXCHANGERATEID ORIGINTOORGANIZATIONEXCHANGERATEID      
 IX_AUCTIONITEM_PACKAGEID PACKAGEID      
 IX_AUCTIONITEM_REVENUEAUCTIONDONATIONID REVENUEAUCTIONDONATIONID      
 IX_AUCTIONITEM_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_AUCTIONITEM ID  
 UC_AUCTIONITEM_LOOKUPID LOOKUPID    

Trigger Name Description
 TR_AUCTIONITEM_INSERTUPDATE_CURRENCY
 TR_AUCTIONITEM_AUDIT_UPDATE
 TR_AUCTIONITEM_AUDIT_DELETE

Referenced by Field
 AUCTIONITEMPURCHASE AUCTIONITEMID
 AUCTIONITEMRESERVATION AUCTIONITEMID
 AUCTIONITEMREVENUEPURCHASE AUCTIONITEMID
 BATCHAMPROIMPORTITEM AUCTIONITEM_LINKID
 BATCHAMPROIMPORTPACKAGE PACKAGE_LINKID

Entity-Relationship diagram of this table