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 |