Inventory Issue and Return Debit/Credit Transaction | IBM Maximo

Maximo doesn't use a reverse entry approach but instead Maximo will change the SIGN(-) of LINECOST and GL accounts remains the same.

e.g.
Issuance:
GL Debit = org-222 $1,000
GL Credit = org-111 $1,000

Return:
GL Debit = org-222 $-1,000
GL Credit = org-111 $-1,000

Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21453747

Extract Segments from GLCode - IBM Maximo

A requirement once occurred at integration level at one of my client, We use below mentioned select clause combination with in-built sql functions "substr" and "instr" to achieve this task.
Segments separator was used there as "."

Example GLCode is as "Asset.OC.AFE.Element.Dept.Account.GLAC"