Script Booking No. Invoice dan Faktur Pajak

Script untuk booking nomor invoice dan nomor faktur pajak untuk nota manual

Scipt booking No. Invoice
SELECT *
FROM
    (SELECT nextval('invoice_generated_id_seq') col --1
    UNION SELECT nextval('invoice_generated_id_seq') --2
    UNION SELECT nextval('invoice_generated_id_seq') --3
    UNION SELECT nextval('invoice_generated_id_seq') --4
    UNION SELECT nextval('invoice_generated_id_seq') --5
    UNION SELECT nextval('invoice_generated_id_seq') --6
    UNION SELECT nextval('invoice_generated_id_seq') --7
    UNION SELECT nextval('invoice_generated_id_seq') --8
    UNION SELECT nextval('invoice_generated_id_seq') --9
    UNION SELECT nextval('invoice_generated_id_seq') --10
    ) t
ORDER BY t.col

Script booking No. Faktur Pajak
SELECT *
FROM
    (SELECT get_faktur_pajak_next_seq() col --1
    UNION SELECT get_faktur_pajak_next_seq() --2
    UNION SELECT get_faktur_pajak_next_seq() --3
    UNION SELECT get_faktur_pajak_next_seq() --4
    UNION SELECT get_faktur_pajak_next_seq() --5
    UNION SELECT get_faktur_pajak_next_seq() --6
    UNION SELECT get_faktur_pajak_next_seq() --7
    UNION SELECT get_faktur_pajak_next_seq() --8
    UNION SELECT get_faktur_pajak_next_seq() --9
    UNION SELECT get_faktur_pajak_next_seq() --10
    ) t
ORDER BY t.col