Tables Involved in Asset Management
Transaction Tables
Asset Related
PS_ASSET
PS_ASSET_LANG
PS_ASSET_ACQ_DET
PS_ASSET_ATTRIBUTE
PS_ASSET_CHECKOUT
PS_ASSET_COMMENTS
PS_ASSET_CUSTODIAN
PS_ASSET_FSC
PS_ASSET_IMAGE
PS_ASSET_INSPCTION
PS_ASSET_INSRNCE_H
PS_ASSET_INSURANCE
PS_ASSET_LICENSE
PS_ASSET_LOCATION
PS_ASSET_MAINT
Cost Related
PS_COST
PS_COST_ARCHIVE
PS_COST_NON_CAP
PS_COST_PEND_TO
PS_COST_PEND_TRANS
Depreciation Related
PS_DEPR_ARCHIVE
PS_DEPR_BOOK
PS_DEPR_COMP
PS_DEPR_RPT
PS_DEPR_RPT_ARCH
PS_DEPR_RPT_CF_SUM
PS_DEPR_RPT_PD_SUM
PS_DEPRECIATION
Set Up Tables
Business Unit Related
PS_BU_BOOK_TBL
PS_BUS_UNIT_TBL_AM
Distribution Related
PS_DIST_TMPL_TBL
PS_DIST_TMPLLN_TBL
Other Set Up Tables
PS_IU_TRF_DEFN_TBL
PS_AMAE_TMPLID_TBL
PS_BOOK_DEFN_TBL
PS_CATEGORIES_TBL
PS_LOCATION
PS_DIST_TMPL_TBL
Asset Related
PS_ASSET
PS_ASSET_LANG
PS_ASSET_ACQ_DET
PS_ASSET_ATTRIBUTE
PS_ASSET_CHECKOUT
PS_ASSET_COMMENTS
PS_ASSET_CUSTODIAN
PS_ASSET_FSC
PS_ASSET_IMAGE
PS_ASSET_INSPCTION
PS_ASSET_INSRNCE_H
PS_ASSET_INSURANCE
PS_ASSET_LICENSE
PS_ASSET_LOCATION
PS_ASSET_MAINT
Cost Related
PS_COST
PS_COST_ARCHIVE
PS_COST_NON_CAP
PS_COST_PEND_TO
PS_COST_PEND_TRANS
Depreciation Related
PS_DEPR_ARCHIVE
PS_DEPR_BOOK
PS_DEPR_COMP
PS_DEPR_RPT
PS_DEPR_RPT_ARCH
PS_DEPR_RPT_CF_SUM
PS_DEPR_RPT_PD_SUM
PS_DEPRECIATION
Set Up Tables
Business Unit Related
PS_BU_BOOK_TBL
PS_BUS_UNIT_TBL_AM
Distribution Related
PS_DIST_TMPL_TBL
PS_DIST_TMPLLN_TBL
Other Set Up Tables
PS_IU_TRF_DEFN_TBL
PS_AMAE_TMPLID_TBL
PS_BOOK_DEFN_TBL
PS_CATEGORIES_TBL
PS_LOCATION
PS_DIST_TMPL_TBL
PS_COST_TYPE_TBL
Asset Profile Related
PS_PROFILE_TBL
PS_PROFILE_BK_TBL
PS_PROFILE_DET_TBL
PS_PROFILE_DET_RT
PS_PROFILE_CR_TBL
PS_PROFILE_PARC_BK
Other Important Tables
PS_AM_AST_COMP_HIS
PS_AM_DOC_SEQ
PS_AM_GL_RECON_TBL
PS_AM_VAT_TRANS
PS_AMBI_INTFC_BILL
PS_ASSET_NBV_ARCH
PS_ASSET_NBV_TBL
PS_ASSET_PROP_TAX
PS_ASSET_PROPERTY
PS_ASSET_RT
PS_ASSET_UD_ATTR
PS_ASSET_WARRANTY
PS_BOOK
PS_BOOK_ARCHIVE
PS_BOOK_HIST
PS_BOOK_TAX_CR
PS_CAP_DET
PS_DIST_LN
PS_DIST_LN_ARCH
PS_INFL_ADJ
PS_INFL_ADJ_CACHE
PS_LEASE
PS_LEASE_OPER
PS_LEASE_SCHED
PS_LEASE_SCHED2
PS_LEASE_STEP_PYMT
PS_LTAX_INFO1_TBL
PS_LTAX_INFO2_TBL
PS_OPEN_TRANS
PS_OPEN_TRANS_ARCH
PS_PI_ASSET_HIST
PS_RET_DET_TBL
PS_RETIREMENT
PS_RETIREMENT_NF
PS_IT_SFTWR_ASSET