multi_org tables have the colums org_id and end's with _all but not in base tables
BASE TABLES ENDS WITH _B, TABLES WHICH ARE HAVING _B HAS TO BE TRANSLATED TO MULTIPLE LANGUAGES
EXAMPLE ITEM INFORMATION IS STORED IN BASE TABLE WHICH HAS TO BE TRANSLATED FOR THIS WE HAVE ANOTHER TABLE WHICH ENDS WITH _TL
_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
_TL These tables provide multiple language support.
_B these are the BASE tables.
_F these are date tracked tables, which occur in HR and Payroll.
_V tables are the views created on base tables
_VL are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV('LANG').
_S are sequences, used for finding new values for the primary key of a table.
_A are Audit Shadow Tables
_AVN and _ACN are Audit Shadow Views (when data was changed, and with what value
No comments:
Post a Comment