Need to add Doctype as parameter Have anyone used it?

[vitusberny]

This below mentioned Query needs a Doctype parameter I was able to set DATE And Status but couldn't set Doctype as parameter, Kindly checkout and if yes kindly share the knowledge.

--/*SELECT FROM [dbo].[OINV] T0 INNER JOIN OUSR T1 ON T1.[USERID] = T0.[UserSign] */
--DECLARE @FromDate DATE
--DECLARE @ToDate DATE
--DECLARE @ UserCode NVARCHAR(10)

--/*WHERE*/
--SET @FromDate=/*Min(T0.DocDate)*/ '[%0]'
--SET @ToDate=/*Max(T0.DocDate)*/ '[%1]'
--SET @UserCode=/*Max(T1.U_Name)*/ '[%2]'
--SET @ObjType=/*(T0.ObjType)*/ '[%3]'

select
case
when zz.ObjType='23' then 'sales Quotation'
when ZZ.ObjType='13' then 'AR Invoice'
when ZZ.ObjType='17' then 'Sales Order'
when ZZ.ObjType='15' then 'Delivery'
When ZZ.ObjType='14' then 'AR Credit Note'
else '' end as 'Document Name'
,ZZ.DocDate,ZZ.[Document Number],Zz.[Customer Code],zz.[Customer Name],zz.[Document Value],ZZ.[Employee Name],ZZ.[User Code],zz.Status

from
(
Select
A.Objtype,A.DocDate'DocDate',A.DocNum'Document Number',A.CardCode'Customer Code',A.CardName'Customer Name',
A.DocTotal'Document Value',C.SlpName'Employee Name',A.UserSign'User Code',A.DocStatus'Status',T1.U_name
from OQUT A
Inner join QUT1 B on B.DocEntry=A.DocEntry
Inner Join OSLP C on C.SlpCode=A.SlpCode
INNER JOIN OUSR T1 ON T1.[USERID] = A.[UserSign]

union all
Select
A.Objtype,A.DocDate'DocDate',A.DocNum'Document Number',A.CardCode'Customer Code',A.CardName'Customer Name',
A.DocTotal'Document Value',C.SlpName'Employee Name',A.UserSign'User Code',A.DocStatus'Status',T1.U_name
from ORDR A
Inner join RDR1 B on B.docentry=A.DocEntry
Inner Join OSLP C on C.SlpCode=A.SlpCode
INNER JOIN OUSR T1 ON T1.[USERID] = A.[UserSign]

union all
Select
A.Objtype,A.DocDate'DocDate',A.DocNum'Document Number',A.CardCode'Customer Code',A.CardName'Customer Name',
A.DocTotal'Document Value',C.SlpName'Employee Name',A.UserSign'User Code',A.DocStatus'Status',T1.U_name
from ODLN A
Inner join DLN1 B on B.DocEntry=A.DocEntry
Inner Join OSLP C on C.SlpCode=A.SlpCode
INNER JOIN OUSR T1 ON T1.[USERID] = A.[UserSign]

union all
Select
A.Objtype,A.DocDate'DocDate',A.DocNum'Document Number',A.CardCode'Customer Code',A.CardName'Customer Name',
A.DocTotal'Document Value',C.SlpName'Employee Name',A.UserSign'User Code',A.DocStatus'Status',T1.U_name
from OINV A
Inner join INV1 B on B.DocEntry=A.DocEntry
Inner Join OSLP C on C.SlpCode=A.SlpCode
INNER JOIN OUSR T1 ON T1.[USERID] = A.[UserSign]

union all
Select
A.Objtype,A.DocDate'DocDate',A.DocNum'Document Number',A.CardCode'Customer Code',A.CardName'Customer Name',
A.DocTotal'Document Value',C.SlpName'Employee Name',A.UserSign'User Code',A.DocStatus'Status',T1.U_name
from ORIN A
Inner join RIN1 B on B.DocEntry=A.DocEntry
Inner Join OSLP C on C.SlpCode=A.SlpCode
INNER JOIN OUSR T1 ON T1.[USERID] = A.[UserSign]
) ZZ