SELECT DISTINCT CM.Code AS CID, CM.Name AS CNAME, CM.Sort AS CCAT1, CM.Territory AS CCAT4, CM.Cat as CCAT2, CM.SalesRep as CCAT3, CM.Contact as CContact, CM.Phone as CPhone1 FROM ADMIN.CUSTOMER_MASTER CM
SELECT DISTINCT PM.Code AS CID, PM.Description AS CNAME, PM.SalesPrice1 AS NUNITPRICE, PM.UnitCost AS NUNITCOST, PM.ProductGroup AS PCAT1, PM.Supplier1 AS PCAT2 FROM ADMIN.PRODUCT_MASTER PM
SELECT trade.account2 as CCUSTID, trade.invdate as DTRANDATE, trade.salescode as CSMANID, trade.qtyinv * -1 AS NUNITS, trade.amtext * -1 as NVALUE, (trade.qtyinv * trade.amtucost * -1) as NCOST, trade.accountid as CPRODID FROM trade trade WHERE left(trade.accountid, 1) = 'I' AND(trade.itsaquote = 0) AND(trade.ledgerno <> 0) AND(trade.ledger2 = 3)
SELECT C.UniqueID as customerid, CT.OutlookID as Contactid, CT.FullName, CT.BusinessPhone as Phone1, CT.MobilePhone as Phone2, CT.Email as Email1, CT.JobTitle, CT.Email2, CT.FirstName, CT.LastName as Surname, CT.Street1 as Address1, CT.Street2 as Address2, CT.Suburb, CT.StateCounty as Suburb, CT.Postcode, CT.Country FROM CONTACTS CT, CUSTOMERS C WHERE CT.AccountID = C.UniqueID
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add email@example.com to your trusted senders list in your email software.