ejimenezbeltre
Technical User
Greetings
I need help with a query to the symphony DB.
I want to obtain the details of all the tickets issued on a specific day.
I have the following query, but I can't get the business date as I get it in micros 3700, any idea how to do it?
DB is CheckPosting
Select (SELECT TOP 1 vh.NameID As StoreID
FROM V_HIERARCHY vh
WHERE vh.HierStrucID = vh.PropHierStrucID) As StoreID, C.CheckID, C.RevCtrID, C.OrdTypeID, C.CheckNumber, C.EmployeeID, E.ObjectNumber As EmployeeIDExt
, E.FirstName + ' ' + E.LastName As NombreEmpleado, C.CashierID, C.CheckOpen, C.CheckClose
, C.WorkstationID, C.LastWorkstationID, C.LastEmployeeID
, C.ServingPeriodID
, C.SubTotal
, C.Tax
, C.AutoGratuity As ServiceCharge
, C.Payment, C.Due, C.MaxTotal, C.Deposit
, C.CheckPostingTime, C.CloseStatus
From CHECKS C
inner join EMPLOYEE E on E.EmployeeID = C.EmployeeID
Where convert(date,CheckOpen) = Convert(date,getdate()-1)
I need help with a query to the symphony DB.
I want to obtain the details of all the tickets issued on a specific day.
I have the following query, but I can't get the business date as I get it in micros 3700, any idea how to do it?
DB is CheckPosting
Select (SELECT TOP 1 vh.NameID As StoreID
FROM V_HIERARCHY vh
WHERE vh.HierStrucID = vh.PropHierStrucID) As StoreID, C.CheckID, C.RevCtrID, C.OrdTypeID, C.CheckNumber, C.EmployeeID, E.ObjectNumber As EmployeeIDExt
, E.FirstName + ' ' + E.LastName As NombreEmpleado, C.CashierID, C.CheckOpen, C.CheckClose
, C.WorkstationID, C.LastWorkstationID, C.LastEmployeeID
, C.ServingPeriodID
, C.SubTotal
, C.Tax
, C.AutoGratuity As ServiceCharge
, C.Payment, C.Due, C.MaxTotal, C.Deposit
, C.CheckPostingTime, C.CloseStatus
From CHECKS C
inner join EMPLOYEE E on E.EmployeeID = C.EmployeeID
Where convert(date,CheckOpen) = Convert(date,getdate()-1)
