SHARE
TWEET

Untitled

a guest Aug 20th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT
  2. Item_Table.IItemID AS ItemID AS customer_pk,
  3. Item_Table.SFullDescription AS description,
  4. Category.ICatNodeID AS category,
  5.  
  6. Item_Table.SMainBarcode AS attributes__MainBarcode,
  7. Item_Table.BCoreRange AS attributes__CoreRange,
  8. Item_Table.SLabelDescription AS attributes__LabelDescription,
  9. Item_Table.CRetailValue AS attributes__RetailValue,
  10. price.ILocationID AS attributes__PriceTypeID,                                                          
  11. price.DTStart,
  12. price.DTFinish,
  13. price.BExpired AS attributes__Expired,
  14. price.CSellInc AS attributes__SellInc,
  15. price.DTLastModified
  16. stk.ILocationID AS attributes__LocationID,
  17. stk.DSoH AS attributes__SoH,
  18. stk.DHoldSoH AS attributes__HoldSoH,
  19. stk.IOnOrder AS attributes__OnOrder,
  20. stk.BStocked AS attributes__Stocked,
  21. stk.ISellMethodID AS attributes__SellMethodID,
  22. stk.DTLastModified,
  23. stk.ILastModifiedUserID AS attributes__LastModifiedUserID,
  24. stk.ILastModifiedRoleID AS attributes__LastModifiedRoleID
  25. location.SDescription AS attributes__LocDescription,
  26. location.SLocationCode AS attributes__LocationCode,
  27. loc2.ILocationID AS attributes__TargetStoreID,
  28. loc2.SLocationCode AS attributes__TargetStore,
  29. Brand.SDescription AS attributes__BrandDescription,
  30. Manufacturer.ISupplierID AS attributes__SupplierID,
  31. Manufacturer.SSupplierName AS attributes__SupplierName
  32. Merchandise.SDescription AS attributes__MerchandiseDescription,
  33. Range.SDescription AS attributes__RangeDescription,
  34. Range.SRangeCode AS attributes__RangeCode,
  35. SIZE.SDescription AS attributes__SizeDescription,
  36. SubRange.SDescription AS attributes__SubRangeDescription,
  37. Variety.SDescription AS attributes__VarietyDescription,
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top