Nummernkreise¶

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

Umstellen auf neue Nummernkreise¶

Hinweis: aktuelle Quellen prüfen!

Kundenanfrage¶

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');

Angebot¶

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'')))');

Auftragsbestätigung¶

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)');