USE [AGA]
GO

/****** Object:  View [dbo].[Stock]    Script Date: 03/05/2026 16:37:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[Stock]
AS
SELECT     dbo.Barang.Kode, dbo.Barang.Jenis, dbo.Barang.Nama, dbo.Barang.Satuan, dbo.Barang.HPP, dbo.Qty_Stock_Awal.Stock_A AS Awal, dbo.Qty_Beli.Beli, dbo.Qty_Jual.Jual, 
                      dbo.Qty_PenggunaanStock.Penggunaan, dbo.Qty_ReturBeli.Retur_Beli, dbo.Qty_ReturJual.Retur_Jual, dbo.Qty_AturStock.Penyesuaian, dbo.Qty_PecahStock.Pecah AS Konversi, 
                      dbo.Qty_Stock_Awal.Stock_A + dbo.Qty_Beli.Beli - dbo.Qty_Jual.Jual - dbo.Qty_PenggunaanStock.Penggunaan - dbo.Qty_ReturBeli.Retur_Beli + dbo.Qty_ReturJual.Retur_Jual + dbo.Qty_AturStock.Penyesuaian
                       + dbo.Qty_PecahStock.Pecah AS Stock, dbo.Barang.Consignor, dbo.Barang.Stocked, dbo.Barang.Status, dbo.Barang.Stock_Minimum
FROM         dbo.Qty_PecahStock RIGHT OUTER JOIN
                      dbo.Qty_Stock_Awal RIGHT OUTER JOIN
                      dbo.Qty_PenggunaanStock RIGHT OUTER JOIN
                      dbo.Barang ON dbo.Qty_PenggunaanStock.Kode = dbo.Barang.Kode ON dbo.Qty_Stock_Awal.Kode = dbo.Barang.Kode ON dbo.Qty_PecahStock.Kode = dbo.Barang.Kode LEFT OUTER JOIN
                      dbo.Qty_ReturJual ON dbo.Barang.Kode = dbo.Qty_ReturJual.Kode LEFT OUTER JOIN
                      dbo.Qty_Beli ON dbo.Barang.Kode = dbo.Qty_Beli.Kode LEFT OUTER JOIN
                      dbo.Qty_ReturBeli ON dbo.Barang.Kode = dbo.Qty_ReturBeli.Kode LEFT OUTER JOIN
                      dbo.Qty_AturStock ON dbo.Barang.Kode = dbo.Qty_AturStock.Kode LEFT OUTER JOIN
                      dbo.Qty_Jual ON dbo.Barang.Kode = dbo.Qty_Jual.Kode
WHERE     (dbo.Barang.Stocked = 1)
GO