Hi! I am trying to fetch data from the second subsidiary field in an advanced intercompany journal but I do not find the field. Does anyone know the name of the "due to/from subsidiary" field / table in suiteql?

it is blank

I don't think that field is exposed anywhere. Saved Searches, SA Workbooks, ODBC were a no go too last I checked. They stubbornly refuse to open it up for some reason. Could file a case to see if it's there, but just has some non-obvious name, but I've never been able to find it.

could you create a custom field and set it with a script or workflow after the record has been saved?