dbo.v_bc25_hdr

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_bc25_hdr
AS
SELECT        dbo.tbl_sa_hdr.id_sa_hdr, dbo.tbl_sa_hdr.SA_NO, dbo.tbl_sa_hdr.status, dbo.tbl_sa_hdr.NPWP_PEMBELI, dbo.tbl_sa_hdr.NAMA_PEMBELI, dbo.tbl_sa_hdr.BC25No, dbo.tbl_sa_hdr.BC25Tg, 
                         dbo.tbl_sa_hdr.BC25NAJU, dbo.tbl_sa_hdr.BC25TGAJU, dbo.tbl_sa_hdr.BC25NAJU1, dbo.tbl_sa_hdr.BC25TGAJU1, dbo.tbl_sa_hdr.KdKpbc, dbo.tbl_sa_hdr.KdKpbcTujuan, dbo.tbl_sa_hdr.JnBC25, 
                         dbo.tbl_sa_hdr.JnBarang, dbo.tbl_sa_hdr.Kondisi, dbo.tbl_sa_hdr.Dari, dbo.tbl_sa_hdr.Tujuan, dbo.tbl_sa_hdr.TujuanKirim, dbo.tbl_sa_hdr.UsahaID, dbo.tbl_sa_hdr.UsahaNpwp, dbo.tbl_sa_hdr.UsahaNama, 
                         dbo.tbl_sa_hdr.UsahaAlmt, dbo.tbl_sa_hdr.UsahaStatus, dbo.tbl_sa_hdr.PenerimaID, dbo.tbl_sa_hdr.PenerimaNpwp, dbo.tbl_sa_hdr.PenerimaNama, dbo.tbl_sa_hdr.PenerimaAlmt, 
                         dbo.tbl_sa_hdr.PenerimaNiper, dbo.tbl_sa_hdr.PenerimaStatus, dbo.tbl_sa_hdr.TempatPenimbunan, dbo.tbl_sa_hdr.TgKeluar, dbo.tbl_sa_hdr.TglMusnah, dbo.tbl_sa_hdr.BAMusnah, dbo.tbl_sa_hdr.KdVal, 
                         dbo.tbl_sa_hdr.Ndpbm, dbo.tbl_sa_hdr.HargaRp, dbo.tbl_sa_hdr.HargaBBRp, dbo.tbl_sa_hdr.Bruto, dbo.tbl_sa_hdr.Netto, dbo.tbl_sa_hdr.JmBrg, dbo.tbl_sa_hdr.JmBB, dbo.tbl_sa_hdr.JmCont, 
                         dbo.tbl_sa_hdr.KotaTtd, dbo.tbl_sa_hdr.TglTtd, dbo.tbl_sa_hdr.NamaTtd, dbo.tbl_sa_hdr.KotattdPenerima, dbo.tbl_sa_hdr.TglTtdPenerima, dbo.tbl_sa_hdr.NamaTtdPenerima, dbo.tbl_sa_hdr.TmpPeriksaFisik, 
                         dbo.tbl_sa_hdr.AlmtPeriksaFisik, dbo.tbl_sa_hdr.TgPeriksaFisik, dbo.tbl_sa_hdr.WkPeriksaFisik, dbo.tbl_sa_hdr.ContakPerson, dbo.tbl_sa_hdr.NoPhone, dbo.tbl_sa_hdr.jml_inv, dbo.tbl_sa_hdr.typedok, 
                         dbo.tbl_sa_hdr.nip_bc, dbo.tbl_sa_hdr.nama_bc, dbo.tbl_sa_hdr.HargaUSD, dbo.tbl_data_out_hdr.id_data_out_hdr, dbo.tbl_data_out_hdr.doc_out_no, dbo.tbl_data_out_hdr.doc_out_date, 
                         dbo.tbl_data_out_hdr.doc_out_to_id, dbo.tbl_data_out_hdr.id_terkait, dbo.tbl_data_out_hdr.approve_date, dbo.enum_data_out_to.doc_out_to_name
FROM            dbo.enum_data_out_to RIGHT OUTER JOIN
                         dbo.tbl_data_out_hdr ON dbo.enum_data_out_to.doc_out_to_id = dbo.tbl_data_out_hdr.doc_out_to_id RIGHT OUTER JOIN
                         dbo.tbl_sa_hdr ON dbo.tbl_data_out_hdr.id_terkait = dbo.tbl_sa_hdr.id_sa_hdr
WHERE        (dbo.tbl_data_out_hdr.doc_out_to_id = 3)
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 = "enum_data_out_to" Begin Extent = Top = 6 Left = 38 Bottom = 102 Right = 221 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_data_out_hdr" Begin Extent = Top = 6 Left = 259 Bottom = 136 Right = 480 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_sa_hdr" Begin Extent = Top = 6 Left = 518 Bottom = 136 Right = 716 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_bc25_hdr'
GO

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