dbo.v_noinv_dtl

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE VIEW dbo.v_noinv_dtl
AS
SELECT     dbo.tbl_inv_dtl.inv_dtl, dbo.tbl_inv_dtl.inv_hdr_id, dbo.tbl_inv_hdr.r3 AS noinv, dbo.tbl_inv_hdr.nobl, dbo.tbl_inv_hdr.tgbl, dbo.tbl_inv_dtl.r1, dbo.tbl_inv_dtl.r2, 
                      dbo.tbl_inv_dtl.r3, dbo.tbl_inv_dtl.r4, dbo.tbl_inv_dtl.r5, dbo.tbl_inv_dtl.r6, dbo.tbl_inv_dtl.r7, dbo.tbl_inv_dtl.r8, dbo.tbl_inv_dtl.r9, dbo.tbl_inv_dtl.r10, 
                      dbo.tbl_inv_dtl.r11, dbo.tbl_inv_dtl.r12, dbo.tbl_inv_dtl.r13, dbo.tbl_inv_dtl.r14, dbo.tbl_inv_dtl.car, dbo.tbl_inv_dtl.nobc, dbo.tbl_inv_dtl.tglbc, 
                      CASE WHEN dbo.tbl_inv_dtl.r4 <> '' THEN dbo.tbl_inv_dtl.r4 ELSE dbo.tbl_inv_dtl.r3 END AS partnumber, CASE ISNUMERIC(dbo.tbl_inv_dtl.r6) 
                      WHEN 1 THEN CAST(dbo.tbl_inv_dtl.r6 AS float) ELSE NULL END AS qty, CASE WHEN len(tbl_inv_dtl.r9) = 20 THEN CASE ISNUMERIC(substring(tbl_inv_dtl.r9, 1, 16)) 
                      WHEN 1 THEN CAST(substring(tbl_inv_dtl.r9, 1, 16) AS float) ELSE NULL END ELSE CASE ISNUMERIC(substring(tbl_inv_dtl.r9, 1, 10)) 
                      WHEN 1 THEN CAST(substring(tbl_inv_dtl.r9, 1, 10) AS float) ELSE NULL END END AS amount, CASE WHEN len(tbl_inv_dtl.r9) 
                      = 20 THEN CASE ISNUMERIC(substring(tbl_inv_dtl.r9, 1, 16)) WHEN 1 THEN CAST(substring(tbl_inv_dtl.r9, 1, 16) AS float) ELSE NULL 
                      END ELSE CASE ISNUMERIC(substring(tbl_inv_dtl.r9, 1, 10)) WHEN 1 THEN CAST(substring(tbl_inv_dtl.r9, 1, 10) AS float) ELSE NULL END END / 1000 AS harga, 
                      CASE WHEN len(dbo.tbl_inv_dtl.r9) = 20 THEN SUBSTRING(dbo.tbl_inv_dtl.r9, 18, 3) ELSE SUBSTRING(dbo.tbl_inv_dtl.r9, 11, 3) END AS kdval, 
                      CASE ISNUMERIC(dbo.tbl_inv_dtl.r13) WHEN 1 THEN CAST(dbo.tbl_inv_dtl.r13 AS float) ELSE NULL END AS box, CASE ISNUMERIC(dbo.tbl_inv_dtl.r8) 
                      WHEN 1 THEN CAST(dbo.tbl_inv_dtl.r8 AS float) ELSE NULL END AS pack
FROM         dbo.tbl_inv_hdr INNER JOIN
                      dbo.tbl_inv_dtl ON dbo.tbl_inv_hdr.inv_hdr_id = dbo.tbl_inv_dtl.inv_hdr_id

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_inv_hdr" Begin Extent = Top = 6 Left = 38 Bottom = 125 Right = 198 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_inv_dtl" Begin Extent = Top = 6 Left = 236 Bottom = 125 Right = 396 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 9 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 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_noinv_dtl'
GO

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