Currency

Used as the core source for loading the Currency dimension.  It contains a list of all currency types associated to each of the offices as specified in the Office load file. If the firm does not deal in multiple currencies, this information may be specified as null, or assigned a default currency of USD.  For firms with foreign offices, the currency is associated with the office, which drives the currency conversion calculations of the Planning Application.

Idx Field Type Maximum Length Required
1 Currency_Code Alphanumeric 3 Yes
2 Currency_Name Alphanumeric 50 Yes

 

Sample Currency Codes and Descriptions

EUR Euro
CAD Canadian Dollar
GBP British Pound
USD US Dollar
Summary

Currency

Used as the core source for loading the Currency dimension.

Columns

 

Currency_Code

Uniquely identifying three-digit code for the currency; standard currency codes are commonly used. Required.

Currency_Name

Standard description of the currency. Required.

Documentation

 

Sample CSV Load File

This load file is a small sample of Currency load.

 

Sample CSV Load File

This load file is a small sample of Currency load.

Filename: Currency.csv

EUR,Euro
CAD,Canadian Dollar
GBP,British Pound
USD,US Dollar

Columns

Currency_Code

Currency_Code varchar( 3 ) NOT NULL

Uniquely identifying three-digit code for the currency; standard currency codes are commonly used. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 3
Required Yes

Currency_Name

Currency_Name varchar( 50 ) NOT NULL

Standard description of the currency. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
Required Yes

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk