Hausing - Register Kontod: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
Resümee puudub
102. rida: 102. rida:
=== Näidis XML päring ===
=== Näidis XML päring ===
<syntaxhighlight lang="xml" line="1">
<syntaxhighlight lang="xml" line="1">
<?xml version='1.0' encoding='UTF-8' standalone='yes'?>
<?xml version="1.0" encoding="UTF-8"?>
<data>
<data>
<register name='AccVc'>
  <register name="AccVc">
<record>
      <record>
<head>
        <head>
<AccNumber>1000</AccNumber>
            <AccNumber>1000</AccNumber>
<Comment>Sales 9%</Comment>
            <Comment>Sales 9%</Comment>
<AccType>3</AccType>
            <AccType>3</AccType>
<NVD>1</NVD>
            <NVD>1</NVD>
<NVC>1</NVC>
            <NVC>1</NVC>
<AutCode>AL1</AutCode>
            <AutCode>AL1</AutCode>
<blockedFlag>0</blockedFlag>
            <blockedFlag>0</blockedFlag>
<VATCode>4</VATCode>
            <VATCode>4</VATCode>
<ControlType>0</ControlType>
            <ControlType>0</ControlType>
<Curncy>AUD</Curncy>
            <Curncy>AUD</Curncy>
<ConsAccNumber>3333</ConsAccNumber>
            <ConsAccNumber>3333</ConsAccNumber>
<Conspr>0</Conspr>
            <Conspr>0</Conspr>
<Objects>522,524</Objects>
            <Objects>522,524</Objects>
<SRUCode></SRUCode>
            <SRUCode />
<ExclFrRep>1</ExclFrRep>
            <ExclFrRep>1</ExclFrRep>
<PeriodCode>PM1</PeriodCode>
            <PeriodCode>PM1</PeriodCode>
<GroupAcc>0</GroupAcc>
            <GroupAcc>0</GroupAcc>
<TransAutCode>AL2</TransAutCode>
            <TransAutCode>AL2</TransAutCode>
<TaxTemplateCode>MG1</TaxTemplateCode>
            <TaxTemplateCode>MG1</TaxTemplateCode>
<AccClass>KL1,KL2</AccClass>
            <AccClass>KL1,KL2</AccClass>
</head>
        </head>
<rows>
        <rows>
<row>
            <row>
<LangCode>EST</LangCode>
              <LangCode>EST</LangCode>
<Text>konto eesti keeles</Text>
              <Text>konto eesti keeles</Text>
</row>
            </row>
<row>
            <row>
<LangCode>FIN</LangCode>
              <LangCode>FIN</LangCode>
<Text>Konto inglise keeles</Text>
              <Text>Konto inglise keeles</Text>
</row>
            </row>
</rows>
        </rows>
</record>
      </record>
</register>
  </register>
</data>
</data>


</syntaxhighlight>
</syntaxhighlight>

Redaktsioon: 22. juuni 2018, kell 06:33

Hausing - Pealeht

Kohustuslikud väljad

Minimaalse XML päringu näide

Kõigi XML väljade kirjeldused

Field name Description Max length, field type
AccNumber Account code (Konto)
Comment Account name (Nimetus)
AccType Account type (Kontoklass) 0=Assets; 1=Liability; 2=Equity;3=Income;4=Expense
NVD Normal account – Debit. 0=no;1=yes (Tavaline kirjeldamine, Deebet linnuke)
NVC Normal account – Credit. 0=no;1=yes (Tavaline kirjeldamine, Deebet linnuke)
AutCode Autotrans (automaatlausend)
blockedFlag Closed. If 1, then closed. (Suletud)
VATCode VAT Code (KM-kood)
ControlType Not used, always 0
Curncy Currency code (Valuuta)
ConsAccNumber Consolidation account code (Konsol. konto)
Conspr Use consolidation percentage. (Kasuta konsolideerimise osakaalu protsenti)
Objects Objects, separated by comma (Objetid)
SRUCode SRU code. Not used, always 0
ExclFrRep Exclude from Riigitarkvara report 0=no;1=yes. (Jäta välja riigitarkvara aruandest)
PeriodCode Accural code (Per. mudeli kood)
GroupAcc Account group (Konto grupp)
TransAutCode Autotrans 2 (automaatlausend 2)
TaxTemplateCode Tax template (Maksugrupp)
AccClass Classification (Klassifikaator)
LangCode Language code in Texts(keel tekstide kaardiosalt)
Text Text in Texts (Tekst tekstide kaardiosalt)

Näidis XML päring

<?xml version="1.0" encoding="UTF-8"?>
<data>
   <register name="AccVc">
      <record>
         <head>
            <AccNumber>1000</AccNumber>
            <Comment>Sales 9%</Comment>
            <AccType>3</AccType>
            <NVD>1</NVD>
            <NVC>1</NVC>
            <AutCode>AL1</AutCode>
            <blockedFlag>0</blockedFlag>
            <VATCode>4</VATCode>
            <ControlType>0</ControlType>
            <Curncy>AUD</Curncy>
            <ConsAccNumber>3333</ConsAccNumber>
            <Conspr>0</Conspr>
            <Objects>522,524</Objects>
            <SRUCode />
            <ExclFrRep>1</ExclFrRep>
            <PeriodCode>PM1</PeriodCode>
            <GroupAcc>0</GroupAcc>
            <TransAutCode>AL2</TransAutCode>
            <TaxTemplateCode>MG1</TaxTemplateCode>
            <AccClass>KL1,KL2</AccClass>
         </head>
         <rows>
            <row>
               <LangCode>EST</LangCode>
               <Text>konto eesti keeles</Text>
            </row>
            <row>
               <LangCode>FIN</LangCode>
               <Text>Konto inglise keeles</Text>
            </row>
         </rows>
      </record>
   </register>
</data>