CAO - FAKTURA

Code: Alles auswählen

select
J.TERM_ID,J.MA_ID,J.REC_ID,J.ASP_ID,J.QUELLE,J.QUELLE_SUB,J.ADDR_ID,J.LIEF_ADDR_ID,
J.VRENUM,J.VLSNUM,J.KM_STAND,J.KFZ_ID,J.VERTRETER_ID,J.GLOBRABATT,
J.RDATUM,J.LDATUM,J.TERMIN,J.LIEFART,J.ZAHLART,J.GEWICHT,J.LOHN,J.WARE,J.ROHGEWINN,J.TKOST,
J.MWST_0,J.MWST_1,J.MWST_2,J.MWST_3,
J.NSUMME,J.NSUMME_0,J.NSUMME_1,J.NSUMME_2,J.NSUMME_3,
J.MSUMME,J.MSUMME_0,J.MSUMME_1,J.MSUMME_2,J.MSUMME_3,
J.BSUMME,J.BSUMME_0,J.BSUMME_1,J.BSUMME_2,J.BSUMME_3,
J.PROVIS_WERT,J.WAEHRUNG,J.KURS,J.GEGENKONTO,J.AUSLAND_TYP,
J.SOLL_STAGE,J.SOLL_SKONTO,J.SOLL_STAGE,J.SOLL_NTAGE,J.SOLL_RATEN,J.SOLL_RATINTERVALL,SOLL_RATBETR,
J.ERSTELLT,J.ERST_NAME,
J.KUN_NUM,J.KUN_ANREDE,J.KUN_NAME1,J.KUN_NAME2,J.KUN_NAME3,J.KUN_ABTEILUNG,J.KUN_STRASSE,
IFNULL(L.POST_CODE,J.KUN_LAND) as KUN_LAND,
J.KUN_LAND as KUN_LAND2,
L.FORMAT as ADRESS_FORMAT,
L.NAME as KUN_LAND_LANG, L.EU_LAND as EU_LAND,
J.KUN_PLZ,J.KUN_ORT,
J.USR1,J.USR2,J.KOPFTEXT,J.FUSSTEXT,J.PROJEKT,J.ORGNUM,J.BEST_NAME,J.BEST_CODE,J.BEST_DATUM,J.INFO,
J.PRINT_FLAG,J.BRUTTO_FLAG,J.MWST_FREI_FLAG,J.FREIGABE1_FLAG,
J.SHOP_ID,J.SHOP_ORDERID,J.SHOP_STATUS
from JOURNAL J
left outer JOIN LAND L on L.ID=J.KUN_LAND
where REC_ID=-1 and QUELLE=3 and QUELLE_SUB<>2