Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

============================================================

Table of Contents

============================================================

SAFIR OVERVIEW


  • Universe: GL_SAFIR.unx

SAFIR : Spring Actual Forecast Integrated Reporting (Spring = Budget; Actual = Realized)

Regarding the forecast data, the universe SAFIR is focus on the Finances, Sales, and Manufacture data in future, this function is orientate by GBUImage Removed 

...

Since 2018, for PEPOL only, forecast also sent from DYNASYS (source code ZD30)


Image Added

  • Available objects in BI4

GBR master data, Structure data:
Unique Ship to: Material: Structure Data

...

BFR(CASH REVIEW) Finance function, For short term forecast, usually data will be entered quarter by quarter
Fields: BFR Qty, BFR Sales, BFR CM,

Road Map Finance and Sale function, For long term(5 year) forecast. 
Fields : Forecast Qty, Forecast Sales, Forecast CM 

SMART CRM function, data come from SMART-Forecast module
Fields: Smart Qty, Smart Sales

...

Fields: APO Sales Qty, APO statistical Qty, APO Budget Qty, APO DP Qty, APO DPC QtyData structure and interface,
Image Removed


DATA STRUCTURE & INTERFACES
Image Added


QUIKLOAD

  • Budget Data

==> is upload by QuikLoad(TMP_GL_FORECAST_BUDGET), the format as below:

...

BFR data* is upload by QuikLoad(TMP_GL_FORECAST_BFR), the format as below:  

Road Map Map is upload by Quikload(TMP_GL_FORECAST_RM)

 

SMART data* is come from SMART system, data flat file will have following format:

...

N_QTE_FCST_SALES

N_QTE_FCST_STAT

N_QTE_FCST_SPRING

N_QTE_FCST_DP

N_QTE_FCST_DPC

Sales QTY

Statistical Qty

Budget Qty

DP Qty

DPC Qty

 

EXCHANGE RATE

BFC will send 2 exchange rate to SAFIR which will save in table TTX_CARAT, For Prompt Currency objects 
  1, Budget exchange rate
  2, BFR exchange rate, It also user for Smart, Road Map

 

SAFIR EXPLOITATION

SAFIR Exploitation: When the user upload the Budget, BFR data via QuikLoad, data file will be saved into BOXI server immediately, and wait for next SAFIR exploitation.
When APO generated the SAFIR data, system will send a message to BOXI, BOXI will start the SAFIR Exploitation.
BOXI will go to APO and SMART get the data file, and upload Budget, BFR, SMART & APO data into SAFIR
Usual SAFIR Exploitation start around 10:00AM SG time.

...

APO,
Most of Enterprises are maintaining the forecast with APO:
The usage of SAFIR


BI4 CORE REPORTS

In Enterprise BOXI Core Report In QV

...