BATCHREVENUEAPPLICATIONPLEDGE
Stores information about new pledges added during the revenue batch process.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| CONSTITUENTID |
uniqueidentifier |
|
|
FK to Constituent table |
| GIVENANONYMOUSLY |
bit |
|
Default = 0 |
Indicates if this revenue was given anonymously. |
| FINDERNUMBER |
bigint |
|
Default = ((0)) |
The direct marketing finder number for this record. |
| DATE |
datetime |
|
|
|
| AMOUNT |
money |
|
Default = 0 |
Amount of gift |
| SOURCECODE |
nvarchar(50) |
|
Default = '' |
The direct marketing source code for this record. |
| BENEFITSWAIVED |
bit |
|
Default = 0 |
Indicates if the benefits for this record were waived by the user. |
| FREQUENCYCODE |
tinyint |
|
Default = 0 |
Indicates the frequency of the installment. |
| NUMBEROFINSTALLMENTS |
int |
|
Default = 0 |
The number of the schedule. |
| STARTDATE |
datetime |
|
|
The start date for the schedule. |
| POSTDATE |
datetime |
yes |
|
The date to use when posting the revenue record. |
| POSTSTATUSCODE |
tinyint |
|
Default = 1 |
Indicates whether the revenue should not be posted. |
| SENDPLEDGEREMINDER |
bit |
|
Default = 1 |
Indicates whether or not to send reminders for a pledge. |
| DONOTACKNOWLEDGE |
bit |
|
Default = 0 |
Indicates that this record should not be acknowledged. |
| 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. |
| REFERENCE |
nvarchar(255) |
|
Default = '' |
Comment specific to this pledge. |
| FREQUENCY |
nvarchar(18) (Computed) |
yes |
CASE [FREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 4 THEN N'Irregular' WHEN 5 THEN N'Single Installment' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END |
Provides a translation for the 'FREQUENCYCODE' field. |
| BASEEXCHANGERATEID |
uniqueidentifier |
yes |
|
The exchange rate used to convert from transaction amount to amount. |
| EXCHANGERATE |
decimal(20, 8) |
|
Default = 0 |
The rate to use when adding a spot rate. |
| INSTALLMENTAMOUNT |
money |
|
Default = 0 |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| CHANNELCODEID |
uniqueidentifier |
yes |
CHANNELCODE.ID
|
The channel for this record. |
| APPEALID |
uniqueidentifier |
yes |
APPEAL.LOCALID
|
The appeal for this record. |
| MAILINGID |
uniqueidentifier |
yes |
MKTSEGMENTATION.ID
|
The mailing for this record. |
| PLEDGESUBTYPEID |
uniqueidentifier |
yes |
PLEDGESUBTYPE.LOCALID
|
Indicates the optional subtype for pledges. |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| GLREVENUECATEGORYMAPPINGID |
uniqueidentifier |
yes |
GLREVENUECATEGORYMAPPING.ID
|
Foreign key to the GLREVENUECATEGORYMAPPING table. |
| OPPORTUNITYID |
uniqueidentifier |
yes |
OPPORTUNITY.ID
|
The opportunity this record is associated with. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_BATCHREVENUEAPPLICATIONPLEDGE_BASEEXCHANGERATEID |
BASEEXCHANGERATEID |
|
|
|
| IX_BATCHREVENUEAPPLICATIONPLEDGE_CONSTITUENTID |
CONSTITUENTID |
|
|
|
| IX_BATCHREVENUEAPPLICATIONPLEDGE_DATEADDED |
DATEADDED |
|
|
yes |
| IX_BATCHREVENUEAPPLICATIONPLEDGE_DATECHANGED |
DATECHANGED |
|
|
|
| PK_BATCHREVENUEAPPLICATIONPLEDGE |
ID |
yes |
yes |
|
Triggers
Referenced by