Pylon SQL - Κινήσεις Retail από POS ή PDA

retailentries_from_pos_or_pda.sql

SELECT
  heRetDocEntries.HEDOCCODE AS DocCode,
  heRetDocEntries.HEREFNUMBER AS RefNumber,
  heRetDocEntries.HEENTRYDATE AS EntryDate,
  heRetDocEntries.HETTOTALVAL AS Total,
  heRetDocEntries.HERETAILSTATION AS RetailStation,
  heResOrders.HEORDERNO AS OrderNo,
  heResServSections.HECODE AS ServingSectionCode,
  heResServSections.HENAME AS ServingSection,
  hePDARoles.HECODE AS PDACode,
  hePDARoles.HENAME AS PDAName,
  poUsers.POUSERNAME AS UserName,
  heBusinessUnits.HENAME AS BU
FROM heRetDocEntries
LEFT JOIN heResOrders
  ON heResOrders.HEID = heRetDocEntries.HERORDID
LEFT JOIN heResServSections
  ON heResServSections.HEID = heResOrders.HERSSSID
LEFT JOIN hePDARoles
  ON heResServSections.HEID = hePDARoles.HERSSSID
INNER JOIN poUsers
  ON heRetDocEntries.HECREATIONUSRSID = poUsers.POID
LEFT JOIN heBusinessUnits
  ON heRetDocEntries.HEBSUTID = heBusinessUnits.HEID