System Parameters File

The dimension file for RA_SRC_CURR_PARAM_G.dat is not used as part of your history load process directly, but instead provides an important piece of information to the platform for operational activities. This file must contain the current business date associated with the files in the ZIP package. The file should be included with the nightly ZIP upload that contains your foundation data, such as RI_RMS_DATA.zip or RAP_DATA.zip. You may use a CTX file to change the column delimiter used in the file, but you should retain the other format characteristics exactly as shown below (for example, the date format must be YYYYMMDD and it does not need a header row).

The file has only two generic columns, PARAM_NAME and PARAM_VALUE. When data is sourced from RMFCS, it will be automatically generated and sent to RAP in the nightly batch. If your data does not come from RMFCS, then you need to include the file manually. Currently, only two rows will be used, but future releases may look for additional parameters in the file.

For non-MFCS customers, the file should contain at least the following rows:

VDATE|20220101
PRIME_CURRENCY_CODE|USD

For anyone that will be using MFCS now or at any time in the future, you instead should provide the full set of parameters that MFCS would eventually be generating for you, like so:

PRIME_CURRENCY_CODE|USD
CONSOLIDATION_CODE|C
VAT_IND|Y
STKLDGR_VAT_INCL_RETL_IND|Y
MULTI_CURRENCY_IND|Y
CLASS_LEVEL_VAT_IND|Y
DOMAIN_LEVEL|D
CALENDAR_454_IND|4
VDATE|20230506
NEXT_VDATE|20230507
LAST_EOM_DATE|20240131
CURR_BOM_DATE|20240201
MAX_BACKPOST_DAYS|10
PRIME_EXCHNG_RATE|1
PRIMARY_LANG|EN
DEFAULT_TAX_TYPE|GTAX
INVOICE_LAST_POST_DATE|20170101

The parameter value with VDATE is the current business date that all your other files were generated for in YYYYMMDD format. The date should match the values on your fact data, such as the DAY_DT columns in sales, inventory, and so on. This format is not configurable and should be provided as shown. The parameter value with PRIME_CURRENCY_CODE is used by the system to set default currencies on fact files when you do not provide them yourself or if there are null currency codes on a row.

Assuming you will be using RDE jobs to extract data from MFCS later on, the other parameters can be provided as shown above or with any other values. The first time you run the RDE job ETLREFRESHGENSDE_JOB, it will extract all the parameter values from MFCS and directly update the RA_SRC_CURR_PARAM_G table records. The update from MFCS assumes that RA_SRC_CURR_PARAM_G already has rows for all of the above parameters, which is why it is important to initialize the data as shown if you are loading data from flat files.