Differences
This shows you the differences between two versions of the page.
control_sql_-_ar_integrity_check [2019/01/27 11:28] 127.0.0.1 external edit |
control_sql_-_ar_integrity_check [2019/02/05 11:30] (current) admin |
||
---|---|---|---|
Line 51: | Line 51: | ||
WHERE (GLAccountID = 14) AND (TransactionID IS NOT NULL) | WHERE (GLAccountID = 14) AND (TransactionID IS NOT NULL) | ||
GROUP BY TransactionID, | GROUP BY TransactionID, | ||
- | HAVING SUM(Amount) | + | HAVING SUM(Amount) |
UNION | UNION | ||
Line 63: | Line 63: | ||
WHERE (GLAccountID = 14) AND (TransactionID IS NULL) | WHERE (GLAccountID = 14) AND (TransactionID IS NULL) | ||
GROUP BY AccountID, COALESCE(DivisionID, | GROUP BY AccountID, COALESCE(DivisionID, | ||
- | HAVING SUM(Amount) | + | HAVING SUM(Amount) |
) AS A | ) AS A | ||
Line 71: | Line 71: | ||
SELECT * | SELECT * | ||
FROM TransHeader | FROM TransHeader | ||
- | WHERE TransactionType | + | WHERE TransactionType |
) AS TH | ) AS TH | ||
Line 78: | Line 78: | ||
LEFT JOIN Account ON Account.ID = COALESCE(A.GLAccountID, | LEFT JOIN Account ON Account.ID = COALESCE(A.GLAccountID, | ||
- | WHERE (COALESCE( (BalanceDue* CASE WHEN StatusID >=3 THEN 1 ELSE TH.PercentComplete/ | + | WHERE (COALESCE( (BalanceDue* CASE WHEN StatusID >=3 THEN 1 ELSE TH.PercentComplete/ |
AND (COALESCE (A.GLAmount, | AND (COALESCE (A.GLAmount, | ||