Database view containing customer delivery method preference

Client wants to report on customer delivery method preference in the accounts receivable customers module

• Enterprise ERP any version

• SSRS reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Account Receivable Customers

The view database column overlay shows delivery method as derived

Preferred Delivery method for a customer is located in [AccountsReceivable].[CustomerDeliveryPreferences] and [AccountsReceivable].[CustomerDeliveryPreferenceDeliveryAddresses]

SELECT * 
FROM [AccountsReceivable].[CustomerDeliveryPreferences] AS CDP
JOIN [AccountsReceivable].[CustomerDeliveryPreferenceDeliveryAddresses] AS CDPA
ON CDP.Id = CustomerDeliveryPreferenceId
JOIN [AccountsReceivable].[CustomerDeliveryAddresses] AS CDA
ON CDA.CustomerId = CDP.CustomerId 
AND CDA.Id = CustomerDeliveryAddressId
JOIN [AccountsReceivableReportingServices].[CustomerAddresses]  AS A
ON A.AddressId = CustomerAddressId
AND A.CustomerNumber = CDP.CustomerId