Description: This solution describes the available fields for Post to GL from Raisers Edge
Environment: RE
Versions: All
Answer:
RE Object | RE Field |
GIFT | ID |
GIFT | ACKNOWLEDGE_FLAG |
GIFT | ADDEDBYID |
GIFT | AMOUNT_SUBJECT_TO_VAT |
GIFT | ANONYMOUS |
GIFT | AUTHORIZATION_CODE |
GIFT | CONSTITUENTBANKID |
GIFT | BROKER_FEE |
GIFT | CHECK_DATE |
GIFT | CHECK_NUMBER |
GIFT | CLAIM_NO |
GIFT | CONSTITUENT_CODE |
GIFT | CONSTIT_ID |
GIFT | ConstituentRecordId |
GIFT | GIFT_STATUS |
GIFT | CREDIT_TYPE |
GIFT | CURRENCY_AMOUNT |
GIFT | CURRENCY_COUNTRY |
GIFT | CURRENCY_EXCHANGE_RATE |
GIFT | CURRENCY_RECEIPT_AMOUNT |
GIFT | DATE_1ST_PAY |
GIFT | DATEADDED |
GIFT | DATECHANGED |
GIFT | DTE |
GIFT | EXPIRES_ON |
GIFT | GIFT_CODE |
GIFT | IMPORT_ID |
GIFT | INSTALLMENT_FREQUENCY |
GIFT | LASTCHANGEDBYID |
GIFT | LETTER_CODE |
GIFT | MG_SOURCE_CONSTIT_ID |
GIFT | NUMBER_OF_INSTALLMENTS |
GIFT | PAYMENT_TYPE |
GIFT | POST_DATE |
GIFT | POST_STATUS |
GIFT | RECEIPT_AMOUNT |
GIFT | RECEIPT_FLAG |
GIFT | RECEIPT_NUMBER |
GIFT | REF |
GIFT | REFERENCE_DATE |
GIFT | REFERENCE_NUMBER |
GIFT | REMIND_FLAG |
GIFT | SALE_OF_STOCK_POST_DATE |
GIFT | SALE_OF_STOCK_POST_STATUS |
GIFT | STANDING_ORDER_SENT |
GIFT | STOCK_SALE_COMMENT |
GIFT | STOCK_SALE_DATE |
GIFT | STOCK_SALE_VALUE |
GIFT | TYPE |
GIFT | VAT_TAX_CODE |
GIFT | EFT_ID |
GIFT | DRAWER |
GIFT | Issuer |
GIFT | IssuerSymbol |
GIFT | IssuerNumUnits |
GIFT | IssuerMedianPrice |
GIFT | BenefitsNotes |
GIFT | BenefitsIncludeNotes |
GIFT | UserGiftId |
GIFT | GiftSubType |
GIFT | AmountBills |
GIFT | AmountCoins |
GIFT | StandingOrderSentDate |
GIFT | Amount |
GIFT | AcknowledgeDate |
GIFT | ReceiptDate |
GIFT | Schedule_Month |
GIFT | Schedule_DayOfMonth |
GIFT | Schedule_MonthlyDayOfWeek |
GIFT | Schedule_Spacing |
GIFT | Schedule_MonthlyType |
GIFT | Schedule_MonthlyOrdinal |
GIFT | Schedule_WeeklyDayOfWeek |
GIFT | AdjustmentNotes |
GIFT | ProcessedByEFT |
GIFT | OrderType |
GIFT | Received |
GIFT | Schedule_DayOfMonth2 |
GIFT | Schedule_SMDayType1 |
GIFT | Schedule_SMDayType2 |
GIFT | VAT_Amount_Charged |
GIFT | GLJournalReference |
GIFT | TransactionPending |
GIFT | SendPrenotification |
GIFT | Last_Prenote_Sent_Date |
GIFT | Send_Prenote_Units |
GIFT | NextTransactionDate |
GIFT | Schedule_EndDate |
GIFT | TaxCanBeClaimed |
GIFT | TaxClaimAmount |
GIFT | VoucherAgency |
GIFT | SendInstruction |
GIFT | InstructionType |
GIFT | InstructionSentDate |
GIFT | InstructionCancelDate |
GIFT | InstructionSetupDate |
GIFT | AdvanceNoticeSentDate |
GIFT | FrequencyDescription |
GIFT | CardholderName |
GIFT | Continuous |
GIFT | DDIReceivedDate |
GIFT | DDISource |
GIFT | ReceiptStack |
GIFT | AckLetterActionID |
GIFT | TaxEligibleCovenant |
GIFT | GiftStatusDate |
GIFT | EnvelopeID |
GIFT | AccountID |
GIFT | GIFTAIDQMETHOD |
GIFT | GIFTAIDQSTATUS |
GIFT | CREDIT_CARD_NUMBER |
GIFT | REVERSEPOSTING |
GIFT | REFUNDTAX |
GIFT | CLAIM_REFUNDNUMBER |
GIFT | ARCHIVEDGIFT |
GIFT | REPLACEMENTGIFTID |
GIFT | PlannedGiftID |
GIFT | CARDTOKEN |
GIFT | Revocable |
GIFT | Vehicle |
GIFT | ExpectedMaturityYear |
GIFT | PlannedGiftStatus |
GIFT | ConstituentIsBeneficiary |
GIFT | FlexibleDeferred |
GIFT | PIFNumUnits |
GIFT | PIFTotalUnits |
GIFT | TrustTaxID |
GIFT | PIFName |
GIFT | PayoutPercent |
GIFT | PayoutAmount |
GIFT | TermType |
GIFT | TermEndDate |
GIFT | YearsInTerm |
GIFT | ConstitAddressID |
GIFT | Realized |
GIFT | NPVAsOf |
GIFT | REVERSALGLPOSTDATE |
GIFT | TAXCLAIMADJUSTREASON |
GIFT | ConstitIsPolicyOwner |
GIFT | ConstitPaysPremium |
GIFT | PremiumFullyPaid |
GIFT | InsuranceCarrier |
GIFT | PolicyNumber |
GIFT | PolicyType |
GIFT | PolicyFaceAmount |
GIFT | Date_1st_Premium |
GIFT | Premium_Frequency |
GIFT | Premium_DayOfMonth |
GIFT | Premium_EndDate |
GIFT | Premium_Month |
GIFT | Premium_Spacing |
GIFT | NetPresentValue |
GIFT | Premium_StartDate |
GIFT | Source_Code |
GIFT | Mailing_ID |
GIFT | Finder_Number |
GIFT | IsOnlineGift |
GIFT | BBNCTransactions_ID |
GIFT | Batch_Number |
GIFT | Batch_Description |
GIFT | Batch_Category |
GIFT | AddedByName |
GIFT | LastChangedByName |
GIFT | PledgeBalance |
GiftSplits | Id |
GiftSplits | fundSystemRecordId |
GiftSplits | campaignSystemRecordId |
GiftSplits | appealSystemRecordId |
GiftSplits | packageSystemRecordId |
GiftSplits | amount |
Distribution | Id |
Distribution | fundSystemRecordId |
Distribution | giftSystemRecordId |
Distribution | adjustmentSystemRecordId |
Distribution | debitOrCredit |
Distribution | debitAccountNumber |
Distribution | creditAccountNumber |
Distribution | amount |
Distribution | isAdjustment |
Distribution | isForSoldStock |
Distribution | glGiftType |
Distribution | projectDescription |
Distribution | projectNumber |
Distribution | isReversingEntry |
Distribution | isDeletedGift |
Distribution | key |
Distribution | feePercentage |
Distribution | ruleCode |
Distribution | constituentName |
Distribution | constituentId |
Distribution | fiscalPeriod |
Distribution | donorId |
Constituents | ID |
Constituents | SORT_NAME |
Constituents | ADDED_BY |
Constituents | BIRTHPLACE |
Constituents | BIRTH_DATE |
Constituents | CONSTITUENT_ID |
Constituents | DATE_ADDED |
Constituents | DATE_LAST_CHANGED |
Constituents | DECEASED_DATE |
Constituents | EMPLOYEES |
Constituents | ETHNICITY |
Constituents | FIRST_NAME |
Constituents | FISCAL_YEAR_STARTS |
Constituents | IS_HONORMEMORIAL |
Constituents | IMPORT_ID |
Constituents | INCOME |
Constituents | INCOME_LEVEL |
Constituents | INDUSTRY |
Constituents | KEY_INDICATOR |
Constituents | KEY_POSITION |
Constituents | LAST_CHANGED_BY |
Constituents | LAST_NAME |
Constituents | MAIDEN_NAME |
Constituents | MARITAL_STATUS |
Constituents | MATCHING_FACTOR |
Constituents | MATCHING_GIFT_FLAG |
Constituents | MATCH_NOTES |
Constituents | MAX_MATCH_ANNUAL |
Constituents | MAX_MATCH_PER_GIFT |
Constituents | MAX_MATCH_TOTAL |
Constituents | MIDDLE_NAME |
Constituents | MIN_MATCH_ANNUAL |
Constituents | MIN_MATCH_PER_GIFT |
Constituents | MIN_MATCH_TOTAL |
Constituents | NICKNAME |
Constituents | ORG_ID |
Constituents | ORG_NAME |
Constituents | PARENT_CORP |
Constituents | PRIMARY_ADDRESSEE_ID |
Constituents | PRIMARY_SALUTATION_ID |
Constituents | RECEIPT_TYPE |
Constituents | RELIGION |
Constituents | SOCIAL_SECURITY_NO |
Constituents | SOLICITOR_FLAG |
Constituents | SPOUSE_ID |
Constituents | SUBSIDIARIES |
Constituents | SUFFIX_1 |
Constituents | SUFFIX_2 |
Constituents | TARGET |
Constituents | TITLE_1 |
Constituents | TITLE_2 |
Constituents | ACADEMY_ID |
Constituents | IS_CONSTITUENT |
Constituents | FULL_NAME |
Constituents | INACTIVE |
Constituents | NO_VALID_ADDRESSES |
Constituents | ANONYMOUS |
Constituents | PRIMARY_SALUTATION |
Constituents | PRIMARY_ADDRESSEE |
Constituents | PRIMARY_ADDRESSEE_EDIT |
Constituents | PRIMARY_SALUTATION_EDIT |
Constituents | AnnotationText |
Constituents | AnnotationAutoDisplay |
Constituents | PARENT_CORP_ID |
Constituents | DECEASED |
Constituents | SOLICITOR_INACTIVE |
Constituents | ConstituentPaysTax |
Constituents | DeclarationMade |
Constituents | ConfirmationSent |
Constituents | ConfirmationReturned |
Constituents | TaxNotes |
Constituents | NO_EMAIL |
Constituents | DeclarationEnds |
Constituents | DeclarationStarts |
Constituents | TAX_PAYER_STATUS |
Constituents | DeclarationIndicator |
Constituents | ACADEMY_DATE_LAST_CHANGED |
Constituents | ACADEMY_LAST_CHANGED_BY |
Constituents | INTEGRATION_ID |
Constituents | INTEGRATION_DATE_LAST_CHANGED |
Constituents | AP7VENDORSID |
Constituents | DECLARATIONSOURCE |
Constituents | GIVING_SCORE_OVERRIDE |
Constituents | USE_BB_GIVING_SCORE |
Constituents | GIVING_SCORE_OVERRIDE_DATE |
Constituents | Gender |
Constituents | PreferredAddrLine1 |
Constituents | PreferredAddrLine2 |
Constituents | PreferredAddrLine3 |
Constituents | PreferredCity |
Constituents | PreferredState |
Constituents | PreferredZip |
Constituents | PreferredCountry |
Constituents | PhoneNumber (Primary by default) |
Constituents | EmailAddress (Primary by default) |
Funds | Id |
Funds | fundId |
Funds | description |
Funds | fundType |
Funds | category |
Funds | isRestricted |
Funds | isInactive |
Funds | startDate |
Funds | endDate |
Funds | goal |
Funds | applyGST |
Fund Attribute | attributeTypeId |
Fund Attribute | category |
Fund Attribute | value |
Fund Attribute | attributeDate |
Fund Attribute | comments |
Campaign | id |
Campaign | campaignId |
Campaign | description |
Campaign | category |
Campaign | isInactive |
Campaign | startDate |
Campaign | endDate |
Campaign | goal |
Campaign Attributes | attributeTypeId |
Campaign Attributes | category |
Campaign Attributes | value |
Campaign Attributes | attributeDate |
Campaign Attributes | comments |
Appeal | id |
Appeal | appealId |
Appeal | description |
Appeal | category |
Appeal | isInactive |
Appeal | startDate |
Appeal | endDate |
Appeal | goal |
FundAttributeTypes | attributeTypesId |
FundAttributeTypes | description |
FundAttributeTypes | typeOfData |
GiftAttributeTypes | attributeTypesId |
GiftAttributeTypes | description |
GiftAttributeTypes | typeOfData |
Package | id |
Package | packageId |
Package | defaultGiftAmount |
Package | packageCategoryId |
Package | description |
Package | startDate |
Package | endDate |
Package | goal |
Batches | ID |
Batches | BATCH_NUMER |
Batches | CREATED_BY |
Batches | DATE_ADDED |
Batches | DELETED |
Batches | DESCRIPTION |
Batches | INCLUDED_FOR_DEPOSTIT |
Batches | DATE_LAST_CHANGED |
Batches | LAST_POSTED |
Batches | PROJECTED_AMOUNT |
Batches | RECURRING |
Batches | TIMES_POSTED |
Batches | USED_FOR_RECURRING |
Batches | POSTED_AMOUNT |
Batches | PROJECTED_NUMBER_RECORDS |
Batches | POSTED_NUMBER_RECORDS |
Batches | OTHERS_CAN_MODIFY |
Batches | AUTOMATICALLY_DISPLAY |
Batches | ACTUAL_NUMBER_RECORDS |
Batches | ACTUAL_AMOUNT |
Batches | MATCHING_GIFT_ACTUAL_NUMBER_RECS |
Batches | MATCHING_GIFT_ACTUAL_AMOUNT |
Batches | LAST_CHANGED_BY |
Batches | SCHEDULE_INSTALLMENT_FREQUENCY |
Batches | SCHEDULE_DATE_BASED_ON_OPTION |
Batches | SCHEDULE_DATE_BASED_ON_OPTION2 |
Batches | SCHEDULE_DATE_BASED_ON |
Batches | SCHEDULE_NUMBER_OF_INSTALLMENTS |
Batches | SCHEDULE_MONTHLY_TYPE |
Batches | SCHEDULE_MONTHLY_ORDINAL |
Batches | SCHEDULE_MONTHLY_DAY_OF_WEEK |
Batches | SCHEDULE_MONTH |
Batches | SCHEDULE_SEMI_MONTHLY_DAY_TYPE1 |
Batches | SCHEDULE_SEMI_MONTHLY_DAY_TYPE2 |
Batches | SCHEDULE_DAY_OF_MONTH |
Batches | SCHEDULE_DAY_OF_MONTH2 |
Batches | SCHEDULE_SPACING |
Batches | SCHEDULE_WEEKLY_DAY_OF_WEEK |
Batches | CREATED_BY_TEXT |
Batches | RECURRING_PARENT_ID |
Batches | TRIBUTE |
Batches | TRIBUTE_TYPE |
Batches | ACKNOWLEDGE |
Batches | TRANSMISSION_FILE_CREATED |
Batches | TRANSACTIONS_DUE_ON |
Batches | FINANCIAL_PROCESSING_DATE |
Batches | SPONSORING_BANK |
Batches | TRIBUTE_NAME |
Batches | TRIBUTE_RECORDS_ID |
Batches | FIRST_GIFT_DATE |
Batches | LAST_GIFT_DATE |
Batches | EVENT_ID |
Adjustment | Id |
Adjustment | giftSystemRecordId |
Adjustment | previousSubType |
Adjustment | previousAmount |
Adjustment | subType |
Adjustment | adjustmentDate |
Adjustment | glPostStatus |
Adjustment | glPostDate |
Adjustment | reason |
Adjustment | notes |
Adjustment | useAdjPostDate |
Gift Benefit | BenefitId |
Gift Benefit | Benefit |
Gift Benefit | Quantity |
Gift Benefit | Price |
Gift Benefit | TotalAmount |
Gift Benefit | Comments |
Constituent_Alias | alias_type |
Constituent_Alias | alias_value |
TransactionPledge | account_id |
TransactionPledge | ack_letter_action_id |
TransactionPledge | acknowledge_date |
TransactionPledge | acknowledge_flag |
TransactionPledge | added_by_name |
TransactionPledge | added_by_id |
TransactionPledge | adjustment_notes |
TransactionPledge | advance_notice_sent_date |
TransactionPledge | amount |
TransactionPledge | amount_bills |
TransactionPledge | amount_coins |
TransactionPledge | amount_subject_to_vat |
TransactionPledge | anonymous |
TransactionPledge | archived_gift |
TransactionPledge | authorization_code |
TransactionPledge | batch_description |
TransactionPledge | batch_number |
TransactionPledge | batch_category |
TransactionPledge | bbnc_transactions_id |
TransactionPledge | benefits_includenotes |
TransactionPledge | benefits_notes |
TransactionPledge | broker_fee |
TransactionPledge | card_holder_name |
TransactionPledge | card_token |
TransactionPledge | check_date |
TransactionPledge | check_number |
TransactionPledge | claim_no |
TransactionPledge | claim_refund_number |
TransactionPledge | constit_address_id |
TransactionPledge | constit_id |
TransactionPledge | constit_is_policy_owner |
TransactionPledge | constit_pays_premium |
TransactionPledge | constituent_bank_id |
TransactionPledge | constituent_code |
TransactionPledge | constituent_is_beneficiary |
TransactionPledge | constituentrecordid |
TransactionPledge | continuous |
TransactionPledge | credit_card_number |
TransactionPledge | credit_type |
TransactionPledge | currency_amount |
TransactionPledge | currency_country |
TransactionPledge | currency_exchange_rate |
TransactionPledge | currency_receipt_amount |
TransactionPledge | date_1st_pay |
TransactionPledge | date_1st_premium |
TransactionPledge | date_added |
TransactionPledge | date_changed |
TransactionPledge | ddi_received_date |
TransactionPledge | ddi_source |
TransactionPledge | drawer |
TransactionPledge | dte |
TransactionPledge | eft_id |
TransactionPledge | envelope_id |
TransactionPledge | expected_maturity_year |
TransactionPledge | expires_on |
TransactionPledge | finder_number |
TransactionPledge | flexible_deferred |
TransactionPledge | frequency_description |
TransactionPledge | gift_aid_qmethod |
TransactionPledge | gift_aid_qstatus |
TransactionPledge | gift_code |
TransactionPledge | gift_status |
TransactionPledge | gift_status_date |
TransactionPledge | gift_sub_type |
TransactionPledge | gl_journal_reference |
TransactionPledge | id |
TransactionPledge | import_id |
TransactionPledge | installment_frequency |
TransactionPledge | instruction_cancel_date |
TransactionPledge | instruction_sent_date |
TransactionPledge | instruction_setup_date |
TransactionPledge | instruction_type |
TransactionPledge | insurance_carrier |
TransactionPledge | is_online_gift |
TransactionPledge | issuer |
TransactionPledge | issuer_median_price |
TransactionPledge | issuer_num_units |
TransactionPledge | issuer_symbol |
TransactionPledge | last_changed_by_name |
TransactionPledge | last_prenote_sent_date |
TransactionPledge | last_changed_by_id |
TransactionPledge | letter_code |
TransactionPledge | mailing_id |
TransactionPledge | mg_source_constit_id |
TransactionPledge | net_present_value |
TransactionPledge | next_transaction_date |
TransactionPledge | npv_as_of |
TransactionPledge | number_of_installments |
TransactionPledge | order_type |
TransactionPledge | payment_type |
TransactionPledge | payout_amount |
TransactionPledge | payout_percent |
TransactionPledge | pif_name |
TransactionPledge | pif_num_units |
TransactionPledge | pif_total_units |
TransactionPledge | planned_gift_id |
TransactionPledge | planned_gift_status |
TransactionPledge | pledge_balance |
TransactionPledge | policy_faceamount |
TransactionPledge | policy_number |
TransactionPledge | policy_type |
TransactionPledge | post_date |
TransactionPledge | post_status |
TransactionPledge | premium_day_of_month |
TransactionPledge | premium_end_date |
TransactionPledge | premium_frequency |
TransactionPledge | premium_fully_paid |
TransactionPledge | premium_month |
TransactionPledge | premium_spacing |
TransactionPledge | premium_start_date |
TransactionPledge | processed_by_eft |
TransactionPledge | realized |
TransactionPledge | receipt_amount |
TransactionPledge | receipt_date |
TransactionPledge | receipt_flag |
TransactionPledge | receipt_number |
TransactionPledge | receipt_stack |
TransactionPledge | received |
TransactionPledge | @ref |
TransactionPledge | reference_date |
TransactionPledge | reference_number |
TransactionPledge | refund_tax |
TransactionPledge | remind_flag |
TransactionPledge | replacement_gift_id |
TransactionPledge | reversal_gl_post_date |
TransactionPledge | reverse_posting |
TransactionPledge | revocable |
TransactionPledge | sale_of_stock_post_date |
TransactionPledge | sale_of_stock_post_status |
TransactionPledge | schedule_day_of_month |
TransactionPledge | schedule_day_of_month_2 |
TransactionPledge | schedule_end_date |
TransactionPledge | schedule_month |
TransactionPledge | schedule_monthly_day_of_week |
TransactionPledge | schedule_monthly_ordinal |
TransactionPledge | schedule_monthly_type |
TransactionPledge | schedule_sm_day_type_1 |
TransactionPledge | schedule_sm_day_type_2 |
TransactionPledge | schedule_spacing |
TransactionPledge | schedule_weekly_day_of_week |
TransactionPledge | send_instruction |
TransactionPledge | send_pre_notification |
TransactionPledge | send_prenote_units |
TransactionPledge | source_code |
TransactionPledge | standing_order_sent |
TransactionPledge | standing_order_sent_date |
TransactionPledge | stock_sale_comment |
TransactionPledge | stock_sale_date |
TransactionPledge | stock_sale_value |
TransactionPledge | tax_can_be_claimed |
TransactionPledge | tax_claim_adjust_reason |
TransactionPledge | tax_claim_amount |
TransactionPledge | tax_eligible_covenant |
TransactionPledge | term_end_date |
TransactionPledge | term_type |
TransactionPledge | transaction_pending |
TransactionPledge | trust_tax_id |
TransactionPledge | type |
TransactionPledge | user_gift_id |
TransactionPledge | vat_amount_charged |
TransactionPledge | vat_tax_code |
TransactionPledge | vehicle |
TransactionPledge | voucher_agency |
TransactionPledge | years_interm |