PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Collapse]Personnel
    [Expand]Employee Files
    [Expand]Calendars
    [Collapse]Employment
     [Expand]Employment Settings
     [Expand]Examples of Use of Employment Module
     [Collapse]Employee Files
      [Expand]Absence
      [Collapse]General
       [Collapse]General
         Entering Suffix for Employee
         Entering Place of Residence
         Zamenjava šifre davčne izpostave z SQL stavkom
       [Expand]Employment Record
      [Expand]Taskbar in Employee Files
      [Expand]Position/Salary
      [Expand]Working Hours
     [Expand]Forms
    [Expand]Payroll
    [Expand]Travel Management
     Authorizations by employee status
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 531.2503 ms
"
   9444 | 10006 | 341173 | Published
Label

Zamenjava šifre davčne izpostave z SQL stavkom

Zamenjava šifre davčne izpostave z SQL stavkom

Zamenjava šifre davčne izpostave z SQL stavkom

10381.gif10411.gif10382.gif10383.gif
79176.gif Primer:

V Personalni mapi l Podatki o v polju ID za DDV  želimo vsem delavcem kateri imajo izbrano še staro šifro davčne izpostave npr. 0824 zamenjati z novo šifro davčne izpostave npr. 08000.

84469.jpg

 

V SQL Server Query Analyzerju zapišemo SQL:

Update thr_prsn set acTaxOffice = 'NOVA ŠIFRA'
Where acTaxOffice = 'STARA ŠIFRA'

 

kjer namesto 'NOVA ŠIFRA' vpišemo v našem primeru '08000' ter namesto 'STARA ŠIFRA' zapišemo '0824'

Izberemo še bazo na kateri želimo narediti zamenjavo davčnih izpostav (v našem primeru je to baza KONFERENCA) ter stisnemo gumb F5.

84470.jpg

 

Odpremo personalno mapo kje se nam bodo pri vseh delavcih kateri so imeli v polju ID za DDV izbrano šifro davčne izpostave 0824 zamenjala z novo šifro 08000.

84471.jpg

 

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!