Examples
This table shows which fact tables will have data erased, according to the selected currency and options.
Scenarios that result in no data being erased are not presented in the table. For example, local, year-to-date intercompany data.
Currency | Data Type Option | Accumulation Method Option | Data Option | Fact *_BASE Tables Affected |
---|---|---|---|---|
Local | Financial | Periodic and Year-to-Date | Adjusted and Unadjusted | FinLoc FinLocAdj FinLocAud FinLocNet FinPer FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Local | Financial | Periodic and Year-to-Date | Adjusted | FinLocAdj FinLocAud FinLocNet FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Local | Financial | Year-to-Date | Adjusted and Unadjusted | FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Local | Financial | Year-to-Date | Adjusted | FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Local | Intercompany | Periodic and Year-to-Date | Adjusted and Unadjusted | ICRepPer ICTransPer ICAdjustment ICAdjTrans |
Local | Intercompany | Periodic and Year-to-Date | Adjusted | ICTransPer ICAdjustment ICAdjTrans |
Translated | Financial | Periodic and Year-to-Date | Adjusted and Unadjusted | FinPer FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Translated | Financial | Periodic and Year-to-Date | Adjusted | FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Translated | Financial | Year-to-Date | Adjusted and Unadjusted | FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Translated | Financial | Year-to-Date | Adjusted | FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet |
Translated | Intercompany | Periodic and Year-to-Date | Adjusted and Unadjusted | ICTransPer ICAdjustment ICAdjTrans |
Translated | Intercompany | Periodic and Year-to-Date | Adjusted | ICTransPer ICAdjustment ICAdjTrans |