Looking for table where Field Service User defined field is stored

(0) Share

Report

Posted on by Alan Lee 2

402

Hopefully someone can help. We are using one of the user defined fields on the Field Service>Service Call Entry/Update window. I'm trying to find the underlying reference SQL table that holds the data. Using the usual string search script to search for the text in all tables didn't throw it up. I'm trying to modify a smartlist so that instead of showing the index value for that user defined field it shows the text associated with that index value.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Community Member on at

Like (0)

Report

I'm having this same issue - I would like to 'name' the first field. Can anyone tell us where to name these fields?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I think it might be here:

Tools > Setup > Project > Service Setup click on Service button, and then click on User Defined in the Service Setup - Service window.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

SVC00200 (open) or SVC30200 (closed)

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

1. Service Call Master Table (Select USERDEF1,USERDEF2,USRDEF03,USRDEF04,USRDEF05, *from SV00200)

2. Service Call Master History (Select USERDEF1,USERDEF2,USRDEF03,USRDEF04,USRDEF05, *from SV30200).

For your reference: Have a look on the below links to find the other tables related to Field Services.

dyndeveloper.com/DynProduct.aspx

Hope this helps!!!

Was this reply helpful? Yes No
Alan Lee 2 402 on at

Like (0)

Report

Thanks all for info so far. Indeed I can find the user defined field data (in my case all) stored in SVC00200, but it still only gets me as far as the index value, as my UDF is in the form of a drop down list. What I'd like to try to find is the link between the reference number in the UDF and the matching table that holds information. In my case this links 1 with Mechanical, 2 with Electrical, 3 with Instrument and so on.

I've been able to create a simple calculated field to get this together in Smartlist Builder so that we can at least create a display for my engineers, but it's not referencing the actual data set, just me creating an output with a matching text string to the current structure :

CASE {Service Call Master:Trade}

WHEN 1 THEN "Mechanical"

WHEN 2 THEN "Electrical"

WHEN 3 THEN "Instrument"

WHEN 4 THEN "Civil"

WHEN 5 THEN "Contractor"

WHEN 6 THEN "Mantech"

ELSE ""

END

I'm vulnerable with this approach to the actual linked names to the referenced values being changed, but the code not getting updated in Smartlist Builder.

Any thoughts folks ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Alan, the UDF out of the box is a simple text field. If you have a drop down list, then the form has been modified. As a guess, I would look in the DUOS table (SY90000) to see if your values are in there, but whoever wrote the customization could have put them anywhere - including a custom table. -Trevor

Was this reply helpful? Yes No
Tom Mathew 1,750 on at

Like (0)

Report

use the "spSearchOnAllDB" from David Musgrave's blog and execute it with any of your user defined field data like

EXEC spSearchOnAllDB 'user defined field data'

It will surely fetch the table.

Regards

Thomas

Was this reply helpful? Yes No
Verified answer

Alan Lee 2 402 on at

Like (0)

Report

Well done Tom - Comrade Musgrave's search to the rescue again.

It found the entries in EXT40102, so I can now use this as my primary link.

Thanks to all who helped

Cheers, Al.

Was this reply helpful? Yes No