FX Rate Stage inbound staging table
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.
| 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. |