Exchange Rate

Exchange Rate

Table Name erate_eratetype_his

Table Comment Gives the history details of the exchange rate types defined
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
exchrate_type	varchar(10)	NOT NULL	Exchange Rate Type	Yes	No
serial_no	int	NOT NULL	Serial Number	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
description	varchar(100)	NULL	Description	No	No
status	varchar(25)	NULL	Status.Values A-Active,I-Inactive	No	No
effective_from	datetime	NULL	Effective From	No	No
effective_to	datetime	NULL	Effective To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name erate_eratetype_mst

Table Comment Gives the exchange rate types
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
exchrate_type	varchar(10)	NOT NULL	Exchange Rate Type	Yes	No
serial_no	int	NOT NULL	Serial Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
description	varchar(100)	NULL	Description	No	No
status	varchar(2)	NULL	Status.Values A-Active,I-Inactive	No	No
effective_from	datetime	NULL	Effective From	No	No
effective_to	datetime	NULL	Effective To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name erate_exrate_his

Table Comment Gives the history of the exchange rates
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
start_date	datetime	NOT NULL	Start Date	Yes	No
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
exchrate_type	varchar(10)	NOT NULL	Exchange Rate Type	Yes	No
from_currency	varchar(5)	NOT NULL	From Currency	Yes	No
to_currency	varchar(5)	NOT NULL	To Currency	Yes	No
inverse_typeno	varchar(1)	NOT NULL	Inverse Type Number	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
end_date	datetime	NULL	End Date	No	No
exchange_rate	numeric(15,5)	NULL	Exchange Rate	No	No
tolerance_flag	varchar(1)	NULL	Tolerance Flag	No	No
tolerance_limit	numeric(28,8)	NULL	Tolerance Limit	No	No
serial_no	int	NULL	Serial Number	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name erate_exrate_mst

Table Comment Gives the exchange rate details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
exchrate_type	varchar(10)	NOT NULL	Exchange Rate Type	Yes	No
from_currency	varchar(5)	NOT NULL	From Currency	Yes	No
to_currency	varchar(5)	NOT NULL	To Currency	Yes	No
inverse_typeno	varchar(1)	NOT NULL	Inverse Type Number	Yes	No
start_date	datetime	NOT NULL	Start Date	Yes	No
timestamp	int	NULL	Time Stamp	No	No
serial_no	int	NULL	Serial Number	No	No
end_date	datetime	NULL	End Date	No	No
exchange_rate	numeric(15,5)	NULL	Exchange Rate	No	No
tolerance_flag	varchar(1)	NULL	Tolerance Flag	No	No
tolerance_limit	numeric(28,8)	NULL	Tolerance Limit	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name erate_yrprdendrate_mst

Table Comment Gives the financial year/period - exchange rate mapping
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
exchrate_type	varchar(10)	NOT NULL	Exchange Rate Type	Yes	No
from_currency	varchar(5)	NOT NULL	From Currency	Yes	No
to_currency	varchar(5)	NOT NULL	To Currency	Yes	No
inverse_typeno	varchar(1)	NOT NULL	Inverse Type Number	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
timestamp	int	NULL	Time Stamp	No	No
exchange_rate	numeric(15,5)	NULL	Exchange Rate	No	No
start_date	datetime	NULL	Start Date	No	No
tolerance_flag	varchar(1)	NULL	Tolerance Flag	No	No
tolerance_limit	numeric(28,8)	NULL	Tolerance Limit	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No