How do I reference the Subsidiary on a customer r...
# suiteql
r
How do I reference the Subsidiary on a customer record
d
Using customersubsidiaryrelationship table, for example: select BUILTIN.DF(C.companyname) as "companyname", BUILTIN.DF(S.subsidiary) as subsidiary from customer C join customersubsidiaryrelationship S on (C.id = S.entity and S.isprimarysub = 'T')