| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_PDEXR | Exchange Rates | 8 | EXCH_RATE | Exchange Rate | decimal | 28 | 14 | | |
2 | EPIC_EBR_HDR | OBSOLETE!!! | 10 | EXCH_RATE | Exchange Rate on Bank Receipt | decimal | 9 | 5 | | |
3 | FIKZD_REGINV_IN | Incoming Invoice Registration Journal | 35 | EXCH_RATE | Exchange rate for FI postings | decimal | 9 | 5 | | |
4 | FIKZD_REGINV_OUT | Outgoing Invoice Registration Journal | 34 | EXCH_RATE | Exchange rate for FI postings | decimal | 9 | 5 | | |
TOPBasis Components |
5 | /XFT/INV_Q | Invoice receipt queue: Header | 63 | EXCH_RATE | Direct Quoted Exchange Rate | decimal | 9 | 5 | | |
6 | /XFT/INV_Q_S | Invoice receipt queue: Header | 63 | EXCH_RATE | Direct Quoted Exchange Rate | decimal | 9 | 5 | | |
TOPGL Account Posting |
7 | TCJ_DOCUMENTS | Cash Journal Documents (Header Data) | 32 | EXCH_RATE | Exchange rate | decimal | 9 | 5 | | |
TOPTravel Expenses |
8 | PTRV_COMM_AMT | Detail Data: Transfer to FM When Trip Saved | 20 | EXCH_RATE | Exchange rate | decimal | 9 | 5 | | |