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
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
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156