Fact tables Fixed Assets - Funds

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 2 rules for the Fixed assets fact table:

• FLUXEXE: Depreciation funds with the FXDLIFL table for source (funds tracking)
• FLUXPER: Period Depreciation funds with the FXDLIFL table for source (funds tracking)

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, etc.
Some dimensions are part of the Fixed assets module and others are common to all the modules (Company, Site, 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 Fixed assets - Funds fact table is given 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 - Funds is provided below.

Technical additions

List of dimensions

Common dimensions

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

Dimensions of the Fixed assets module

• Funds - accounting codes - FLUXACC
  Source table: GACCCODE
  Update type: Incremental
   
• Funds - Legal company - FLUXCPY
  Source table: COMPANY
  Update type: Incremental
   
• Funds - Folder - FLUXDOSS
  Source table: ADOSSIER
  Update type: Cancels and replaces
   
• Funds - Asset - FLUXFAS
  Source table: FXDASSETS
  Update type: Incremental
   
• Funds - Financial site - FLUXFCY
  Source table: FACILITY
  Update type: Incremental
   
• Funds - Orig financial site - FLUXFCYORI
  Source table: FACILITY
  Update type: Incremental
   
• Funds - Accounts - FLUXGAC
  Source table: GACCOUNT
  Update type: Incremental
   
• Funds - Fiscal stmt item - FLUXPAR
  Source table: PARFLUXDET
  Update type: Cancels and replaces
   
• Flux - Orig fiscal stmt line - FLUXPARORI
  Source table: PARFLUXDET
  Update type: Cancels and replaces
    

List of the predefined conditions

Code	Title	Dimension
FLUXCOA	Chart of accounts
FLUXCPYBEG	Company Start	FLUXCPY
FLUXCPYEND	Company End	FLUXCPY
FLUXEXE	Financial year situation
FLUXEXER	Financial year situation	FLUXFAS
FLUXFCYBEG	Financial site Start	FLUXFCY
FLUXFCYEND	Financial site Year	FLUXFCY
FLUXFIYBEG	Fiscal year start date
FLUXFIYEND	Fiscal year end date
FLUXGACBEG	From accounting account	FLUXGAC
FLUXGACEND	To accounting account	FLUXGAC
FLUXPER	Fiscal year
FLUXPERBEG	Period start date
FLUXPEREND	Period end date
FLUXPLN	Depreciation plan
FLUXSTA	Funds status
FLUXTYP	Funds type

List of sub-classes

Sub-classes 

• Depreciations
• Depreciation context
• Book vs tax
• Funds flag
• Fixed Assets
• Chart of accounts
• Revaluations
• Issues