Description |
Error SQL72014: .Net SqlClient Data Provider: Msg 205, Level 16, State 1, Procedure vyuAPReceivedItems, Line 4 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Error SQL72045: Script execution error. The executed script:
CREATE VIEW [dbo].[vyuAPReceivedItems]
AS
SELECT CAST (ROW_NUMBER() OVER (ORDER BY intInventoryShipmentItemId, intInventoryReceiptItemId, intPurchaseDetailId) AS INT) AS intReceivedItemId,
Items.*
FROM (SELECT A.[intEntityVendorId] AS [intEntityVendorId],
A.dtmDate AS [dtmDate],
A.strReference AS [strReference],
tblReceived.strReceiptNumber AS [strSourceNumber],
A.strPurchaseOrderNumber AS [strPurchaseOrderNumber],
B.intPurchaseDetailId AS [intPurchaseDetailId],
B.intItemId AS [intItemId],
B.strMiscDescription AS [strMiscDescription],
C.strItemNo AS [strItemNo],
C.strDescription AS [strDescription],
NULL AS [intPurchaseTaxGroupId],
tblReceived.dblOrderQty AS [dblOrderQty],
tblReceived.dblPOOpenReceive AS [dblPOOpenReceive],
tblReceived.dblOpenReceive AS [dblOpenReceive],
(tblR
!pastedImage_d110898_0.png!
|