Site ID Table and Table Name??

(0) Share

Report

Posted on by Community Member

I am working on an integration CRM<-->GP , to "push" an Account record from CRM to GP to create a new customer one of the fields we want to populate is Site ID.

Can someone please tell me which table this field can be found on and what the field would be called on the table?

Thanks

Retreever

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

The Site Master in GP in IV40700.

But not clear on how/why you would tie to a customer. GP holds on Item/Site combinations.

Good Luck!

Was this reply helpful? Yes No
Verified answer

MattPaulen 6,912 on at

Like (0)

Report
Copy link

Link copied!

The Site is also held at the address level for the customer so it's the RM00102 table. It's the LOCNCODE field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, LOCNCODE it is.

Was this reply helpful? Yes No