/**
* Do NOT access this view by this view name.  Instead, use the CustomerInformation synonym which will either
* point to this view or to the CustomerInformation_XLedger as appropriate for that system.
*/
create view [dbo].[CustomerInformation_Legacy]
(
    CustomerNumber,
    CustomerName,
    OnHold,
    NoCreditFlag,
    CreditLimit,
    Inactive,
    CustomerClass,
    City,
    [State],
    CustomerId,
    CustomerJoinField,
    Hold,
    TaxExempt
)
as
select
    CustomerNumber = Customer.CUSTNMBR,
    CustomerName = Customer.CUSTNAME,
    OnHold = case
        when Customer.HOLD = 1 and Customer.INACTIVE = 1 then 'On Hold, Inactive'
        when Customer.HOLD = 1 then 'On Hold'
        when Customer.INACTIVE = 1 then 'Inactive'
        else ''
    end,
    NoCreditFlag = convert( bit, case when Customer.CRLMTTYP = 0 then 1 else 0 end ),
    CreditLimit = convert( money, Customer.CRLMTAMT ),
    Inactive = convert( bit, Customer.INACTIVE ),
    CustomerClass = Customer.CUSTCLAS,
    City = Customer.City,
    [State] = Customer.[State],
    CustomerId = convert( int, null ),
    CustomerJoinField = Customer.CUSTNMBR,
    Hold = convert( bit, Customer.HOLD ),
    TaxExempt = Customer.TAXEXMT1
from RM00101_Synonym as Customer
GO
GRANT SELECT ON  [dbo].[CustomerInformation_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[CustomerInformation_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[CustomerInformation_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[CustomerInformation_Legacy] TO [MssExec]
GO