GET
Získá kolekci BO Datový zdroj
GET
Získá seznam položek BO, které mohou být chráněny na BO Datový zdroj
GET
Získá pohled nad BO Datový zdroj
GET
Získá daný BO Datový zdroj
GET
Otestuje, zda existuje editační zámek na daném BO Datový zdroj
GET
Získá seznam chráněných položek, které jsou na BO Datový zdroj aktuálnímu uživateli znepřístupněny
GET
Získá řádky kolekce Řádek datového zdroje
GET
Získá daný řádek kolekce Řádek datového zdroje
GET
Získá seznam uživatelských parametrů včetně jejich hodnot k danému BO Datový zdroj
POST
Vytvoří nový BO Datový zdroj
POST
Vyhodnotí query dotaz nad BO Datový zdroj
POST
Vytvoří nový řádek v kolekci Řádek datového zdroje
PUT
Modifikuje daný BO Datový zdroj
PUT
Vytvoří editační zámek na daném BO Datový zdroj
PUT
Zruší editační zámek na daném BO Datový zdroj
PUT
Modifikuje řádek v kolekci Řádek datového zdroje
DELETE
Smaže BO Datový zdroj
DELETE
Smaže řádek z kolekce Řádek datového zdroje
Kód, pole vlastněné tabulkou, možné řadit a filtrovat
Typ dokumentu, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR
Skrytý, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu
Druh, 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
Poznámka, 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 datového zdroje, pole je duplikováno při klonování objektu, objekt na který pole odkazuje je 'vlastněn'
SQL dotaz, 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
Název, pouze pro čtení
Vlastní ID, pouze pro čtení, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR
GET
https://atd.abra.eu/demodata/scmdatasources?take=1
ResponseGET
https://atd.abra.eu/demodata/scmdatasources/{id}
{
"objversion": 1,
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"hidden": false,
"code": "Stav skladu",
"name": "Stav skladu",
"kind": 1,
"documenttype": "",
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true,
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav."
}
POST
https://atd.abra.eu/demodata/query
{"class": "scmdatasources", "take": "1"}
POST
https://atd.abra.eu/demodata/scmdatasources/query
{"take": "1"}
Response
{
"objversion": 1,
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"hidden": false,
"code": "Stav skladu",
"name": "Stav skladu",
"kind": 1,
"documenttype": "",
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true,
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav."
}
BodyPOST
https://atd.abra.eu/demodata/scmdatasources?select=id
{
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
}
Response
{
"id": "1600000101"
}
BodyPUT
https://atd.abra.eu/demodata/scmdatasources/{id}?select=id
{
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
}
Response
{
"id": "1600000101"
}
ResponseDELETE
https://atd.abra.eu/demodata/scmdatasources/{id}
200 - OK Everything worked as expected.
PUT
https://atd.abra.eu/demodata//batch
{
"items": [
{
"type": "create",
"id": "id0",
"data": {
"class_id": "scmdatasources",
"object_data": {
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
},
"query": {
"select": [
"id"
]
}
}
},
{
"type": "create",
"id": "id1",
"data": {
"class_id": "scmdatasources",
"object_data": {
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
},
"query": {
"select": [
"id"
]
}
}
}
]
}
{
"items": [
{
"type": "update",
"id": "id0",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000100",
"object_data": {
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
},
"query": {
"select": [
"id"
]
}
}
},
{
"type": "update",
"id": "id1",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000101",
"object_data": {
"code": "Stav skladu",
"documenttype": "",
"hidden": false,
"kind": 1,
"name": "Stav skladu",
"note": "Datový zdroj slouží k získání stavu skladu.\r\nZahrnuje pouze dílčí skladové karty, které mají nenulový stav.",
"rows": [
{
"caption": "Skladová karta",
"datatype": 2,
"id": "1000000000",
"kind": 1,
"name": "StoreCard_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 1,
"rollclsid": "S3WZQKDB5FDL342M01C0CX3FCC",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Sklad",
"datatype": 2,
"id": "2000000000",
"kind": 1,
"name": "Store_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 2,
"rollclsid": "O3ZO2K155FDL3CL100C4RHECN0",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Množství",
"datatype": 1,
"id": "4000000000",
"kind": 2,
"name": "Quantity",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 4,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Pořadí ve vývoji",
"datatype": 0,
"id": "J400000000",
"kind": 0,
"name": "EvolutionOrder",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 3,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
},
{
"caption": "Středisko",
"datatype": 2,
"id": "W400000000",
"kind": 1,
"name": "Division_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 5,
"rollclsid": "OA5JMX4J2FD135CH000ILPWJF4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Zakázka",
"datatype": 2,
"id": "X400000000",
"kind": 1,
"name": "BusOrder_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 6,
"rollclsid": "03OXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Obch. případ",
"datatype": 2,
"id": "Y400000000",
"kind": 1,
"name": "BusTransaction_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 7,
"rollclsid": "0BOXHKRF4VD13ACL03KIU0CLP4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Projekt",
"datatype": 2,
"id": "Z400000000",
"kind": 1,
"name": "BusProject_ID",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 8,
"rollclsid": "ZX20VMNR1NV4N30K2MRDAXLRN4",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "Code",
"system": true
},
{
"caption": "Datum",
"datatype": 3,
"id": "5500000000",
"kind": 0,
"name": "Date$DATE",
"objversion": 1,
"parent_id": "1000000000",
"posindex": 9,
"rollclsid": "00000000000000000000000000",
"rollmask": 0,
"rollparams": "",
"rolltextfield": "",
"system": true
}
],
"sqlquery": "SELECT\r\n Store_ID,\r\n StoreCard_ID,\r\n 0 AS EvolutionOrder,\r\n Quantity,\r\n ' ' AS Division_ID,\r\n ' ' AS BusOrder_ID,\r\n ' ' AS BusTransaction_ID,\r\n ' ' AS BusProject_ID,\r\n 0.0 AS Date$DATE\r\nFROM\r\n StoreSubCards\r\nWHERE\r\n Quantity <> 0",
"system": true
},
"query": {
"select": [
"id"
]
}
}
}
]
}
{
"items": [
{
"type": "delete",
"id": "id0",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000100"
}
},
{
"type": "delete",
"id": "id1",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000101"
}
},
{
"type": "delete",
"id": "id2",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000102"
}
},
{
"type": "delete",
"id": "id3",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000103"
}
},
{
"type": "delete",
"id": "id4",
"data": {
"class_id": "scmdatasources",
"obj_id": "1600000104"
}
}
]
}