Apparently `{territory.id}` works, but I have no i...
# general
k
Apparently
{territory.id}
works, but I have no idea why. I thought I would need to use something from this list: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/odbc/record/territory.html
d
You can't think of Saved Searches as the same thing as a SQL query... Yes, they have similarities, but their very different animals. The schema you linked to is based on ODBC views that NS has prebuilt. Saved Searches, and specifically the field naming conventions more closely follow the suitescript schema, which is why it's territory.id instead of territory.territory_id. http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/customer.html