Home » Categories » Solutions by Business Process » Finance » Currency

Currency Rates File

Datafile Software

Currency Rates File

No Item Name Type Description

1 CODE X (8) Prime Index. Holds a combined code of the currency code and the period for which it applies.

2 01-RATE M Daily Spot Rate for the 1stof a month

3 02-RATE M Daily Spot Rate for the 2ndof a month

4 03-RATE M

5 04-RATE M

6 05-RATE M

7 06-RATE M

8 07-RATE M

9 08-RATE M

10 09-RATE M

11 10-RATE M

12 11-RATE M

13 12-RATE M

14 13-RATE M

15 14-RATE M

16 15-RATE M

17 16-RATE M

18 17-RATE M

19 18-RATE M

20 19-RATE M

21 20-RATE M

22 21-RATE M

23 22-RATE M

24 23-RATE M

25 24-RATE M

26 25-RATE M

27 26-RATE M

28 27-RATE M

29 28-RATE M

30 29-RATE M

31 30-RATE M

32 31-RATE M

33 P01-RATE M Holding rate for 1stperiod of the year

34 P02-RATE M Holding rate for 2ndperiod of the year

35 P03-RATE M

36 P04-RATE M

37 P05-RATE M

38 P06-RATE M

39 P07-RATE M

40 P08-RATE M

41 P09-RATE M

42 P10-RATE M

43 P11-RATE M

44 P12-RATE M

45 P13-RATE M

46 SPOT-RATE M

49 SPOT-P01 M Spot rate for 1stperiod of the year

50 SPOT-P02 M Spot rate for 2ndperiod of the year

51 SPOT-P03 M

52 SPOT-P04 M

53 SPOT-P05 M

54 SPOT-P06 M

55 SPOT-P07 M

56 SPOT-P08 M

57 SPOT-P09 M

58 SPOT-P10 M

59 SPOT-P11 M

60 SPOT-P12 M

61 SPOT-P13 M

NB: If adding your own items they should be from item 101 onwards.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Database Structures
Viewed 828 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger Revaluations - Revalue a Nominal Account
Viewed 924 times since Tue, Jun 26, 2012
Application Differences - Sales & Purchase Ledger Revaluations - Spot Rate Revaluation
Viewed 1236 times since Tue, Jun 26, 2012
Converting Existing Ledgers - Stock Control - Menu Design
Viewed 905 times since Tue, Jun 26, 2012
Nominal Ledger Revaluations
Viewed 985 times since Tue, Jun 26, 2012
Converting Exisiting Ledgers - Order Processing - Screen Design and Documents
Viewed 889 times since Tue, Jun 26, 2012
Invoicer, SOP and POP Applications
Viewed 970 times since Tue, Jun 26, 2012
Application Differences - Nominal Ledger - Year-End Procedures
Viewed 924 times since Tue, Jun 26, 2012
Currency Codes
Viewed 948 times since Tue, Jun 26, 2012
Converting Exisiting Ledgers - Order Processing - Database Profiles
Viewed 950 times since Tue, Jun 26, 2012