Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0 The amount for given revenue detail split.
 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.
 TYPECODE tinyint   Default = 0 The type of revenue split.
 APPLICATIONCODE tinyint   Default = 0 What the revenue item is applied to.
 DESCRIPTION nvarchar(700) (Computed) dbo.UFN_REVENUESPLIT_GETDESCRIPTION(ID) Provides a translation field for the revenue split
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the revenue split in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the revenue split in transaction currency.
 OVERRIDEBUSINESSUNITS bit   Default = 0 Boolean value to tell whether business units attached to the application/payment were overriden
 TYPE nvarchar(25) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Gift' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Membership' WHEN 3 THEN N'Grant award' WHEN 4 THEN N'Other' WHEN 5 THEN N'Ticket' WHEN 6 THEN N'Fee' WHEN 7 THEN N'Tax' WHEN 8 THEN N'Miscellaneous' WHEN 9 THEN N'Sponsorship' WHEN 10 THEN N'Supply/Equipment Resource' WHEN 11 THEN N'Staffing Resource' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Security deposit' WHEN 14 THEN N'Facility' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' END Provides a translation for the 'TYPECODE' field.
 APPLICATION nvarchar(18) (Computed) CASE [APPLICATIONCODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Pledge' WHEN 3 THEN N'Recurring gift' WHEN 4 THEN N'Other' WHEN 5 THEN N'Membership' WHEN 6 THEN N'Planned gift' WHEN 7 THEN N'Matching gift' WHEN 8 THEN N'Grant award' WHEN 9 THEN N'Admission' WHEN 10 THEN N'Order' WHEN 11 THEN N'Miscellaneous' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Donor challenge' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' WHEN 17 THEN N'Pending gift' END Provides a translation for the 'APPLICATIONCODE' field.

Foreign Key Field Type Null Notes Description
 REVENUEID uniqueidentifier   REVENUE.LOCALID FK to REVENUE table.
 DESIGNATIONID uniqueidentifier DESIGNATION.ID FK to DESIGNATION table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue split.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this revenue split.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amount.
 REVENUESPLITBUSINESSUNITOVERRIDECODEID uniqueidentifier REVENUESPLITBUSINESSUNITOVERRIDECODE.ID Stores the reason for overriding business units on this revenue split record.

Index Name Field(s) Unique Primary Clustered
 IX_REVENUESPLIT_APPLICATIONCODE_REVENUEID APPLICATIONCODE, REVENUEID      
 IX_REVENUESPLIT_BASECURRENCYID BASECURRENCYID      
 IX_REVENUESPLIT_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_REVENUESPLIT_DATEADDED DATEADDED    
 IX_REVENUESPLIT_DATECHANGED DATECHANGED      
 IX_REVENUESPLIT_DESIGNATIONID DESIGNATIONID      
 IX_REVENUESPLIT_ID ID      
 IX_REVENUESPLIT_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_REVENUESPLIT_REVENUEID REVENUEID      
 IX_REVENUESPLIT_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_REVENUESPLIT ID  

Trigger Name Description
 TR_REVENUESPLIT_DELETE_BBNCREVENUESPLITIDMAP
 TR_REVENUESPLIT_INSERT_BBNCREVENUESPLITIDMAP
 TR_REVENUESPLIT_AUDIT_UPDATE
 TR_REVENUESPLIT_AUDIT_DELETE
 TR_REVENUESPLIT_T2BDELETE
 TR_REVENUESPLIT_AUDIT_ETLDELETEDID
 TR_REVENUESPLIT_INSERTUPDATE_CURRENCY

Referenced by Field
 AUCTIONITEMPURCHASE PURCHASEID
 CREDITITEM REVENUESPLITID
 CREDITPAYMENT REVENUESPLITID
 DONORCHALLENGEENCUMBERED REVENUESPLITID
 EVENTREGISTRANTPAYMENT PAYMENTID
 FAFGIFTACKNOWLEDGEMENT REVENUESPLITID
 INSTALLMENTSPLITPAYMENT PAYMENTID
 MEMBERSHIPTRANSACTION REVENUESPLITID
 NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT REVENUESPLITID
 ORDERPAYMENTSPLIT PAYMENTID
 PLANNEDGIFTREVENUESPLIT REVENUESPLITID
 R68DETAIL REVENUESPLITID
 R68REFUNDDETAIL REVENUESPLITID
 RE7MAPGIFTSPLIT ID
 RECURRINGGIFTACTIVITY PAYMENTREVENUEID
 REVENUEBENEFIT REVENUESPLITID
 REVENUECATEGORY ID
 REVENUEGLDISTRIBUTIONREVENUESPLITMAP REVENUESPLITID
 REVENUEOPPORTUNITY ID
 REVENUERECOGNITION REVENUESPLITID
 REVENUESOLICITOR REVENUESPLITID
 REVENUESPLITBUSINESSUNIT REVENUESPLITID
 REVENUESPLITCAMPAIGN REVENUESPLITID
 REVENUESPLITGIFTAID ID
 REVENUESPLITGIFTAIDREFUND REVENUESPLITID
 REVENUESPLITGIFTFEE ID
 REVENUESPLITORDER ID
 REVENUESPLITOTHER ID
 SALESORDERITEMDONATION REVENUESPLITID
 SPONSORSHIP REVENUESPLITID
 SPONSORSHIPPAYMENT ID

Entity-Relationship diagram of this table (AUCTIONITEMPURCHASE-REVENUE)
Entity-Relationship diagram of this table (REVENUEBENEFIT-SPONSORSHIPPAYMENT)