FX Rate Stage inbound staging table

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.

    The following table lists fields for the FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table.
    Table 1. FX Rate Stage inbound staging table
    Field Data type Description
    Conversion date String Date of currency conversion.
    ERP source String ERP source from which data is imported. For purchase order, receipt, and invoice integrations, the ERP source is determined through the legal entity associated with these records.

    This is a mandatory field.
    Exchange rate Floating point number Rate of exchange for currency conversion.

    This is a mandatory field.
    From currency String Currency that is imported from.

    This is a mandatory field.
    Rate type String Specifies the type of exchange rate used for currency conversion.
    Span end String End date for the FX rate schedule.
    Span start String Start date for the FX rate schedule.
    To currency String Currency that is imported to.

    This is a mandatory field.