Entity ExchangeRateProg

Description of Entity ExchangeRateProg

Keeps track of foreign exchange rates used in wage computation.


List of all Dependencies of the Entity ExchangeRateProg

Name

Code

Class Name

Relation_333312

Relation_333312

Reference


List of Attributes of the Entity ExchangeRateProg

Name

Code

ExChgRateProgSysId

ExChgRateProgSysId

Effective Date

ExChgRateEffectiveDate

Foreign > Local

ForeignLocalRate

Local > Foreign

LocalForeignRate


Entity Attribute ExChgRateProgSysId of the Entity ExchangeRateProg

Card of Attribute ExChgRateProgSysId of the Entity ExchangeRateProg

Name

ExChgRateProgSysId

Code

ExChgRateProgSysId

Data Type

integer

Mandatory

Yes


Description of Attribute ExChgRateProgSysId of the Entity ExchangeRateProg

A system generated identity. It is blind to the user. It acts as a primary key for the ExchangeRateProg table.


Entity Attribute Effective Date of the Entity ExchangeRateProg

Card of Attribute Effective Date of the Entity ExchangeRateProg

Name

Effective Date

Code

ExChgRateEffectiveDate

Data Type

date

Mandatory

No


Description of Attribute Effective Date of the Entity ExchangeRateProg

Shows the effective date of the exchange rate. It can mean which day the exchange rate was recorded because the rate changes everyday.
The date is usually in the format: DD-MM-YYYY.
If no matching exchange rate is found, then an error results and quite likely the amounts will be either set to zero or will not be generated at all. This may seem vague but the exchange rate ID itself is only a reference point and can be used by many different type of processes. These may or may not be payroll processes.


Entity Attribute Foreign > Local of the Entity ExchangeRateProg

Card of Attribute Foreign > Local of the Entity ExchangeRateProg

Name

Foreign > Local

Code

ForeignLocalRate

Data Type

double

Mandatory

No


Description of Attribute Foreign > Local of the Entity ExchangeRateProg

Shows the foreign and local rates from a foreign country. It refers to the country on the General tab.


Entity Attribute Local > Foreign of the Entity ExchangeRateProg

Card of Attribute Local > Foreign of the Entity ExchangeRateProg

Name

Local > Foreign

Code

LocalForeignRate

Data Type

double

Mandatory

No


Description of Attribute Local > Foreign of the Entity ExchangeRateProg

Shows the foreign and local rate of other countries locally.