dbo.v_bcall_hdr

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_bcall_hdr
AS
SELECT        dbo.tbl_bc_out_hdr.id_bc_out_hdr, dbo.tbl_bc_out_hdr.CAR, dbo.tbl_bc_out_hdr.JnEks, dbo.tbl_bc_out_hdr.KatEks, dbo.tbl_bc_out_hdr.JNPEB, dbo.tbl_bc_out_hdr.JNEKSOld, dbo.tbl_bc_out_hdr.JNLAIN, 
                         dbo.tbl_bc_out_hdr.JNDAG, dbo.tbl_bc_out_hdr.JNBYR, dbo.tbl_bc_out_hdr.IDEKS, dbo.tbl_bc_out_hdr.NPWPEKS, dbo.tbl_bc_out_hdr.NamaEks, dbo.tbl_bc_out_hdr.AlmtEks, dbo.tbl_bc_out_hdr.NoSiup, 
                         dbo.tbl_bc_out_hdr.TgSiup, dbo.tbl_bc_out_hdr.JnPerus, dbo.tbl_bc_out_hdr.NoTdp, dbo.tbl_bc_out_hdr.TgTdp, dbo.tbl_bc_out_hdr.Niper, dbo.tbl_bc_out_hdr.StatusH, dbo.tbl_bc_out_hdr.IdQq, 
                         dbo.tbl_bc_out_hdr.NpwpQq, dbo.tbl_bc_out_hdr.NamaQq, dbo.tbl_bc_out_hdr.AlmtQq, dbo.tbl_bc_out_hdr.NiperQq, dbo.tbl_bc_out_hdr.NAMABELI, dbo.tbl_bc_out_hdr.ALMTBELI, dbo.tbl_bc_out_hdr.NEGBELI, 
                         dbo.tbl_bc_out_hdr.IDPPJK, dbo.tbl_bc_out_hdr.NPWPPPJK, dbo.tbl_bc_out_hdr.NamaPpjk, dbo.tbl_bc_out_hdr.AlmtPpjk, dbo.tbl_bc_out_hdr.NoPpjk, dbo.tbl_bc_out_hdr.TgPpjk, dbo.tbl_bc_out_hdr.MODA, 
                         dbo.tbl_bc_out_hdr.TGEKS, dbo.tbl_bc_out_hdr.CARRIER, dbo.tbl_bc_out_hdr.VOY, dbo.tbl_bc_out_hdr.NOSHIPORD, dbo.tbl_bc_out_hdr.TGSHIPORD, dbo.tbl_bc_out_hdr.PELMUAT, 
                         dbo.tbl_bc_out_hdr.PELBONGKAR, dbo.tbl_bc_out_hdr.PELTRANSIT, dbo.tbl_bc_out_hdr.NOINV, dbo.tbl_bc_out_hdr.TGINV, dbo.tbl_bc_out_hdr.NOLPSE, dbo.tbl_bc_out_hdr.TGLPSE, 
                         dbo.tbl_bc_out_hdr.PROPBRG, dbo.tbl_bc_out_hdr.NEGTUJU, dbo.tbl_bc_out_hdr.DELIVERY, dbo.tbl_bc_out_hdr.KDVAL, dbo.tbl_bc_out_hdr.KdHrg, dbo.tbl_bc_out_hdr.NilInv, dbo.tbl_bc_out_hdr.FREIGHT, 
                         dbo.tbl_bc_out_hdr.ASURANSI, dbo.tbl_bc_out_hdr.FOB, dbo.tbl_bc_out_hdr.MERK, dbo.tbl_bc_out_hdr.JMCONT, dbo.tbl_bc_out_hdr.BRUTO, dbo.tbl_bc_out_hdr.NETTO, dbo.tbl_bc_out_hdr.JMBRG, 
                         dbo.tbl_bc_out_hdr.JMBRGCTH, dbo.tbl_bc_out_hdr.NODAFT, dbo.tbl_bc_out_hdr.TGDAFT, dbo.tbl_bc_out_hdr.KDKTR, dbo.tbl_bc_out_hdr.KDLOKBRG, dbo.tbl_bc_out_hdr.KDKTRMUAT, 
                         dbo.tbl_bc_out_hdr.KDKTRPRIKS, dbo.tbl_bc_out_hdr.NILKURS, dbo.tbl_bc_out_hdr.typedok, dbo.tbl_bc_out_hdr.statusdok, dbo.tbl_bc_out_hdr.bc_in_from_in, dbo.tbl_bc_out_hdr.NAMABELI2, 
                         dbo.tbl_bc_out_hdr.ALMTBELI2, dbo.tbl_bc_out_hdr.NEGBELI2, dbo.tbl_bc_out_hdr.tujuan_pengiriman, 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.tbl_data_out_hdr.id_data_out_hdr
FROM            dbo.tbl_data_out_hdr RIGHT OUTER JOIN
                         dbo.tbl_bc_out_hdr ON dbo.tbl_data_out_hdr.id_terkait = dbo.tbl_bc_out_hdr.id_bc_out_hdr
WHERE        (dbo.tbl_bc_out_hdr.id_bc_out_hdr IS NOT NULL) AND (dbo.tbl_data_out_hdr.doc_out_to_id IN (2, 3, 4, 5, 6, 7))
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_data_out_hdr" Begin Extent = Top = 6 Left = 38 Bottom = 136 Right = 259 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_bc_out_hdr" Begin Extent = Top = 6 Left = 297 Bottom = 136 Right = 486 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_bcall_hdr'
GO

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