Item GTINs

CREATE VIEW [dbo].[vw_inventInventItemGTIN] 
AS 
  SELECT 'INVENTITEMGTIN_DATAAREAID' = iig.dataareaid, 
         'INVENTITEMGTIN_DEL_MODIFIEDTIME' = 
            iig.del_modifiedtime, 
         'INVENTITEMGTIN_DESCRIPTION' = iig.description, 
         'INVENTITEMGTIN_GLOBALTRADEITEMNUMBER' = 
         iig.globaltradeitemnumber, 
         'INVENTITEMGTIN_GTINSETUP' = iig.gtinsetup, 
         'INVENTITEMGTIN_INVENTDIMID' = iig.inventdimid, 
         'INVENTITEMGTIN_ITEMID' = iig.itemid, 
         'INVENTITEMGTIN_MODIFIEDBY' = iig.modifiedby, 
         'INVENTITEMGTIN_MODIFIEDDATETIME' = 
            iig.modifieddatetime, 
         'INVENTITEMGTIN_PARTITION' = iig.partition, 
         'INVENTITEMGTIN_RECID' = iig.recid, 
         'INVENTITEMGTIN_RECVERSION' = iig.recversion, 
         'INVENTITEMGTIN_UNITID' = iig.unitid, 
         '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, 
         'INVENTDIMCOMBINATION_CREATEDDATETIME' = 
            idc.createddatetime, 
         'INVENTDIMCOMBINATION_DATAAREAID' = idc.dataareaid, 
         'INVENTDIMCOMBINATION_DISTINCTPRODUCTVARIANT' = 
         idc.distinctproductvariant, 
         'INVENTDIMCOMBINATION_INVENTDIMID' = 
         idc.inventdimid, 
         'INVENTDIMCOMBINATION_ITEMID' = idc.itemid, 
         'INVENTDIMCOMBINATION_PARTITION' = idc.partition, 
         'INVENTDIMCOMBINATION_RECID' = idc.recid, 
         'INVENTDIMCOMBINATION_RECVERSION' = idc.recversion, 
         'INVENTDIMCOMBINATION_RETAILVARIANTID' = 
            idc.retailvariantid 
  FROM   inventitemgtin iig 
         INNER JOIN inventdim id 
                 ON id.inventdimid = iig.inventdimid 
                    AND id.dataareaid = iig.dataareaid 
                    AND id.partition = iig.partition 
         INNER JOIN inventtable it 
                 ON it.itemid = iig.itemid 
                    AND it.dataareaid = iig.dataareaid 
                    AND it.partition = iig.partition 
         LEFT JOIN inventdimcombination idc 
                ON idc.inventdimid = iig.inventdimid 
                   AND idc.itemid = iig.itemid 
                   AND idc.dataareaid = iig.dataareaid 
                   AND idc.partition = iig.partition 

go