Home > Uncategorized > Available overflow tables

Available overflow tables

Available overflow tables
Assets table (amAsset)

This is the main overflow table in Asset Manager. The only portfolio items not recorded in this table are those defined as untracked batched.

The overflow link (PortfolioItems) contained in this table enables the creation of batches and shares the foreign key.

This table enables you to store detailed information on assets:
1) Purchase date
2) Status (amAsset.Status)
3) Rent
4) Acquisition method
5) Fixed Asset number
6) Serial NUmber (SerialNo)
7) AssetTag
8) vzCreateDate
9) vzArchiveDate
10) vzADRCompletionDate
11) vzBusinessUnit
12) Linked to amModel by lModelId
13) PK is lAstId

Computers table (amComputer)

This table is an overflow table of the Assets table: Creating a computer generates a record in the Portfolio Items table, the Assets table, and the Computers table.

In particular, it is used to store information relating to integration with
software distribution tools: Software distribution identifier (SWDID)

lComputerId ?

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: