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
- addSalesDocument
Saadetav BC-sse päring addSalesDocument - Kohustuste saatmine BCsse (päis)
{ "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)
{
"@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": ""
}
2. addSalesDocumentLine
Saadetav BC-sse päring addSalesDocumentLine - Kohustuste saatmine BCsse (rida)
{
"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)
{
"@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": ""
}
3. referenceNoBalance (Saldo päring)
SPOKUst saadetav päring
https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/referenceNoBalance?$filter=paymentReferenceNo%20eq%20'4499030200128'
BC-st tulev vastus
{
"@odata.context": "https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/referenceNoBalance",
"value": []
}
4. customerTransaction (Asutuse tehingute küsimine)
SPOKUst saadetav päring
https://pperp.piksel.ee:3058/SAUE150SERVLIVE/ODataV4/Company('Saue%20Piksel%2019.05.2021')/customerTransactions?$filter=paymentReferenceNo%20eq%20'4109293390'
BC-st tulev vastus
{
"@odata.context": "https://erp.sauevald.ee:3058/SAUE150SERVLIVE/ODataV4/$metadata#Company('Saue%20Piksel%2019.05.2021')/customerTransactions",
"value": []
}
