Sorry "No the AllFieldsList property does bot show it as a property" Should have said that reselller is not a member of AllFieldsList . The AllFieldsList has 22 memebers of which reselller is not one. There are 24 variables in the stored proc @Customer_UID_ORGPK and @reseller are added for strataframe |
CREATE PROCEDURE UDSP_Customers_Update
(
@Customer_UID uniqueidentifier ,
@CustomerName varchar(50) = NULL,
@CustomerStreet varchar(50) = NULL,
@CustomerStreet2 varchar(50) = NULL,
@CustomerCity varchar(32) = NULL,
@CustomerState char(2) = NULL,
@CustomerZIP varchar(9) = NULL,
@LCon_Name varchar(50) = NULL,
@LCon_Phone varchar(20) = NULL,
@LCon_Ext varchar(4) = NULL,
@LCon_Mobile varchar(20) = NULL,
@LCon_Fax varchar(20) = NULL,
@LCon_EmailAddr varchar(80) = NULL,
@Status char(16) = NULL,
@DealerNum char(7) = NULL,
@ODNum char(7) = NULL,
@OD2Num char(7) = NULL,
@UpdatedBy varchar(16) ,
@CreatedBy varchar(16) = NULL,
@Updateddt datetime = NULL,
@Createddt datetime = NULL,
@Customer_UID_ORGPK uniqueidentifier = NULL,
@Reseller_UID uniqueidentifier = NULL,
-- bellow added for sf
@reseller varchar(16) = NULL
)
AS