select sku.ownerid, sku.fsl_tablecode, sku.sku, sku.skuid, sku.prodid, sku.mfrid, skuDesc, packSizeDesc, mfr_name, prd.shortdesc, prd.product, upc, scc14, master_gross_weight, master_gross_weight_unit, master_net_weight, master_unit_qty, master_unit_size, master_unit_size_measure, master_net_weight_unit, master_cube, master_unit_size_desc, master_height, master_width, master_length, pallet_tie, pallet_high, sku.internalnotes, sku.discontinued, sku.privateLabelType, dot.stockingStatus dotStockingStatus, dot.dotCode, sku.dst_id as privateLabelDstId, sku.foodservice_rewards, sku.star_awards, sku.value_plus, sku.cool_school, pkg.shelf_life, pkg.shelf_life_ambient, pkg.shelf_life_refrig, pkg.shelf_life_frozen, mfr.gs1_gln, pkg.kosher, pkg.kosher_comments, sku.opr_id, sku.productVideoURL, mfr.gs1_syncEnabled, sku.gs1_syncDate, sku.hasChildNutrition, 'Y' as gs1_syncEnabled, #dateformat(now(),"mm/dd/yyyy")# as gs1_syncDate, case when sku.focusproduct = 'y' or prd.focusproduct = 'y' then 'Y' else 'N' end as focusProduct from tbl_prd_skus sku with (nolock) left outer join tblmanufacturers mfr with (nolock) on mfr.mfr_id = sku.mfrid left outer join tbl_prd_products prd with (nolock) on prd.prodid = sku.prodid left outer join tbl_prd_packaging pkg with (nolock) on pkg.linkid = sku.skuid and pkg.linktype = 'sku' left outer join tbl_DOT_StockingStatus dot with (nolock) on dot.GTIN = pkg.scc14 where sku.skuid =
  • GTIN-12
    #qryChildSkuInfo.upc#
    •
  • GTIN-14
    #qryChildSkuInfo.scc14#
    •
  • Pack/Size
    #qryChildSkuInfo.master_unit_size_desc##qryChildSkuInfo.master_unit_qty#/#qryChildSkuInfo.master_unit_size# #qryChildSkuInfo.master_unit_size_measure#
  • Gross Weight
    #qryChildSkuInfo.master_gross_weight# #qryChildSkuInfo.master_gross_weight_unit#
  • Net Weight
    #qryChildSkuInfo.master_net_weight# #qryChildSkuInfo.master_net_weight_unit#
  • Cube Size
    #qryChildSkuInfo.master_cube#
  • Height
    #qryChildSkuInfo.master_Height#
  • Width
    #qryChildSkuInfo.master_Width#
  • Length
    #qryChildSkuInfo.master_Length#
  •  
     
    •