8 Foreign Country/Currency Exchange Mapping
Use this section to update Foreign Country/Currency Exchange Mapping .
Exchange Flag Derivation in CTR
Users must enter data in the N_TRANSACTION_AMT_ACTIVITY and V_ACTIVITY_CURRENCY columns of the STG_FRONT_OFFICE_TXN_PARTY table within the staging layer.
After ingestion, this information is transferred to the business table into the N_TRXN_ACTIVITY_AM and V_TRXN_ACTIVITY_CCY_CD columns of FCC_TRXN_PARTY.
CTR processes this business data and retrieves the country value from the FCC_RR_MAP_CNTRY_CCY table. Based on this, the CTR will determine and populate the Foreign In-country and Foreign Out-of-country values.
If a transaction has ACTIVITY_CURRENCY_CD ≠ USD, then:
- The foreign amount and country will be populated.
- The Debit/Credit code will be marked as Exchange in CTR.
- For CREDIT transactions, the FOREIGN_IN columns will be populated.
- For DEBIT transactions, the FOREIGN_OUT columns will be populated.
Table 8-1 Business Table and Columns Mapping
| Details | Existing business table and columns mapping | New business table and columns mapping |
|---|---|---|
| Table Name | FCC_TRXN | FCC_TRXN_PARTY |
| Column | N_TRXN_AMT | N_TRXN_ACTIVITY_AM |
| Column | V_TRXN_CCY_CD | V_TRXN_ACTIVITY_CCY_CD |
Table 8-2 Staging Table and Columns Mapping
| Details | Existing Staging table and columns mapping | New Staging table and columns mapping |
|---|---|---|
| Table Name | STG_TXN_ALT_CCY_VALUES | stg_front_office_txn_party |
| Column | N_TXN_AMOUNT_RCY | N_TRANSACTION_AMT_ACTIVITY |
| Column | V_RCY_CODE | V_ACTIVITY_CURRENCY |