GiftTransaction DMO

Object API Name: ssot__GiftTransaction__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• GiftCommitmentId has a FOREIGNKEY relationship with the Gift Commitment DMO Id field.
• GiftCommitmentScheduleId has a FOREIGNKEY relationship with the Gift Commitment Schedule DMO Id field.
• PaymentMethodId has a FOREIGNKEY relationship with the Payment Method DMO Id field.
• OutreachSourceCodeId has a FOREIGNKEY relationship with the Outreach Source Code DMO Id field.
• DonorId has a FOREIGNKEY relationship with the Account DMO Id field.
• CampaignId has a FOREIGNKEY relationship with the Campaign DMO Id field.
• PaymentInstrumentId has a FOREIGNKEY relationship with the Payment Instrument DMO Id field.
• ContactId has a FOREIGNKEY relationship with the Individual DMO Id field.
• MatchingEmployerTransactionId has a FOREIGNKEY relationship with the GiftTransaction DMO Id field.

• AcknowledgementDate
• AcknowledgementStatus
• AdvancementType
• CampaignId
• cdp_sys_record_currency
• CheckDate
• ContactId
• CreatedDate
• CurrentAmount
• DataSourceId
• DataSourceObjectId
• Description
• DonorCoverAmount
• DonorGiftConceptId
• DonorId
• GatewayReference
• GatewayTransactionFeeAmount
• GenerationalCohort
• GiftAgreementId
• GiftCommitmentId
• GiftCommitmentScheduleId
• GiftTransactionStatus
• GiftType
• GraduationAchievement
• GraduationCohort
• Id
• InternalOrganizationId
• IsFullyRefunded
• IsPaid
• IsPartiallyRefunded
• IsWrittenOff
• KQ_CampaignId
• KQ_ContactId
• KQ_DonorId
• KQ_GiftCommitmentId
• KQ_GiftCommitmentScheduleId
• KQ_Id
• KQ_MatchingEmployerTransactionId
• KQ_OutreachSourceCodeId
• KQ_PaymentInstrumentId
• KQ_PaymentMethodId
• LastGatewayErrorMessage
• LastGatewayProcessedDate
• LastGatewayResponseCode
• MatchingEmployerTransactionId
• Name
• NonTaxDeductibleAmount
• OriginalAmount
• OutreachSourceCodeId
• PartyPhilanthropicRsrchPrflId
• PaymentIdentifier
• PaymentInstrumentId
• PaymentMethodId
• ProcessorReference
• ProcessorTransactionFeeAmount
• RefundedAmount
• TaxDeductionAmount
• TaxReceiptStatus
• TotalTransactionFeeAmount
• TransactionDate

• Field API Name: ssot__AcknowledgementDate__c
• Data Type: DATETIME
• Description: The date and time of the acknowledgement date.

• Field API Name: ssot__AcknowledgementStatus__c
• Data Type: TEXT
• Description: The status of the acknowledgement that’s sent for the gift transaction.

• Field API Name: ssot__AdvancementType__c
• Data Type: TEXT
• Description: The type of advancement that matches the role or relationship of the person with the institution. Example values include Alumni, Student, Parent.

• Field API Name: ssot__CampaignId__c
• Data Type: TEXT
• Description: The campaign associated with the gift transaction.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__CheckDate__c
• Data Type: DATETIME
• Description: The date and time of the check date.

• Field API Name: ssot__ContactId__c
• Data Type: TEXT
• Description: The contact associated with the gift transaction.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time when this record was created.

• Field API Name: ssot__CurrentAmount__c
• Data Type: DOUBLE
• Description: The total amount of the gift transaction and donor cover after refunds.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: The description of the gift transaction.

• Field API Name: ssot__DonorCoverAmount__c
• Data Type: DOUBLE
• Description: The amount the donor added to their gift to cover fees.

• Field API Name: ssot__DonorGiftConceptId__c
• Data Type: TEXT
• Description: The gift concept associated with the gift transaction.

• Field API Name: ssot__DonorId__c
• Data Type: TEXT
• Description: The person, household, or organization account associated with the gift transaction.

• Field API Name: ssot__GatewayReference__c
• Data Type: TEXT
• Description: Reference of the transaction that the payment processor assigned.

• Field API Name: ssot__GatewayTransactionFeeAmount__c
• Data Type: DOUBLE
• Description: The transaction fee charged by the payment gateway.

• Field API Name: ssot__GenerationalCohort__c
• Data Type: TEXT
• Description: The person’s generational cohort, or age group, based on their birth date. Example values include Silent Generation (1928-1945), Baby Boomers (1946-1964), Generation X (1965-1980).

• Field API Name: ssot__GiftAgreementId__c
• Data Type: TEXT
• Description: The gift agreement associated with the gift transaction.

• Field API Name: ssot__GiftCommitmentId__c
• Data Type: TEXT
• Description: The gift commitment associated with the gift transaction.

