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.