USE [P21]
GO

/****** Object:  View [dbo].[vatcImportCUSTCONTACT]    Script Date: 9/29/2024 9:52:31 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[vatcImportCUSTCONTACT]
AS
SELECT        '10' AS CompanyID, dbo.p21_view_customer.customer_id AS CustID, dbo.p21_view_contacts.first_name + ' ' + dbo.p21_view_contacts.last_name AS ContactName, '' AS Comment, 
                         CASE WHEN p21_view_customer.invoice_batch_uid = 3 THEN '1' + replace(dbo.p21_view_contacts.direct_fax, ' ', '') 
                         + '@nextivafax.com' ELSE dbo.p21_view_contacts.email_address END AS EmailAddr, dbo.p21_view_contacts.direct_fax AS Fax, dbo.p21_view_contacts.fax_ext AS FaxExt, 
                         REPLACE(dbo.p21_view_contacts.direct_phone, ' ', '.') AS Phone, dbo.p21_view_contacts.phone_ext AS PhoneExt, '1' AS PrimaryContactFlag, dbo.p21_view_contacts.title, 
                         dbo.p21_view_address.mail_address1 AS AddrLine1, dbo.p21_view_address.mail_address2 AS AddrLine2, '' AS AddrLine3, '' AS AddrLine4, '' AS AddrLine5, 
                         dbo.p21_view_address.mail_city AS City, dbo.p21_view_address.mail_state AS State, dbo.p21_view_address.mail_postal_code AS PostalCode, dbo.p21_view_address.mail_country AS Country, '' AS UDF1, 
                         '' AS UDF2, '' AS UDF3, '' AS UDF4, '' AS UDF5, '' AS UDF6, '' AS UDF7, '' AS UDF8, '' AS UDF9, '' AS UDF10, dbo.p21_view_contacts.date_last_modified AS UpdateDate
FROM            dbo.p21_view_contacts INNER JOIN
                         dbo.p21_view_customer ON dbo.p21_view_contacts.id = dbo.p21_view_customer.bill_to_contact_id INNER JOIN
                         dbo.p21_view_address ON dbo.p21_view_contacts.address_id = dbo.p21_view_address.id
WHERE        (dbo.p21_view_contacts.delete_flag = 'N') AND (dbo.p21_view_customer.delete_flag = 'N') AND (dbo.p21_view_customer.bill_to_contact_id IS NOT NULL)
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[15] 2[17] 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 = "contacts"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 135
               Right = 282
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "customer"
            Begin Extent = 
               Top = 138
               Left = 38
               Bottom = 267
               Right = 314
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "address"
            Begin Extent = 
               Top = 6
               Left = 320
               Bottom = 135
               Right = 572
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 11
         Width = 284
         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 = 1815
         Alias = 2160
         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'vatcImportCUSTCONTACT'
GO

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


