SPOKU oskab suhelda Business Central-iga ning initsialiseerida see registri juures.
...
Uue asutuse reklaamimaksu viitenumber tekib deklaratsiooni esitamisega eeldusel, et vormi lisaväljade osas on olemas väli tüübiga "Taotleja andmed: Viitenumber". Antud valik on olemas ainult ühel SPOKU kasutajal (andmebaasi sp_viitenr tabelis on rida olemas).
...
Deklaratsiooni (nõue) saatmine Business Central-isse
Deklaratsiooni andmete saatmist saab häälestada SPOKU-s valikuga ...
Andmevälja tüübiks on "Tekst" ning valemi näide (dimensioonide väärtused on illustratiivsed). Antud valem saadab vastavalt taotleja omandivormile omad dimentsiooni väärtused ning ainult need deklaratsioonid, mis oli esitatud alates 01.01.2021
| Koodilõik |
|---|
{if $register.esitatud_kp >= '2021-01-01'}
{if $register.asutus.omandivorm == -1}
{registriTeenus teenus='saada_andmed_bc' konto='304300' dim_kood1='TT' dim_vaartus1='31800' dim_kood2='TKL' dim_vaartus2='334400' objekti_konto='103300' dim_kood3='TP' dim_vaartus3='833699' dim_kood4='ÜKSUS' dim_vaartus4='201'}
{elseif $register.asutus.omandivorm == 4}
{registriTeenus teenus='saada_andmed_bc' konto='304300' dim_kood1='TT' dim_vaartus1='31800' dim_kood2='TKL' dim_vaartus2='334400' objekti_konto='103330' dim_kood3='TP' dim_vaartus3='833399' dim_kood4='ÜKSUS' dim_vaartus4='201'}
{else}
{registriTeenus teenus='saada_andmed_bc' konto='304300' dim_kood1='TT' dim_vaartus1='31800' dim_kood2='TKL' dim_vaartus2='333400' objekti_konto='103300' dim_kood3='TP' dim_vaartus3='833599' dim_kood4='ÜKSUS' dim_vaartus4='201'}
{/if}
{else}Andmeid ei saadeta BCsse, kuna maksudeklaratsiooni koostamise kuupäev varasem kui 01.01.2021
{/if} |
...
Näited
Näide 1. addSalesDocument
Saadetav BC-sse päring addSalesDocument - Kohustuste saatmine BCsse (päis)
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
{ "documentType": "Invoice", "documentNo": "DEKL-2021/00054", "lineCount": 1, "sellToCustomerNo": "10283105", "sellToCustomerName": "IT Medical Tecnologies OÜ", "billToCustomerNo": "10283105", "billToCustomerName": "IT Medical Tecnologies OÜ", "referenceNo": "4102831050", "objectAccountNo": "103000", "invoiceDescription": "Reklaamimaksu deklaratsioon (01.08.2021-08.09.2021)", "documentDate": "2021-08-05", "postingDate": "2021-08-05", "dueDate": "2021-08-19", "relatedInvoiceNo": null, "dimCode1": "TT", "dimValue1": "01800", "dimCode2": "TKL", "dimValue2": "304400", "dimCode3": "TP", "dimValue3": "800599", "dimCode4": "ÜKSUS", "dimValue4": "201", "dimCode5": null, "dimValue5": null, "dimCode6": null, "dimValue6": null, "dimCode7": null, "dimValue7": null, "dimCode8": null, "dimValue8": null, "dimCode9": null, "dimValue9": null, "dimCode10": null, "dimValue10": null, "dimCode11": null, "dimValue11": null, "dimCode12": null, "dimValue12": null } |
|
BC-st tulnud vastus (päring õnnestus)
| Laienda |
|---|
| title | Vaatamiseks tee lahti >>> |
|---|
|
| Koodilõik |
|---|
{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/addSalesDocument/$entity",
"@odata.etag": "W/\"JzQ0OzlNSUdOUy80R0JOU2ordkZqRkllWGhLZ2tQRmIwcE53SG9oNUVtMTRZMWM9MTswMDsn\"",
"SystemId": "02f2e9c5-d6f5-eb11-a4a0-000c29ced534",
"documentType": "Invoice",
"documentNo": "DEKL-2021/00054",
"lineCount": 1,
"sellToCustomerNo": "10283105",
"sellToCustomerName": "IT Medical Tecnologies OÜ",
"billToCustomerNo": "10283105",
"billToCustomerName": "IT Medical Tecnologies OÜ",
"billToCustomerEMail": "",
"referenceNo": "4102831050",
"objectAccountNo": "103000",
"invoiceDescription": "Reklaamimaksu deklaratsioon (01.08.2021-08.09.2021)",
"documentDate": "2021-08-05",
"postingDate": "2021-08-05",
"dueDate": "2021-08-19",
"createdTime": "2021-08-05T10:20:36.827Z",
"relatedInvoiceNo": "",
"eInvoice": false,
"standingOrderPmntCode": "",
"dimCode1": "TT",
"dimValue1": "01800",
"dimCode2": "TKL",
"dimValue2": "304400",
"dimCode3": "TP",
"dimValue3": "800599",
"dimCode4": "ÜKSUS",
"dimValue4": "201",
"dimCode5": "",
"dimValue5": "",
"dimCode6": "",
"dimValue6": "",
"dimCode7": "",
"dimValue7": "",
"dimCode8": "",
"dimValue8": "",
"dimCode9": "",
"dimValue9": "",
"dimCode10": "",
"dimValue10": "",
"dimCode11": "",
"dimValue11": "",
"dimCode12": "",
"dimValue12": ""
} |
|
Näide 2. addSalesDocumentLine
Saadetav BC-sse päring addSalesDocumentLine - Kohustuste saatmine BCsse (rida)
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
{
"documentType": "Invoice",
"documentNo": "DEKL-2021/00054",
"lineNo": 1,
"accountNo": "304400",
"unitOfMeasureCode": "TK",
"amount": 356.77,
"description": "Reklaamimaksu deklaratsioon (01.08.2021-08.09.2021)",
"INF3": false,
"dimCode1": "TT",
"dimValue1": "01800",
"dimCode2": "TKL",
"dimValue2": "304400",
"dimCode3": "TP",
"dimValue3": "800599",
"dimCode4": "ÜKSUS",
"dimValue4": "201",
"dimCode5": null,
"dimValue5": null,
"dimCode6": null,
"dimValue6": null,
"dimCode7": null,
"dimValue7": null,
"dimCode8": null,
"dimValue8": null,
"dimCode9": null,
"dimValue9": null,
"dimCode10": null,
"dimValue10": null,
"dimCode11": null,
"dimValue11": null,
"dimCode12": null,
"dimValue12": null
} |
|
BC-st tulnud vastus (päring õnnestus)
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/addSalesDocumentLine/$entity",
"@odata.etag": "W/\"JzQ0O0NNUWRFcFY4TFExS3ZiT3RwbHBjT1RTQUcrMnQ3eGc4T29BYWJVZjhlbDg9MTswMDsn\"",
"documentType": "Invoice",
"documentNo": "DEKL-2021/00054",
"lineNo": 1,
"accountNo": "304400",
"unitOfMeasureCode": "TK",
"amount": 356.77,
"description": "Reklaamimaksu deklaratsioon (01.08.2021-08.09.2021)",
"INF3": false,
"dimCode1": "TT",
"dimValue1": "01800",
"dimCode2": "TKL",
"dimValue2": "304400",
"dimCode3": "TP",
"dimValue3": "800599",
"dimCode4": "ÜKSUS",
"dimValue4": "201",
"dimCode5": "",
"dimValue5": "",
"dimCode6": "",
"dimValue6": "",
"dimCode7": "",
"dimValue7": "",
"dimCode8": "",
"dimValue8": "",
"dimCode9": "",
"dimValue9": "",
"dimCode10": "",
"dimValue10": "",
"dimCode11": "",
"dimValue11": "",
"dimCode12": "",
"dimValue12": ""
} |
|
Näide 3. referenceNoBalance (Saldo päring)
SPOKUst saadetav päring
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/referenceNoBalance?$filter=paymentReferenceNo%20eq%20'4499030200128' |
|
BC-st tulev vastus
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/referenceNoBalance",
"value": []
} |
|
Näide 4. customerTransaction (Asutuse tehingute küsimine)
SPOKUst saadetav päring
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/customerTransactions?$filter=paymentReferenceNo%20eq%20'4109293390' |
|
BC-st tulev vastus
| Laienda |
|---|
| title | Vaatamiseks tee lahti |
|---|
|
...
|
| Koodilõik |
|---|
{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/customerTransactions",
"value": []
} |
|
