EXPORT ZOQL - Howto query account level custom fields visible on the JournalEntryItem data source

[JeanChristophe]

We have a custom field named ‘WorkshareBillingEntity__c’ , on the account object.

In the Data Source export we observe a column "Journal Entry: Account Workshare Billing Entity" and we can't find a way to query this field using the EXPORT ZOQL on a JournalEntryItem data source

We’ve tried different queries with the following field name but they all supply the same error.

WorkshareBillingEntity__c
JournalEntry.WorkshareBillingEntity__c

[JeanChristophe · Accepted solution]

The "Account Workshare Billing Entity" field you can see on the "Journal Entry" object on the JournalEntryItem Data Source is related to the Segmentation Rule you have created on your tenant using the Custom field.

https://apisandbox.zuora.com/apps/SegmentationRule.do?method=list

With the EXPORT ZOQL, you can query this field with "__s" and not "__c" at the end of the field name:
JournalEntry.AccountWorkshareBillingEntity__s