Company:	Link Technologies
Case No:	L12455
Logged By:	Sanjay (Link Technologies) on 19 Jul 2012 07:43PM
Priority:	Not Applicable
Product:	Other
Group:	To be assigned
Time Taken:	0.00
Assigned To:	Sanjay (Link Technologies)
Circulation:	Sanjay
Resolve By:	Thursday, 19 July 2012 07:43 PM [4292 days since logged date]
Status:	Closed

Subject:

SQL Script to extract Epicor Multi Currency information from Epicor Company Database

Summary:

The script below will display the multi-currency values entered into the company database:

select Convert(varchar(12),DATEADD(dd,( Date_valid_from -(SIGN( Date_valid_from )*693596)),'19000101'), 102) as 'DateFrom'
,Convert(varchar(12),DATEADD(dd,( Date_valid_to -(SIGN( Date_valid_to )*693596)),'19000101'), 102) as 'DateTo'
,from_currency, to_currency, rate_type, buy_rate, valid_for_days
from mccu3_vw
Order by 1 desc

Results below:

Audit Notes:

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12455 in the subject line of all emails regarding this issue.

Document size: 0.9 KB
For call complaints, please contact the Managing Director of the company using this form.