| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fu_description | Area Description | nvarchar | |
| fu_pk | Area Record Id | int | vr_area |
| fu_unitID | Area Location Id | nvarchar | |
| Id | Key Cabinet Id | int | vr_KeyCabinet |
| kc_description | Key Cabinet Description | nvarchar | |
| kc_pk | Key Cabinet Id | int | vr_KeyCabinet |
| kc_tagNumber | Key Cabinet Tag Number | nvarchar | |
| keyInventoryQuantity | Key Inventory Quantity | int | |
| kser_serialNumber | Key Serial Number | nvarchar | |
| ktr_kc_fk | Key Cabinet Id | int | vr_KeyCabinet |
| ktr_kser_fk | Key Serial Id | int | |
| ktr_ky_fk | Key Id | int | vr_Key |
| ky_description | Key Description | nvarchar | |
| ky_number | Key Number | nvarchar | |
| ky_pk | Key Id | int | vr_Key |