GP Tables
Financials
Human Resources
Inventory
Payroll
Purchasing
Sales
Marketplace
Extensions
Services
Free Downloads
Useful SmartLists Pack
Useful SQL Scripts
Excel Refreshable Report
EFT File Generator
Professional Invoice Templates
BAI2 Statement Format
Home
FieldService
SVC00101 - Technician Schedule
Query Builder
Select * from SVC00101
Column
Description
Data Type
Length
Tables This Field Is In
In Query
(
)
TECHID
Tech ID
String
12
View
STRTDATE
Start Date
Date
4
View
STRTTIME
Start Time
Time
4
View
ENDDATE
End Date
Date
4
View
ENDTME
SVC_End Time
Time
4
View
TECHSTAT
Tech Status
String
12
View
TECHID2
Tech ID2
String
12
View