| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| Code | Trade Code | nvarchar | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| DefaultCharge | Default Charge | decimal | |
| DefaultSupervisor | Default Supervisor | nvarchar | |
| Description | Trade Description | nvarchar | |
| nvarchar | |||
| Id | Trade Id | int | |
| IsCustodial | Indicates if this Trade can be used on Custodial Records | bit | |
| IsShopActive | Indicates if this Trade's associated Shop is active (true) or inactive (false) | bit | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| ShopCode | Shop Code | nvarchar | |
| ShopFaxNumber | Shop Fax Number | nvarchar | |
| ShopId | Shop Id | int | vr_shop |
| ShopName | Shop Name | nvarchar | |
| ShopPhoneNumber | Shop Phone Number | nvarchar | |
| TechnicianCode | Technician Code | nvarchar | |
| TechnicianId | Technician Id | int | vrpt_Technician |
| TechnicianName | Technician Name | nvarchar | |
| UserQueryHeaderId | Query Id | int | vt_userQueryHeader |
| UserQueryHeaderName | Query Name | nvarchar | |
| VirtualWarehouseCode | Virtual Warehouse Code | nvarchar | |
| VirtualWarehouseId | Virtual Warehouse Id | int | vr_warehouse |
| VirtualWarehouseName | Virtual Warehouse Name | nvarchar |