GET
Získá kolekci BO Definice sloupců bilance
GET
Získá seznam položek BO, které mohou být chráněny na BO Definice sloupců bilance
GET
Získá pohled nad BO Definice sloupců bilance
GET
Získá daný BO Definice sloupců bilance
GET
Získá řádky kolekce Skupina definice sloupců
GET
Získá daný řádek kolekce Skupina definice sloupců
GET
Otestuje, zda existuje editační zámek na daném BO Definice sloupců bilance
GET
Získá seznam chráněných položek, které jsou na BO Definice sloupců bilance aktuálnímu uživateli znepřístupněny
GET
Získá řádky kolekce Řádek definice sloupců
GET
Získá daný řádek kolekce Řádek definice sloupců
GET
Získá seznam uživatelských parametrů včetně jejich hodnot k danému BO Definice sloupců bilance
POST
Vytvoří nový BO Definice sloupců bilance
POST
Vyhodnotí query dotaz nad BO Definice sloupců bilance
POST
Vytvoří nový řádek v kolekci Skupina definice sloupců
POST
Vytvoří nový řádek v kolekci Řádek definice sloupců
PUT
Modifikuje daný BO Definice sloupců bilance
PUT
Vytvoří editační zámek na daném BO Definice sloupců bilance
PUT
Zruší editační zámek na daném BO Definice sloupců bilance
PUT
Modifikuje řádek v kolekci Skupina definice sloupců
PUT
Modifikuje řádek v kolekci Řádek definice sloupců
DELETE
Smaže BO Definice sloupců bilance
DELETE
Smaže řádek z kolekce Skupina definice sloupců
DELETE
Smaže řádek z kolekce Řádek definice sloupců
Kód, pole vlastněné tabulkou, možné řadit a filtrovat
Sada datových zdrojů, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu
kolekce BO Skupina definice sloupců, pole je duplikováno při klonování objektu, objekt na který pole odkazuje je 'vlastněn'
Skrytý, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu
Název, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu
Verze objektu, pouze pro čtení, pole vlastněné tabulkou, možné řadit a filtrovat, pole nepodporuje ochranu dat/GDPR
kolekce BO Řádek definice sloupců, pole je duplikováno při klonování objektu, objekt na který pole odkazuje je 'vlastněn'
Nastavení, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu
Systémová, pole vlastněné tabulkou, možné řadit a filtrovat
ID třídy, pouze pro čtení, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR
Určení
Název, pouze pro čtení
Vlastní ID, pouze pro čtení, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR
GET
https://atd.abra.eu/demodata/scmcolumnsdefinitions?take=1
ResponseGET
https://atd.abra.eu/demodata/scmcolumnsdefinitions/{id}
{
"objversion": 1,
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"hidden": false,
"code": "Obchod",
"name": "Bilance pro obchodní firmy",
"datasourceset_id": "1000000000",
"system": true,
"setting_id": "1000000000",
"groups": []
}
POST
https://atd.abra.eu/demodata/query
{"class": "scmcolumnsdefinitions", "take": "1"}
POST
https://atd.abra.eu/demodata/scmcolumnsdefinitions/query
{"take": "1"}
Response
{
"objversion": 1,
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"hidden": false,
"code": "Obchod",
"name": "Bilance pro obchodní firmy",
"datasourceset_id": "1000000000",
"system": true,
"setting_id": "1000000000",
"groups": []
}
BodyPOST
https://atd.abra.eu/demodata/scmcolumnsdefinitions?select=id
{
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
}
Response
{
"id": "1600000101"
}
BodyPUT
https://atd.abra.eu/demodata/scmcolumnsdefinitions/{id}?select=id
{
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
}
Response
{
"id": "1600000101"
}
ResponseDELETE
https://atd.abra.eu/demodata/scmcolumnsdefinitions/{id}
200 - OK Everything worked as expected.
PUT
https://atd.abra.eu/demodata//batch
{
"items": [
{
"type": "create",
"id": "id0",
"data": {
"class_id": "scmcolumnsdefinitions",
"object_data": {
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
},
"query": {
"select": [
"id"
]
}
}
},
{
"type": "create",
"id": "id1",
"data": {
"class_id": "scmcolumnsdefinitions",
"object_data": {
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
},
"query": {
"select": [
"id"
]
}
}
}
]
}
{
"items": [
{
"type": "update",
"id": "id0",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000100",
"object_data": {
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
},
"query": {
"select": [
"id"
]
}
}
},
{
"type": "update",
"id": "id1",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000101",
"object_data": {
"code": "Obchod",
"datasourceset_id": "1000000000",
"groups": [],
"hidden": false,
"name": "Bilance pro obchodní firmy",
"rows": [
{
"aggregatefunction": 0,
"caption": "Stav skladu",
"conditions": "",
"datasource_id": "1000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "1000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Spodní limit",
"conditions": "",
"datasource_id": "4000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "2000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "LowLimit_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 5,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OP",
"conditions": "",
"datasource_id": "2000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "3000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "RO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 6,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "OV",
"conditions": "",
"datasource_id": "3000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "4000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "IO_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 7,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Požad. na OV",
"conditions": "",
"datasource_id": "9000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "5000000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "OR_Quantity",
"objversion": 2,
"parent_id": "1000000000",
"posindex": 8,
"showcondition": "",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Dostupné množství",
"conditions": "",
"datasource_id": "M000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "E100000000",
"includetoresult": false,
"iscalculated": false,
"kind": 2,
"name": "Store_AvailableQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"showcondition": "false",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Ve výdeji",
"conditions": "",
"datasource_id": "L000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "F100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_BookedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "V příjmu",
"conditions": "",
"datasource_id": "K000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "G100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_AcceptedQuantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. výdeje",
"conditions": "",
"datasource_id": "N000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "H100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedDelivery",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
},
{
"aggregatefunction": 0,
"caption": "Plán. příjmy",
"conditions": "",
"datasource_id": "O000000000",
"datatype": 1,
"displaywidth": 80,
"expression": "",
"fieldname": "Quantity",
"id": "I100000000",
"includetoresult": true,
"iscalculated": false,
"kind": 2,
"name": "Store_PlannedIncome",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 10,
"showcondition": "NxGetParameterValue('{743F235D-BB62-4A76-9515-296B83CC4209}') = 1",
"system": true
}
],
"setting_id": "1000000000",
"system": true
},
"query": {
"select": [
"id"
]
}
}
}
]
}
{
"items": [
{
"type": "delete",
"id": "id0",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000100"
}
},
{
"type": "delete",
"id": "id1",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000101"
}
},
{
"type": "delete",
"id": "id2",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000102"
}
},
{
"type": "delete",
"id": "id3",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000103"
}
},
{
"type": "delete",
"id": "id4",
"data": {
"class_id": "scmcolumnsdefinitions",
"obj_id": "1600000104"
}
}
]
}