Fact tables Fixed Assets

Activity codes

The volume of information displayed in the environment using the Infoview tool is quite substantial.
It is possible to hide useless information by setting to 'No'' the activity codes globally assigned to the dimensions concerned, or the activity codes only assigned to the given fields of the fact table or of the various dimensions.
The following activity codes are suggested:

• BIF1 - Insurance
• BIF2 - Vehicule
• BIF3 - Market value
• BIF4 - Impairment loss
• BIF5 - Book vs. Tax provision
• BIF6 - Revaluation
• BIF7 - Exceptional depreciation
• BIF8 - Fiscal reintegration
• BIF9 - VAT
• BIF10 - Budget
• BIF11 - Deferred

In case thevalue of one or multiple activity codes is modified, the environment must be regenerated.

Description

To this fact table are linked:

Synchronization rules

These are the rules used to define the way the data are extracted from the database and the way the fact table is loaded. There are 3 for the Fixed assetsfact table:

• EXPENSES: Fixed assets expenses with LAYOUTFAS as source table (expenses)
• DEPRECEXE: Financial year depreciations with DEPREC as origin table (depreciation plans)

Update 8.0.0 and higher: 

• PHYELT: Physical elements with PHYELT as source table (physical elements)

The table fields can be loaded directly via a base field or their value determined via a calculation formula or the call result to a function.

Dimensions

These are database tables such as the country tables, sites, accounting codes.
Some dimensions are part of the Fixed assets module and others are common to all the modules (Company, Site, Analytical dimension types etc.) and can be linked to multiple fact tables. Links have been defined between these various dimensions.
When a field in a fact table is linked to a dimension, the corresponding link expression is defined in the fact table (Links tab). The dimension list linked to the fact table Fixed assets is given below.

From the Hierarchies

These are pre-defined grouping criteria, used to navigate in the report according to the required detail level, by grouping or zooming on the detail of the hierarchy criteria.
These hierarchies are defined for the Datamart. They are detailed below.

Predefined conditions

These are conditions that will be used as filter criteria in the report itself. They are defined for each fact tables.
It can either be, simple conditions using fields or constants, or conditions requiring values (conditions corresponding to queries to be entered in the reports).
Their list is given below.

Sub-classes

In the fact table, each field with the object type: Measure can be identified as belonging to a sub-class. Thanks to the BO Infoview tool, this classification is used to display this information grouped by sub-class in the Fixed assets environment.

 The sub-classes list linked to the fact table Fixed Assets is provided below.

Technical additions

Dimensions list

Common dimensions

• Company - COMPANY
  Source table: COMPANY
  Update type: Incremental
  
• Site - FACILITY
  Source table: FACILITY
  Update type: Incremental
   
• Currency - CURRENCY
  Source table: TABCUR
  Update type: Incremental

Version 7.2 and higher:

• Geographic site - GEOFCY
  Source table: FACILITY
  Update type: Incremental

Dimensions of the Fixed assets module
 

• Asset - Accounting code - FASACCOD
  Source table: GACCCODE
  Update type: Cancels and replaces
   
• Assets - FASASSETS
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Assets - Insurance contract - FASASSUR
  Source table: FXDASSETS
  Update type: Incremental
   
• Depreciation plan - FASDEPREC
  Source table: IMPAIRM
  Update type: Cancels and replaces
   
• Assets - Asset disposal - FASISSUE
  Source table: FXDASSETS
  Update type: Incremental
   
• Assets - VAT - FASTVA
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Assets - Vehicules - FASVEH
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Depreciation contexts - FISCYEAR
  Source table: FISCYEAR
  Update type: Cancels and replaces
   
• Subsidies - GRANTS
  Source table: GRANTS
  Update type: Incremental
   
• Subsidies - Collection - GRTCASH
  Source table: CASHING
  Update type: Incremental
   
• Expenses - LAYOUTFAS
  Source table: LAYOUTFAS
  Update type: Cancels and replaces
   
• Localization - LOCALIZAT
  Source table: LOCALIZAT
  Update type: Incremental
   
• Physical elements - PHYELT
  Source table: PHYELT
  Update type: Cancels and replaces
   

Hierarchy list

• FASANA1 - Analytical dimension 1

- Company
- Site
- Dimension 1
- Account no.
- Asset reference

• FASANA2 - Analytical dimension 2

- Company
- Site
- Dimension 2
- Account no.
- Asset reference

• FASIMPIAS - IFRS Allocation

- Company
- Site
- Accounting code
- IFRS account
- Asset reference

• FASIMPPCG - CoA Allocation

- Company
- Site
- Accounting code
- CoA account
- Asset reference

List of the predefined conditions

Code	Title	Dimension
COA	Chart of accounts	FASDEPREC
CPTPCGEND	End of the PCG account	FASASSETS
CPTPCGSTR	Start of the PCG account	FASASSETS
FASCPYEND	Company End	COMPANY
FASCPYSTR	Company Start	COMPANY
FASFCYEND	Financial site Year	FACILITY
FASFCYSTR	Financial site Start	FACILITY
FASSIMUEND	Analysis end date	FASDEPREC
FASSIMUSTR	Analysis end date	FASDEPREC
FASSTRSIMU	Simulation start date	FASDEPREC
FASTYPDET	Holding Type	FASASSETS
FASTYPDETP	Property	FASASSETS
FIYEND	Fiscal year end date	FASASSETS
FIYENDN	Fiscal year N end date	FASDEPREC
FIYENDN-1	Fiscal year N-1 end date	FASDEPREC
FIYENDN-2	N-2 Fiscal year end date	FASDEPREC
FIYSTR	Fiscal year start date	FASDEPREC
PEREND	Period end date	FASDEPREC
PERENDN	Period N end date	FASDEPREC
PERENDN-1	Period N-1 end date	FASDEPREC
PERENDN-2	N-2 Period end date	FASDEPREC
PERSTR	Period start date	FASDEPREC
PLN	Depreciation plan	FASDEPREC
SITUEXE	Financial year situation	FASDEPREC
STAFIY	Financial year status	FASDEPREC

Sub-classes list (Indicators)

Sub-classes 

• Financial help
• Exceptional depreciations
• Asset - Insurances
• Asset - Free amounts
• Asset - Social/IFRS amounts
• Asset - Asset disposal
• Asset - Local taxes
• Asset - VAT
• Intra-group sales
• Expenditure
• Expense - Free amounts
• Expense - Subsidies
• Write-off
• Book vs tax
• Fiscal deferred
• Depreciation charges
• Plan variances
• Physical elements - Free amounts
• Fixed Assets
• Revaluations
• Fiscal reintegration