Open topic with navigation

EVENTEXPENSE (4.0SP20)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Contains information pertaining to an event expense.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
EVENTID	uniqueidentifier	false	EVENT.ID	FK to EVENT
EVENTEXPENSETYPECODEID	uniqueidentifier	false	EVENTEXPENSETYPECODE.ID	FK to EVENTEXPENSETYPECODE
VENDORID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this expense.
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert to organization amount.

Fields
Field	Field Type	Null	Notes	Description
BUDGETEDAMOUNT	money	false	0	The budgeted amount for this expense in base currency.
ACTUALAMOUNT	money	false	0	The actual amount charged by the vendor for this expense in base currency.
AMOUNTPAID	money	false	0	The amount paid for this expense in base currency.
DATEDUE	datetime	true
DATEPAID	datetime	true
COMMENT	nvarchar(250)	false	''
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.
ORGANIZATIONBUDGETEDAMOUNT	money	false	0	The budgeted amount for this expense in organization currency.
ORGANIZATIONACTUALAMOUNT	money	false	0	The actual amount charged by the vendor for this expense in organization currency.
ORGANIZATIONAMOUNTPAID	money	false	0	The amount paid for this expense in organization currency.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_EVENTEXPENSE_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_EVENTEXPENSE_DATEADDED	DATEADDED	False	False	True
IX_EVENTEXPENSE_DATECHANGED	DATECHANGED	False	False	False
IX_EVENTEXPENSE_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID	False	False	False
IX_EVENTEXPENSE_VENDORID	VENDORID	False	False	False
PK_EVENTEXPENSE	ID	True	True	False

Triggers
Trigger Name	Description
TR_EVENTEXPENSE_INSERTUPDATE_CURRENCY
TR_EVENTEXPENSE_AUDIT_UPDATE
TR_EVENTEXPENSE_AUDIT_DELETE