Cannot select a record in Item table (InventTable). Item number: , . The SQL database has issued an error.
 SQL error description: [Microsoft Business Solutions-Axapta] Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [] Error message []
 SQL statement: SELECT A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A.WIDTH,A.SALESMODEL,A.COSTGROUPID,A.REQGROUPID,A.PRIMARYVENDORID,A.NETWEIGHT,A.DEPTH,A.UNITVOLUME,A.BOMUNITID,A.DENSITY,A.DEL_SCRAPTYPEID,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.COSTMODEL,A.USEALTITEMID,A.ALTITEMID,A.INTRACODE,A.BOMMANUALCONSUMP,A.BOMMANUALRECEIPT,A.STOPEXPLODE,A.DEL_COVPERINVENTLOCATION,A.PHANTOM,A.INTRAUNIT,A.BOMLEVEL,A.BATCHNUMGROUPID,A.AUTOREPORTFINISHED,A.ORIGCOUNTRYID,A.STATISTICSFACTOR,A.DEL_CONFIGACTIVE,A.PRODPOOLID,A.ABCTIEUP,A.ABCREVENUE,A.ABCVALUE,A.ABCCONTRIBUTIONMARGIN,A.COMMISSIONGROUPID,A.DEL_BARCODE,A.DEL_BARCODETYPE,A.SALESPERCENTMARKUP,A.SALESCONTRIBUTIONRATIO,A.SALESPRICEMODELBASIC,A.MINAVERAGESETTLE,A.NAMEALIAS,A.PRODGROUPID,A.GROSSDEPTH,A.GROSSWIDTH,A.GROSSHEIGHT,A.SORTCODE,A.SERIALNUMGROUPID,A.DIMGROUPID,A.MODELGROUPID,A.ITEMBUYERGROUPID,A.TAXPACKAGINGQTY,A.DEL_TEMPLATE,A.ORIGSTATEID,A.STOPEXPLODEPRICE,A.TARAWEIGHT,A.PACKAGINGGROUPID,A.SCRAPVAR,A.SCRAPCONST,A.ITEMDIMCOMBINATIONAUTOCREATE,A.ITEMDIMCOSTPRICE,A.RIP_PRIMARYLOCATION,A.RIP_SECONDARYLOCATION,A.RIP_SECONDARYPRICEGROUPID,A.RIP_PRICEGROUPID,A.RIP_BUYINGNOTES,A.RIP_DISCONTINUED,A.RIP_INVENTHISTORYFUTURE,A.RIP_SELLINGSTATUS,A.EW_PO_UOM_TEXT,A.RIP_ABC,A.EW_GERMANY,A.EW_SERIALNUMBEREDITEM,A.EW_UNITTEXTPO,A.EW_UNITTEXTSO,A.RIP_SOWARNINGNOTE,A.EW_EXPLODE_BOM,A.EW_ABC_ADVERTISING,A.EW_FIRSTRECEIVED,A.EW_AUTOORDERING,A.EW_FORCASTERRORINDEX,A.EW_FIRSTSOLD,A.EW_PLANNINGEXCEPTION,A.EW_ITEMIMAGELINK,A.EW_BRANDID,A.EW_EXCLUDEFROMCALC,A.EW_RETAILMULTIPLIER,A.EW_BUSHDATAID,A.YS_WEEE,A.YS_EXPORTFORWEB,A.SRCM_ITEMSIZE,A.ISBOM,A.SRCM_COURIERSERVICELEVEL,A.SRCM_COURIERID,A.YS_BATT,A.YS_FIRSTCHAR,A.YS_BATTERYWEIGHT,A.YS_BATTERYTYPE,A.YS_WEEECATEGORYID,A.BOMMAIN,A.SRCM_POSTAGESCORE,A.BORDER,A.SRCM_IMPORTEDTEXT,A.SRCM_KEYWORDS,A.YS_MARKUP,A.SRCM_DEALS,A.SRCM_LABEL,A.WEB_SPARESCATEGORYID,A.UPGRADEID,A.SRCM_SHOWINSTOCK,A.SRCM_OVERRIDESTOCKSTATUS,A.WEBITEMNAME,A.RET_SALESCATEGORY,A.SRCM_DARRENAPPROVED,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECID,B.ITEMID,B.BRANDID,B.PICTUREFILEITEM,B.INSTRUCTIONSPDF,B.CATALOGUEPAGE,B.SPECINTABLE,B.ACTIVE,B.RANK,B.SPECIALPAGE,B.EW_SEARCH,B.RETAILPRICE,B.LASTCHECKED,B.DE_RETAILPRICE,B.DE_INSTRUCTIONSPDF,B.VIDEO_HTML,B.URL,B.PHOTOREQUIRED,B.SRCM_RRP,B.WEB_RRP,B.ITEMREPLACEMENT,B.DAMAGED,B.DAMAGEDPARENTID,B.RECID,B.SHORTDESCRIPTION,B.LONGDESCRIPTION FROM INVENTTABLE A(NOLOCK) ,EW_WEBITEMSDATA B(NOLOCK) WHERE ((A.DATAAREAID='rcd') AND ((( NOT ((A.RIP_SELLINGSTATUS=2)) AND NOT ((A.RIP_SELLINGSTATUS=3))) AND NOT ((A.RIP_SELLINGSTATUS=13))) AND NOT ((A.SRCM_DEALS=1)))) AND ((B.DATAAREAID='rcd') AND ((B.ITEMID='164072') AND (A.ITEMID=B.ITEMID))) ORDER BY A.DATAAREAID,A.ITEMID OPTION(FAST 4)
Slough Radio Control Models Slough Radio Control Models - Home
Home My Basket Checkout Account Help Login
See our Videos on YouTubeFollow us on TwitterLike us on FaceBookRead our Articles on Blogger
  
Search  First for Mail Order 
All Products > "164072 Multiplex RX XTAL CH 72 D/C"
SORT BY: 
 
 
  

 
  

 
 
  

Click here to see our contact details, a detailed map, and our in-store opening times.
Click on the image above to see our contact details, a detailed map, and our in-store opening times.