FX conversion rate staging table
The FX conversion rate staging primary data lists the columns in the staging table.
Table | Column name | Column label |
sn_sap_data_int_fx_rate_stg | client | Client |
sn_sap_data_int_fx_rate_stg | effective_date | Date as of which the exchange rate is effective |
sn_sap_data_int_fx_rate_stg | erp_source | Erp source |
sn_sap_data_int_fx_rate_stg | exchange_rate | Exchange rate |
sn_sap_data_int_fx_rate_stg | exchange_rate_type | Exchange rate type |
sn_sap_data_int_fx_rate_stg | from_currency | From currency |
sn_sap_data_int_fx_rate_stg | from_ratio | Ratio for the from currency units |
sn_sap_data_int_fx_rate_stg | to_currency | To currency |
sn_sap_data_int_fx_rate_stg | to_ratio | Ratio for the to-currency units |