MaintenanceRecords Service Manager Task information.
Service Manager
Maintenance
|
Name |
Type |
Link To/Supplied |
|
JobID |
VarChar |
|
|
JobNo |
Int |
|
|
ServiceID |
VarChar |
SM_Service.ServiceID |
|
DepartmentID |
VarChar |
SM_Department.DepartmentID |
|
SubCategoryID |
VarChar |
SM_SubCategory.SubCategoryID |
|
Priority |
VarChar |
SM_Priority.PriorityID |
|
Status |
VarChar |
SM_Status.StatusID |
|
AssignedStaffID |
Char |
HR_Staff.StaffID |
|
Description |
Text |
|
|
Comments |
Text |
|
|
DateLogged |
Date/Time |
|
|
LoggedBy |
VarChar |
HR_Staff.StaffID |
|
ScheduledStart |
Date/Time |
|
|
EstimatedDuration |
Decimal |
|
|
HasDeadline |
Bit |
|
|
Deadline |
Date/Time |
|
|
CompletionID |
VarChar |
HR_Staff.StaffID |
|
CompletionDate |
Date/Time |
|
|
LastSavedDateTime |
Date/Time |
|
|
LastSavedStaffID |
VarChar |
HR_Staff.StaffID |
|
SupportPackID |
Char |
SM_SupportPack.PackID |
|
AddressID |
Text |
"" = No Task Address DB_Main1.DebtorID (Debtor Mailing Address) DB_DeliveryAddress.DeliveryID (Debtor Delivery Address) |
|
ClientSystemID |
Text |
SM_ClientSystem.ClientSystemID |
Copyright © 2012 Jiwa Financials. All rights reserved.