SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[VWInvoiceDetailComplete]
AS
SELECT     dbo.invoiceDetailTbl.GoodSysCode, dbo.invoiceDetailTbl.Quantity * dbo.InvoiceTbl.Sign * dbo.invoiceDetailTbl.UnitRate AS NetQuantity, 
                      dbo.invoiceDetailTbl.Fee, dbo.invoiceDetailTbl.SerialNo, dbo.invoiceDetailTbl.Size, dbo.invoiceDetailTbl.Color, dbo.invoiceDetailTbl.WareHouse, 
                      dbo.InvoiceTbl.Amani, dbo.InvoiceTbl.Type, dbo.InvoiceTbl.FK_DocsysCode, dbo.InvoiceTbl.InvoiceDate, dbo.InvoiceTbl.CustomerName, 
                      dbo.InvoiceTbl.InvoiceSerialNo, dbo.InvoiceTbl.FK_AccountSysCode, dbo.invoiceDetailTbl.SysCode
FROM         dbo.invoiceDetailTbl INNER JOIN
                      dbo.InvoiceTbl ON dbo.invoiceDetailTbl.FK_InvoiceSysCode = dbo.InvoiceTbl.InvoiceSerialNo
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO