Comments (...)

SQL - POS/Sklad - hlavička dokladu - od verze 2016.12.11a

 

SELECT

 

  DruhDokladu,

  CisloDokladu,

  DatumDokladu,

 

  CASE WHEN (DatumDokladu IS NULL) THEN 0 ELSE EXTRACT( DAY FROM DatumDokladu ) END AS Den,

  CASE WHEN (DatumDokladu IS NULL) THEN 0 ELSE EXTRACT( MONTH FROM DatumDokladu ) END AS Mesic,

  CASE WHEN (DatumDokladu IS NULL) THEN 0 ELSE EXTRACT( YEAR FROM DatumDokladu ) END AS Rok,

 

  // EET

  CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

  CASE WHEN (POkres IS NULL) THEN 0 ELSE POkres END AS EET_CasMS,

  PuvodniDruhDokladu AS EET_IDPokl,

  KS AS EET_porad_cis,

  CASE WHEN (VetaPlatby4 IS NULL) THEN 0 ELSE VetaPlatby4/100.0 END AS EET_celk_trzba,

  CASE WHEN (UUctoval IS NULL) THEN 0 ELSE UUctoval/100.0 END AS EET_T_Zakl_DPH0,

  CASE WHEN (ULikvidoval IS NULL) THEN 0 ELSE ULikvidoval/100.0 END AS EET_T_Zakl_DPH1,

  CASE WHEN (UKontroloval IS NULL) THEN 0 ELSE UKontroloval/100.0 END AS EET_T_DPH1,

  CASE WHEN (Stredisko IS NULL) THEN 0 ELSE Stredisko/100.0 END AS EET_T_Zakl_DPH2,

  CASE WHEN (Zakazka IS NULL) THEN 0 ELSE Zakazka/100.0 END AS EET_T_DPH2,

  CASE WHEN (TypDokladuZauctovani IS NULL) THEN 0 ELSE TypDokladuZauctovani/100.0 END AS EET_T_Zakl_DPH3,

  CASE WHEN (Rozvoz IS NULL) THEN 0 ELSE Rozvoz/100.0 END AS EET_T_DPH3,

  CASE WHEN (VetaObjednavka IS NULL) THEN 0 ELSE VetaObjednavka/100.0 END AS EET_T_Urc_Cerp,

  CASE WHEN (VetaPlatby3 IS NULL) THEN 0 ELSE VetaPlatby3/100.0 END AS EET_T_Cerp_Zuct,

  CASE WHEN (StavPrenosu IS NULL) THEN 0 ELSE StavPrenosu END AS EET_Overeni,

  DatumExpedice AS EET_Datum,

  CASE WHEN (PCelekEU IS NULL) THEN 0 ELSE PCelekEU END AS EET_PocetOpakovaniOdeslani,

  DatumPosledniPenalizace AS EET_DatumEETOK,

  DatumPoslednihoSmiru AS EET_DatumEETNeodeslo,

  DatabazePlatby1+DatabazePlatby2+DatabazePlatby3+DatabazePlatby4 AS EET_DatumTrzby,

  BlobMEMO AS EET_BlobMemoUctenka,

 

  // plati pro POS doklady R1-8/O1-8/V1-8 - 987xx

  CASE WHEN (CastkaPlatby1 IS NULL) THEN 0 ELSE CastkaPlatby1 END AS POSCelkem98760,

  CASE WHEN (CastkaPlatby2 IS NULL) THEN 0 ELSE CastkaPlatby2 END AS POSCelkem98762,

  CASE WHEN (CastkaPlatby3 IS NULL) THEN 0 ELSE CastkaPlatby3 END AS POSCelkem98763,

  CASE WHEN (CastkaPlatby4 IS NULL) THEN 0 ELSE CastkaPlatby4 END AS POSCelkem98764,

  CASE WHEN (CastkaPlatby5 IS NULL) THEN 0 ELSE CastkaPlatby5 END AS POSCelkem98765,

  CASE WHEN (Osvobozeno IS NULL) THEN 0 ELSE Osvobozeno END AS POSCelkem98766,

  CASE WHEN (PKraj IS NULL) THEN 0 ELSE PKraj/100.0 END AS POSCelkem98767,

  CASE WHEN (CelkemCenaBezDPHTransfer IS NULL) THEN 0 ELSE CelkemCenaBezDPHTransfer END AS POSCelkem98769,

  CASE WHEN (Zaloha IS NULL) THEN 0 ELSE Zaloha END AS POSCelkem98770,

  CASE WHEN (CastkaPosledniPenalizace IS NULL) THEN 0 ELSE CastkaPosledniPenalizace END AS POSCelkem98771,

  CASE WHEN (CastkaPosledniUpominky IS NULL) THEN 0 ELSE CastkaPosledniUpominky END AS POSCelkem98772,

  CASE WHEN (Uvedouci IS NULL) THEN 0 ELSE Uvedouci/100.0 END AS POSCelkem98773,

  CASE WHEN (SlevaProc IS NULL) THEN 0 ELSE SlevaProc END AS POSCelkem98774,

  CASE WHEN (PocetPalet IS NULL) THEN 0 ELSE PocetPalet/1000.0 END AS POSCelkem98775,

 

  CASE WHEN (Z0 IS NULL) THEN 0 ELSE Z0 END,

  CASE WHEN (Z5 IS NULL) THEN 0 ELSE Z5 END AS Z1,

  CASE WHEN (Z22 IS NULL) THEN 0 ELSE Z22 END AS Z2,

  CASE WHEN (VetaLikvidace IS NULL) THEN 0 ELSE VetaLikvidace/100.0 END AS Z3,

  CASE WHEN (D5 IS NULL) THEN 0 ELSE D5 END AS D1,

  CASE WHEN (D22 IS NULL) THEN 0 ELSE D22 END AS D2,

  CASE WHEN (VetaZdroj IS NULL) THEN 0 ELSE VetaZdroj/100.0 END AS D3,

  CASE WHEN (Zaokrouhleni IS NULL) THEN 0 ELSE Zaokrouhleni END,

  CASE WHEN (SluzbyZ0 IS NULL) THEN 0 ELSE SluzbyZ0 END AS POSLahveCelkem,

  CASE WHEN (SluzbyZ5 IS NULL) THEN 0 ELSE SluzbyZ5 END AS POSZaokrouhleni,

  CASE WHEN (SluzbyZ22 IS NULL) THEN 0 ELSE SluzbyZ22 END AS POSCelkem,

  CASE WHEN (VyrobkyZ0 IS NULL) THEN 0 ELSE VyrobkyZ0 END AS POSZaplaceno,

  CASE WHEN (VyrobkyZ5 IS NULL) THEN 0 ELSE VyrobkyZ5 END AS POSVratit,

  CASE WHEN (VyrobkyZ22 IS NULL) THEN 0 ELSE VyrobkyZ22 END AS POSKreditPartnera,

  CASE WHEN (ObalyZ0 IS NULL) THEN 0 ELSE ObalyZ0 END AS POSCelkemZ0SeZaokrouhlenim,

  CASE WHEN (ObalyZ5 IS NULL) THEN 0 ELSE ObalyZ5 END AS POSCelkemZ1SeZaokrouhlenim,

  CASE WHEN (ObalyZ22 IS NULL) THEN 0 ELSE ObalyZ22 END AS POSCelkemZ2SeZaokrouhlenim,

  CASE WHEN (VratneObalyZ0 IS NULL) THEN 0 ELSE VratneObalyZ0 END AS POSCelkemZ0BezZaokrouhleni,

  CASE WHEN (VratneObalyZ5 IS NULL) THEN 0 ELSE VratneObalyZ5 END AS POSCelkemZ1BezZaokrouhleni,

  CASE WHEN (VratneObalyZ22 IS NULL) THEN 0 ELSE VratneObalyZ22 END AS POSCelkemZ2BezZaokrouhleni,

 

  CisloPartnera,

  NazevPartnera,

 

  DatumUskZdPl,

 

  VS,

 

  PICO,

 

  PObalySDPHOK AS PLZapsanoOK,

 

  VetaPlatby1/100.0 AS ObalyZ2,

  VetaPlatby2/100.0 AS ObalyD2,

 

  UTransfer AS CelkemFotografiiFILE01,

  DatumPlatby5 AS FILE01Datum,

  DatabazePlatby5 AS FILE01PuvodniDatabaze,

  VetaPlatby5 AS FILE01PuvodniVeta,

 

  UZavoznik/100.0 AS ZalohovaPlatba1Z1,

  UVyhotovil/100.0 AS ZalohovaPlatba1D1,

  USkladnik/100.0 AS ZalohovaPlatba1Z2,

  UPorizovac/100.0 AS ZalohovaPlatba1D2,

  UDispecer AS ZalohaVS,

  UPrepisovac AS ZalohaKc,

  UOsoba AS ZalohaDatum,

 

  Cinnost AS DatumGenerovaniAlkoholu,

 

  CastkaPoslednihoSmiru AS ZatizeniVP,

 

  TypUhrady AS PocetOdblokovaniDokladu,

 

  Stav AS UzavrenoJe1,

  Barva,

 

  DatumKursu AS CasServeruUzavreniDokladu,

  PuvodniDatabaze AS UzavreniDokladuVerzeProgramu,

  PuvodniVeta AS UzavreniDokladuUzivatel,

  PuvodniPC AS UzavreniDokladuPC,

 

  TiskOK,

  DatumPlatby1 AS CasTiskuNaTiskarnu,

  ZpusobPlatby2 AS TiskNaTiskarnuPC,

  ZpusobPlatby3 AS TiskNaTiskarnuUzivatel,

  DatumTisku,

 

  VetaUcto AS CelkemZboziZ3SeZaokrouhlenim,

  StavZauctovani AS CelkemZboziZ3BezZaokrouhleni,

  CelkemCenaBezDPH,

  CelkemCenaSDPH,

 

  ULikvidovalPlatbu1 AS Nakup1,

  ULikvidovalPlatbu2 AS Nakup2,

  ULikvidovalPlatbu3 AS Nakup3,

 

  UVychystavac2 AS CisloProdejny,

 

  UExpedient AS SlevaOzProc,

 

  DatabazeLikvidace AS CisloUzivatele,

 

  DatabazeZdroj AS VerzeProgramu,

 

  DatabazeUcto AS CisloInsertu,

 

  DatumSplatnosti AS DatumZpracovani,

 

  MistoZavozu AS EMail,

 

  CisloListu AS CisloDL,

 

  AgendaSklad,

  Agenda,

 

  Tonaz,

 

  ZpusobPlatby1 AS HO0PREV1ZAP2,

 

  ZpusobPlatby5 AS Mlecka1,

  ULikvidovalPlatbu5 AS CisloObjednavkyMlecka,

 

  ULikvidovalPlatbu4 AS PocetRadku,

 

  DatabazeRadky,

  DatabazeObraty,

  DatabazeObratyPrijem,

  DatabazeObjednavka,

  DatumObjednavky,

  CisloObjednavky,

 

  BlobMemoPoznamka,

  BlobMemoStav,

 

  DatumZpracovani,

  DatumPorizeni,

  DatumLikvidace,

  DatumServeru,

 

  PBankovniUcet,

  PKodBanky,

 

  PTypCeny,

  PCenovaSkupina,

 

  PObec,

  PPSC,

  PFakturacniMisto,

  PSkupina,

 

  Auto,

  RL,

  Soupis,

 

  PC,

  UUzivatel,

 

  ZmenaKod,

  ZmenaKdo,

  ZmenaPC,

  ZmenaPocet,

  ZmenaDatum,

  ZmenaDatumServer,

 

  URidic,

 

  UDealer,

  UVychystavac,

  UScaner,

 

  Poznamka,

 

  KoeficientCeny,

 

  TypDPH,

  TypCeny,

 

  ZavazekOK,

  PohledavkaOK,

 

  DatumPlatby2,

 

  DatumPlatby4 AS KurzEURDatum,

  Kurs AS KurzEUR,

 

  BlokovaniOK,

 

  PCelek AS CisloUzivatele,

 

  DatumPlatby3 AS Volne1_DateTime,

  ZpusobPlatby1 AS Volne2OK_Byte,

  ZpusobPlatby4 AS Volne3OK_Byte,

  SS AS Volne4_String10,

  Mena AS Volne5OK_String3,

  PuvodniStredisko AS Volne6_String2,

  DatumPosledniUpominky AS Volne7OK_DateTime,

  StavArchivace AS Volne9_Byte,

  CisloDokladuZauctovani AS Volne11_String16,

 

  DokladStornovanOK AS Volne8,

  ZasobyOK AS Volne12,

  RLOK AS Volne13,

  DanovyDokladOK AS Volne14,

  ExportOK AS Volne15,

  ImportOK AS Volne16,

  KontrolaRLOK AS Volne17,

  VPOK AS Volne18,

  SaldoOK AS Volne19

 

FROM

  XXG_X_R1

 

 

 

 

Comments (...)