REVENUESPLITTEMP
Contains revenue detail split information for a given revenue detail record.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| ID |
uniqueidentifier |
|
Default = (newid()) |
Primary Key. |
| REVENUEID |
uniqueidentifier |
|
|
FK to REVENUE table. |
| DESIGNATIONID |
uniqueidentifier |
yes |
|
FK to DESIGNATION table. |
| AMOUNT |
money |
|
Default = 0 |
The amount for given revenue detail split. |
| ADDEDBYID |
uniqueidentifier |
|
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
|
FK to CHANGEAGENT. |
| 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. |
| TYPECODE |
tinyint |
|
Default = 0 |
The type of revenue split. |
| APPLICATIONCODE |
tinyint |
|
Default = 0 |
What the revenue item is applied to. |
| BASECURRENCYID |
uniqueidentifier |
yes |
|
The base currency associated with this revenue split. |
| ORGANIZATIONAMOUNT |
money |
|
Default = 0 |
The amount of the revenue split in organization currency. |
| ORGANIZATIONEXCHANGERATEID |
uniqueidentifier |
yes |
|
The exchange rate used to calculate the organization amount. |
| TRANSACTIONAMOUNT |
money |
|
Default = 0 |
The amount of the revenue split in transaction currency. |
| TRANSACTIONCURRENCYID |
uniqueidentifier |
yes |
|
The transaction currency associated with this revenue split. |
| BASEEXCHANGERATEID |
uniqueidentifier |
yes |
|
The exchange rate used to calculate the base amount. |
| OVERRIDEBUSINESSUNITS |
bit |
|
Default = 0 |
Boolean value to tell whether business units attached to the application/payment were overridden |
| REVENUESPLITBUSINESSUNITOVERRIDECODEID |
uniqueidentifier |
yes |
|
Stores the reason for overriding business units on this revenue split record. |
| APPLICATION |
nvarchar(18) (Computed) |
yes |
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. |
| TYPE |
nvarchar(27) (Computed) |
yes |
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' WHEN 17 THEN N'Sponsorship additional gift' END |
Provides a translation for the 'TYPECODE' field. |
| DESCRIPTION |
nvarchar(700) (Computed) |
yes |
dbo.UFN_REVENUESPLIT_GETDESCRIPTION(ID) |
|
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_REVENUESPLIT_DATEADDED |
DATEADDED |
|
|
yes |
Triggers