• Field API Name: ssot__GiftCommitmentScheduleId__c
• Data Type: TEXT
• Description: The gift commitment schedule associated with the gift transaction.

• Field API Name: ssot__GiftTransactionStatus__c
• Data Type: TEXT
• Description: The status of the gift transaction.

• Field API Name: ssot__GiftType__c
• Data Type: TEXT
• Description: The type of gift that’s associated with the gift transaction.

• Field API Name: ssot__GraduationAchievement__c
• Data Type: TEXT
• Description: The achievement that represents the graduation status of the alumni user. Example values include Secondary Diploma, Associate Degree, Undergraduate Degree.

• Field API Name: ssot__GraduationCohort__c
• Data Type: TEXT
• Description: The cohort a person belongs to based on their advancement graduation date. Example values include 0-5 Years Since Graduation, 6-10 Years Since Graduation, 11-20 Years Since Graduation.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this GiftTransaction record. Maximum size is 15 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__IsFullyRefunded__c
• Data Type: TEXT
• Description: Whether the gift transaction is fully refunded.

• Field API Name: ssot__IsPaid__c
• Data Type: TEXT
• Description: Whether the gift transaction is paid.

• Field API Name: ssot__IsPartiallyRefunded__c
• Data Type: TEXT
• Description: Whether the gift transaction is partially refunded.

• Field API Name: ssot__IsWrittenOff__c
• Data Type: TEXT
• Description: Whether the gift transaction is written off.

• Field API Name: KQ_CampaignId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CampaignId

• Field API Name: KQ_ContactId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ContactId

• Field API Name: KQ_DonorId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DonorId

• Field API Name: KQ_GiftCommitmentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for GiftCommitmentId

• Field API Name: KQ_GiftCommitmentScheduleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for GiftCommitmentScheduleId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_MatchingEmployerTransactionId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MatchingEmployerTransactionId

• Field API Name: KQ_OutreachSourceCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OutreachSourceCodeId

• Field API Name: KQ_PaymentInstrumentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PaymentInstrumentId

• Field API Name: KQ_PaymentMethodId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PaymentMethodId

• Field API Name: ssot__LastGatewayErrorMessage__c
• Data Type: TEXT
• Description: The most recent error message that’s received by the gateway.

• Field API Name: ssot__LastGatewayProcessedDate__c
• Data Type: DATETIME
• Description: The date and time of the last processing attempt by the gateway.

• Field API Name: ssot__LastGatewayResponseCode__c
• Data Type: TEXT
• Description: The most recent response code that’s received by the gateway.

• Field API Name: ssot__MatchingEmployerTransactionId__c
• Data Type: TEXT
• Description: The gift transaction made by the employer that matches the gift transaction.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The name of the gift transaction.

• Field API Name: ssot__NonTaxDeductibleAmount__c
• Data Type: DOUBLE
• Description: The portion of the gift transaction amount that can’t be claimed as a tax deduction by the donor.

• Field API Name: ssot__OriginalAmount__c
• Data Type: DOUBLE
• Description: The original amount of gift transaction that includes donor cover and excludes the transaction fees.

• Field API Name: ssot__OutreachSourceCodeId__c
• Data Type: TEXT
• Description: The outreach source code associated with the gift transaction.

• Field API Name: ssot__PartyPhilanthropicRsrchPrflId__c
• Data Type: TEXT
• Description: The research profile associated with the gift.

• Field API Name: ssot__PaymentIdentifier__c
• Data Type: TEXT
• Description: The reference number associated with the payment method for the gift, such as check number, transaction order number, merchant order number.

• Field API Name: ssot__PaymentInstrumentId__c
• Data Type: TEXT
• Description: The Payment Instrument used to complete the transaction.

• Field API Name: ssot__PaymentMethodId__c
• Data Type: TEXT
• Description: The payment method used to complete the gift transaction.

• Field API Name: ssot__ProcessorReference__c
• Data Type: TEXT
• Description: The reference of the payment processor associated with the payment instrument.

• Field API Name: ssot__ProcessorTransactionFeeAmount__c
• Data Type: DOUBLE
• Description: The transaction fee charged by the payment processor.

• Field API Name: ssot__RefundedAmount__c
• Data Type: DOUBLE
• Description: The amount of the original gift transaction that was refunded.

• Field API Name: ssot__TaxDeductionAmount__c
• Data Type: DOUBLE
• Description: The tax deduction applicable to the gift transaction.

• Field API Name: ssot__TaxReceiptStatus__c
• Data Type: TEXT
• Description: The status of the tax receipt for the gift transaction. Example values include To Be Sent, Sent, Don’t Send.

• Field API Name: ssot__TotalTransactionFeeAmount__c
• Data Type: DOUBLE
• Description: The total amount of fees charged by the payment gateway and processor for this transaction.

• Field API Name: ssot__TransactionDate__c
• Data Type: DATETIME
• Description: The date and time of the transaction date.