3. Suhtlus Business Central-iga

SPOKU oskab suhelda Business Central-iga ning initsialiseerida see registri juures.

SPOKU ja BC suhtlevad viitenumbri ("referenceNo") alusel. Selleks on "taotleja andmed" lisavälja all valik viitenumber (kui sp_viitenr andmebaasi tabelis on rida olemas) ning selle korral saab valida, millist viitenumbrit näidata. Selle lisavälja seade korral leitakse asutuse viitenumber andmebaasist ning kui viitenumbrit pole, siis see lisatakse.

ASUTUSE REKLAAMIMAKSU VIITENUMBRI VAATAMINE

Asutuse reklaamimaksu viitenumbri saab vaadata SPOKU keskkonnas valikuga "Ametnik" > "Asutused" > Vajaliku asutuse rea lõppus silmaikoon:

Antud liigutus avab asutuse andmete akna, kus paistab reklaamimaksu viitenumber:

DEKLARATSIOONI SAATMINE BUSINESS CENTRAL-isse

Deklaratsiooni andmete saatmist saab häälestada SPOKU-s valikuga ...

"Ametnik" > "Registrid" >	"Reklaamimaksu deklaratsioon": Pliiatsi ikoon >	lisavälja "BC" seadete alt (3 täpi).

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

{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)

Vaatamiseks tee lahti >>>>

{ "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)

Vaatamiseks tee lahti >>>

{
"@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)

Vaatamiseks tee lahti >>>>

{
"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)

Vaatamiseks tee lahti >>>>

{
"@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

Vaatamiseks tee lahti >>>>

https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/referenceNoBalance?$filter=paymentReferenceNo%20eq%20'4499030200128'

BC-st tulev vastus

Vaatamiseks tee lahti >>>>

{
"@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

Vaatamiseks tee lahti >>>>

https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/customerTransactions?$filter=paymentReferenceNo%20eq%20'4109293390'

BC-st tulev vastus

Vaatamiseks tee lahti >>>>

{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/customerTransactions",
"value": []
}