ok cool... so i have to take the third letter and decode it...
where can i get all the values and its translations (Asset, Liability, Revenue, Owner Equity etc..)... are they stored in some standard lookup or will i have to write a decode hard codedly ??
These values are stored somewhere in a lookup.
Anyway, you have only five of them.
A(sset), E(xpense), L(iability),O(wner's Equity) and R(evenue)
Don't know exactly what are you trying to achieve...
I'm an accoutant so I easily deal with this sort of stuff.
Only the ACCOUNT_TYPE stored at GL_CODE_COMBINATIONS is important. The qualifier at value level is not important because the debits and credits are stored against the combinatios, not against single values.And only the Natural Account segment values have that type of qualifier.
Does this helps you?
My question is answered.. Thank you exceedingly much.. to answer your curiosity, this query is to get the data from one instance and uploading it at another different system..