Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
RateType | FromCurr | ToCurr | DateFrom | ExchRate |
---|---|---|---|---|
P | EUR | USD | 20120701 | 1.3234 |
M | EUR | USD | 20120101 | 1.2442 |
CompanyCode | FiscPer | ProdHierLev1 | DocCurr | NetRevenue |
---|---|---|---|---|
0500 | 001.2012 | PYT | EUR | 100 |
0500 | 001.2012 | PYT | GBP | 200 |
I fixed this myself. I joined the billing facts table to the exchange rate table on DOC_CURRCY. For P rate conversions only the latest P rate is used regardless of time so I just needed to find the latest P rate for the DOC_CURRCY and the TO_CURRCY.