REVENUESPLITORDER

Stores information about order revenue applications.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		FINANCIALTRANSACTIONLINEITEM.ID	Primary Key.
PROGRAMID	uniqueidentifier	yes	PROGRAM.ID	The program of this application.
FEEID	uniqueidentifier	yes	FEE.ID	The fee for this application.
TAXID	uniqueidentifier	yes	TAX.ID	The tax for this application.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
MEMBERSHIPLEVELID	uniqueidentifier	yes	MEMBERSHIPLEVEL.ID	The membership level for this application.
EVENTID	uniqueidentifier	yes	EVENT.ID	The event for this application.
RESOURCEID	uniqueidentifier	yes	RESOURCE.ID	The supply/equipment resource for this application.
VOLUNTEERTYPEID	uniqueidentifier	yes	VOLUNTEERTYPE.LOCALID	The staffing resource for this application.
EVENTLOCATIONID	uniqueidentifier	yes	EVENTLOCATION.ID	The event location for this application.
MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier	yes	MERCHANDISEPRODUCTINSTANCE.ID	The merchandise product instance for this application.
MEMBERSHIPADDONID	uniqueidentifier	yes	MEMBERSHIPADDON.ID
DESIGNATIONID	uniqueidentifier	yes	DESIGNATION.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REVENUESPLITORDER_DATEADDED	DATEADDED			yes
IX_REVENUESPLITORDER_DATECHANGED	DATECHANGED
PK_REVENUESPLITORDER	ID	yes	yes

Triggers

Trigger Name	Description
TR_REVENUESPLITORDER_AUDIT_UPDATE
TR_REVENUESPLITORDER_AUDIT_DELETE