BATCHAUCTIONITEM (4.0SP17)

ID

uniqueidentifier

BATCHID

uniqueidentifier

true

FK to BATCH

AUCTIONITEMCATEGORYID

uniqueidentifier

true

FK to AUCTIONITEMCATEGORY

AUCTIONITEMSUBCATEGORYID

uniqueidentifier

true

FK to AUCTIONITEMSUBCATEGORY

EVENTAUCTIONID

uniqueidentifier

true

FK to EVENTAUCTION

DESIGNATIONID

uniqueidentifier

true

FK to DESIGNATION

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PDACCOUNTSYSTEMID

uniqueidentifier

true

FK to PDACCOUNTSYSTEM

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this revenue.

TRANSACTIONCURRENCYID

uniqueidentifier

true

The transaction currency associated with this revenue.

SEQUENCE

int

false

CONSTITUENTID

uniqueidentifier

false

NAME

nvarchar(100)

false

DESCRIPTION

nvarchar(255)

false

VALUE

money

false

MINIMUMBID

money

false

DONATIONDATE

datetime

true

EXPIRATIONDATE

datetime

true

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

GIVENANONYMOUSLY

bit

false

POSTDATE

datetime

true

POSTSTATUSCODE

tinyint

false

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

The rate to use when adding a spot rate.

IX_BATCHAUCTIONITEM_AUCTIONITEMCATEGORYID

False

False

False

IX_BATCHAUCTIONITEM_AUCTIONITEMSUBCATEGORYID

False

False

False

IX_BATCHAUCTIONITEM_BASECURRENCYID

False

False

False

IX_BATCHAUCTIONITEM_BASEEXCHANGERATEID

False

False

False

IX_BATCHAUCTIONITEM_BATCHID

False

False

False

IX_BATCHAUCTIONITEM_CONSTITUENTID

False

False

False

IX_BATCHAUCTIONITEM_DATEADDED

False

False

True

IX_BATCHAUCTIONITEM_DATECHANGED

False

False

False

IX_BATCHAUCTIONITEM_DESIGNATIONID

False

False

False

IX_BATCHAUCTIONITEM_EVENTAUCTIONID

False

False

False

IX_BATCHAUCTIONITEM_PDACCOUNTSYSTEMID

False

False

False

IX_BATCHAUCTIONITEM_TRANSACTIONCURRENCYID

False

False

False

PK_BATCHAUCTIONITEM

True

True

False

TR_BATCHAUCTIONITEM_INSERTUPDATE_CURRENCY

TR_BATCHAUCTIONITEM_AUDIT_UPDATE

TR_BATCHAUCTIONITEM_AUDIT_DELETE

BATCHAUCTIONITEMBATCHSYSTEMMESSAGES

BATCHAUCTIONITEMID

BATCHAUCTIONITEMBATCHUSERMESSAGE

ID