3. Installation › 3.3 Define Database Complex › 3.3.5 Define Currency Type Format and Informat

Previous Topic: 3.3.4 Move CA MICS FSP Screens and Tables Files

Next Topic: 3.3.6 Set Up the CA MICS ISPF Environment

3.3.5 Define Currency Type Format and Informat


CA MICS provides a MONEY format for writing monetary values
in output reports.  All data elements, such as the xxxCOST
fields, defined in the CA MICS database have their SAS
FORMAT defined as MONEY.  The standard format displayed by
the MONEY format is a display in U.S. dollars.
 
If you want to have the monetary values in your database
formatted in a currency notation other than U.S. dollars,
update 'sharedprefix.MICS.SOURCE(MONEY)'.  The changes that
are made take effect when BASPGEN or ALLPGEN is executed.
 
If you update the MONEY member, you should refer to
'sharedprefix.MICS.SOURCE(MONEYSMP)' for sample SAS formats.
This member contains the same format as MONEY and also
contains a format example which can be easily adapted to
represent various European currency notations.  You should
NOT modify the MONEYSMP member as it is designed to receive
maintenance from CA and must therefore be considered static.
 
SINGLE CURRENCY DISPLAY MODE
 
In addition to the MONEY format, the MONEY member also
contains the MONEYR format, used to print rates in the
Accounting Component.  The MONEYB format, used to print
budget amounts for certain invoice formats in the Accounting
Component, is found in sharedprefix.MICS.SOURCE(MONEYB).  The
three formats differ as follows:
 
  MONEY    Used to display charges and certain other monetary
           amounts.  Displays two decimal places.
 
  MONEYB   Used to print budget amounts for certain invoice
           formats.  Displays no decimal places.
 
  MONEYR   Used to print rates.  Displays four decimal places
           and does not support negative values.
 
  Note:  As delivered, each of these formats prints in US
         dollars.  If you alter the MONEY format, you should
         alter MONEYR and MONEYB so that they reflect the
         same notation used for MONEY.
 
DUAL CURRENCY DISPLAY MODE
 
CA MICS provides euro and dual currency support in the
CA MICS Accounting and Chargeback component.  To learn more
about activating euro support and about using the euro MONEYE
formats, see Appendix C of the CA MICS Accounting and
Chargeback User Guide.