Last active
May 25, 2022 10:17
-
-
Save nikolasd/7af3cf2aebf8e22fc58beb0614951f05 to your computer and use it in GitHub Desktop.
Pylon SQL - Εύρεση αξιογράφων που δεν έχουν ενημερώσει σωστά τον κάτοχο
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Επιστρέφει τον κάτοχο, το αξιόγραφο, το παραστατικό πληρωμής | |
με το οποίο εκδόθηκε το αξιόγραφο και τον συναλλασόμενο | |
που αφορά το αξιόγραφο | |
*/ | |
SELECT | |
heBanknoteTrans.HEOWNERNAME, | |
heBanknotes.HECODE AS BankNote, | |
heBanknotes.HEBANKNOTENUM, | |
heBanknoteTrans.HEENDORSERNAME, | |
heBanknotes.HEVALUE, | |
heBanknotes.HEKIND, | |
heBanknoteTrans.HEOWNERCAT, | |
heBanknoteTrans.HEENDORSERCAT, | |
heBanknoteTrans.HEDATE, | |
heDocEntries.HEDOCCODE, | |
heFinancialEntries.HESPLRID, | |
heSuppliers.HECODE AS Supplier, | |
heSuppliers.HENAME | |
FROM heBanknoteTrans | |
INNER JOIN heBanknotes | |
ON heBanknotes.HECOMPID = heBanknoteTrans.HECOMPID | |
AND heBanknotes.HEID = heBanknoteTrans.HEBNKNID | |
INNER JOIN heFentLines | |
ON heFentLines.HEFENTID = heBanknoteTrans.HEFENTID | |
AND heFentLines.HEDENTID = heBanknoteTrans.HEDENTID | |
AND heFentLines.HEID = heBanknoteTrans.HEFENLID | |
AND heBanknotes.HECOMPID = heFentLines.HECOMPID | |
AND heBanknotes.HEID = heFentLines.HEBNKNID | |
INNER JOIN heFinancialEntries | |
ON heFinancialEntries.HEDENTID = heFentLines.HEDENTID | |
AND heFinancialEntries.HECOMPID = heFentLines.HECOMPID | |
AND heFinancialEntries.HEID = heFentLines.HEFENTID | |
INNER JOIN heDocEntries | |
ON heDocEntries.HEID = heFinancialEntries.HEDENTID | |
LEFT JOIN heSuppliers | |
ON heFinancialEntries.HESPLRID = heSuppliers.HEID | |
WHERE heBanknoteTrans.HEOWNERNAME IS NULL | |
AND heBanknotes.HEKIND = 1 -- Πληρωτέα | |
AND heBanknoteTrans.HEOWNERCAT = 5 -- Κάτοχος Πιστωτής | |
AND heBanknoteTrans.HEENDORSERCAT = 1 -- Εκδότης Εταιρία |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment