|
Id
|
integer
|
|
N
|
|
Auto-assigned
|
|
AccountId
|
integer
|
|
N
|
|
|
|
AppealId
|
integer
|
|
N
|
|
|
|
BatchId
|
integer
|
|
N
|
|
|
| FK: T_BATCH.batch_no |
|
BillingAccount
|
string
|
30
|
N
|
|
|
|
BillingTypeId
|
integer
|
|
N
|
|
|
|
BusinessUnitId
|
integer
|
|
N
|
|
|
|
Campaign
|
CampaignSummary
|
|
N
|
|
|
| FK: T_CAMPAIGN.campaign_no Resource: Campaigns |
|
Cancel
|
string
|
|
N
|
|
|
|
Channel
|
SalesChannelSummary
|
|
N
|
|
|
| FK: TR_SALES_CHANNEL.id Resource: SalesChannels |
|
ContributionAmount
|
decimal number
|
|
N
|
|
|
|
ContributionDesignation
|
integer
|
|
N
|
|
|
|
ContributionDateTime
|
date
|
|
N
|
|
|
|
Type
|
string
|
|
N
|
|
|
|
CreatedDateTime
|
date
|
|
N
|
|
Auto-assigned
|
|
CreateLocation
|
string
|
|
N
|
|
Auto-assigned
|
|
CreatedBy
|
string
|
|
N
|
|
Auto-assigned
|
|
Custom0
|
string
|
255
|
N
|
|
|
|
Custom1
|
string
|
255
|
N
|
|
|
|
Custom2
|
string
|
255
|
N
|
|
|
|
Custom3
|
string
|
255
|
N
|
|
|
|
Custom4
|
string
|
255
|
N
|
|
|
|
Custom5
|
string
|
255
|
N
|
|
|
|
Custom6
|
string
|
255
|
N
|
|
|
|
Custom7
|
string
|
255
|
N
|
|
|
|
Custom8
|
string
|
255
|
N
|
|
|
|
Custom9
|
string
|
255
|
N
|
|
|
|
Initiator
|
ConstituentDisplaySummary
|
|
N
|
|
|
| FK: T_CUSTOMER.customer_no Resource: Constituents |
|
Constituent
|
ConstituentDisplaySummary
|
|
Y
|
|
|
| FK: T_CUSTOMER.customer_no Resource: Constituents |
|
Fund
|
FundSummary
|
|
N
|
|
|
| FK: T_FUND.fund_no Resource: Funds |
|
Plan
|
PlanSummary
|
|
N
|
|
|
| FK: T_PLAN.plan_no Resource: Plans |
|
KindGiftTransferDateTime
|
date
|
|
N
|
|
|
|
KindGiftDescription
|
string
|
50
|
N
|
|
|
|
UpdatedDateTime
|
date
|
|
N
|
|
Auto-assigned
|
|
UpdatedBy
|
string
|
|
N
|
|
Auto-assigned
|
|
MatchIndicator
|
string
|
|
N
|
|
|
|
MatchingContributionId
|
integer
|
|
N
|
|
|
|
MediaType
|
MediaTypeSummary
|
|
N
|
|
|
| FK: TR_MEDIA_TYPE.id Resource: MediaTypes |
|
MirrorLock
|
integer
|
|
N
|
|
|
|
Notes
|
string
|
255
|
N
|
|
|
|
PaymentEndDateTime
|
date
|
|
N
|
|
|
|
PledgeStatusId
|
integer
|
|
N
|
|
|
|
PaymentStartDateTime
|
date
|
|
N
|
|
|
|
ReceivedAmount
|
decimal number
|
|
N
|
|
|
|
Solicitor
|
string
|
8
|
N
|
|
|
|
SourceId
|
integer
|
|
N
|
|
|
|
EditIndicator
|
boolean
|
|
|
|
|