Field Service table information

(0) Share

Report

Posted on by Community Member

Good Afternoon! I need to find out if field PROJCTID in svc00200 flows to any other tables in GP. Also, where on the interface is the field ProjectRef1 located.

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Other tables including the Project ID fields are as below;

SELECT PROJCTID, * FROM SVC00200 -- Service Call Master
SELECT PROJCTID, * FROM RM10101 -- RM Distribution Work File
SELECT PROJCTID, * FROM RM30301 -- Receivables GL Distribution History
SELECT PROJCTID, * FROM SVC30200 -- Service Call Master History

Hope this helps,

Was this reply helpful? Yes No