Table Suffixes in Oracle Apps :
1. _ALL: A table ending with _ALL means it stores data related to multiple organizations.
2. _TL: The table ending with _TL is a Translation Table. Such tables have a column called language.
3. _B: Tables ending _B are the base tables.
4. _VL: Tables ending with _VL are Views built upon multi-language or translation tables.
5. _V : Tables ending with _V are views.
6. _S : Tables ending with _S are Sequences.
7. _A, _Avn, _ACn: Tables ending with _A, _Avn, _ACn are audit tables.
8. _F: Tables in which data is tracked with two date columns (Effective_start_Date, Effective_end_date). These tables are primarily used in HRMS and payroll modules.
1. _ALL: A table ending with _ALL means it stores data related to multiple organizations.
2. _TL: The table ending with _TL is a Translation Table. Such tables have a column called language.
3. _B: Tables ending _B are the base tables.
4. _VL: Tables ending with _VL are Views built upon multi-language or translation tables.
5. _V : Tables ending with _V are views.
6. _S : Tables ending with _S are Sequences.
7. _A, _Avn, _ACn: Tables ending with _A, _Avn, _ACn are audit tables.
8. _F: Tables in which data is tracked with two date columns (Effective_start_Date, Effective_end_date). These tables are primarily used in HRMS and payroll modules.
No comments:
Post a Comment