Fact tables

Fact table	Description
FINLOC_BASE	Periodic, local, untranslated reported (unadjusted) data specified via data entry or loaded via Data Loader
FINLOCADJ_BASE	Periodic, local, untranslated adjustment data produced by the Consolidation process
FINLOCAUD_BASE	Periodic, local, untranslated adjustment detail data produced by the Consolidation process
FINLOCNET_BASE	Periodic, local, untranslated net-adjusted data produced by the Consolidation process
FINPER_BASE	Periodic, translated, unadjusted data produced by the Consolidation process
FINPERADJ_BASE	Periodic, translated adjustment data produced by the Consolidation process
FINPERAUD_BASE	Periodic, translated adjustment detail data produced by the Consolidation process
FINPERAUDSOURCE_BASE	Periodic, translated adjustment detail data produced by the Consolidation process and that is the source data for Ownership journals
FINPERNET_BASE	Periodic, translated net-adjusted data produced by the Consolidation process
FINPERSTDNET_BASE	Periodic, translated, net of Standard and Intercompany Eliminations journal data produced by the Consolidation process
FINYTD_BASE	Year-to-date, local, translated, and untranslated unadjusted data produced by the Consolidation process
FINYTDADJ_BASE	Year-to-date, local, translated, and untranslated adjustment data produced by the Consolidation process
FINYTDAUD_BASE	Year-to-date, local, translated, and untranslated adjustment detail data produced by the Consolidation process
FINYTDAUDSOURCE_BASE	Year-to-date, local, translated, and untranslated adjustment detail data produced by the Consolidation process and that is the source data for Ownership journals
FINYTDNET_BASE	Year-to-date, local, translated, and untranslated net-adjusted data produced by the Consolidation process
ICREPPER_BASE	Periodic, intercompany data specified via the Intercompany Data Entry page or loaded via Data Loader in a specified currency
ICTRANSPER_BASE	Periodic, intercompany data translated to a specified currency by the Prepare Intercompany Eliminations process
ICADJUSTMENT_BASE	Periodic, translated intercompany data created by the Prepare Intercompany Eliminations process that are posted by the Consolidation process to elimination units or ownership units
ICADJTRANS_BASE	Data to map between elimination or ownership unit data and affiliated unit intercompany transaction data
WS_DETAILS_BASE	Periodic, local, untranslated reported (unadjusted) data specified via Worksheet Detail data entry or loaded via Data Loader.
WS_WORKSHEETS	Periodic, local, untranslated reported (unadjusted) data specified via Worksheet Detail data entry or loaded via Data Loader.

FINLOC_BASE

Periodic, local, untranslated reported (unadjusted) data specified via data entry or loaded via Data Loader

FINLOCADJ_BASE

Periodic, local, untranslated adjustment data produced by the Consolidation process

FINLOCAUD_BASE

Periodic, local, untranslated adjustment detail data produced by the Consolidation process

FINLOCNET_BASE

Periodic, local, untranslated net-adjusted data produced by the Consolidation process

FINPER_BASE

Periodic, translated, unadjusted data produced by the Consolidation process

FINPERADJ_BASE

Periodic, translated adjustment data produced by the Consolidation process

FINPERAUD_BASE

Periodic, translated adjustment detail data produced by the Consolidation process

FINPERAUDSOURCE_BASE

Periodic, translated adjustment detail data produced by the Consolidation process and that is the source data for Ownership journals

FINPERNET_BASE

Periodic, translated net-adjusted data produced by the Consolidation process

FINPERSTDNET_BASE

Periodic, translated, net of Standard and Intercompany Eliminations journal data produced by the Consolidation process

FINYTD_BASE

Year-to-date, local, translated, and untranslated unadjusted data produced by the Consolidation process

FINYTDADJ_BASE

Year-to-date, local, translated, and untranslated adjustment data produced by the Consolidation process

FINYTDAUD_BASE

Year-to-date, local, translated, and untranslated adjustment detail data produced by the Consolidation process

FINYTDAUDSOURCE_BASE

Year-to-date, local, translated, and untranslated adjustment detail data produced by the Consolidation process and that is the source data for Ownership journals

FINYTDNET_BASE

Year-to-date, local, translated, and untranslated net-adjusted data produced by the Consolidation process

ICREPPER_BASE

Periodic, intercompany data specified via the Intercompany Data Entry page or loaded via Data Loader in a specified currency

ICTRANSPER_BASE

Periodic, intercompany data translated to a specified currency by the Prepare Intercompany Eliminations process

ICADJUSTMENT_BASE

Periodic, translated intercompany data created by the Prepare Intercompany Eliminations process that are posted by the Consolidation process to elimination units or ownership units

ICADJTRANS_BASE

Data to map between elimination or ownership unit data and affiliated unit intercompany transaction data

WS_DETAILS_BASE

Periodic, local, untranslated reported (unadjusted) data specified via Worksheet Detail data entry or loaded via Data Loader.

WS_WORKSHEETS

Periodic, local, untranslated reported (unadjusted) data specified via Worksheet Detail data entry or loaded via Data Loader.