Dynamics Community Forum Thread Details

econnect requester

Hello,

am working with econnect_out_setup table and econnect requester

am inserting new columns in econnect_out_setup and creating trigger in econnect requester

it's working fine for first line but getting issue with trigger column in join row

please suggest me what wrong i did

insert into eConnect_Out_Setup(DOCTYPE,MAIN,PARENTLEVEL,ORDERBY,INDEX1,INDEXCNT,TRIGGER1,TRIGGERCNT,TABLENAME,ALIAS,
    DATACNT,DATA1,DATA2,DATA3,DATA4)
select
    'PriceBook',1,0,1,'PRCBKID',1,'PRCBKID',1,'SOP10109','PriceBook',4,
   'DESCEXPR','ISBASE','NOTEINDX','DEX_ROW_ID'
GO

insert into eConnect_Out_Setup(DOCTYPE,MAIN,PARENTLEVEL,ORDERBY,INDEX1,INDEX2,INDEX3,INDEXCNT,TRIGGER1,TRIGGERCNT,TABLENAME,ALIAS,JOINTABLE,JOIN1,JOINTO1,
    DATACNT,DATA1,DATA2,DATA3)
select
    'PriceBook',2,1,1,'PRCSHID','LINKCODE','SEQNUMBR',3,'SEQNUMBR',1,'RM00500','AssignedSheets','SOP10109','LINKCODE','PRCBKID',3,
   'PRODTCOD','DEX_ROW_ID','PSSEQNUM'
GO

insert into eConnect_Out_Setup(DOCTYPE,MAIN,PARENTLEVEL,ORDERBY,INDEX1,INDEXCNT,TABLENAME,ALIAS,JOINTABLE,JOIN1,JOINTO1,
    DATACNT,DATA1,DATA2,DATA3,DATA4,DATA5,DATA6,DATA7,DATA8,DATA9)
select
    'PriceBook',3,2,1,'PRCSHID',1,'SOP10110','SheetDetails','RM00500','PRCSHID','PRCSHID',9,
   'DESCEXPR','NTPRONLY','ACTIVE','STRTDATE','ENDDATE','NOTEINDX','PROMO','CURNCYID','DEX_ROW_ID'
GO