You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Chart of accounts mapping tables - can't find the table or column name for "condition"

Summary: Need to know the table name and column name for the field "condition" in Manage Chart of Accounts Mapping form.

I was able to build a sql query with all the columns I need except none of the COA mapping tables have a column name "condition". The valid values for "Condition" are "equal to" and "Between".

Content (please ensure you mask any confidential information):

I am building a BIP report to show the COA mapping configuration for one our Local Ledgers to the Global Ledger. (Setup and maintenance '> Manage Chart of Accounts Mapping). I was able to build a sql query with all the columns I need except none of the COA mapping tables have a column named "condition". The valid values for "Condition" are "equal to" and "Between".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!