Trying to recreate the OOTB Financial report
The only field that I'm not able to cleanly re-create from all the extracts is the csr_id, which is on the extract_audit table, because the subscription_id does not give a clean join.
We are having to try and use the time stamp on that table to find the nearest touch and go with that.
Support ticket discussion: ACS-25018
Response: It looks like the csr_id is not possible with extracts other than csrAudit_extract and for some records in extract_activity at the moment. If it is required in extract_activity, kindly add this into our Ideas portal for further enhancement.
Richard
