Home > Uncategorized > Main tables in EAM – amPortfolio and amAsset

Main tables in EAM – amPortfolio and amAsset

The Portfolio items table (amPortfolio)

All portfolio items are recorded in this table.

By using the detail of an asset you can access the detail of a portfolio item.
The Portfolio items table is linked to other tables, which enable you to put
these items into context:
1) The Employees and Departments table (amEmplDept) provides the items’
users and supervisors.
2) The Locations table (amLocation) provides their location.
3) The Cost Centers table (amCostCenter) provides their related expense

— =====================================================
— amAsset and amPortfolio (or item, or portfolio item)
— link: lAstId
— amPortfolio: this is the table that links all together,
— amPortfolio: lAstId, lModelId, lUserId, lLocaId, lCostCatId, lCostId,
— =====================================================


The Assets table (amAsset)

Portfolio items with records in the Assets table can be tracked more closely, since, here, they are linked to their corresponding financial, technical and contractual information. This information is recorded in multiple tables with which the Assets table is linked. Among the most important of these tables are:
1) The Contracts table (amContract)
2) The Work Orders table (amWOrder)
3) The table of assets assigned to projects (amAstProjDesc)
4) The Requests table (amRequest)
5) The Purchase Orders table (amPOrder)
6) The Receipt Lines table (amReceiptLine)

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: