| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| id | IT Equipment Id | int | vr_ITEquipment |
| itfc_code | IT Equipment Type Code | nvarchar | |
| itfc_description | IT Equipment Type Description | nvarchar | |
| itfm_acquisitionCost | Acquisition Cost | decimal | |
| itfm_clnt_fk | Obsolete Column (No Longer Used) | int | |
| itfm_description | It Equipment Description | nvarchar | |
| itfm_pk | IT Equipment Id | int | vr_ITEquipment |
| itfm_purchaseDate | Purchase Date | datetime | |
| itfm_tagNumber | IT Equipment Tag Number | nvarchar | |
| replacementCost | Replacement Cost | int | |
| replacementDate | Replacement Date | int |