Locating "Import Journal Process ID"
I've found this information on the structure of journal batch names:
Spreadsheet A 72002 97252 N
In our general ledger reporting we often refer to this "Import Journal Process ID" as a journal identifier, as such it would be useful to be able to join to the raw value in the database (i'm currently doing some searching/extracting from the batch name but this is not very performative)
The desire would be to locate this process ID from a starting point of GL_JE_Batches.