想達成效果ex:(20240614->20240814) (20241217->2025217) SELECT DEPT.SalesDepartmentID, DEPT.SalesDepartmentName, EMP.EmployeeID AS SalesEmployeeID, EMP.EmployeeName AS SalesEmployeeName, CEIL(A.TransactionBalanceAmount / 1000) AS TransactionBalanceAmount, ScheduledCollectionDate, DATE_FORMAT(DATE_ADD(A.ScheduledCollectionDate, INTERVAL 2 MONTH), '%Y-%m') AS Overdue_Date, JWS.JWSNO, JWS.Status, JWS.IssueDate, JWS.JournalizeDate, JWS.CloseDate, ACCT.AccountID FROM "public"."lcactjwsarcreatejournal" A LEFT JOIN "public"."lcactjournalworksheet" JWS ON A.JournalWorkSheet = JWS.Sysid LEFT JOIN "public"."lccoreaccount" ACCT ON A.Account = ACCT.Sysid LEFT JOIN "public"."lccoresalesdepartment" DEPT ON A.SalesDepartment = DEPT.Sysid LEFT JOIN "public"."lccoreemployee" EMP ON A.SalesEmployee = EMP.Sysid WHERE ACCT.AccountID = '1107000' AND (JWS.Status IS NOT NULL AND JWS.Status != 'X') AND A.ScheduledCollectionDate <= '${TODAY()}'
|
1min目标场景问卷
立即参与
