Item Data

CREATE VIEW [dbo].[vw_inventInventTable] 
AS 
  SELECT 'INVENTTABLE_ABCCONTRIBUTIONMARGIN' = 
         it.abccontributionmargin, 
         'INVENTTABLE_ABCREVENUE' = it.abcrevenue, 
         'INVENTTABLE_ABCTIEUP' = it.abctieup, 
         'INVENTTABLE_ABCVALUE' = it.abcvalue, 
         'INVENTTABLE_ALCOHOLMANUFACTURERID_RU' = 
         it.alcoholmanufacturerid_ru, 
         'INVENTTABLE_ALCOHOLPRODUCTIONTYPEID_RU' = 
         it.alcoholproductiontypeid_ru, 
         'INVENTTABLE_ALCOHOLSTRENGTH_RU' = 
            it.alcoholstrength_ru, 
         'INVENTTABLE_ALTCONFIGID' = it.altconfigid, 
         'INVENTTABLE_ALTINVENTCOLORID' = 
         it.altinventcolorid, 
         'INVENTTABLE_ALTINVENTSIZEID' = it.altinventsizeid, 
         'INVENTTABLE_ALTINVENTSTYLEID' = 
         it.altinventstyleid, 
         'INVENTTABLE_ALTITEMID' = it.altitemid, 
         'INVENTTABLE_APPROXTAXVALUE_BR' = 
            it.approxtaxvalue_br, 
         'INVENTTABLE_ASSETGROUPID_RU' = it.assetgroupid_ru, 
         'INVENTTABLE_ASSETID_RU' = it.assetid_ru, 
         'INVENTTABLE_AUTOREPORTFINISHED' = 
            it.autoreportfinished, 
         'INVENTTABLE_BATCHMERGEDATECALCULATIONMETHOD' = 
         it.batchmergedatecalculationmethod, 
         'INVENTTABLE_BATCHNUMGROUPID' = it.batchnumgroupid, 
         'INVENTTABLE_BOMCALCGROUPID' = it.bomcalcgroupid, 
         'INVENTTABLE_BOMLEVEL' = it.bomlevel, 
         'INVENTTABLE_BOMMANUALRECEIPT' = 
         it.bommanualreceipt, 
         'INVENTTABLE_BOMUNITID' = it.bomunitid, 
         'INVENTTABLE_COMMISSIONGROUPID' = 
            it.commissiongroupid, 
         'INVENTTABLE_COSTGROUPID' = it.costgroupid, 
         'INVENTTABLE_COSTMODEL' = it.costmodel, 
         'INVENTTABLE_CREATEDBY' = it.createdby, 
         'INVENTTABLE_CREATEDDATETIME' = it.createddatetime, 
         'INVENTTABLE_CUSTOMSEXPORTTARIFFCODETABLE_IN' = 
         it.customsexporttariffcodetable_in, 
         'INVENTTABLE_CUSTOMSIMPORTTARIFFCODETABLE_IN' = 
         it.customsimporttariffcodetable_in, 
         'INVENTTABLE_DATAAREAID' = it.dataareaid, 
         'INVENTTABLE_DAXINTEGRATIONKEY' = 
            it.daxintegrationkey, 
         'INVENTTABLE_DEFAULTDIMENSION' = 
         it.defaultdimension, 
         'INVENTTABLE_DEL_CREATEDTIME' = it.del_createdtime, 
         'INVENTTABLE_DEL_MODIFIEDTIME' = 
         it.del_modifiedtime, 
         'INVENTTABLE_DENSITY' = it.density, 
         'INVENTTABLE_DEPTH' = it.depth, 
         'INVENTTABLE_EPCMANAGER' = it.epcmanager, 
         'INVENTTABLE_EXCEPTIONCODE_BR' = 
         it.exceptioncode_br, 
         'INVENTTABLE_EXCISETARIFFCODES_IN' = 
            it.excisetariffcodes_in, 
         'INVENTTABLE_EXIMPRODUCTGROUPTABLE_IN' = 
         it.eximproductgrouptable_in, 
         'INVENTTABLE_FISCALLIFOAVOIDCALC' = 
            it.fiscallifoavoidcalc, 
         'INVENTTABLE_FISCALLIFONORMALVALUE' = 
         it.fiscallifonormalvalue, 
         'INVENTTABLE_FISCALLIFONORMALVALUECALC' = 
         it.fiscallifonormalvaluecalc, 
         'INVENTTABLE_FORECASTDMPINCLUDE' = 
            it.forecastdmpinclude, 
         'INVENTTABLE_GROSSDEPTH' = it.grossdepth, 
         'INVENTTABLE_GROSSHEIGHT' = it.grossheight, 
         'INVENTTABLE_GROSSWIDTH' = it.grosswidth, 
         'INVENTTABLE_HEIGHT' = it.height, 
         'INVENTTABLE_ICMSONSERVICE_BR' = 
         it.icmsonservice_br, 
         'INVENTTABLE_INTRACODE' = it.intracode, 
         'INVENTTABLE_INTRASTATEXCLUDE' = 
         it.intrastatexclude, 
         'INVENTTABLE_INTRASTATPROCID_CZ' = 
            it.intrastatprocid_cz, 
         'INVENTTABLE_INTRAUNIT' = it.intraunit, 
         'INVENTTABLE_INVENTFISCALLIFOGROUP' = 
         it.inventfiscallifogroup, 
         'INVENTTABLE_INVENTPRODUCTTYPE_BR' = 
            it.inventproducttype_br, 
         'INVENTTABLE_ITEMBUYERGROUPID' = 
         it.itembuyergroupid, 
         'INVENTTABLE_ITEMDIMCOSTPRICE' = 
         it.itemdimcostprice, 
         'INVENTTABLE_ITEMID' = it.itemid, 
         'INVENTTABLE_ITEMPRICETOLERANCEGROUPID' = 
         it.itempricetolerancegroupid, 
         'INVENTTABLE_ITEMTAGGINGLEVEL' = 
         it.itemtagginglevel, 
         'INVENTTABLE_ITEMTYPE' = it.itemtype, 
         'INVENTTABLE_MARKUPCODE_RU' = it.markupcode_ru, 
         'INVENTTABLE_MATCHINGPOLICY' = it.matchingpolicy, 
         'INVENTTABLE_MINIMUMPALLETQUANTITY' = 
         it.minimumpalletquantity, 
         'INVENTTABLE_MODIFIEDBY' = it.modifiedby, 
         'INVENTTABLE_MODIFIEDDATETIME' = 
         it.modifieddatetime, 
         'INVENTTABLE_NAMEALIAS' = it.namealias, 
         'INVENTTABLE_NETWEIGHT' = it.netweight, 
         'INVENTTABLE_NGPCODESTABLE_FR' = 
         it.ngpcodestable_fr, 
         'INVENTTABLE_NRTAXGROUP_LV' = it.nrtaxgroup_lv, 
         'INVENTTABLE_ORIGCOUNTRYREGIONID' = 
            it.origcountryregionid, 
         'INVENTTABLE_ORIGCOUNTYID' = it.origcountyid, 
         'INVENTTABLE_ORIGSTATEID' = it.origstateid, 
         'INVENTTABLE_PACKAGINGGROUPID' = 
         it.packaginggroupid, 
         'INVENTTABLE_PACKING_RU' = it.packing_ru, 
         'INVENTTABLE_PALLETTAGGING' = it.pallettagging, 
         'INVENTTABLE_PARTITION' = it.partition, 
         'INVENTTABLE_PBAAUTOSTART' = it.pbaautostart, 
         'INVENTTABLE_PBAHIDEAPPROVAL' = it.pbahideapproval, 
         'INVENTTABLE_PBAHIDEDIALOG' = it.pbahidedialog, 
         'INVENTTABLE_PBAINVENTITEMGROUPID' = 
            it.pbainventitemgroupid, 
         'INVENTTABLE_PBAITEMAUTOGENERATED' = 
            it.pbaitemautogenerated, 
         'INVENTTABLE_PBAITEMCONFIGURABLE' = 
            it.pbaitemconfigurable, 
         'INVENTTABLE_PBAMANDATORYCONFIG' = 
            it.pbamandatoryconfig, 
         'INVENTTABLE_PDSBASEATTRIBUTEID' = 
            it.pdsbaseattributeid, 
         'INVENTTABLE_PDSBESTBEFORE' = it.pdsbestbefore, 
         'INVENTTABLE_PDSCWWMSMINIMUMPALLETQTY' = 
         it.pdscwwmsminimumpalletqty, 
         'INVENTTABLE_PDSCWWMSQTYPERLAYER' = 
            it.pdscwwmsqtyperlayer, 
         'INVENTTABLE_PDSCWWMSSTANDARDPALLETQTY' = 
         it.pdscwwmsstandardpalletqty, 
         'INVENTTABLE_PDSFREIGHTALLOCATIONGROUPID' = 
         it.pdsfreightallocationgroupid, 
         'INVENTTABLE_PDSITEMREBATEGROUPID' = 
            it.pdsitemrebategroupid, 
         'INVENTTABLE_PDSPOTENCYATTRIBRECORDING' = 
         it.pdspotencyattribrecording, 
         'INVENTTABLE_PDSSHELFADVICE' = it.pdsshelfadvice, 
         'INVENTTABLE_PDSSHELFLIFE' = it.pdsshelflife, 
         'INVENTTABLE_PDSTARGETFACTOR' = it.pdstargetfactor, 
         'INVENTTABLE_PDSVENDORCHECKITEM' = 
            it.pdsvendorcheckitem, 
         'INVENTTABLE_PHANTOM' = it.phantom, 
         'INVENTTABLE_PKWIUCODE_PL' = it.pkwiucode_pl, 
         'INVENTTABLE_PMFPLANNINGITEMID' = 
            it.pmfplanningitemid, 
         'INVENTTABLE_PMFPRODUCTTYPE' = it.pmfproducttype, 
         'INVENTTABLE_PMFYIELDPCT' = it.pmfyieldpct, 
         'INVENTTABLE_PRIMARYVENDORID' = it.primaryvendorid, 
         'INVENTTABLE_PRODFLUSHINGPRINCIP' = 
            it.prodflushingprincip, 
         'INVENTTABLE_PRODGROUPID' = it.prodgroupid, 
         'INVENTTABLE_PRODPOOLID' = it.prodpoolid, 
         'INVENTTABLE_PRODUCT' = it.product, 
         'INVENTTABLE_PROJCATEGORYID' = it.projcategoryid, 
         'INVENTTABLE_PROPERTYID' = it.propertyid, 
         'INVENTTABLE_PURCHMODEL' = it.purchmodel, 
         'INVENTTABLE_QTYPERLAYER' = it.qtyperlayer, 
         'INVENTTABLE_RECID' = it.recid, 
         'INVENTTABLE_RECVERSION' = it.recversion, 
         'INVENTTABLE_REQGROUPID' = it.reqgroupid, 
         'INVENTTABLE_SADRATECODE_PL' = it.sadratecode_pl, 
         'INVENTTABLE_SALESCONTRIBUTIONRATIO' = 
         it.salescontributionratio, 
         'INVENTTABLE_SALESMODEL' = it.salesmodel, 
         'INVENTTABLE_SALESPERCENTMARKUP' = 
            it.salespercentmarkup, 
         'INVENTTABLE_SALESPRICEMODELBASIC' = 
            it.salespricemodelbasic, 
         'INVENTTABLE_SCRAPCONST' = it.scrapconst, 
         'INVENTTABLE_SCRAPVAR' = it.scrapvar, 
         'INVENTTABLE_SERIALNUMGROUPID' = 
         it.serialnumgroupid, 
         'INVENTTABLE_SERVICECODETABLE_IN' = 
            it.servicecodetable_in, 
         'INVENTTABLE_SKIPINTRACOMPANYSYNC_RU' = 
         it.skipintracompanysync_ru, 
         'INVENTTABLE_SORTCODE' = it.sortcode, 
         'INVENTTABLE_STANDARDCONFIGID' = 
         it.standardconfigid, 
         'INVENTTABLE_STANDARDINVENTCOLORID' = 
         it.standardinventcolorid, 
         'INVENTTABLE_STANDARDINVENTSIZEID' = 
            it.standardinventsizeid, 
         'INVENTTABLE_STANDARDINVENTSTYLEID' = 
         it.standardinventstyleid, 
         'INVENTTABLE_STANDARDPALLETQUANTITY' = 
         it.standardpalletquantity, 
         'INVENTTABLE_STATISTICSFACTOR' = 
         it.statisticsfactor, 
         'INVENTTABLE_TARAWEIGHT' = it.taraweight, 
         'INVENTTABLE_TAXATIONORIGIN_BR' = 
            it.taxationorigin_br, 
         'INVENTTABLE_TAXFISCALCLASSIFICATION_BR' = 
         it.taxfiscalclassification_br, 
         'INVENTTABLE_TAXPACKAGINGQTY' = it.taxpackagingqty, 
         'INVENTTABLE_TAXSERVICECODE_BR' = 
            it.taxservicecode_br, 
         'INVENTTABLE_UNITVOLUME' = it.unitvolume, 
         'INVENTTABLE_USEALTITEMID' = it.usealtitemid, 
         'INVENTTABLE_WIDTH' = it.width, 
         'INVENTTABLE_WMSARRIVALHANDLINGTIME' = 
         it.wmsarrivalhandlingtime, 
         'INVENTTABLE_WMSPALLETTYPEID' = it.wmspallettypeid, 
         'INVENTTABLE_WMSPICKINGQTYTIME' = 
            it.wmspickingqtytime, 
         'prodTransl_DESCRIPTION' = prodTransl.description, 
         'prodTransl_LANGUAGEID' = prodTransl.languageid, 
         'prodTransl_MODIFIEDBY' = prodTransl.modifiedby, 
         'prodTransl_NAME' = prodTransl.NAME, 
         'prodTransl_PARTITION' = prodTransl.partition, 
         'prodTransl_PRODUCT' = prodTransl.product, 
         'prodTransl_RECID' = prodTransl.recid, 
         'prodTransl_RECVERSION' = prodTransl.recversion, 
         'invItemGroup_ITEMDATAAREAID' = 
            invItemGroup.itemdataareaid, 
         'invItemGroup_ITEMGROUPDATAAREAID' = 
         invItemGroup.itemgroupdataareaid, 
         'invItemGroup_ITEMGROUPID' = 
            invItemGroup.itemgroupid, 
         'invItemGroup_ITEMID' = 
         invItemGroup.itemid, 
         'invItemGroup_PARTITION' = invItemGroup.partition, 
         'invItemGroup_RECID' = invItemGroup.recid, 
         'invItemGroup_RECVERSION' = 
         invItemGroup.recversion, 
         'invModGroup_ITEMDATAAREAID' = 
            invModGroup.itemdataareaid, 
         'invModGroup_ITEMID' = invModGroup.itemid, 
         'invModGroup_MODELGROUPDATAAREAID' = 
         invModGroup.modelgroupdataareaid, 
         'invModGroup_MODELGROUPID' = 
            invModGroup.modelgroupid, 
         'invModGroup_PARTITION' = 
         invModGroup.partition, 
         'invModGroup_RECID' = invModGroup.recid, 
         'invModGroup_RECVERSION' = invModGroup.recversion, 
         'whsit_DATAAREAID' = whsit.dataareaid, 
         'whsit_FILTERCHANGED' = whsit.filterchanged, 
         'whsit_FILTERCODE' = whsit.filtercode, 
         'whsit_FILTERCODE2_' = whsit.filtercode2_, 
         'whsit_FILTERCODE3_' = whsit.filtercode3_, 
         'whsit_FILTERCODE4_' = whsit.filtercode4_, 
         'whsit_FILTERGROUP' = whsit.filtergroup, 
         'whsit_FILTERGROUP2_' = whsit.filtergroup2_, 
         'whsit_ITEMID' = whsit.itemid, 
         'whsit_MAXPICKQTY' = whsit.maxpickqty, 
         'whsit_MODIFIEDBY' = whsit.modifiedby, 
         'whsit_MODIFIEDDATETIME' = whsit.modifieddatetime, 
         'whsit_PACKAGECLASSID' = whsit.packageclassid, 
         'whsit_PACKSIZECATEOGRYID' = 
            whsit.packsizecateogryid, 
         'whsit_PARTITION' = whsit.partition, 
         'whsit_PHYSDIMID' = whsit.physdimid, 
         'whsit_PICKWCNEG' = whsit.pickwcneg, 
         'whsit_PRODQTY' = whsit.prodqty, 
         'whsit_RECID' = whsit.recid, 
         'whsit_RECVERSION' = whsit.recversion, 
         'whsit_RFDESCRIPTION1' = whsit.rfdescription1, 
         'whsit_RFDESCRIPTION2' = whsit.rfdescription2, 
         'whsit_UOMSEQGROUPID' = whsit.uomseqgroupid, 
         'purch_ALLOCATEMARKUP' = purch.allocatemarkup, 
         'purch_CREATEDBY' = purch.createdby, 
         'purch_CREATEDDATETIME' = purch.createddatetime, 
         'purch_DATAAREAID' = purch.dataareaid, 
         'purch_DEL_CREATEDTIME' = purch.del_createdtime, 
         'purch_DEL_MODIFIEDTIME' = purch.del_modifiedtime, 
         'purch_ENDDISC' = purch.enddisc, 
         'purch_INTERCOMPANYBLOCKED' = 
            purch.intercompanyblocked, 
         'purch_ITEMID' = purch.itemid, 
         'purch_LINEDISC' = purch.linedisc, 
         'purch_MARKUP' = purch.markup, 
         'purch_MARKUPGROUPID' = purch.markupgroupid, 
         'purch_MARKUPSECCUR_RU' = purch.markupseccur_ru, 
         'purch_MAXIMUMRETAILPRICE_IN' = 
            purch.maximumretailprice_in, 
         'purch_MODIFIEDBY' = purch.modifiedby, 
         'purch_MODIFIEDDATETIME' = purch.modifieddatetime, 
         'purch_MODULETYPE' = purch.moduletype, 
         'purch_MULTILINEDISC' = purch.multilinedisc, 
         'purch_OVERDELIVERYPCT' = purch.overdeliverypct, 
         'purch_PARTITION' = purch.partition, 
         'purch_PDSPRICINGPRECISION' = 
            purch.pdspricingprecision, 
         'purch_PRICE' = purch.price, 
         'purch_PRICEDATE' = purch.pricedate, 
         'purch_PRICEQTY' = purch.priceqty, 
         'purch_PRICESECCUR_RU' = purch.priceseccur_ru, 
         'purch_PRICEUNIT' = purch.priceunit, 
         'purch_RECID' = purch.recid, 
         'purch_RECVERSION' = purch.recversion, 
         'purch_SUPPITEMGROUPID' = purch.suppitemgroupid, 
         'purch_TAXITEMGROUPID' = purch.taxitemgroupid, 
         'purch_TAXWITHHOLDCALCULATE_TH' = 
         purch.taxwithholdcalculate_th, 
         'purch_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         purch.taxwithholditemgroupheading_th, 
         'purch_UNDERDELIVERYPCT' = purch.underdeliverypct, 
         'purch_UNITID' = purch.unitid, 
         'sales_ALLOCATEMARKUP' = sales.allocatemarkup, 
         'sales_CREATEDBY' = sales.createdby, 
         'sales_CREATEDDATETIME' = sales.createddatetime, 
         'sales_DATAAREAID' = sales.dataareaid, 
         'sales_DEL_CREATEDTIME' = sales.del_createdtime, 
         'sales_DEL_MODIFIEDTIME' = sales.del_modifiedtime, 
         'sales_ENDDISC' = sales.enddisc, 
         'sales_INTERCOMPANYBLOCKED' = 
            sales.intercompanyblocked, 
         'sales_ITEMID' = sales.itemid, 
         'sales_LINEDISC' = sales.linedisc, 
         'sales_MARKUP' = sales.markup, 
         'sales_MARKUPGROUPID' = sales.markupgroupid, 
         'sales_MARKUPSECCUR_RU' = sales.markupseccur_ru, 
         'sales_MAXIMUMRETAILPRICE_IN' = 
            sales.maximumretailprice_in, 
         'sales_MODIFIEDBY' = sales.modifiedby, 
         'sales_MODIFIEDDATETIME' = sales.modifieddatetime, 
         'sales_MODULETYPE' = sales.moduletype, 
         'sales_MULTILINEDISC' = sales.multilinedisc, 
         'sales_OVERDELIVERYPCT' = sales.overdeliverypct, 
         'sales_PARTITION' = sales.partition, 
         'sales_PDSPRICINGPRECISION' = 
            sales.pdspricingprecision, 
         'sales_PRICE' = sales.price, 
         'sales_PRICEDATE' = sales.pricedate, 
         'sales_PRICEQTY' = sales.priceqty, 
         'sales_PRICESECCUR_RU' = sales.priceseccur_ru, 
         'sales_PRICEUNIT' = sales.priceunit, 
         'sales_RECID' = sales.recid, 
         'sales_RECVERSION' = sales.recversion, 
         'sales_SUPPITEMGROUPID' = sales.suppitemgroupid, 
         'sales_TAXITEMGROUPID' = sales.taxitemgroupid, 
         'sales_TAXWITHHOLDCALCULATE_TH' = 
         sales.taxwithholdcalculate_th, 
         'sales_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         sales.taxwithholditemgroupheading_th, 
         'sales_UNDERDELIVERYPCT' = sales.underdeliverypct, 
         'sales_UNITID' = sales.unitid, 
         'invent_ALLOCATEMARKUP' = invent.allocatemarkup, 
         'invent_CREATEDBY' = invent.createdby, 
         'invent_CREATEDDATETIME' = invent.createddatetime, 
         'invent_DATAAREAID' = invent.dataareaid, 
         'invent_DEL_CREATEDTIME' = invent.del_createdtime, 
         'invent_DEL_MODIFIEDTIME' = 
         invent.del_modifiedtime, 
         'invent_ENDDISC' = invent.enddisc, 
         'invent_INTERCOMPANYBLOCKED' = 
            invent.intercompanyblocked, 
         'invent_ITEMID' = invent.itemid, 
         'invent_LINEDISC' = invent.linedisc, 
         'invent_MARKUP' = invent.markup, 
         'invent_MARKUPGROUPID' = invent.markupgroupid, 
         'invent_MARKUPSECCUR_RU' = invent.markupseccur_ru, 
         'invent_MAXIMUMRETAILPRICE_IN' = 
         invent.maximumretailprice_in, 
         'invent_MODIFIEDBY' = invent.modifiedby, 
         'invent_MODIFIEDDATETIME' = 
         invent.modifieddatetime, 
         'invent_MODULETYPE' = 
         invent.moduletype, 
         'invent_MULTILINEDISC' = invent.multilinedisc, 
         'invent_OVERDELIVERYPCT' = invent.overdeliverypct, 
         'invent_PARTITION' = invent.partition, 
         'invent_PDSPRICINGPRECISION' = 
            invent.pdspricingprecision, 
         'invent_PRICE' = invent.price, 
         'invent_PRICEDATE' = invent.pricedate, 
         'invent_PRICEQTY' = invent.priceqty, 
         'invent_PRICESECCUR_RU' = invent.priceseccur_ru, 
         'invent_PRICEUNIT' = invent.priceunit, 
         'invent_RECID' = invent.recid, 
         'invent_RECVERSION' = invent.recversion, 
         'invent_SUPPITEMGROUPID' = invent.suppitemgroupid, 
         'invent_TAXITEMGROUPID' = invent.taxitemgroupid, 
         'invent_TAXWITHHOLDCALCULATE_TH' = 
         invent.taxwithholdcalculate_th, 
         'invent_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         invent.taxwithholditemgroupheading_th, 
         'invent_UNDERDELIVERYPCT' = 
         invent.underdeliverypct, 
         'invent_UNITID' = invent.unitid 
  FROM   inventtable AS it 
         JOIN ecoresproducttranslation AS prodTransl 
           ON prodTransl.partition = it.partition 
              AND prodTransl.product = it.product 
              AND prodTransl.languageid = 'EN-US' 
         JOIN inventitemgroupitem AS invItemGroup 
           ON invItemGroup.partition = it.partition 
              AND invItemGroup.itemid = it.itemid 
              AND invItemGroup.itemdataareaid = 
                  it.dataareaid 
         JOIN inventmodelgroupitem AS invModGroup 
           ON invModGroup.partition = it.partition 
              AND invModGroup.itemid = it.itemid 
              AND invModGroup.itemdataareaid = it.dataareaid 
         JOIN whsinventtable whsit 
           ON whsit.itemid = it.itemid 
              AND whsit.partition = it.partition 
              AND whsit.dataareaid = it.dataareaid 
         JOIN inventtablemodule purch 
           ON purch.moduletype = 1 
              AND purch.itemid = it.itemid 
              AND purch.dataareaid = it.dataareaid 
              AND purch.partition = it.partition 
         JOIN inventtablemodule sales 
           ON sales.moduletype = 2 
              AND sales.itemid = it.itemid 
              AND sales.dataareaid = it.dataareaid 
              AND sales.partition = it.partition 
         JOIN inventtablemodule Invent 
           ON invent.moduletype = 0 
              AND invent.itemid = it.itemid 
              AND invent.dataareaid = it.dataareaid 
              AND invent.partition = it.partition 

go