Powered by InfoCaptor


Previous Page   Next Page

Asset Book
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.FAFG_BOOKSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AP Intercompany AccountIntercompany payables account segmentAsset Book.AP Intercompany AccountAP_INTERCOMPANY_ACCTAP_INTERCOMPANY_ACCT116390
AR Intercompany AccountIntercompany receivables account segmentAsset Book.AR Intercompany AccountAR_INTERCOMPANY_ACCTAR_INTERCOMPANY_ACCT116455
Allow Amortize FlagIndicates whether or not to allow amortized changesAsset Book.Allow Amortize FlagAMORTIZE_FLAGALLOW_AMORTIZE_FLAG115539
Allow Cost CeilingIndicates whether or not to allow cost ceilingsAsset Book.Allow Cost CeilingALLOW_COST_CEILINGALLOW_COST_CEILING115541
Allow Depreciation AdjustmentsIndicates whether or not to allow depreciation reserve adjustments in tax booksAsset Book.Allow Depreciation AdjustmentsALLOW_DEPRN_ADJUSTMENTSALLOW_DEPRN_ADJUSTMENTS115542
Allow Depreciation Expense CeilingIndicates whether or not to allow depreciation expense ceilingsAsset Book.Allow Depreciation Expense CeilingALLOW_DEPRN_EXP_CEILINGALLOW_DEPRN_EXP_CEILING115543
Allow Mass ChangesIndicates whether or not to allow mass changesAsset Book.Allow Mass ChangesALLOW_MASS_CHANGESALLOW_MASS_CHANGES115545
Allow Mass CopyIndicates whether or not to allow mass copyAsset Book.Allow Mass CopyALLOW_MASS_COPYALLOW_MASS_COPY115546
Allow Purge FlagIndicates whether or not to allow purgeAsset Book.Allow Purge FlagALLOW_PURGE_FLAGALLOW_PURGE_FLAG115548
Allow Revaluation FlagIndicates whether or not to allow revaluationAsset Book.Allow Revaluation FlagALLOW_REVAL_FLAGALLOW_REVAL_FLAG115549
Allowed GL Posting FlagIndicates whether or not to allow posting to GLAsset Book.Allowed GL Posting FlagGL_POSTING_ALLOWED_FLAGALLOWED_GL_POSTING_FLAG115535
Amortize Revaluation Reserve FlagIndicates whether or not to amortize revaluation reserveAsset Book.Amortize Revaluation Reserve FlagAMORTIZE_REVAL_RESERVE_FLAGAMORTIZE_REVAL_RESERVE_FLAG115845
Book ClassIndicates whether the book is a corporate, tax, or budget bookAsset Book.Book ClassBOOK_CLASSBOOK_CLASS120179
Book Type CodeBook NameAsset Book.Book Type CodeBOOK_TYPE_CODEBOOK_NAME120182
Book Type NameDescription of the bookAsset Book.Book Type NameBOOK_TYPE_NAMEBOOK_TYPE_NAME120191
Capital Gain ThresholdMinimum time to hold an asset for Oracle Assets to report it as a capital gain on the form 4797 reports when you retire itAsset Book.Capital Gain ThresholdCAPITAL_GAIN_THRESHOLDCAPITAL_GAIN_THRESHOLD121555
Copy Additions FlagIndicates whether or not to copy additions in a mass copyAsset Book.Copy Additions FlagCOPY_ADDITIONS_FLAGCOPY_ADDITIONS_FLAG123521
Copy Adjustments FlagIndicates whether or not to copy adjustments in a mass copyAsset Book.Copy Adjustments FlagCOPY_ADJUSTMENTS_FLAGCOPY_ADJUSTMENTS_FLAG123522
Copy Retirements FlagIndicates whether or not to copy retirements in a mass copyAsset Book.Copy Retirements FlagCOPY_RETIREMENTS_FLAGCOPY_RETIREMENTS_FLAG123532
Copy Salvage Value FlagIndicates whether or not to mass copy salvage valueAsset Book.Copy Salvage Value FlagCOPY_SALVAGE_VALUE_FLAGCOPY_SALVAGE_VALUE_FLAG123537
Cost Of Removal Clearing AccountClearing account segment for cost of removal upon retirementAsset Book.Cost Of Removal Clearing AccountCOST_OF_REMOVAL_CLEARING_ACCTCOST_OF_REMOVAL_CLEARING_ACCT123741
Cost Of Removal Gain AccountAccount segment for cost of removal upon retirement that results in a gainAsset Book.Cost Of Removal Gain AccountCOST_OF_REMOVAL_GAIN_ACCTCOST_OF_REMOVAL_GAIN_ACCT123742
Cost Of Removal Loss AccountAccount segment for cost of removal upon retirement that results in a lossAsset Book.Cost Of Removal Loss AccountCOST_OF_REMOVAL_LOSS_ACCTCOST_OF_REMOVAL_LOSS_ACCT123743
Created ByStandard WHO column.Asset Book.Created ByCREATED_BYCREATED_BY124574
Creation DateStandard WHO column.Asset Book.Creation DateCREATION_DATECREATION_DATE125999
Current Fiscal YearCurrent fiscal year for the bookAsset Book.Current Fiscal YearCURRENT_FISCAL_YEARCURRENT_FISCAL_YEAR127354
Date IneffectiveDate that the book is no longer activeAsset Book.Date IneffectiveDATE_INEFFECTIVEDATE_INEFFECTIVE128352
Default Life Extension CeilingDefault maximum factor by which the life can be multiplied when backing out depreciation during revaluation. Does not affect the actual asset lifeAsset Book.Default Life Extension CeilingDEFAULT_LIFE_EXTENSION_CEILINGDEFAULT_LIFE_EXTENSION_CEILING128825
Default Life Extension FactorDefault factor by which to extend the life when revaluing a fully reserved assetAsset Book.Default Life Extension FactorDEFAULT_LIFE_EXTENSION_FACTORDEFAULT_LIFE_EXTENSION_FACTOR128826
Deferred Depreciation Expense AccountExpense account segment for deferred depreciationAsset Book.Deferred Depreciation Expense AccountDEFERRED_DEPRN_EXPENSE_ACCTDEFERRED_DEPRN_EXPENSE_ACCT128885
Deferred Depreciation Reserve AccountReserve account segment for deferred depreciationAsset Book.Deferred Depreciation Reserve AccountDEFERRED_DEPRN_RESERVE_ACCTDEFERRED_DEPRN_RESERVE_ACCT128886
Depreciate First Year Retirements FlagIndicates whether or not to depreciate assets retired in the first year of lifeAsset Book.Depreciate First Year Retirements FlagDEPR_FIRST_YEAR_RET_FLAGDEPR_FIRST_YEAR_RET_FLAG129245
Depreciation Adjustment AccountAccount segment for reserve adjustments in tax booksAsset Book.Depreciation Adjustment AccountDEPRN_ADJUSTMENT_ACCTDEPRN_ADJUSTMENT_ACCT129238
Depreciation CalendarName of depreciation calendarAsset Book.Depreciation CalendarDEPRN_CALENDARDEPRN_CALENDAR129241
Distribution Source BookAssociated corporate book used for tracking distributionsAsset Book.Distribution Source BookDISTRIBUTION_SOURCE_BOOKDISTRIBUTION_SOURCE_BOOK130253
Fiscal Year NameName of fiscal year for which the book is definedAsset Book.Fiscal Year NameFISCAL_YEAR_NAMEFISCAL_YEAR_NAME134413
GL Journal Entry SourceGeneral Ledger journal entry sourceAsset Book.GL Journal Entry SourceGL_JE_SOURCEGL_JE_SOURCE135238
ITC Allowed FlagIndicates whether or not to allow ITCAsset Book.ITC Allowed FlagITC_ALLOWED_FLAGITC_ALLOWED_FLAG137679
Initial DateDate the last time depreciation was run for this book on the previous asset systemAsset Book.Initial DateINITIAL_DATEINITIAL_DATE136893
Journal Entry Addition CategoryJournal category for additionsAsset Book.Journal Entry Addition CategoryJE_ADDITION_CATEGORYJE_ADDITION_CATEGORY138008
Journal Entry Adjustment CategoryJournal category for adjustmentsAsset Book.Journal Entry Adjustment CategoryJE_ADJUSTMENT_CATEGORYJE_ADJUSTMENT_CATEGORY138009
Journal Entry CIP Addition CategoryJournal category for CIP additionsAsset Book.Journal Entry CIP Addition CategoryJE_CIP_ADDITION_CATEGORYJE_CIP_ADDITION_CATEGORY138016
Journal Entry CIP Adjustment CategoryJournal category for CIP adjustmentsAsset Book.Journal Entry CIP Adjustment CategoryJE_CIP_ADJUSTMENT_CATEGORYJE_CIP_ADJUSTMENT_CATEGORY138017
Journal Entry CIP Reclass CategoryJournal category for CIP reclassificationsAsset Book.Journal Entry CIP Reclass CategoryJE_CIP_RECLASS_CATEGORYJE_CIP_RECLASS_CATEGORY138018
Journal Entry CIP Retirement CategoryJournal category for CIP retirementsAsset Book.Journal Entry CIP Retirement CategoryJE_CIP_RETIREMENT_CATEGORYJE_CIP_RETIREMENT_CATEGORY138019
Journal Entry CIP Revaluation CategoryReserved for future useAsset Book.Journal Entry CIP Revaluation CategoryJE_CIP_REVAL_CATEGORYJE_CIP_REVAL_CATEGORY138020
Journal Entry CIP Transfer CategoryJournal category for CIP transfersAsset Book.Journal Entry CIP Transfer CategoryJE_CIP_TRANSFER_CATEGORYJE_CIP_TRANSFER_CATEGORY138021
Journal Entry Deferred Depreciation CategoryJournal category for deferred depreciationAsset Book.Journal Entry Deferred Depreciation CategoryJE_DEFERRED_DEPRN_CATEGORYJE_DEFERRED_DEPRN_CATEGORY138022
Journal Entry Depreciation Adjustment CategoryJournal category for tax depreciation adjustmentsAsset Book.Journal Entry Depreciation Adjustment CategoryJE_DEPRN_ADJUSTMENT_CATEGORYJE_DEPRN_ADJUSTMENT_CATEGORY138024
Journal Entry Depreciation CategoryJournal category for depreciationAsset Book.Journal Entry Depreciation CategoryJE_DEPRECIATION_CATEGORYJE_DEPRECIATION_CATEGORY138023
Journal Entry Reclass CategoryJournal category for reclassificationsAsset Book.Journal Entry Reclass CategoryJE_RECLASS_CATEGORYJE_RECLASS_CATEGORY138029
Journal Entry Retirement CategoryJournal category for retirementsAsset Book.Journal Entry Retirement CategoryJE_RETIREMENT_CATEGORYJE_RETIREMENT_CATEGORY138030
Journal Entry Transfer CategoryJournal category for transfersAsset Book.Journal Entry Transfer CategoryJE_TRANSFER_CATEGORYJE_TRANSFER_CATEGORY138033
Last Depreciation Run DateDate of the last depreciationAsset Book.Last Depreciation Run DateLAST_DEPRN_RUN_DATELAST_DEPRN_RUN_DATE138512
Last Period CounterLast period depreciated in this bookAsset Book.Last Period CounterLAST_PERIOD_COUNTERLAST_PERIOD_COUNTER138582
Last Period NameLast system generated accounting period nameAsset Book.Last Period NameLAST_PERIOD_NAMELAST_PERIOD_NAME138583
Last Update DateStandard WHO column.Asset Book.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140533
Last Updated ByStandard WHO column.Asset Book.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139201
Mass Copy Source BookAssociated corporate book to Mass Copy fromAsset Book.Mass Copy Source BookMASS_COPY_SOURCE_BOOKMASS_COPY_SOURCE_BOOK146246
Multicurrency Source FlagIndicates whether the book is an MRC-enabled bookAsset Book.Multicurrency Source FlagMC_SOURCE_FLAGMC_SOURCE_FLAG146509
Net Book Value Retired Gain Account CodeNBV retired account segment to use if retirement results in a gainAsset Book.Net Book Value Retired Gain Account CodeNBV_RETIRED_GAIN_ACCTNBV_RETIRED_GAIN_ACCT_CODE147859
Net Book Value Retired Loss Account CodeNBV retired account segment to use if retirement results in a lossAsset Book.Net Book Value Retired Loss Account CodeNBV_RETIRED_LOSS_ACCTNBV_RETIRED_LOSS_ACCT_CODE147860
Proceeds Of Sale Clearing AccountProceeds of sale clearing account segmentAsset Book.Proceeds Of Sale Clearing AccountPROCEEDS_OF_SALE_CLEARING_ACCTPROCEEDS_OF_SALE_CLEARING_ACCT155769
Proceeds Of Sale Gain AccountProceeds of sale account segment to use if retirement results in a gainAsset Book.Proceeds Of Sale Gain AccountPROCEEDS_OF_SALE_GAIN_ACCTPROCEEDS_OF_SALE_GAIN_ACCT155770
Proceeds Of Sale Loss AccountProceeds of sale account segment to use if retirement results in a lossAsset Book.Proceeds Of Sale Loss AccountPROCEEDS_OF_SALE_LOSS_ACCTPROCEEDS_OF_SALE_LOSS_ACCT155771
Prorate CalendarName of prorate calendarAsset Book.Prorate CalendarPRORATE_CALENDARPRORATE_CALENDAR156773
Retire Revaluation Reserve FlagIndicates whether or not to retire revaluation reserveAsset Book.Retire Revaluation Reserve FlagRETIRE_REVAL_RESERVE_FLAGRETIRE_REVAL_RESERVE_FLAG159316
Revaluation Journal CategoryJournal category for revaluationAsset Book.Revaluation Journal CategoryJE_REVAL_CATEGORYREVALUATION_JOURNAL_CATEGORY159369
Revaluation Reserve Retired Gain AccountRevaluation reserve retired account segment to use if retirement results in a gainAsset Book.Revaluation Reserve Retired Gain AccountREVAL_RSV_RETIRED_GAIN_ACCTREVAL_RSV_RETIRED_GAIN_ACCT159375
Revaluation Reserve Retired Loss AccountRevaluation reserve retired account segment to use if retirement results in a lossAsset Book.Revaluation Reserve Retired Loss AccountREVAL_RSV_RETIRED_LOSS_ACCTREVAL_RSV_RETIRED_LOSS_ACCT159376
Revalue Depreciation Reserve FlagIndicates whether or not to revalue depreciation reserveAsset Book.Revalue Depreciation Reserve FlagREVAL_DEPRN_RESERVE_FLAGREVALUE_DEPRN_RESERVE_FLAG159370
Revalue On Retirement FlagIndicates whether or not to revalue upon retirementAsset Book.Revalue On Retirement FlagREVALUE_ON_RETIREMENT_FLAGREVALUE_ON_RETIREMENT_FLAG159371
Set Of Books IdThe unique identification number assigned to a set of books.Asset Book.Set Of Books IdSET_OF_BOOKS_IDSET_OF_BOOKS_ID161486
Set Of Books NameThe set of books name.Asset Book.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161556
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Asset Book -> AssetAsset Book.Book Type Code = Asset.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> Asset Accounting PeriodAsset Book.Book Type Code = Asset Accounting Period.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> Asset AssignmentAsset Book.Book Type Code = Asset Assignment.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> Asset Book AssetAsset Book.Book Type Code = Asset Book Asset.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> Asset Transaction HeaderAsset Book.Book Type Code = Asset Transaction Header.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> Asset Transaction LineAsset Book.Book Type Code = Asset Transaction Line.Book Type CodeAlways exist in master folderNoneNo
Asset Book -> DepreciationAsset Book.Book Type Code = Depreciation.Book Type CodeAlways exist in master folderNoneNo