user territories: - request.qmd_userterritories - limited to list of user territories - territoryid colummn client.usr_userterritories (all terrs, factoring in all terr visibility) the list of all mfrs a user can/should see use this to determine user ownership of certain partner types, opr, mfr, cdr, etc. Query fields: PARTNERID,PARTNERNAME,PARTNERTYPE,TERRITORYID this approach is used in the mfr sales call search ctr, and by mg in the following dashboard code