Notifications
Clear all
Feb 21, 2023 8:55 pm
Câu truy vấn:
SELECT T0."DocNum", T1."ItemCode", T1."Dscription", T1."LineStatus", T1."BaseLine", T1."BaseEntry", T1."BaseType", T1."BaseRef" FROM OPCH T0 INNER JOIN PCH1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T1."BaseType" = '-1' and T0."DocDate" >= '[%0]' and T0."DocDate" <= '[%1]'