Powered by InfoCaptor


Previous Page   Next Page

Journal Entries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.GLFG_JOURNAL_ENTRIESUnknown
NoneNone.GLFG_JOURNAL_ENTRIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Balance Type Journal Entries.Balance TypeBALANCE_TYPEBALANCE_TYPE268426
Budget NameThe budget name.Journal Entries.Budget NameBUDGET_NAMEBUDGET_NAME120391
Budget Version IDThe unique identification number assigned to a budget.Journal Entries.Budget Version IDBUDGET_VERSION_IDBUDGET_VERSION_ID120472
Control TotalThe total amount that a journal entry should sum to.Journal Entries.Control TotalCONTROL_TOTALCONTROL_TOTAL123426
Converted Journal Total CreditsThe journal entry converted running total credit in the functional currency.Journal Entries.Converted Journal Total CreditsCONVERTED_JOURNAL_TOTAL_CRCONVERTED_JOURNAL_TOTAL_CR123481
Converted Journal Total DebitsThe journal entry converted running total debit in the functional currency.Journal Entries.Converted Journal Total DebitsCONVERTED_JOURNAL_TOTAL_DRCONVERTED_JOURNAL_TOTAL_DR123483
CurrencyThe currency for an account balance.Journal Entries.CurrencyCURRENCYCURRENCY126928
Currency Conversion DateThe currency conversion date.Journal Entries.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127094
Currency Conversion RateThe currency exchange rate.Journal Entries.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127105
Currency Conversion TypeThe type of currency exchange rate.Journal Entries.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127173
Currency Conversion Type CodeThe conversion rates type code.Journal Entries.Currency Conversion Type CodeCURRENCY_CONVERSION_TYPE_CODECURRENCY_CONVERSION_TYPE_CODE127186
DescriptionThe accounting period description.Journal Entries.DescriptionDESCRIPTIONDESCRIPTION129546
Document NumberThe journal entry document number.Journal Entries.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130340
Effective DateThe journal entry effective date.Journal Entries.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130760
Encumbrance TypeThe name of an encumbrance type.Journal Entries.Encumbrance TypeENCUMBRANCE_TYPEENCUMBRANCE_TYPE132699
Encumbrance Type IDThe unique identification number assigned to an encumbrance type.Journal Entries.Encumbrance Type IDENCUMBRANCE_TYPE_IDENCUMBRANCE_TYPE_ID132707
Entered Journal Total CreditsThe journal entry running total credit in the entered currency.Journal Entries.Entered Journal Total CreditsENTERED_JOURNAL_TOTAL_CRENTERED_JOURNAL_TOTAL_CR133426
Entered Journal Total DebitsThe journal entry running total debit in the entered currency.Journal Entries.Entered Journal Total DebitsENTERED_JOURNAL_TOTAL_DRENTERED_JOURNAL_TOTAL_DR133430
External ReferenceAdditional reference information.Journal Entries.External ReferenceEXTERNAL_REFERENCEEXTERNAL_REFERENCE134162
Journal Batch IDThe unique identification number assigned to a journal batch.Journal Entries.Journal Batch IDJOURNAL_BATCH_IDJOURNAL_BATCH_ID138287
Journal Batch NameThe name of the journal batch.Journal Entries.Journal Batch NameJOURNAL_BATCH_NAMEJOURNAL_BATCH_NAME138295
Journal CategoryThe journal entry category.Journal Entries.Journal CategoryJOURNAL_CATEGORYJOURNAL_CATEGORY138299
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Entries.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138303
Journal Entry NameThe name of the journal entry.Journal Entries.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138308
Journal SourceThe journal entry source.Journal Entries.Journal SourceJOURNAL_SOURCEJOURNAL_SOURCE138320
Originating Balancing Segment ValueThe balancing segment value against which automatically generated intercompany journal lines should balance.Journal Entries.Originating Balancing Segment ValueORIGINATING_BAL_SEG_VALUEORIGINATING_BAL_SEG_VALUE151241
Period NameThe name of an accounting period.Journal Entries.Period NamePERIOD_NAMEPERIOD_NAME153112
Primary Journal Entry IDThe unique identification number assigned to the originating journal entry in the MRC primary set of books.Journal Entries.Primary Journal Entry IDPRIMARY_JOURNAL_ENTRY_IDPRIMARY_JOURNAL_ENTRY_ID155545
Primary Journal Entry NameThe name of the originating journal entry in the MRC primary set of books.Journal Entries.Primary Journal Entry NamePRIMARY_JOURNAL_ENTRY_NAMEPRIMARY_JOURNAL_ENTRY_NAME155548
Reversal DateThe journal entry reversal effective date.Journal Entries.Reversal DateREVERSAL_DATEREVERSAL_DATE159453
Reversal Method Journal Entries.Reversal MethodREVERSAL_METHODREVERSAL_METHOD268429
Reversal PeriodThe journal entry reversal period.Journal Entries.Reversal PeriodREVERSAL_PERIODREVERSAL_PERIOD159464
Reverse Status Flag Journal Entries.Reverse Status FlagREVERSE_STATUS_FLAGREVERSE_STATUS_FLAG268428
Reversed Journal Entry IDThe unique identification number assigned to the journal entry that is reversed by this journal entry.Journal Entries.Reversed Journal Entry IDREVERSED_JOURNAL_ENTRY_IDREVERSED_JOURNAL_ENTRY_ID159470
Reversed Journal Entry NameThe name of the journal entry which is reversed by this journal entry.Journal Entries.Reversed Journal Entry NameREVERSED_JOURNAL_ENTRY_NAMEREVERSED_JOURNAL_ENTRY_NAME159474
Set Of Books IDThe unique identification number assigned to a set of books.Journal Entries.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161509
Set Of Books NameThe set of books name.Journal Entries.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161579
Tax Status Journal Entries.Tax StatusTAX_STATUSTAX_STATUS268427
Balance Type Journal Entries.Balance TypeBALANCE_TYPEBALANCE_TYPE268426
Budget NameThe budget name.Journal Entries.Budget NameBUDGET_NAMEBUDGET_NAME120391
Budget Version IDThe unique identification number assigned to a budget.Journal Entries.Budget Version IDBUDGET_VERSION_IDBUDGET_VERSION_ID120472
Control TotalThe total amount that a journal entry should sum to.Journal Entries.Control TotalCONTROL_TOTALCONTROL_TOTAL123426
Converted Journal Total CreditsThe journal entry converted running total credit in the functional currency.Journal Entries.Converted Journal Total CreditsCONVERTED_JOURNAL_TOTAL_CRCONVERTED_JOURNAL_TOTAL_CR123481
Converted Journal Total DebitsThe journal entry converted running total debit in the functional currency.Journal Entries.Converted Journal Total DebitsCONVERTED_JOURNAL_TOTAL_DRCONVERTED_JOURNAL_TOTAL_DR123483
CurrencyThe currency for an account balance.Journal Entries.CurrencyCURRENCYCURRENCY126928
Currency Conversion DateThe currency conversion date.Journal Entries.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127094
Currency Conversion RateThe currency exchange rate.Journal Entries.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127105
Currency Conversion TypeThe type of currency exchange rate.Journal Entries.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127173
Currency Conversion Type CodeThe conversion rates type code.Journal Entries.Currency Conversion Type CodeCURRENCY_CONVERSION_TYPE_CODECURRENCY_CONVERSION_TYPE_CODE127186
DescriptionThe accounting period description.Journal Entries.DescriptionDESCRIPTIONDESCRIPTION129546
Document NumberThe journal entry document number.Journal Entries.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130340
Effective DateThe journal entry effective date.Journal Entries.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130760
Encumbrance TypeThe name of an encumbrance type.Journal Entries.Encumbrance TypeENCUMBRANCE_TYPEENCUMBRANCE_TYPE132699
Encumbrance Type IDThe unique identification number assigned to an encumbrance type.Journal Entries.Encumbrance Type IDENCUMBRANCE_TYPE_IDENCUMBRANCE_TYPE_ID132707
Entered Journal Total CreditsThe journal entry running total credit in the entered currency.Journal Entries.Entered Journal Total CreditsENTERED_JOURNAL_TOTAL_CRENTERED_JOURNAL_TOTAL_CR133426
Entered Journal Total DebitsThe journal entry running total debit in the entered currency.Journal Entries.Entered Journal Total DebitsENTERED_JOURNAL_TOTAL_DRENTERED_JOURNAL_TOTAL_DR133430
External ReferenceAdditional reference information.Journal Entries.External ReferenceEXTERNAL_REFERENCEEXTERNAL_REFERENCE134162
Journal Batch IDThe unique identification number assigned to a journal batch.Journal Entries.Journal Batch IDJOURNAL_BATCH_IDJOURNAL_BATCH_ID138287
Journal Batch NameThe name of the journal batch.Journal Entries.Journal Batch NameJOURNAL_BATCH_NAMEJOURNAL_BATCH_NAME138295
Journal CategoryThe journal entry category.Journal Entries.Journal CategoryJOURNAL_CATEGORYJOURNAL_CATEGORY138299
Journal Entry IDThe unique identification number assigned to a journal entry.Journal Entries.Journal Entry IDJOURNAL_ENTRY_IDJOURNAL_ENTRY_ID138303
Journal Entry NameThe name of the journal entry.Journal Entries.Journal Entry NameJOURNAL_ENTRY_NAMEJOURNAL_ENTRY_NAME138308
Journal SourceThe journal entry source.Journal Entries.Journal SourceJOURNAL_SOURCEJOURNAL_SOURCE138320
Originating Balancing Segment ValueThe balancing segment value against which automatically generated intercompany journal lines should balance.Journal Entries.Originating Balancing Segment ValueORIGINATING_BAL_SEG_VALUEORIGINATING_BAL_SEG_VALUE151241
Period NameThe name of an accounting period.Journal Entries.Period NamePERIOD_NAMEPERIOD_NAME153112
Primary Journal Entry IDThe unique identification number assigned to the originating journal entry in the MRC primary set of books.Journal Entries.Primary Journal Entry IDPRIMARY_JOURNAL_ENTRY_IDPRIMARY_JOURNAL_ENTRY_ID155545
Primary Journal Entry NameThe name of the originating journal entry in the MRC primary set of books.Journal Entries.Primary Journal Entry NamePRIMARY_JOURNAL_ENTRY_NAMEPRIMARY_JOURNAL_ENTRY_NAME155548
Reversal DateThe journal entry reversal effective date.Journal Entries.Reversal DateREVERSAL_DATEREVERSAL_DATE159453
Reversal Method Journal Entries.Reversal MethodREVERSAL_METHODREVERSAL_METHOD268429
Reversal PeriodThe journal entry reversal period.Journal Entries.Reversal PeriodREVERSAL_PERIODREVERSAL_PERIOD159464
Reverse Status Flag Journal Entries.Reverse Status FlagREVERSE_STATUS_FLAGREVERSE_STATUS_FLAG268428
Reversed Journal Entry IDThe unique identification number assigned to the journal entry that is reversed by this journal entry.Journal Entries.Reversed Journal Entry IDREVERSED_JOURNAL_ENTRY_IDREVERSED_JOURNAL_ENTRY_ID159470
Reversed Journal Entry NameThe name of the journal entry which is reversed by this journal entry.Journal Entries.Reversed Journal Entry NameREVERSED_JOURNAL_ENTRY_NAMEREVERSED_JOURNAL_ENTRY_NAME159474
Set Of Books IDThe unique identification number assigned to a set of books.Journal Entries.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161509
Set Of Books NameThe set of books name.Journal Entries.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161579
Tax Status Journal Entries.Tax StatusTAX_STATUSTAX_STATUS268427
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Journal Entries -> Journal LinesJournal Entries.Journal Entry ID = Journal Lines.Journal Entry IDAlways exist in master folderNoneNo