Territory on Business Partner
I have a Business Partner set up as a Customer. I need to know which SQL Table the Territory is stored in.
In looking at System Information it does not give my any Table Information and I can not find any information on where it is stored.
Thanks for any help.
Owen Slater replied
The key field to link the OCRD (Business Partner) table and the OTER table is a field called Territory in the OCRD. This maps to the territryID field in the OTER table. The SQL will look something like:
SELECT T0.CardCode, isnull(T1.descript, '') FROM OCRD T0 left outer join OTER T1 ON T0.Territory = T1.territryID
Hope this helps,