PRODAT PUBLIC

h1. Nummernkreise

h2. Einstellen der Dokumentnummern

SELECT setval('auftg_ag_dokunr_seq', 25200000); -- Angebot/Auftragsnummer

SELECT setval('ldsdok_ld_dokunr_seq', 24200000); -- Bestellung

SELECT setval('auswlog_aw_dokunr_seq', 26200000); -- Auswärts

h2. Umstellen auf neue Nummernkreise

> Hinweis: aktuelle Quellen prüfen!

h3. Kundenanfrage

<pre><code class="sql">

UPDATE TSystem.numcircles SET nc_active = FALSE WHERE nc_ident = 'kanfrage';

INSERT INTO TSystem.numcircles (nc_ident, nc_description, nc_preselect, nc_num, nc_modulname, nc_checksql)

     VALUES ('kanfrage', 'Kundenanfragen', '''ANFK'' || to_char(current_date, ''YY'') || ''-'' || lpad(NC_NUM, 5, 0)', 0, 'TFormKundenAnfrage',

             'SELECT true FROM kundanfrage WHERE kanf_nr = :mynewchecknumber');

</code></pre>

h3. Angebot

<pre><code class="sql">

INSERT INTO TSystem.numcircles (nc_ident, nc_description, nc_preselect, nc_num, nc_modulname, nc_checksql)

     VALUES ('aauftg', 'Angebote', '''AN'' || to_char(current_date, ''YY'') || ''-'' || lpad(NC_NUM, TSystem.Settings__GetInteger(''auftg__ag_nr__numlength'', 5), 0)', 0, 'TFormAuftg',

            'SELECT true FROM auftg WHERE ag_astat = ''A'' AND ((ag_nr = :mynewchecknumber) OR (ag_nr = (:mynewchecknumber || ''.QS'')))');

</code></pre>

h3. Auftragsbestätigung

<pre><code class="sql">

UPDATE TSystem.numcircles SET nc_active = FALSE WHERE nc_ident = 'eauftg';

INSERT INTO TSystem.numcircles (nc_ident, nc_description, nc_preselect, nc_num, nc_modulname, nc_checksql)

     VALUES ('eauftg', 'Kundenaufträge', '''AG'' || to_char(current_date, ''YY'') || ''-'' || lpad(NC_NUM, 5, 0)', 0, 'TFormAuftg',

            'SELECT true FROM auftg WHERE ag_astat = ''E'' AND ((ag_nr = :mynewchecknumber) OR (ag_nr = (:mynewchecknumber || ''.QS'')))');

UPDATE TSystem.numcircles SET nc_active = FALSE WHERE nc_ident = 'rauftg';    

INSERT INTO TSystem.numcircles (nc_ident, nc_description, nc_preselect, nc_num, nc_modulname, nc_checksql)

     VALUES ('rauftg', 'Rahmenaufträge', '''RA'' || to_char(current_date, ''YY'') || ''-'' || lpad(NC_NUM, 5, 0)', 0, 'TFormAuftg',

            'SELECT true FROM auftg WHERE ag_astat = ''R'' AND (ag_nr = :mynewchecknumber)');

</code></pre>