USE [P21]
GO

/****** Object:  View [dbo].[vatcImportPayment]    Script Date: 9/29/2024 9:54:29 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE VIEW [dbo].[vatcImportPayment]
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.remitter_id AS CustID, dbo.ar_payment_details.payment_date AS TranDate, dbo.ar_payment_details.payment_date AS PostDate, '' AS TranCmnt, 
              dbo.ar_payment_details.payment_amount AS TranAmt, dbo.ar_payment_details.payment_amount AS TranAmtHC, '' AS UnappliedAmt, '' AS UnappliedAmtHC, 
              dbo.payment_types.payment_type_desc AS TenderTypeID, dbo.ar_payment_details.check_number AS PmtRef, '' AS RevrsTranNo, '' AS RevrsTranType, dbo.currency_hdr.currency_desc AS CurrID, '' AS UDF1, 
              '' AS UDF2, '' AS UDF3, '' AS UDF4, '' AS UDF5, '' AS UDF6, '' AS UDF7, '' AS UDF8, '' AS UDF9, '' AS UDF10, dbo.ar_payment_details.date_last_modified AS UpdateDate
FROM          dbo.ar_payment_details WITH (NOLOCK)
                INNER JOIN dbo.ar_receipts WITH (NOLOCK) ON
                  dbo.ar_receipts.payment_number = dbo.ar_payment_details.payment_number
				INNER JOIN dbo.payment_types WITH (NOLOCK) ON
				  dbo.payment_types.payment_type_id = dbo.ar_payment_details.payment_type_id
				INNER JOIN dbo.customer WITH (NOLOCK) ON
				  dbo.customer.customer_id = dbo.ar_receipts.remitter_id
                INNER JOIN dbo.currency_hdr WITH (NOLOCK) ON
				  dbo.currency_hdr.currency_id = dbo.customer.currency_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[32] 4[13] 2[39] 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_payment_details"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 135
               Right = 296
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ar_receipts"
            Begin Extent = 
               Top = 6
               Left = 334
               Bottom = 135
               Right = 537
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "payment_types"
            Begin Extent = 
               Top = 138
               Left = 38
               Bottom = 267
               Right = 279
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "customer"
            Begin Extent = 
               Top = 138
               Left = 317
               Bottom = 267
               Right = 593
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "currency_hdr"
            Begin Extent = 
               Top = 6
               Left = 575
               Bottom = 135
               Right = 816
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 28
         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
         Wid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vatcImportPayment'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'th = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2370
         Alias = 2070
         Table = 1860
         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'vatcImportPayment'
GO

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


