---

Transaction

This report gives a complete listing of all transactions for a User for the review and approval of expenditure.

The report requires the following parameters:

Parameters

· Programmes · Account Types · Admin Ctrs. · Status · Transaction Groups · Date Type · From Date · To Date · Display Currency · Sort By · Output Format · When

Tips:

· Use the From Date and To Date parameters for ad-hoc reporting (not suitable for auditable statement submission).

· Delete Programmes by selecting them and clicking the Delete selected Programme icon.

· Delete Account Types by selecting them and clicking the Delete selected Account Type icon.

· Delete Admin Ctrs. by selecting them and clicking the Delete selected Admin Ctrs. icon.

· Delete Status by selecting them and clicking the Delete selected Status icon.

· Delete Transaction Groups by selecting them and clicking the Delete selected Expense Groups icon.

The report generates the following fields:

Fields

· Programme ID · Description · Card Type · Reference Number · Purchase Date · Merchant Name · User Name · Employee ID · Unit ID · GL Code · Tax Code · Tax Receipt · Tax Evidence · Home Currency Type · Transaction Tax Amount · Original Currency Amount · Original Currency Country · Original Currency Code

· Status · Account Reference Number · GL Line Number · Created By · Commit Description · Base Currency Type · Base Currency Rate · Report Currency Type · Report Currency Rate · Original Amount · Report Currency Amount · Original Net Amount · Report Currency Net Amount · Original Tax Amount · Report Currency Tax Amount · Original Gross Amount · Report Currency Gross Amount

Notes:

· Programme ID - Programme ID as stored in the warehouse database.

· Programme Description - Programme description as stored in the warehouse database.

· Card Type - Account type.

· Reference Number - Transaction reference number.

· Purchase Date - Transaction date.

· User Name - Account Holder's user name.

· Employee ID - Account Holder's employee ID.

· Unit ID - Admin Centre of Account Holder.

· GL Code - Line GL assignment.

· Tax Evidence - Tax evidence flag.

· Programme Currency Type - Home currency type of programme.

· Transaction Tax Amount - Tax amount for credit card transaction.

· Original Currency Amount - Foreign transaction amount.

· Original Currency Country - Country code for foreign transaction.

· Original Currency Code - Currency code for foreign transaction.

· Status - Transaction status.

· Created By - User name of user that created line item.

· Commit Description - Expense description for linked transactions.

· Base Currency Type - Standard currency type.

· Base Currency Rate - Standard rate as of transaction date.

· Report Currency Type - Requested currency type for report.

· Report Currency Rate - Currency rate of the requested currency type as of transaction date.

· Tran Amount Local - Transaction amount in local currency.

· Tran Amount Converted - Transaction amount in requested currency.

· Net Amount Local - Line net amount in local currency.

· Net Amount Converted - Line net amount in requested currency.

· Tax Amount Local - Line tax amount in local currency.

· Tax Amount Converted - Line tax amount in requested currency.

· Gross Amount Local - Line gross amount in local currency.

· Gross Amount Converted - Line gross amount in requested currency.

Inlogik Pty Limited