Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 60)

10-6

Data > General > Unit of Measure. This page is only available when you are logged in as

DBA.ADMIN. For more information on this topic refer to the help topic “Unit of Measure”.

Changing Currency Settings

By default, Oracle Transportation Management uses US Dollars when saving costs to the database.

Also by default, Oracle Transportation Management triangulates all currency conversions through US

Dollars.

This example illustrates how Oracle Transportation Management stores a shipment cost record with

the currency storage default set to two different currencies:

Total actual cost of shipment is 1000 JPY. If Oracle Transportation Management’s currency storage

default is USD (current default in all Oracle Transportation Management installations), Oracle

Transportation Management stores this cost as follows:

Total_actual-cost

Total-actual-cost_currency_GID

Total_Actual_cost_base

1000

JPY

7.76

If instead Oracle Transportation Management’s currency storage default is GBP:

Total_actual-cost

Total-actual-cost_currency_GID

Total_Actual_cost_base

1000

JPY

5.31

In the first instance, the rate of 7.76 represents the USD value of 1000 JPY converted at the current

rate in Oracle Transportation Management (128.77) while in the second instance, the rate of 5.31

represents the GBP value of 1000 JPY converted at the current JPY/GBP rate in the system (188.08).

When to Change Currency Storage Default

There are two scenarios where you would like to change your currency storage default: either you only

use one currency other than USD or you use multiple currencies but not USD.

Rates in One Single Currency

In this case, you only need to set your currency storage default to the currency you use. For example,

Oracle Transportation Management stores a 100 GBP shipment cost as 100 in both the total cost and

the total cost base fields so no currency conversion is needed.

1. Run the following insert statement (example using GBP as new storage default) as the DBA

user:

INSERT INTO UOM (TYPE, UOM_CODE, UOM_SHORT_DESCRIPTION,

UOM_LONG_DESCRIPTION, UOM_RANK, IS_STORAGE_DEFAULT,

IS_DISPLAY_DEFAULT, DOMAIN_NAME) VALUES (‘CURRENCY’, ‘GBP’, ‘UK

POUND’, ‘UK POUND’, 1, ‘Y’, ‘Y’, ‘DBA’)

Rates in Several Currencies

In this case, you need to:

1. Decide what the currency storage default is for your Oracle Transportation Management

installation.

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 105 106

Kommentare zu diesen Handbüchern

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 60

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Axis RightFax 8.5