Description |
Error SQL72014: .Net SqlClient Data Provider: Msg 209, Level 16, State 1, Procedure vyuARCustomer, Line 6 Ambiguous column name 'intPaymentMethodId'.
Error SQL72045: Script execution error. The executed script:
CREATE VIEW [dbo].[vyuARCustomer]
AS
SELECT Entity.intEntityId,
strPaymentMethod,
intPaymentMethodId,
Entity.strName,
CASE WHEN Cus.strCustomerNumber = '' THEN Entity.strEntityNo ELSE Cus.strCustomerNumber END AS strCustomerNumber,
Cus.strType,
EnPhoneNo.strPhone,
Loc.strAddress,
Loc.strCity,
Loc.strState,
Loc.strZipCode,
Cus.ysnActive,
Cus.intSalespersonId,
Cus.intCurrencyId,
Cus.intTermsId,
Loc.intShipViaId,
ShipToLoc.strLocationName AS strShipToLocationName,
ShipToLoc.strAddress AS strShipToAddress,
ShipToLoc.strCity AS strShipToCity,
ShipToLoc.strState AS strShipToState,
ShipToLoc.strZipCode AS strShipToZipCode,
ShipToLoc.strCountry AS strShipToCountry,
BillToLoc.strLocationName AS strBillToLocationName,
BillToLoc.strAddress AS strBillToAddress,
BillToLoc.strCity AS strBillToCity,
BillToLoc.strState AS strB
|