is it possible in the analytics connector to link a revenue element to the corresponding revenue arrangement

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the Revenue Plan is connected to transactions or sales orders through the Revenue Element. Each item in a sales order creates a Revenue Element, which in turn generates the actual Revenue Plan for posting. The Revenue Element's

source

field holds the document id, and the

referenceid

field holds the internal id in the format

<RecordType>_<InternalId>

. However, it's important to note that the

referenceid

is stored as text and not a direct link. To extract the internal id for a join in SuiteQL, you can use

SUBSTR(revenueElement.referenceid, INSTR(revenueElement.referenceid, '_') + 1)

. As for linking a Revenue Element to the corresponding Revenue Arrangement, it seems that this is done automatically when the Revenue Element is created. However, the conversations do not provide a definitive answer on whether this can be done manually through the Analytics Connector. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******