Product: Omatic Cloud Post to GL

Description: This solution describes the available fields for Post to GL from Raisers Edge

Environment: RE

Versions: All

Answer:

 

RE ObjectRE Field
GIFTID
GIFTACKNOWLEDGE_FLAG
GIFTADDEDBYID
GIFTAMOUNT_SUBJECT_TO_VAT
GIFTANONYMOUS
GIFTAUTHORIZATION_CODE
GIFTCONSTITUENTBANKID
GIFTBROKER_FEE
GIFTCHECK_DATE
GIFTCHECK_NUMBER
GIFTCLAIM_NO
GIFTCONSTITUENT_CODE
GIFTCONSTIT_ID
GIFTConstituentRecordId
GIFTGIFT_STATUS
GIFTCREDIT_TYPE
GIFTCURRENCY_AMOUNT
GIFTCURRENCY_COUNTRY
GIFTCURRENCY_EXCHANGE_RATE
GIFTCURRENCY_RECEIPT_AMOUNT
GIFTDATE_1ST_PAY
GIFTDATEADDED
GIFTDATECHANGED
GIFTDTE
GIFTEXPIRES_ON
GIFTGIFT_CODE
GIFTIMPORT_ID
GIFTINSTALLMENT_FREQUENCY
GIFTLASTCHANGEDBYID
GIFTLETTER_CODE
GIFTMG_SOURCE_CONSTIT_ID
GIFTNUMBER_OF_INSTALLMENTS
GIFTPAYMENT_TYPE
GIFTPOST_DATE
GIFTPOST_STATUS
GIFTRECEIPT_AMOUNT
GIFTRECEIPT_FLAG
GIFTRECEIPT_NUMBER
GIFTREF
GIFTREFERENCE_DATE
GIFTREFERENCE_NUMBER
GIFTREMIND_FLAG
GIFTSALE_OF_STOCK_POST_DATE
GIFTSALE_OF_STOCK_POST_STATUS
GIFTSTANDING_ORDER_SENT
GIFTSTOCK_SALE_COMMENT
GIFTSTOCK_SALE_DATE
GIFTSTOCK_SALE_VALUE
GIFTTYPE
GIFTVAT_TAX_CODE
GIFTEFT_ID
GIFTDRAWER
GIFTIssuer
GIFTIssuerSymbol
GIFTIssuerNumUnits
GIFTIssuerMedianPrice
GIFTBenefitsNotes
GIFTBenefitsIncludeNotes
GIFTUserGiftId
GIFTGiftSubType
GIFTAmountBills
GIFTAmountCoins
GIFTStandingOrderSentDate
GIFTAmount
GIFTAcknowledgeDate
GIFTReceiptDate
GIFTSchedule_Month
GIFTSchedule_DayOfMonth
GIFTSchedule_MonthlyDayOfWeek
GIFTSchedule_Spacing
GIFTSchedule_MonthlyType
GIFTSchedule_MonthlyOrdinal
GIFTSchedule_WeeklyDayOfWeek
GIFTAdjustmentNotes
GIFTProcessedByEFT
GIFTOrderType
GIFTReceived
GIFTSchedule_DayOfMonth2
GIFTSchedule_SMDayType1
GIFTSchedule_SMDayType2
GIFTVAT_Amount_Charged
GIFTGLJournalReference
GIFTTransactionPending
GIFTSendPrenotification
GIFTLast_Prenote_Sent_Date
GIFTSend_Prenote_Units
GIFTNextTransactionDate
GIFTSchedule_EndDate
GIFTTaxCanBeClaimed
GIFTTaxClaimAmount
GIFTVoucherAgency
GIFTSendInstruction
GIFTInstructionType
GIFTInstructionSentDate
GIFTInstructionCancelDate
GIFTInstructionSetupDate
GIFTAdvanceNoticeSentDate
GIFTFrequencyDescription
GIFTCardholderName
GIFTContinuous
GIFTDDIReceivedDate
GIFTDDISource
GIFTReceiptStack
GIFTAckLetterActionID
GIFTTaxEligibleCovenant
GIFTGiftStatusDate
GIFTEnvelopeID
GIFTAccountID
GIFTGIFTAIDQMETHOD
GIFTGIFTAIDQSTATUS
GIFTCREDIT_CARD_NUMBER
GIFTREVERSEPOSTING
GIFTREFUNDTAX
GIFTCLAIM_REFUNDNUMBER
GIFTARCHIVEDGIFT
GIFTREPLACEMENTGIFTID
GIFTPlannedGiftID
GIFTCARDTOKEN
GIFTRevocable
GIFTVehicle
GIFTExpectedMaturityYear
GIFTPlannedGiftStatus
GIFTConstituentIsBeneficiary
GIFTFlexibleDeferred
GIFTPIFNumUnits
GIFTPIFTotalUnits
GIFTTrustTaxID
GIFTPIFName
GIFTPayoutPercent
GIFTPayoutAmount
GIFTTermType
GIFTTermEndDate
GIFTYearsInTerm
GIFTConstitAddressID
GIFTRealized
GIFTNPVAsOf
GIFTREVERSALGLPOSTDATE
GIFTTAXCLAIMADJUSTREASON
GIFTConstitIsPolicyOwner
GIFTConstitPaysPremium
GIFTPremiumFullyPaid
GIFTInsuranceCarrier
GIFTPolicyNumber
GIFTPolicyType
GIFTPolicyFaceAmount
GIFTDate_1st_Premium
GIFTPremium_Frequency
GIFTPremium_DayOfMonth
GIFTPremium_EndDate
GIFTPremium_Month
GIFTPremium_Spacing
GIFTNetPresentValue
GIFTPremium_StartDate
GIFTSource_Code
GIFTMailing_ID
GIFTFinder_Number
GIFTIsOnlineGift
GIFTBBNCTransactions_ID
GIFTBatch_Number
GIFTBatch_Description
GIFTBatch_Category
GIFTAddedByName
GIFTLastChangedByName
GIFTPledgeBalance
GiftSplitsId
GiftSplitsfundSystemRecordId
GiftSplitscampaignSystemRecordId
GiftSplitsappealSystemRecordId
GiftSplitspackageSystemRecordId
GiftSplitsamount
Distribution Id
DistributionfundSystemRecordId
DistributiongiftSystemRecordId
DistributionadjustmentSystemRecordId
DistributiondebitOrCredit
DistributiondebitAccountNumber
DistributioncreditAccountNumber
Distributionamount
DistributionisAdjustment
DistributionisForSoldStock
DistributionglGiftType
DistributionprojectDescription
DistributionprojectNumber
DistributionisReversingEntry
DistributionisDeletedGift
Distributionkey
DistributionfeePercentage
DistributionruleCode
DistributionconstituentName
DistributionconstituentId
DistributionfiscalPeriod
DistributiondonorId
ConstituentsID
ConstituentsSORT_NAME
ConstituentsADDED_BY
ConstituentsBIRTHPLACE
ConstituentsBIRTH_DATE
ConstituentsCONSTITUENT_ID
ConstituentsDATE_ADDED
ConstituentsDATE_LAST_CHANGED
ConstituentsDECEASED_DATE
ConstituentsEMPLOYEES
ConstituentsETHNICITY
ConstituentsFIRST_NAME
ConstituentsFISCAL_YEAR_STARTS
ConstituentsIS_HONORMEMORIAL
ConstituentsIMPORT_ID
ConstituentsINCOME
ConstituentsINCOME_LEVEL
ConstituentsINDUSTRY
ConstituentsKEY_INDICATOR
ConstituentsKEY_POSITION
ConstituentsLAST_CHANGED_BY
ConstituentsLAST_NAME
ConstituentsMAIDEN_NAME
ConstituentsMARITAL_STATUS
ConstituentsMATCHING_FACTOR
ConstituentsMATCHING_GIFT_FLAG
ConstituentsMATCH_NOTES
ConstituentsMAX_MATCH_ANNUAL
ConstituentsMAX_MATCH_PER_GIFT
ConstituentsMAX_MATCH_TOTAL
ConstituentsMIDDLE_NAME
ConstituentsMIN_MATCH_ANNUAL
ConstituentsMIN_MATCH_PER_GIFT
ConstituentsMIN_MATCH_TOTAL
ConstituentsNICKNAME
ConstituentsORG_ID
ConstituentsORG_NAME
ConstituentsPARENT_CORP
ConstituentsPRIMARY_ADDRESSEE_ID
ConstituentsPRIMARY_SALUTATION_ID
ConstituentsRECEIPT_TYPE
ConstituentsRELIGION
ConstituentsSOCIAL_SECURITY_NO
ConstituentsSOLICITOR_FLAG
ConstituentsSPOUSE_ID
ConstituentsSUBSIDIARIES
ConstituentsSUFFIX_1
ConstituentsSUFFIX_2
ConstituentsTARGET
ConstituentsTITLE_1
ConstituentsTITLE_2
ConstituentsACADEMY_ID
ConstituentsIS_CONSTITUENT
ConstituentsFULL_NAME
ConstituentsINACTIVE
ConstituentsNO_VALID_ADDRESSES
ConstituentsANONYMOUS
ConstituentsPRIMARY_SALUTATION
ConstituentsPRIMARY_ADDRESSEE
ConstituentsPRIMARY_ADDRESSEE_EDIT
ConstituentsPRIMARY_SALUTATION_EDIT
ConstituentsAnnotationText
ConstituentsAnnotationAutoDisplay
ConstituentsPARENT_CORP_ID
ConstituentsDECEASED
ConstituentsSOLICITOR_INACTIVE
ConstituentsConstituentPaysTax
ConstituentsDeclarationMade
ConstituentsConfirmationSent
ConstituentsConfirmationReturned
ConstituentsTaxNotes
ConstituentsNO_EMAIL
ConstituentsDeclarationEnds
ConstituentsDeclarationStarts
ConstituentsTAX_PAYER_STATUS
ConstituentsDeclarationIndicator
ConstituentsACADEMY_DATE_LAST_CHANGED
ConstituentsACADEMY_LAST_CHANGED_BY
ConstituentsINTEGRATION_ID
ConstituentsINTEGRATION_DATE_LAST_CHANGED
ConstituentsAP7VENDORSID
ConstituentsDECLARATIONSOURCE
ConstituentsGIVING_SCORE_OVERRIDE
ConstituentsUSE_BB_GIVING_SCORE
ConstituentsGIVING_SCORE_OVERRIDE_DATE
ConstituentsGender
ConstituentsPreferredAddrLine1
ConstituentsPreferredAddrLine2
ConstituentsPreferredAddrLine3
ConstituentsPreferredCity
ConstituentsPreferredState
ConstituentsPreferredZip
ConstituentsPreferredCountry
ConstituentsPhoneNumber (Primary by default)
ConstituentsEmailAddress (Primary by default)
FundsId 
FundsfundId
Fundsdescription
FundsfundType
Fundscategory
FundsisRestricted
FundsisInactive
FundsstartDate
FundsendDate
Fundsgoal
FundsapplyGST
Fund AttributeattributeTypeId
Fund Attributecategory
Fund Attributevalue
Fund AttributeattributeDate
Fund Attributecomments
Campaignid
CampaigncampaignId
Campaigndescription
Campaigncategory
CampaignisInactive
Campaign startDate
Campaign endDate
Campaign goal
Campaign AttributesattributeTypeId
Campaign Attributescategory
Campaign Attributesvalue
Campaign AttributesattributeDate
Campaign Attributescomments
Appeal id
AppealappealId
Appealdescription
Appealcategory
AppealisInactive
AppealstartDate
AppealendDate
Appealgoal
FundAttributeTypesattributeTypesId
FundAttributeTypesdescription
FundAttributeTypestypeOfData
GiftAttributeTypesattributeTypesId
GiftAttributeTypesdescription
GiftAttributeTypestypeOfData
Packageid
PackagepackageId
PackagedefaultGiftAmount
PackagepackageCategoryId
Packagedescription
PackagestartDate
PackageendDate
Packagegoal
BatchesID
BatchesBATCH_NUMER
BatchesCREATED_BY
BatchesDATE_ADDED
BatchesDELETED
BatchesDESCRIPTION
BatchesINCLUDED_FOR_DEPOSTIT
BatchesDATE_LAST_CHANGED
BatchesLAST_POSTED
BatchesPROJECTED_AMOUNT
BatchesRECURRING
BatchesTIMES_POSTED
BatchesUSED_FOR_RECURRING
BatchesPOSTED_AMOUNT
BatchesPROJECTED_NUMBER_RECORDS
BatchesPOSTED_NUMBER_RECORDS
BatchesOTHERS_CAN_MODIFY
BatchesAUTOMATICALLY_DISPLAY
BatchesACTUAL_NUMBER_RECORDS
BatchesACTUAL_AMOUNT
BatchesMATCHING_GIFT_ACTUAL_NUMBER_RECS
BatchesMATCHING_GIFT_ACTUAL_AMOUNT
BatchesLAST_CHANGED_BY
BatchesSCHEDULE_INSTALLMENT_FREQUENCY
BatchesSCHEDULE_DATE_BASED_ON_OPTION
BatchesSCHEDULE_DATE_BASED_ON_OPTION2
BatchesSCHEDULE_DATE_BASED_ON
BatchesSCHEDULE_NUMBER_OF_INSTALLMENTS
BatchesSCHEDULE_MONTHLY_TYPE
BatchesSCHEDULE_MONTHLY_ORDINAL
BatchesSCHEDULE_MONTHLY_DAY_OF_WEEK
BatchesSCHEDULE_MONTH
BatchesSCHEDULE_SEMI_MONTHLY_DAY_TYPE1
BatchesSCHEDULE_SEMI_MONTHLY_DAY_TYPE2
BatchesSCHEDULE_DAY_OF_MONTH
BatchesSCHEDULE_DAY_OF_MONTH2
BatchesSCHEDULE_SPACING
BatchesSCHEDULE_WEEKLY_DAY_OF_WEEK
BatchesCREATED_BY_TEXT
BatchesRECURRING_PARENT_ID
BatchesTRIBUTE
BatchesTRIBUTE_TYPE
BatchesACKNOWLEDGE
BatchesTRANSMISSION_FILE_CREATED
BatchesTRANSACTIONS_DUE_ON
BatchesFINANCIAL_PROCESSING_DATE
BatchesSPONSORING_BANK
BatchesTRIBUTE_NAME
BatchesTRIBUTE_RECORDS_ID
BatchesFIRST_GIFT_DATE
BatchesLAST_GIFT_DATE
BatchesEVENT_ID
AdjustmentId
AdjustmentgiftSystemRecordId
AdjustmentpreviousSubType
AdjustmentpreviousAmount
AdjustmentsubType
AdjustmentadjustmentDate
AdjustmentglPostStatus
AdjustmentglPostDate
Adjustmentreason
Adjustmentnotes
AdjustmentuseAdjPostDate
Gift BenefitBenefitId
Gift BenefitBenefit
Gift BenefitQuantity
Gift BenefitPrice
Gift BenefitTotalAmount
Gift BenefitComments
Constituent_Aliasalias_type
Constituent_Aliasalias_value
TransactionPledgeaccount_id
TransactionPledgeack_letter_action_id
TransactionPledgeacknowledge_date
TransactionPledgeacknowledge_flag
TransactionPledgeadded_by_name
TransactionPledgeadded_by_id
TransactionPledgeadjustment_notes
TransactionPledgeadvance_notice_sent_date
TransactionPledgeamount
TransactionPledgeamount_bills
TransactionPledgeamount_coins
TransactionPledgeamount_subject_to_vat
TransactionPledgeanonymous
TransactionPledgearchived_gift
TransactionPledgeauthorization_code
TransactionPledgebatch_description
TransactionPledgebatch_number
TransactionPledgebatch_category
TransactionPledgebbnc_transactions_id
TransactionPledgebenefits_includenotes
TransactionPledgebenefits_notes
TransactionPledgebroker_fee
TransactionPledgecard_holder_name
TransactionPledgecard_token
TransactionPledgecheck_date
TransactionPledgecheck_number
TransactionPledgeclaim_no
TransactionPledgeclaim_refund_number
TransactionPledgeconstit_address_id
TransactionPledgeconstit_id
TransactionPledgeconstit_is_policy_owner
TransactionPledgeconstit_pays_premium
TransactionPledgeconstituent_bank_id
TransactionPledgeconstituent_code
TransactionPledgeconstituent_is_beneficiary
TransactionPledgeconstituentrecordid
TransactionPledgecontinuous
TransactionPledgecredit_card_number
TransactionPledgecredit_type
TransactionPledgecurrency_amount
TransactionPledgecurrency_country
TransactionPledgecurrency_exchange_rate
TransactionPledgecurrency_receipt_amount
TransactionPledgedate_1st_pay
TransactionPledgedate_1st_premium
TransactionPledgedate_added
TransactionPledgedate_changed
TransactionPledgeddi_received_date
TransactionPledgeddi_source
TransactionPledgedrawer
TransactionPledgedte
TransactionPledgeeft_id
TransactionPledgeenvelope_id
TransactionPledgeexpected_maturity_year
TransactionPledgeexpires_on
TransactionPledgefinder_number
TransactionPledgeflexible_deferred
TransactionPledgefrequency_description
TransactionPledgegift_aid_qmethod
TransactionPledgegift_aid_qstatus
TransactionPledgegift_code
TransactionPledgegift_status
TransactionPledgegift_status_date
TransactionPledgegift_sub_type
TransactionPledgegl_journal_reference
TransactionPledgeid
TransactionPledgeimport_id
TransactionPledgeinstallment_frequency
TransactionPledgeinstruction_cancel_date
TransactionPledgeinstruction_sent_date
TransactionPledgeinstruction_setup_date
TransactionPledgeinstruction_type
TransactionPledgeinsurance_carrier
TransactionPledgeis_online_gift
TransactionPledgeissuer
TransactionPledgeissuer_median_price
TransactionPledgeissuer_num_units
TransactionPledgeissuer_symbol
TransactionPledgelast_changed_by_name
TransactionPledgelast_prenote_sent_date
TransactionPledgelast_changed_by_id
TransactionPledgeletter_code
TransactionPledgemailing_id
TransactionPledgemg_source_constit_id
TransactionPledgenet_present_value
TransactionPledgenext_transaction_date
TransactionPledgenpv_as_of
TransactionPledgenumber_of_installments
TransactionPledgeorder_type
TransactionPledgepayment_type
TransactionPledgepayout_amount
TransactionPledgepayout_percent
TransactionPledgepif_name
TransactionPledgepif_num_units
TransactionPledgepif_total_units
TransactionPledgeplanned_gift_id
TransactionPledgeplanned_gift_status
TransactionPledgepledge_balance
TransactionPledgepolicy_faceamount
TransactionPledgepolicy_number
TransactionPledgepolicy_type
TransactionPledgepost_date
TransactionPledgepost_status
TransactionPledgepremium_day_of_month
TransactionPledgepremium_end_date
TransactionPledgepremium_frequency
TransactionPledgepremium_fully_paid
TransactionPledgepremium_month
TransactionPledgepremium_spacing
TransactionPledgepremium_start_date
TransactionPledgeprocessed_by_eft
TransactionPledgerealized
TransactionPledgereceipt_amount
TransactionPledgereceipt_date
TransactionPledgereceipt_flag
TransactionPledgereceipt_number
TransactionPledgereceipt_stack
TransactionPledgereceived
TransactionPledge  @ref
TransactionPledgereference_date
TransactionPledgereference_number
TransactionPledgerefund_tax
TransactionPledgeremind_flag
TransactionPledgereplacement_gift_id
TransactionPledgereversal_gl_post_date
TransactionPledgereverse_posting
TransactionPledgerevocable
TransactionPledgesale_of_stock_post_date
TransactionPledgesale_of_stock_post_status
TransactionPledgeschedule_day_of_month
TransactionPledgeschedule_day_of_month_2
TransactionPledgeschedule_end_date
TransactionPledgeschedule_month
TransactionPledgeschedule_monthly_day_of_week
TransactionPledgeschedule_monthly_ordinal
TransactionPledgeschedule_monthly_type
TransactionPledgeschedule_sm_day_type_1
TransactionPledgeschedule_sm_day_type_2
TransactionPledgeschedule_spacing
TransactionPledgeschedule_weekly_day_of_week
TransactionPledgesend_instruction
TransactionPledgesend_pre_notification
TransactionPledgesend_prenote_units
TransactionPledgesource_code
TransactionPledgestanding_order_sent
TransactionPledgestanding_order_sent_date
TransactionPledgestock_sale_comment
TransactionPledgestock_sale_date
TransactionPledgestock_sale_value
TransactionPledgetax_can_be_claimed
TransactionPledgetax_claim_adjust_reason
TransactionPledgetax_claim_amount
TransactionPledgetax_eligible_covenant
TransactionPledgeterm_end_date
TransactionPledgeterm_type
TransactionPledgetransaction_pending
TransactionPledgetrust_tax_id
TransactionPledgetype
TransactionPledgeuser_gift_id
TransactionPledgevat_amount_charged
TransactionPledgevat_tax_code
TransactionPledgevehicle
TransactionPledgevoucher_agency
TransactionPledgeyears_interm