--SQL script to convert from json to regular table
CREATE TABLE fisaip as (
        select
--json_each(c_json->'declaratieFisaIP') ,
(c_json->'declaratieFisaIP'->>'@an')::bigint as an,
(c_json->'declaratieFisaIP'->>'@luna')::bigint as luna,
(c_json->'declaratieFisaIP'->>'@totalPlata_A')::bigint as totalPlata_A,
(c_json->'declaratieFisaIP'->>'@d_rec')::bigint as d_rec,
(c_json->'declaratieFisaIP'->>'@tip_actiune')::bigint as tip_actiune,
c_json->'declaratieFisaIP'->>'@nume_ip' as nume_ip,
c_json->'declaratieFisaIP'->>'@nume_scurt_ip' as nume_scurt_ip,
(c_json->'declaratieFisaIP'->>'@cif')::bigint as cif,
(c_json->'declaratieFisaIP'->>'@cod_nom_categ_emit')::bigint as cod_nom_categ_emit,
c_json->'declaratieFisaIP'->>'@nume_emitent' as nume_emitent,
(c_json->'declaratieFisaIP'->>'@cod_nom_categ_act')::bigint as cod_nom_categ_act,
c_json->'declaratieFisaIP'->>'@nume_act_emit' as nume_act_emit,
c_json->'declaratieFisaIP'->>'@data_inf' as data_inf,
(c_json->'declaratieFisaIP'->>'@cod_uat')::bigint as cod_uat,
(c_json->'declaratieFisaIP'->>'@cui_uat')::bigint as cui_uat,
(c_json->'declaratieFisaIP'->>'@cod_jud_uat')::bigint as cod_jud_uat,
(c_json->'declaratieFisaIP'->>'@cod_tip_uat')::bigint as cod_tip_uat,
c_json->'declaratieFisaIP'->>'@den_trez' as den_trez,
c_json->'declaratieFisaIP'->>'@cod_trez' as cod_trez,
c_json->'declaratieFisaIP'->>'@cod_trez_fiscal' as cod_trez_fiscal,
c_json->'declaratieFisaIP'->>'@mail_pub' as mail_pub,
c_json->'declaratieFisaIP'->>'@mail_coresp_1' as mail_coresp_1,
c_json->'declaratieFisaIP'->>'@mail_coresp_2' as mail_coresp_2,
(c_json->'declaratieFisaIP'->>'@tip_act')::bigint as tip_act,
c_json->'declaratieFisaIP'->>'@sect_spe' as sect_spe,
--- aSoc ----
c_json->'declaratieFisaIP'->'aSoc'->>'@nume_jud' as aSoc_nume_jud,
c_json->'declaratieFisaIP'->'aSoc'->>'@cod_jud' as aSoc_cod_jud,
c_json->'declaratieFisaIP'->'aSoc'->>'@den_loc' as aSoc_den_loc,
c_json->'declaratieFisaIP'->'aSoc'->>'@tip_a' as aSoc_tip_a,
c_json->'declaratieFisaIP'->'aSoc'->>'@den_a' as aSoc_den_a,
c_json->'declaratieFisaIP'->'aSoc'->>'@nr' as aSoc_nr,
c_json->'declaratieFisaIP'->'aSoc'->>'@bl' as aSoc_bl,
c_json->'declaratieFisaIP'->'aSoc'->>'@cp' as aSoc_cp,
c_json->'declaratieFisaIP'->'aSoc'->>'@tel' as aSoc_tel,
c_json->'declaratieFisaIP'->'aSoc'->>'@fax' as aSoc_fax,
-- aFis ---
c_json->'declaratieFisaIP'->'aFis'->>'@nume_jud' as aFis_nume_jud,
c_json->'declaratieFisaIP'->'aFis'->>'@cod_jud' as aFis_cod_jud,
c_json->'declaratieFisaIP'->'aFis'->>'@den_loc' as aFis_den_loc,
c_json->'declaratieFisaIP'->'aFis'->>'@tip_a' as aFis_tip_a,
c_json->'declaratieFisaIP'->'aFis'->>'@den_a' as aFis_den_a,
c_json->'declaratieFisaIP'->'aFis'->>'@nr' as aFis_nr,
c_json->'declaratieFisaIP'->'aFis'->>'@bl' as aFis_bl,
c_json->'declaratieFisaIP'->'aFis'->>'@cp' as aFis_cp,
c_json->'declaratieFisaIP'->'aFis'->>'@tel' as aFis_tel,
c_json->'declaratieFisaIP'->'aFis'->>'@fax' as aFis_fax,
--- aCoresp ----
c_json->'declaratieFisaIP'->'aCoresp'->>'@nume_jud' as aCoresp_nume_jud,
c_json->'declaratieFisaIP'->'aCoresp'->>'@cod_jud' as aCoresp_cod_jud,
c_json->'declaratieFisaIP'->'aCoresp'->>'@den_loc' as aCoresp_den_loc,
c_json->'declaratieFisaIP'->'aCoresp'->>'@tip_a' as aCoresp_tip_a,
c_json->'declaratieFisaIP'->'aCoresp'->>'@den_a' as aCoresp_den_a,
c_json->'declaratieFisaIP'->'aCoresp'->>'@nr' as aCoresp_nr,
c_json->'declaratieFisaIP'->'aCoresp'->>'@bl' as aCoresp_bl,
c_json->'declaratieFisaIP'->'aCoresp'->>'@cp' as aCoresp_cp,
c_json->'declaratieFisaIP'->'aCoresp'->>'@tel' as aCoresp_tel,
c_json->'declaratieFisaIP'->'aCoresp'->>'@fax' as aCoresp_fax,

c_json->'declaratieFisaIP'->'activFinProp' as activFinProp,
c_json->'declaratieFisaIP'->'sectorBugetar' as sectorBugetar

from fisaep_t_json limit 20000
)