dbo.v_sa_bom

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_sa_bom
AS
SELECT        dbo.tbl_sa_bom.id_sa_bom, dbo.tbl_sa_bom.id_sa, dbo.tbl_sa_bom.id_sa_hdr, dbo.tbl_sa_bom.id_bc_in_hdr, dbo.tbl_sa_bom.id_bc_in_dtl, dbo.tbl_sa_bom.id_data_in_hdr, dbo.tbl_sa_bom.id_data_in_dtl, 
                         dbo.tbl_sa_bom.SA_NO, dbo.tbl_sa_bom.KODE_BARANG, dbo.tbl_sa_bom.PART_NO, dbo.tbl_sa_bom.URAIAN, dbo.tbl_sa_bom.JUMLAH_SATUAN, dbo.tbl_sa_bom.JENIS_SATUAN, dbo.tbl_sa_bom.STATUS, 
                         dbo.tbl_sa_bom.CURR, dbo.tbl_sa_bom.PRICE, dbo.tbl_sa_bom.CIF, dbo.tbl_sa_bom.NDPMB, dbo.tbl_sa_bom.NDPDM_NOW, dbo.tbl_sa_bom.HARGA_PABEAN, dbo.tbl_sa_bom.HS, dbo.tbl_sa_bom.BM, 
                         dbo.tbl_sa_bom.PPN, dbo.tbl_sa_bom.PPH, dbo.tbl_sa_bom.NOMOR_DAFTAR_DOK_ASAL, dbo.tbl_sa_bom.TANGGAL_DAFTAR_DOK_ASAL, dbo.tbl_sa_bom.SERI_BARANG, dbo.tbl_sa_bom.SERI_BAHAN_BAKU, 
                         dbo.tbl_sa_bom.SERI_BAHAN_BAKU_ASAL, dbo.tbl_sa_bom.ASSY_NO, dbo.tbl_sa_bom.KODE_JENIS_DOK_ASAL, dbo.tbl_sa_bom.KODE_KANTOR, dbo.tbl_sa_bom.NOMOR_AJU_DOK_ASAL, 
                         dbo.tbl_sa_bom.KODE_ASAL_BAHAN_BAKU, dbo.tbl_sa_bom.create_date, dbo.tbl_sa_bom.create_by, dbo.tbl_sa_bom.update_date, dbo.tbl_sa_bom.update_by, dbo.tbl_sa.ASSY_CODE, dbo.tbl_sa.TOTAL_SET, 
                         dbo.tbl_sa_bom.JUMLAH_SATUAN_ASAL, ISNULL(dbo.tbl_sa_bom.HARGA_PABEAN, 0) * ISNULL(dbo.tbl_sa_bom.BM, 0) / 100 AS BM_RP, ISNULL(dbo.tbl_sa_bom.HARGA_PABEAN, 0) 
                         * ISNULL(dbo.tbl_sa_bom.PPN, 0) / 100 AS PPN_RP, ISNULL(dbo.tbl_sa_bom.HARGA_PABEAN, 0) * ISNULL(dbo.tbl_sa_bom.PPH, 0) / 100 AS PPH_RP, dbo.tbl_sa_bom.KODE_ASAL_BAHAN_BAKU AS typedok, 
                         ISNULL(dbo.tbl_sa_bom.PRICE, 0) * ISNULL(dbo.tbl_sa_bom.JUMLAH_SATUAN, 0) AS CIF_PAKAI
FROM            dbo.tbl_sa_bom INNER JOIN
                         dbo.tbl_sa ON dbo.tbl_sa_bom.id_sa = dbo.tbl_sa.id_sa AND dbo.tbl_sa_bom.id_sa_hdr = dbo.tbl_sa.id_sa_hdr
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPane1', 
N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = "tbl_sa" Begin Extent = Top = 138 Left = 38 Bottom = 268 Right = 214 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_sa_bom" Begin Extent = Top = 6 Left = 38 Bottom = 136 Right = 292 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'v_sa_bom'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'v_sa_bom'
GO