Top 1 Query (SQL, Key Operation)

2359990.000 Sql="SELECT TOP 45
T1._IDRRef,
T1._Marked,
T1._Number,
T1._Date_Time,
T1._Posted,
T1._Fld4621RRef,
T1._Fld4622RRef,
T1._Fld4625RRef,
T1._Fld4633,
T1._Fld4635RRef,
T1._Fld4654RRef,
T1._Fld4657RRef,
CASE WHEN ((T1._Fld4657RRef = ?) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T14.Fld10346Balance_ AS NUMERIC(33, 2)),0.0) > 0.0) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 4.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 6.0 ELSE 5.0 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 0.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 2.0 ELSE 1.0 END END ELSE 7.0 END,
T19._Fld12313RRef,
CASE WHEN ((ISNULL(CAST(T20.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) > 0.0) THEN (ISNULL(CAST(T20.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) ELSE 0.0 END,
CASE WHEN (T1._Fld4657RRef = ?) THEN CASE WHEN T1._Posted = 0x01 THEN CASE WHEN T1._Fld14039 = 0x01 THEN CASE WHEN (ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) <= 0.0) THEN 0.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) <= 0.5) THEN 1.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) < 1.0) THEN 2.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) >= 1.0) THEN 3.0 END ELSE 3.0 END ELSE 0.0 END ELSE 7.0 END,
T32._Fld1191,
T1._Fld4642
FROM dbo._Document233 T1
LEFT OUTER JOIN (SELECT
T3._Fld11328RRef AS Fld11328RRef,
CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8)) AS Fld11330Turnover_
FROM dbo._AccumRgTn11332 T3
WHERE ((T3._Fld595 = ?)) AND ((T3._Fld11330 <> ?))
GROUP BY T3._Fld11328RRef
HAVING (CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8))) <> 0.0) T2
ON (T1._IDRRef = T2.Fld11328RRef)
LEFT OUTER JOIN (SELECT
T5._Fld10540_TYPE AS Fld10540_TYPE,
T5._Fld10540_RTRef AS Fld10540_RTRef,
T5._Fld10540_RRRef AS Fld10540_RRRef,
CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8)) AS Fld10545Balance_
FROM dbo._AccumRgT10549 T5
WHERE (((T5._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T6
ON ((T5._Fld10538RRef = T6._IDRRef)) AND (T6._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T7
INNER JOIN dbo._Reference21 T8
ON (((T7._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T9
WHERE ((T9._Fld595 = ?)) AND ((T9._Fld12065RRef = T7._IDRRef) AND (T9._Fld12066RRef = T8._IDRRef)))) AND T8._IDRRef IN
(SELECT
T10._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T10
INNER JOIN dbo._InfoRg9937 T11
ON ((T11._Fld9939_TYPE = 0x08 AND T11._Fld9939_RTRef = 0x00000095 AND T11._Fld9939_RRRef = ?) AND (T11._Fld9938_TYPE = T10._Fld784_TYPE AND T11._Fld9938_RTRef = T10._Fld784_RTRef AND T11._Fld9938_RRRef = T10._Fld784_RRRef))
WHERE ((T10._Fld595 = ?)) AND (T11._Fld595 = ?)))
WHERE ((T8._Fld595 = ?)) AND ((CASE WHEN T6._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T12
WHERE ((T12._Fld595 = ?)) AND ((T12._Fld12072RRef = T8._IDRRef) AND (T12._Fld12073_TYPE = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END AND T12._Fld12073_RTRef = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T12._Fld12073_RRRef = T6._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T13
WHERE ((T13._Fld595 = ?)) AND ((T13._Fld12199RRef = T8._IDRRef) AND T13._Fld12200_TYPE = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END AND T13._Fld12200_RTRef = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T13._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T5._Period = ? AND (T5._Fld10545 <> ?) AND (T5._Fld10545 <> ?))
GROUP BY T5._Fld10540_TYPE,
T5._Fld10540_RTRef,
T5._Fld10540_RRRef
HAVING (CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8))) <> 0.0) T4
ON (0x08 = T4.Fld10540_TYPE AND 0x000000E9 = T4.Fld10540_RTRef AND T1._IDRRef = T4.Fld10540_RRRef)
LEFT OUTER JOIN (SELECT
T15.Fld10344RRef AS Fld10344RRef,
CAST(SUM(T15.Fld10346Balance_) AS NUMERIC(38, 8)) AS Fld10346Balance_
FROM (SELECT
T16._Fld10344RRef AS Fld10344RRef,
CAST(SUM(T16._Fld10346) AS NUMERIC(33, 8)) AS Fld10346Balance_
FROM dbo._AccumRgT10349 T16
WHERE ((T16._Fld595 = ?)) AND (T16._Period = ? AND (T16._Fld10346 <> ?) AND (T16._Fld10346 <> ?))
GROUP BY T16._Fld10344RRef
HAVING (CAST(SUM(T16._Fld10346) AS NUMERIC(33, 8))) <> 0.0
UNION ALL SELECT
T17._Fld10344RRef AS Fld10344RRef,
CAST(CAST(SUM(CASE WHEN T17._RecordKind = 0.0 THEN -T17._Fld10346 ELSE T17._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2)) AS Fld10346Balance_
FROM dbo._AccumRg10339 T17
WHERE ((T17._Fld595 = ?)) AND (T17._Period >= ? AND T17._Period < ? AND T17._Active = 0x01)
GROUP BY T17._Fld10344RRef
HAVING (CAST(CAST(SUM(CASE WHEN T17._RecordKind = 0.0 THEN -T17._Fld10346 ELSE T17._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2))) <> 0.0) T15
GROUP BY T15.Fld10344RRef
HAVING (CAST(SUM(T15.Fld10346Balance_) AS NUMERIC(38, 8))) <> 0.0) T14
ON (T1._IDRRef = T14.Fld10344RRef)
LEFT OUTER JOIN dbo._InfoRg9134 T18
ON ((0x08 = T18._Fld9136_TYPE AND 0x000000E9 = T18._Fld9136_RTRef AND T1._IDRRef = T18._Fld9136_RRRef)) AND (T18._Fld595 = ?)
LEFT OUTER JOIN dbo._InfoRg11720 T19
ON ((0x08 = T19._Fld12312_TYPE AND 0x000000E9 = T19._Fld12312_RTRef AND T1._IDRRef = T19._Fld12312_RRRef)) AND (T19._Fld595 = ?)
LEFT OUTER JOIN (SELECT
T21._Fld10332_TYPE AS Fld10332_TYPE,
T21._Fld10332_RTRef AS Fld10332_RTRef,
T21._Fld10332_RRRef AS Fld10332_RRRef,
CAST(SUM(T21._Fld10335) AS NUMERIC(33, 8)) AS Fld10335Balance_
FROM dbo._AccumRgT10337 T21
WHERE (((T21._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T22
ON ((T21._Fld10330RRef = T22._IDRRef)) AND (T22._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T23
INNER JOIN dbo._Reference21 T24
ON (((T23._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T25
WHERE ((T25._Fld595 = ?)) AND ((T25._Fld12065RRef = T23._IDRRef) AND (T25._Fld12066RRef = T24._IDRRef)))) AND T24._IDRRef IN
(SELECT
T26._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T26
INNER JOIN dbo._InfoRg9937 T27
ON ((T27._Fld9939_TYPE = 0x08 AND T27._Fld9939_RTRef = 0x00000095 AND T27._Fld9939_RRRef = ?) AND (T27._Fld9938_TYPE = T26._Fld784_TYPE AND T27._Fld9938_RTRef = T26._Fld784_RTRef AND T27._Fld9938_RRRef = T26._Fld784_RRRef))
WHERE ((T26._Fld595 = ?)) AND (T27._Fld595 = ?)))
WHERE ((T24._Fld595 = ?)) AND ((CASE WHEN T22._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T28
WHERE ((T28._Fld595 = ?)) AND ((T28._Fld12072RRef = T24._IDRRef) AND (T28._Fld12073_TYPE = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END AND T28._Fld12073_RTRef = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T28._Fld12073_RRRef = T22._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T29
WHERE ((T29._Fld595 = ?)) AND ((T29._Fld12199RRef = T24._IDRRef) AND T29._Fld12200_TYPE = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END AND T29._Fld12200_RTRef = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T29._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T21._Period = ? AND (T21._Fld10335 <> ?) AND (T21._Fld10335 <> ?))
GROUP BY T21._Fld10332_TYPE,
T21._Fld10332_RTRef,
T21._Fld10332_RRRef
HAVING (CAST(SUM(T21._Fld10335) AS NUMERIC(33, 8))) <> 0.0) T20
ON (0x08 = T20.Fld10332_TYPE AND 0x000000E9 = T20.Fld10332_RTRef AND T1._IDRRef = T20.Fld10332_RRRef)
LEFT OUTER JOIN (SELECT
T31._Fld14033RRef AS Fld14033RRef,
CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN T31._Fld14035 ELSE 0.0 END) AS NUMERIC(26, 8)) AS Fld14035Receipt_,
CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN 0.0 ELSE T31._Fld14035 END) AS NUMERIC(26, 8)) AS Fld14035Expense_
FROM dbo._AccumRg14026 T31
WHERE ((T31._Fld595 = ?)) AND (T31._Active = 0x01 AND ((T31._Fld14031RRef = ?)))
GROUP BY T31._Fld14033RRef
HAVING (CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN T31._Fld14035 ELSE 0.0 END) AS NUMERIC(26, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN 0.0 ELSE T31._Fld14035 END) AS NUMERIC(26, 8))) <> 0.0) T30
ON (T30.Fld14033RRef = T1._IDRRef)
LEFT OUTER JOIN dbo._Reference51 T32
ON (T1._Fld4635RRef = T32._IDRRef) AND (T32._Fld595 = ?)
WHERE (((T1._Fld595 = ?)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T33
ON ((T1._Fld4625RRef = T33._IDRRef)) AND (T33._Fld595 = ?)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T34
INNER JOIN dbo._Reference21 T35
ON (((T34._Fld1685 = ?) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T36
WHERE ((T36._Fld595 = ?)) AND ((T36._Fld12065RRef = T34._IDRRef) AND (T36._Fld12066RRef = T35._IDRRef)))) AND T35._IDRRef IN
(SELECT
T37._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T37
INNER JOIN dbo._InfoRg9937 T38
ON ((T38._Fld9939_TYPE = 0x08 AND T38._Fld9939_RTRef = 0x00000095 AND T38._Fld9939_RRRef = ?) AND (T38._Fld9938_TYPE = T37._Fld784_TYPE AND T38._Fld9938_RTRef = T37._Fld784_RTRef AND T38._Fld9938_RRRef = T37._Fld784_RRRef))
WHERE ((T37._Fld595 = ?)) AND (T38._Fld595 = ?)))
WHERE ((T35._Fld595 = ?)) AND ((CASE WHEN T33._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T39
WHERE ((T39._Fld595 = ?)) AND ((T39._Fld12072RRef = T35._IDRRef) AND (T39._Fld12073_TYPE = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END AND T39._Fld12073_RTRef = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T39._Fld12073_RRRef = T33._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T40
WHERE ((T40._Fld595 = ?)) AND ((T40._Fld12199RRef = T35._IDRRef) AND T40._Fld12200_TYPE = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END AND T40._Fld12200_RTRef = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T40._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T1._Fld4621RRef = ?) AND (T1._Posted = 0x00) AND (T1._Marked = 0x00))
ORDER BY (T1._Date_Time) DESC, (T1._IDRRef) DESC
",Context=System.GetForm : Document.InventoryExpense.ListForm