[{"compid":"","data":[{
"table" : "system.importfunctions",
"fields" : [
"uuid","createdtime","createduser","lastupdatetime","lastupdateuser","createddatasource","internalsyncstat","sernr","tablename","importname","modulecode","comment","importformat","activeflag","newrecordatfield","newrecordatrowcount","maxrowsforimpdata","template","templatename","execflag","timestampfield","saveimportrec","skipokedupdate","attachrecordlink","setcolour","delimiter","encoding","importcomment","runworkflow","runsecondaryimports","namespace"
],
"data" : [
["0a1e4d8e-5cfa1e1c-5d60449d-b6497a1e-b5176594","","","2023-08-25T18:30:35","5","","","10","cash.cashreceipts","Kases ie\u0146\u0113mumu orderu imports*","modcash","Skaidras naudas ie\u0146\u0113mumu kas\u0113 (Z atskaites) datu imports","4","1","refstr","","","","","0","","","1","","orange","","","Import\u0113jams, aizpild\u012bts XLSX fails ko var ieg\u016bt help.moneo.lv m\u0101jaslap\u0101 vai mod.Sist\u0113ma/iest.Importa funkacijas, 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 \"Skaidra nauda\" (D kolonna) summa b\u016bs liel\u0101ka k\u0101 0\n\nSist\u0113m\u0101 j\u0101b\u016bt:\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" : [
["10","0","","t_transdate","","1","","4",""],
["10","1","","t_reportnr","","2","","",""],
["10","2","","t_gt","","3","","",""],
["10","3","","t_paycash","","4","","2",""],
["10","4","","t_dealtype","","7","","3",""],
["10","5","","t_docuser","","19","","3",""],
["10","6","","t_custcode","","20","","3",""],
["10","7","","transdate","","","","",""],
["10","8","","comment","","","","",""],
["10","9","","refstr","","","","",""],
["10","10","","docuser","","","","",""],
["10","11","","custcode","","","","",""],
["10","12","","details.dealtype","","","","",""],
["10","13","","details.rowsum","","","","",""],
["10","14","","details.bankrowsum","","","","",""],
["10","15","","details.rowcomment","","","","",""]

]
}
,
{
"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" : [
["10","0","11","Indeksu saraksts, (0,1,2,..-2,-1)","0,1,2","","","","","","","","","","","","","","","","","",""],
["10","1","4","Filtra nosac\u012bjums","t_paycash>0","","","","","","","","","","","","","","","","","",""],
["10","2","6","Uzst\u0101d\u012bt lauku","transdate","Izteiksme","t_transdate","","","","","","","","","","","","","","","",""],
["10","3","6","Uzst\u0101d\u012bt lauku","comment","Izteiksme","\"Skaidras naudas ie\u0146\u0113mumi no \"+datetostr(t_transdate,\"DD.MM.YYYY\")","","","","","","","","","","","","","","","",""],
["10","4","6","Uzst\u0101d\u012bt lauku","refstr","Izteiksme","\"Skaidras naudas ie\u0146\u0113mumi no \"+datetostr(t_transdate,\"DD.MM.YYYY\")","","","","","","","","","","","","","","","",""],
["10","5","6","Uzst\u0101d\u012bt lauku","docuser","Izteiksme","_base.lookupdata(\"contacts.employeescontactpersons\",t_docuser,\"code\") if _base.lookupdata(\"contacts.employeescontactpersons\",t_docuser,\"code\") else \"\"","","","","","","","","","","","","","","","",""],
["10","6","6","Uzst\u0101d\u012bt lauku","custcode","Izteiksme","_base.lookupdata(\"contacts.customersemp\",t_custcode,\"code\") if _base.lookupdata(\"contacts.customersemp\",t_custcode,\"code\") else \"\"","","","","","","","","","","","","","","","",""],
["10","7","6","Uzst\u0101d\u012bt lauku","details.dealtype","Izteiksme","t_dealtype","","","","","","","","","","","","","","","",""],
["10","8","6","Uzst\u0101d\u012bt lauku","details.rowsum","Izteiksme","t_paycash","","","","","","","","","","","","","","","",""],
["10","9","6","Uzst\u0101d\u012bt lauku","details.bankrowsum","Izteiksme","t_paycash","","","","","","","","","","","","","","","",""],
["10","10","6","Uzst\u0101d\u012bt lauku","details.rowcomment","Izteiksme","\"Skaidras naudas ie\u0146\u0113mumi no EKA, Z:\"+t_reportnr+\", no \"+datetostr(transdate,\"DD.MM.YYYY\")","","","","","","","","","","","","","","","",""]

]
}

]}]