Share via

Finance Database

  • Article

Finance Database

The SQL Server 2000 Finance database is the primary storage device for data that is used in the Expense Report solution. Specifically, the Finance database stores three key pieces of information:

  • Expense Report form data. The data entered into the form is stored in and retrieved from the expense, expense_item, and expense_status tables.

  • Credit card charges. The Expense Report form allows for the import of the originator's credit card charges, which are stored in the CreditCardCharges table.

  • Exchange rate information. Daily exchange rates for foreign transactions are identified in the Expense Report form through the ExchangeRateWS Web service, which pulls data from the MonetaryExchangeRate table.

For more information about the schema and related tables, refer to the discussion of the Finance database in the Code Review section below.

 

© 2005 Microsoft Corporation. All rights reserved.