Skip to main content

PeopleSoft Asset Management Tables

Below is the list of main tables being used in PeopleSoft Asset Management

PS_ASSET
PS_BOOK
PS_COST
PS_DEPRECIATION
PS_DIST_LN
PS_OPEN_TRANS
PS_ASSET_ACQ_DETAILS
PS_RETIREMENT

When new asset has been created then it inserts asset details into PS_ASSET, PS_BOOK,PS_ASSET_ACQ_DETAILS & PS_OPEN_TRANS tables.

If the asset has cost then there will be entry in PS_COST table.

Once asset has been added, we need to run Depreciation calculation process. System will calculate the depreciation based on details in book and cost details, depreciation entries will be inserted into PS_DEPRECIATION table.

Create Accounting entries or closure process will insert accounting entries into PS_DIST_LN table.

In case if an asset is retired then an entry will be inserted into PS_RETIREMENT table.

Apart from these base tables, there are two main reporting tables being used across AM reports.

PS_DEPR_RPT  - This table holds cost and depreciation details break down to individual accounting period.

PS_ASSET_NBV_TBL - This table hold asset cost and NBV details.


Now we will discuss in detail about important fields in those tables:

PS_OPEN_TRANS:

TRANS_DT : Date actual transaction has happened
ACCOUNTING_DT:   Accounting date is the date when you want to book those transactions in your books.
TRANS_TYPE: Type of transaction happended
CALC_DEPR_STATUS: Depreciation Calculation Status flag. When any new transaction happens  this flag is set to "P" (Pending). Once depreciation calculation is done, it will be set to "C".
CALC_DIST_STATUS: Accounting Entry creation status flag. In case accounting entry is not needed for a book then it is marked as "N", else it will be "P"/"C".
CALC_DEPR_STATUS: Indicates whether reporting table has been updated or not. 

Labels

Labels:

Comments

Aishwarya said…
Wonderful blog & good post.Its really helpful for me, Your blog is easily understandable and give complete information. Keep sharing new ideas and features.
Asset Management Software
Asset Tracking Software
Asset Management Software India
Asset Management Software Chennai
June 3, 2019 at 10:27 PM
Kavi Priya said…
I simply want to tell you that I’m all new to blogs and truly liked you’re blog site. Very likely I’m likely to bookmark your site .You surely come with remarkable articles.
Asset Management Software
August 21, 2019 at 5:35 AM
Bala Vignesh said…
Really very great information for that post, am amazed and then more new information are get after refer that post. I like that post.
Asset Management Software India
Asset Management Software Chennai
Asset Management Software
Asset Management Software Mumbai
Asset Management Software Bangalore
October 12, 2020 at 9:29 AM
Post a Comment

Popular posts from this blog

Making PS Query into Tile in PeopleSoft

MAKING A QUERY INTO A TILE Refer to Oracle documentation for creating  PeopleSoft fluid tile using PS query. Link:  Link to "Query to Tile" Documentation   Since many of you not able to access the document, I have listed the ontent of the document below for making a query into a tile.   1.      1. Create Query (or reuse an available query)   Pillar(HCM, FSCM, ELM, etc) > Reporting Tools > Query > Query Manager       The above query is just a list of employees and their health benefit plans.   Very simple query, but I wanted it to be simple to show how easy the process is to create a tile from a query.   2.  Create Pivot Grid (or reuse an available pivot grid) Pillar > Reporting Tools > Pivot Grid > Pivot Grid Wizard   Enter the name and the Title of the Pivot Grid. Grid Types: Private models are only available to the users who created the model and the users who have ...
Post a Comment
Read more

PeopleSoft eProcurement to AM

Below is the sequence or process flow for adding an asset from eProcurement: 1. Create Requisition, while creating requisition in Asset information tab, enter BU and profile id. Once after creation and approve the requisition. 2. Run Auto Requisition Selection process to stage the approve requisition data into PO Staging table. 3. Run PO Calculate process 4. Run PO Create process to create Purchase order for the staged data. 5. Approve the requisition and dispatch it. 6. Create Receipt for the dispatched PO:                   In Receipt page select "Interface Receipts" option and save it, this will trigger  RECV_02  PS job. This job  consists  of below process, basically these process will push the data from PO to AM, process the AM staged data and creates assets in AM. PO_RECVPUSH AMPS1000 AMIF1000
1 comment
Read more