Dynamics Community Forum Thread Details

econnect_out_setup

Hello,

i am trying to setup new doctype in econnect_out_setup, but getting wrong data please check my below quires

what wrong i did

insert into eConnect_Out_Setup(DOCTYPE,MAIN,PARENTLEVEL,ORDERBY,INDEX1,INDEXCNT,TRIGGER1,TRIGGERCNT,TABLENAME,ALIAS,
    DATACNT,DATA1,DATA2,DATA3,DATA4,DATA5,DATA6,DATA7,DATA8,DATA9,DATA10)
select
    'PriseSheetTrigger',1,0,1,'PRCSHID',1,'PRCSHID',1,'IV10401','PriceSheet',10,
   'SEQNUMBR','EPITMTYP','ITEMNMBR','BRKPTPRC','ACTIVE','BASEUOFM','PRODTCOD','PROMOTYP','PROMOLVL','DEX_ROW_ID'
GO

insert into eConnect_Out_Setup(
DOCTYPE,MAIN,PARENTLEVEL,ORDERBY,INDEX1,INDEXCNT,TRIGGER1,TRIGGER2,TRIGGERCNT,TABLENAME,ALIAS,JOINTABLE,JOIN1,JOINTO1,
DATACNT,DATA1,DATA2,DATA3,DATA4,DATA5,DATA6,DATA7,DATA8,DATA9,DATA10)
select 'PriseSheetTrigger',2,1,1, 'PRCSHID',1,'ITEMNMBR','PRCSHID',2,'IV10402','SheetPrices','IV10401','ITEMNMBR','ITEMNMBR',
10,'ITEMNMBR','EPITMTYP','QTYFROM','QTYTO','PSITMVAL','EQUOMQTY','UOFM','QTYBSUOM','SEQNUMBR','DEX_ROW_ID' GO

Thanks,

Naresh.Sangana

Quick Links

Leaderboard