| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| ftr_active | Indicates if the trade is active or not | bit | |
| ftr_code | Trade Code | nvarchar | |
| ftr_createdDate | Record Creation Date | datetime | |
| ftr_creator_fk | User Id (Record Creator) | int | vr_users |
| ftr_defaultCharge | Trade Default Charge | decimal | |
| ftr_defaultSupervisor | Trade Default Supervisor | nvarchar | |
| ftr_description | Trade Description | nvarchar | |
| ftr_email | Trade Email | nvarchar | |
| ftr_isCustodial | Indicates if the Trade is available for Custodial records | bit | |
| ftr_modifiedDate | Last Modified Date | datetime | |
| ftr_modifier_fk | User Id (Record Modifier) | int | vr_users |
| ftr_pk | Trade Id | int | vr_Trade |
| ftr_sh_fk | Shop Id | int | vr_Shop |
| ftr_supervisor_wk_fk | Supervisor Technician Id | int | vrpt_Technician |
| ftr_userQuery_header_fk | User Query Header Id | int | vt_userQueryHeader |
| Id | Trade Id | int | vr_Trade |
| WKFTR_createdDate | Record Creation Date | datetime | |
| WKFTR_CREATOR_FK | User Id (Record Creator) | int | vr_users |
| WKFTR_FTR_FK | Trade Id | int | vr_Trade |
| WKFTR_modifiedDate | Last Modified Date | datetime | |
| WKFTR_MODIFIER_FK | User Id (Record Modifier) | int | vr_users |
| wkftr_preferred | Preferred Technician Trade | bit | |
| WKFTR_WK_FK | Technician Id | int | vrpt_Technician |