Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AUCTIONITEM_MAPPINGID int   Default = 0 The mapping ID used to identify this item in AuctionMaestro Pro.
 AUCTIONITEM_UPDATEDNAME nvarchar(100)   Default = '' Name of the item.
 AUCTIONITEM_UPDATEDDESCRIPTION nvarchar(255)   Default = '' Description of the item.
 AUCTIONITEM_UPDATEDEXPIRATIONDATE datetime Dxpiration date of the item.
 AUCTIONITEM_UPDATEDDONATIONDATE datetime   Donation date of the item
 AUCTIONITEM_UPDATEDCATEGORY nvarchar(100)   Default = '' Category of the item
 AUCTIONITEM_UPDATEDSUBCATEGORY nvarchar(100)   Default = '' Subcategory of the item
 AUCTIONITEM_UPDATEDMINIMUMBID money   Default = 0 Minimum bid of the item
 AUCTIONITEM_UPDATEDVALUE money   Default = 0 Value of the item
 AUCTIONITEM_CONSTITUENTID uniqueidentifier
 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.
 AUCTIONITEM_ADJUSTMENTDATE datetime
 AUCTIONITEM_ADJUSTMENTPOSTDATE datetime
 AUCTIONITEM_ADJUSTMENTREASON nvarchar(300)   Default = ''

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   BATCHAMPROIMPORT.ID Primary Key.
 AUCTIONITEM_LINKID uniqueidentifier AUCTIONITEM.ID FK to AUCTIONITEM
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 AUCTIONITEM_ADJUSTMENTREASONCODEID uniqueidentifier ADJUSTMENTREASONCODE.ID FK to ADJUSTMENTREASONCODE

Index Name Field(s) Unique Primary Clustered
 IX_BATCHAMPROIMPORTITEM_DATEADDED DATEADDED    
 IX_BATCHAMPROIMPORTITEM_DATECHANGED DATECHANGED      
 PK_BATCHAMPROIMPORTITEM ID  

Trigger Name Description
 TR_BATCHAMPROIMPORTITEM_AUDIT_UPDATE
 TR_BATCHAMPROIMPORTITEM_AUDIT_DELETE

Entity-Relationship diagram of this table