USE [P21]
GO

/****** Object:  View [dbo].[vatcImportPaymentAppl]    Script Date: 9/29/2024 9:55:12 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE VIEW [dbo].[vatcImportPaymentAppl]
AS
SELECT        dbo.ar_receipts.company_id AS CompanyID, dbo.ar_receipts.receipt_number AS TranNo, CASE WHEN ar_receipts.reverse_payment_flag = 'Y' THEN 'RV' ELSE 'CR' END AS TranType, 
              dbo.ar_receipts.payment_number AS EntryNo, dbo.ar_payment_details.payment_date AS ApplyToTranDate, dbo.ar_receipts_detail.invoice_no AS ApplyToTranNo, 
              dbo.invoice_hdr.invoice_type AS ApplyToTranType, dbo.ar_receipts_detail.payment_amount AS PmtAmt, dbo.ar_receipts_detail.payment_amount AS PmtAmtHC, '' AS UDF1, '' AS UDF2, '' AS UDF3, '' AS UDF4, 
              '' AS UDF5, '' AS UDF6, '' AS UDF7, '' AS UDF8, '' AS UDF9, '' AS UDF10, dbo.ar_receipts_detail.date_last_modified AS UpdateDate
FROM          dbo.ar_receipts WITH (NOLOCK)
                INNER JOIN dbo.ar_receipts_detail WITH (NOLOCK) ON
				  dbo.ar_receipts.receipt_number = dbo.ar_receipts_detail.receipt_number 
				INNER JOIN dbo.ar_payment_details WITH (NOLOCK) ON 
                  dbo.ar_receipts.payment_number = dbo.ar_payment_details.payment_number 
				INNER JOIN dbo.invoice_hdr WITH (NOLOCK) ON
				  dbo.ar_receipts_detail.invoice_no = dbo.invoice_hdr.invoice_no 
				INNER JOIN dbo.payment_types WITH (NOLOCK) ON
				  dbo.ar_payment_details.payment_type_id = dbo.payment_types.payment_type_id
WHERE         datediff(day, getdate(), dbo.ar_payment_details.payment_date) >= -90 AND
              dbo.ar_payment_details.delete_flag = 'N'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[42] 4[20] 2[26] 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 = "ar_receipts"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 135
               Right = 241
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ar_receipts_detail"
            Begin Extent = 
               Top = 6
               Left = 279
               Bottom = 135
               Right = 532
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ar_payment_details"
            Begin Extent = 
               Top = 138
               Left = 38
               Bottom = 267
               Right = 296
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "invoice_hdr"
            Begin Extent = 
               Top = 138
               Left = 334
               Bottom = 267
               Right = 616
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "payment_types"
            Begin Extent = 
               Top = 6
               Left = 570
               Bottom = 135
               Right = 811
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 21
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vatcImportPaymentAppl'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'      Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2355
         Alias = 1995
         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
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vatcImportPaymentAppl'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vatcImportPaymentAppl'
GO


