| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| ac_code | Asset Type Code | nvarchar | |
| ac_description | Asset Type Description | nvarchar | |
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| Id | Asset Id | int | |
| p_description | Description | nvarchar | |
| p_originalCost | Original Cost | decimal | |
| p_purchaseDate | Purchase Date | datetime | |
| p_tagNumber | Tag Number | nvarchar | |
| replacementCost | Replacement Cost | decimal | |
| replacementDate | Replacement Date | datetime |