Open topic with navigation

BATCHAUCTIONITEM (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores rows for auction item batches.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier	true	BATCH.ID	FK to BATCH
AUCTIONITEMCATEGORYID	uniqueidentifier	true	AUCTIONITEMCATEGORY.ID	FK to AUCTIONITEMCATEGORY
AUCTIONITEMSUBCATEGORYID	uniqueidentifier	true	AUCTIONITEMSUBCATEGORY.ID	FK to AUCTIONITEMSUBCATEGORY
EVENTAUCTIONID	uniqueidentifier	true	EVENTAUCTION.ID	FK to EVENTAUCTION
DESIGNATIONID	uniqueidentifier	true	DESIGNATION.ID	FK to DESIGNATION
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
PDACCOUNTSYSTEMID	uniqueidentifier	true	PDACCOUNTSYSTEM.ID	FK to PDACCOUNTSYSTEM
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this revenue.
TRANSACTIONCURRENCYID	uniqueidentifier	true	CURRENCY.ID	The transaction currency associated with this revenue.

Fields
Field	Field Type	Null	Notes	Description
SEQUENCE	int	false	0
CONSTITUENTID	uniqueidentifier	false
NAME	nvarchar(100)	false	''
DESCRIPTION	nvarchar(255)	false	''
VALUE	money	false	0
MINIMUMBID	money	false	0
DONATIONDATE	datetime	true
EXPIRATIONDATE	datetime	true
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
GIVENANONYMOUSLY	bit	false	0
POSTDATE	datetime	true
POSTSTATUSCODE	tinyint	false	1	1=Not posted, 2=Do not post
POSTSTATUS	nvarchar(11) (Computed)	true		Provides a translation for the 'POSTSTATUSCODE' field.
BASEEXCHANGERATEID	uniqueidentifier	true		The exchange rate used to convert from transaction amount to amount.
EXCHANGERATE	decimal(20, 8)	false	0	The rate to use when adding a spot rate.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHAUCTIONITEM_AUCTIONITEMCATEGORYID	AUCTIONITEMCATEGORYID	False	False	False
IX_BATCHAUCTIONITEM_AUCTIONITEMSUBCATEGORYID	AUCTIONITEMSUBCATEGORYID	False	False	False
IX_BATCHAUCTIONITEM_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_BATCHAUCTIONITEM_BASEEXCHANGERATEID	BASEEXCHANGERATEID	False	False	False
IX_BATCHAUCTIONITEM_BATCHID	BATCHID	False	False	False
IX_BATCHAUCTIONITEM_CONSTITUENTID	CONSTITUENTID	False	False	False
IX_BATCHAUCTIONITEM_DATEADDED	DATEADDED	False	False	True
IX_BATCHAUCTIONITEM_DATECHANGED	DATECHANGED	False	False	False
IX_BATCHAUCTIONITEM_DESIGNATIONID	DESIGNATIONID	False	False	False
IX_BATCHAUCTIONITEM_EVENTAUCTIONID	EVENTAUCTIONID	False	False	False
IX_BATCHAUCTIONITEM_PDACCOUNTSYSTEMID	PDACCOUNTSYSTEMID	False	False	False
IX_BATCHAUCTIONITEM_TRANSACTIONCURRENCYID	TRANSACTIONCURRENCYID	False	False	False
PK_BATCHAUCTIONITEM	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHAUCTIONITEM_INSERTUPDATE_CURRENCY
TR_BATCHAUCTIONITEM_AUDIT_UPDATE
TR_BATCHAUCTIONITEM_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHAUCTIONITEMBATCHSYSTEMMESSAGES	BATCHAUCTIONITEMID
BATCHAUCTIONITEMBATCHUSERMESSAGE	ID