Thursday, August 22, 2013

Dynamics GP - Field Service Tables

https://www.gptablereference.com/2010/Group/Field%20Service

---------------------------------------
Preventative Maintenance Tables
---------------------------------------


Tables found under Fieldservice>Project
--------------------------------------
Service Call Management Tables
---------------------------------------
RM00101 - Customer Master
RM00102 - Customer Address Master

SVC00300 - Equipment Serial Master
SVC00911 - Equipment Status Master

SVC00100 - Tech Master
SVC00905 - Tech Status Codes
SVC00907 - Problem Codes
SVC00901 - Cause Codes
SVC00908 - Repair Codes
SVC00909 - Service Area Codes
SVC00913 - Service Call Status Codes

SVC00200 - Service Call Work
SVC00201 - Service Call Problem, Cause, Repair Codes
SVC00202 - Service Call Equipment
SVC00203 - Parts and Labor Lines
SVC00207 - If Multiple Techs are assigned to a service call, this table is populated, otherwise it is blank

SY03900 - Service Call Note
SVC00220-Service Invoice History
SVC30220-Service Invoice History History
---------------------------------------
Contract Administration Tables
----------------------------------------
SVC00600 - Contract Hdr
SVC00601 - Contract Lines (use a macro import to get these in)

SVC00300 - Serial Numbers for Items
SVC00301 - Posted Meter Readings
SVC00609 - Contract Line Distribution

SVC00300 - Serial Master - Equipment Master
SVC00310 - Serial Master - Audit (Contains user activity log information on field service)
SVC00951 - Extensions-Item

SVC00615 - Contract Billing Temp
-----------------------------------------
Inventory Tables
------------------------------------------
IV30300 - Item transaction detail
SVC00710 - Inventory Requirements Work
SVC30700 - In-Transit Transfer History Hdr
SVC30701 - In-Transit Transfer History Dtl


http://dyndeveloper.com/DynTable.aspx?ModuleID=SVC

No comments:

Post a Comment