Fixed Assests Important Tables and Process Details

FA Tables Description
SET-UP
PS_BUS_UNIT_TBL_AM All the AM Business Units
PS_CATEGORY_TBL All the AM Categories
PS_PROFILE_TBL All the AM Profiles
PS_PROFILE_DET_TBL All the Details about Profiles
PS_BOOK_DEFN_TBL All the AM Books
PS_BU_BOOK_TBL Gives you the details about the BOOKS attached to each BU
PS_ASSET_CLASS_TBL All the AM Classes
PS_DIST_TMPLLN_TBL Accounting Entry Templates

Interface
PS_INTFC_PRE_AM
PS_INTFC_PHY_A
PS_INTFC_FIN

TRANSACTIONAL
PS_ASSET One row per asset
PS_ASSET_ACQ_DET Gives us the detail about the PO / Voucher etc for an ASSET
PS_BOOK One row per asset about the Life of an asset ,Method of Depr etc.,
PS_BOOK_HIST All the rows for one asset
PS_COST Gives us the Cost Information & all the transactions on an asset
PS_DEPRECIATION Depereciation of an asset for the whole life
PS_DIST_LN Accounting enty table of an asset simialr to PS_VCHR_ACCTG_LINE
PS_ASSET_LOCATION Gives us the Location of an asset
PS_ASSET_CUSTODIAN Gives us the Custodian of an asset
PS_ASSET_ATTRIBUTE Som other attributes of an asset -- Not Imp
PS_RETIREMENT One row for each asset which is retired
PS_OPEN_TRANS one row for each transaction used for depr & acctg
PS_ASSET_LICENSE Some other attributes of an asset -- Not Imp
PS_BU_BOOK_CLOSE

REPORTING
PS_DPR_RPT
PS_ASSET_NBV_TBL



FA Processes - Description > Navigation
PO_RECVPUSH - Loads the PO Information in the INTFC_PRE_AM Table Purchasing > Receipts > Process Receipts

INTFAPAM - Loads the AP Information in the INTFC_PRE_AM Table Accounts Payables > Batch Processes > Extracts & Loads > Load Asset Requests

AMPS1000 - Load info from INTFC_PRE_AM into INTFC_PHY_A & INTFC_FIN Asset Management > Send/Receive info > Retrieve info from AP/PO

AMIF1000 - Load all the asset tables Asset Management > Send/Receive info > Load Transaction in AM

AM_DEPR_CALC - Depreciation Calculation Asset Management > Depreciation > Processing > Calculate

AMAEDIST/ AMAEJOB - Accounting entries for an asset Asset Management > Acc Entries > Create Acc Entries

AMDPCLOS - Accounting entries for an asset Depreciation Asset Management > Acc Entries > Close Depreciation