[{"compid":"","data":[{
"table" : "system.importfunctions",
"fields" : [
"uuid","sernr","tablename","importname","modulecode","comment","importformat","activeflag","newrecordatfield","newrecordatrowcount","maxrowsforimpdata","template","templatename","execflag","timestampfield","saveimportrec","skipokedupdate","attachrecordlink","setcolour","delimiter","encoding","lastupdatetime","lastupdateuser","importcomment","runworkflow"
],
"data" : [
["deb5eff2-5ab51f66-ba74ede7-77dc8f65-91bb7a58","9","finance.transactions","Z atskai\u0161u datu imports*","modnl","Dienas ie\u0146\u0113mumu (Z atskaites) datu imports","4","1","reference","","","","","3","","","1","","orange","","","2023-10-23T14:52:27","5","Import\u0113jams, aizpild\u012bts XLSX fails ko var ieg\u016bt help.moneo.lv m\u0101jaslap\u0101 vai mod.Sist\u0113ma/iest.Importa\nfunkacijas, ieraksta \"Skaidras naudas ie\u0146\u0113mumu kas\u0113 (Z atskaites) datu imports\" piesaist\u0146u log\u0101.\n\nTiks import\u0113tas t\u0101das excel faila rindas, kur\u0101s kolonn\u0101 \"Kop\u0101\" (F kolonna) summa b\u016bs liel\u0101ka k\u0101 0\nKolonna G noteiks Elektronisk\u0101 kases apar\u0101ta gr\u0101matved\u012bbas kontu. \u0160\u012b v\u0113rt\u012bba (EKA1) tiks mekl\u0113ta \nDar\u012bjuma veidos (ie\u0146\u0113mumi) un no t\u0101 atgriez\u012bs Kontu\n\nFail\u0101\nDatuma form\u0101ts: DD.MM.GGGG, kur D-diena, M-m\u0113nesis, G-gads\nP\u0101rliecinies, ka visu dar\u012bjumu p\u0113c PVN likm\u0113m kopsummas sakr\u012bt ar nor\u0113\u0137inu (skaidras naudas un \nbezskaidras naudas) kopsummu, cit\u0101di min\u0113t\u0101 importa funkcija neieg\u016bs vienlielas Debeta un Kred\u012bta \nv\u0113rt\u012bbas un gr\u0101matojumu neizveidos. P\u0101rliecinies, ka katra dar\u012bjuma p\u0113c PVN likm\u0113m \nKopsumma ir vien\u0101da ar Summa bez PVN un PVN summa kopsumma.\n\nSist\u0113m\u0101 j\u0101b\u016bt:\nmod.Finanses/iest.Gr\u0101matojumu klases  ZATS- Z atskaites ie\u0146\u0113mumu gr\u0101matojums\nmod.Sist\u0113ma/iest.Konvert\u0101cijas tabula ZATS_POS_KONTS, kur\u0101 vecais kods ir faila kolonnas G v\u0113rt\u012bba\nmod.Realiz\u0101cija/iest.Dar\u012bjuma veidi ar t\u0101du kodu, k\u0101ds uzr\u0101d\u012bs import\u0113jam\u0101 faila G kolonn\u0101\n\nTiks import\u0113ti pirm\u0101s izkl\u0101jlapas dati.",""]

]
}
,
{
"table" : "system.importfunctions_fields_rows",
"fields" : [
"_sernr","_rownr","path","field","expression","attribute","element_type","data_type","donot_store_field"
],
"data" : [
["9","0","","t_transdate","","1","","4",""],
["9","1","","t_reportnr","","2","","3",""],
["9","2","","t_gt","","3","","",""],
["9","3","","t_paycash","","4","","2",""],
["9","4","","t_paycard","","5","","2",""],
["9","5","","t_paytot","","6","","2",""],
["9","6","","t_dealtype","","7","","",""],
["9","7","","t_0vatdealstot","","8","","2",""],
["9","8","","t_5vatdealstot","","9","","2",""],
["9","9","","t_5vatwithoutvat","","10","","2",""],
["9","10","","t_5vatcalcvat","","11","","2",""],
["9","11","","t_12vatdealstot","","12","","2",""],
["9","12","","t_12vatwithoutvat","","13","","2",""],
["9","13","","t_12vatcalcvat","","14","","2",""],
["9","14","","t_21vatdealstot","","15","","2",""],
["9","15","","t_21vatwithoutvat","","16","","2",""],
["9","16","","t_21vatcalcvat","","17","","2",""],
["9","17","","t_checkvalue","","","","2",""],
["9","18","","t_ekaaccnumber","","","","",""],
["9","19","","t_posaccnumber","","7","","",""],
["9","20","","transdate","","","","4",""],
["9","21","","comment","","","","",""],
["9","22","","reference","","","","",""],
["9","23","","transactionclass","","","","",""],
["9","24","","accounts.accnumber","","","","",""],
["9","25","","accounts.debval","","","","",""],
["9","26","","accounts.credval","","","","",""],
["9","27","","accounts.curdebval","","","","",""],
["9","28","","accounts.curcredval","","","","",""],
["9","29","","accounts.taxcode","","","","",""]

]
}
,
{
"table" : "system.importfunctions_postactions_rows",
"fields" : [
"_sernr","_rownr","action_type","param_name1","param_value1","param_name2","param_value2","param_name3","param_value3","param_name4","param_value4","param_name5","param_value5","param_name6","param_value6","param_name7","param_value7","param_name8","param_value8","param_name9","param_value9","param_name10","param_value10"
],
"data" : [
["9","0","11","Indeksu saraksts, (0,1,2,..-2,-1)","0,1,2","","","","","","","","","","","","","","","","","",""],
["9","1","4","Filtra nosac\u012bjums","t_paytot>0","","","","","","","","","","","","","","","","","",""],
["9","2","6","Uzst\u0101d\u012bt lauku","transdate","Izteiksme","t_transdate","","","","","","","","","","","","","","","",""],
["9","3","6","Uzst\u0101d\u012bt lauku","comment","Izteiksme","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","","","","","","","","","","","","","","","",""],
["9","4","6","Uzst\u0101d\u012bt lauku","reference","Izteiksme","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","","","","","","","","","","","","","","","",""],
["9","5","6","Uzst\u0101d\u012bt lauku","transactionclass","Izteiksme","\"ZATS\"","","","","","","","","","","","","","","","",""],
["9","6","6","Uzst\u0101d\u012bt lauku","t_ekaaccnumber","Izteiksme","_base.lookupdata(\"sales.dealtypes\",t_dealtype,\"corespacc\",\"code\")","","","","","","","","","","","","","","","",""],
["9","7","8","Lauks","t_posaccnumber","Konvert\u0101cijas tabula","ZATS_POS_KONTS","Nav atrasts v\u0113rt\u012bba","","","","","","","","","","","","","","",""],
["9","8","6","Uzst\u0101d\u012bt lauku","accounts.accnumber","Izteiksme","t_ekaaccnumber","","","","","","","","","","","","","","","",""],
["9","9","6","Uzst\u0101d\u012bt lauku","accounts.debval","Izteiksme","t_paytot","","","","","","","","","","","","","","","",""],
["9","10","6","Uzst\u0101d\u012bt lauku","accounts.curdebval","Izteiksme","t_paytot","","","","","","","","","","","","","","","",""],
["9","11","6","Uzst\u0101d\u012bt lauku","t_checkvalue","Izteiksme","t_paytot","","","","","","","","","","","","","","","",""],
["9","12","10","accounts.accnumber","\"6110\"","accounts.credval","t_0vatdealstot","accounts.curcredval","t_0vatdealstot","accounts.taxcode","\"B\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_0vatdealstot","transactionclass","\"ZATS\"","",""],
["9","13","10","accounts.accnumber","\"6110\"","accounts.credval","t_5vatwithoutvat","accounts.curcredval","t_5vatwithoutvat","accounts.taxcode","\"5\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_5vatwithoutvat","transactionclass","\"ZATS\"","",""],
["9","14","10","accounts.accnumber","\"5722\"","accounts.credval","t_5vatcalcvat","accounts.curcredval","t_5vatcalcvat","accounts.taxcode","\"5\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_5vatcalcvat","transactionclass","\"ZATS\"","",""],
["9","15","10","accounts.accnumber","\"6110\"","accounts.credval","t_12vatwithoutvat","accounts.curcredval","t_12vatwithoutvat","accounts.taxcode","\"12\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_12vatwithoutvat","transactionclass","\"ZATS\"","",""],
["9","16","10","accounts.accnumber","\"5722\"","accounts.credval","t_12vatcalcvat","accounts.curcredval","t_12vatcalcvat","accounts.taxcode","\"12\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_12vatcalcvat","transactionclass","\"ZATS\"","",""],
["9","17","10","accounts.accnumber","\"6110\"","accounts.credval","t_21vatwithoutvat","accounts.curcredval","t_21vatwithoutvat","accounts.taxcode","\"21\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_21vatwithoutvat","transactionclass","\"ZATS\"","",""],
["9","18","10","accounts.accnumber","\"5722\"","accounts.credval","t_21vatcalcvat","accounts.curcredval","t_21vatcalcvat","accounts.taxcode","\"21\"","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","t_checkvalue","t_21vatcalcvat","transactionclass","\"ZATS\"","",""],
["9","19","10","accounts.accnumber","t_ekaaccnumber","accounts.credval","t_paycard","accounts.curcredval","t_paycard","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","transactionclass","\"ZATS\"","t_checkvalue","t_paycard","","","",""],
["9","20","10","accounts.accnumber","t_posaccnumber","accounts.debval","t_paycard","accounts.curdebval","t_paycard","transdate","t_transdate","comment","\"Ie\u0146\u0113mumu gr\u0101matojums, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","reference","\"Z:\"+t_reportnr+\", GT \"+str(t_gt)+\", \"+datetostr(t_transdate,\"DD.MM.YYYY\")+\", \"+t_dealtype","transactionclass","\"ZATS\"","t_checkvalue","t_paycard","","","",""],
["9","21","4","Filtra nosac\u012bjums","t_checkvalue!=0","","","","","","","","","","","","","","","","","",""]

]
}

]}]