There is a need to develop data model to develop Interface errors in different sub ledgers like GL,AR,AP,INV, BOM etc. Every sub ledger interface table structure is different. please suggest if the below 1 table with all sublegers interface tables concatenated as all_interface is loaded with interface1 concatenate interface2 concatenate interface3.......interfaceN.
ALL_INTERFACE:
interface1
---- c1,c2 c3...cn columns and concatenated key (every subledger will have a unique key link other master tables.
...... interface N
---- c1,c2 c3...cn columns and concatenated key to link to other master tables.
How to display this on the dashboard in a single view.?
