Difference between revisions of "Import:Vanzare cu incasare XML"

From docs
Jump to: navigation, search
(Xml - Sales invoice with payment)
Line 8: Line 8:
 
===Xml - Sales invoice with payment===
 
===Xml - Sales invoice with payment===
 
  *elements marked with this sign are mandatory
 
  *elements marked with this sign are mandatory
+
 
 
  <span style="color:#00008b">
 
  <span style="color:#00008b">
 
  <<span style="color:#8B0000"><b>root</b></span>>
 
  <<span style="color:#8B0000"><b>root</b></span>>
 
   <<span style="color:#8B0000"><b>docs</b></span>>
 
   <<span style="color:#8B0000"><b>docs</b></span>>
 
     <<span style="color:#8B0000"><b>doc</b></span>>
 
     <<span style="color:#8B0000"><b>doc</b></span>>
       <<span style="color:#8B0000"><b>nrcrt</b></span> />* - if xml contains more than one document this element is mandatory. Each document must have a unique value in this field.
+
       <<span style="color:#8B0000"><b>crtno </b></span>/>* - if xml contains more than one document this element is mandatory. Each document must have a unique value in this field.
 
       &lt;!--<span style="color:green">identify company</span>--&gt;
 
       &lt;!--<span style="color:green">identify company</span>--&gt;
       <<span style="color:#8B0000"><b>companyunitcode</b></span> /> * - company unit code defined in ERP.
+
       <<span style="color:#8B0000"><b>companyunitcode </b></span>/> * - company unit code defined in ERP.
       <<span style="color:#8B0000"><b>companydivisioncode</b></span> /> * - company division code defined in ERP.
+
       <<span style="color:#8B0000"><b>companydivisioncode </b></span>/> * - company division code defined in ERP.
 
       &lt;!--<span style="color:green">document specific info</span>--&gt;
 
       &lt;!--<span style="color:green">document specific info</span>--&gt;
       <<span style="color:#8B0000"><b>docid</b></span> /> * - document is a mandatory field. It can be determined from one of these elements: <span style="color:#8B0000">docid</span> , <span style="color:#8B0000">doccode</span> or <span style="color:#8B0000">docname</span>. At least one of this elements must have value.
+
       <<span style="color:#8B0000"><b>docid </b></span>/> - document is a mandatory field. It can be determined from one of these elements: <span style="color:#8B0000">docid</span> , <span style="color:#8B0000">doccode</span> or <span style="color:#8B0000">docname</span>. At least one of this elements must have value.
       <<span style="color:#8B0000"><b>doccode</b></span> />
+
       <<span style="color:#8B0000"><b>doccode </b></span>/>
       <<span style="color:#8B0000"><b>docname</b></span> />
+
       <<span style="color:#8B0000"><b>docname </b></span>/>
       <<span style="color:#8B0000"><b>doctype</b></span> /> - document type – from list defined in ERP under the document identified from previous elements
+
       <<span style="color:#8B0000"><b>doctype </b></span>/> - document type – from list defined in ERP under the document identified from previous elements
       <<span style="color:#8B0000"><b>docdate</b></span> /> * - document date
+
       <<span style="color:#8B0000"><b>docdate </b></span>/> * - document date
       <<span style="color:#8B0000"><b>docreportingdate</b></span> /> - for companies wich use 2 reportings : one for state reporting and one for reporting to group
+
      <<span style="color:#8B0000"><b>docoriginaldate </b></span>/> - document original date – for invoices with date in a closed period in what concerns reporting
       <<span style="color:#8B0000"><b>docnumber</b></span> /> * - document number
+
       <<span style="color:#8B0000"><b>docreportingdate </b></span>/> - for companies wich use 2 reportings : one for state reporting and one for reporting to group
       <<span style="color:#8B0000"><b>duedate</b></span> /> - due date
+
       <<span style="color:#8B0000"><b>docnumber </b></span>/> * - document number
       <<span style="color:#8B0000"><b>determineduedate</b></span> /> - used if duedate field has no value. If value is 1 due date is determined based on number of days configured in commercial policy of customer.
+
      <<span style="color:#8B0000"><b>grnnumber </b></span>/> - Goods Received Note number
       <<span style="color:#8B0000"><b>explanations</b></span> />
+
      <<span style="color:#8B0000"><b>grndate </b></span>/> - Goods Received Note date
       <<span style="color:#8B0000"><b>explanations2</b></span> />
+
       <<span style="color:#8B0000"><b>duedate </b></span>/> - due date
       <<span style="color:#8B0000"><b>docexternalimportid</b></span> /> - identification number from another system
+
       <<span style="color:#8B0000"><b>determineduedate </b></span>/> - used if <span style="color:#8B0000">duedate</span> field has no value. If value is 1 due date is determined based on number of days configured in commercial policy of customer.
       <<span style="color:#8B0000"><b>docexternalimportidcheckisunique</b></span> /> - if value is 1, an error is returned if exists another document with this external id.
+
       <<span style="color:#8B0000"><b>explanations </b></span>/>
 +
       <<span style="color:#8B0000"><b>explanations2 </b></span>/>
 +
       <<span style="color:#8B0000"><b>docexternalimportid </b></span>/> - identification number from another system
 +
       <<span style="color:#8B0000"><b>docexternalimportidcheckisunique </b></span>/> - if value is 1, an error is returned if exists another document with this external id.
 
       &lt;!--<span style="color:green">document context info</span>--&gt;
 
       &lt;!--<span style="color:green">document context info</span>--&gt;
 
       <<span style="color:#8B0000"><b>dociscancelled</b></span> /> - document is marked as canceled
 
       <<span style="color:#8B0000"><b>dociscancelled</b></span> /> - document is marked as canceled
 
       <<span style="color:#8B0000"><b>iscustomerreturn</b></span> /> - set value to 1 if is customer return
 
       <<span style="color:#8B0000"><b>iscustomerreturn</b></span> /> - set value to 1 if is customer return
       <<span style="color:#8B0000"><b>companyvatuponcollection</b></span> /> - set value to 1 if company is registered for VAT upon collection
+
       <<span style="color:#8B0000"><b>companyvatuponcollection </b></span>/> - set value to 1 if company is registered for VAT upon collection
       <<span style="color:#8B0000"><b>companyvatuponcollectionfromconfig</b></span> /> - if value is 1, the element <span style="color:#8B0000">companyvatuponcollection</span> is decided based on fiscal configuration found in ERP (on company)
+
       <<span style="color:#8B0000"><b>companyvatuponcollectionfromconfig </b></span>/> - if value is 1, the element <span style="color:#8B0000">companyvatuponcollection</span> is decided based on fiscal configuration found in ERP (on company)
       <<span style="color:#8B0000"><b>accountingregisternumber</b></span> /> * - found in Accounting register list. The accounting register is mandatory. It can be obtained from following elements: <span style="color:#8B0000">accountingregisternumber</span> , <span style="color:#8B0000">accountingregistername</span> , <span style="color:#8B0000">doctype</span> (if document type has accounting register configured).
+
       <<span style="color:#8B0000"><b>accountingregisternumber </b></span>/> - found in Accounting register list. The accounting register is mandatory. It can be obtained from following elements: <span style="color:#8B0000">accountingregisternumber</span> , <span style="color:#8B0000">accountingregistername</span> , <span style="color:#8B0000">doctype</span> (if document type has accounting register configured). At least one of the mentioned elements must have value.
       <<span style="color:#8B0000"><b>accountingregistername</b></span> />
+
       <<span style="color:#8B0000"><b>accountingregistername </b></span>/>
       <<span style="color:#8B0000"><b>reversechargecategory</b></span> /> - from list defined in ERP
+
       <<span style="color:#8B0000"><b>reversechargecategory </b></span>/> - from list defined in ERP
       <<span style="color:#8B0000"><b>specialregimecategory</b></span> /> - from list defined in ERP
+
       <<span style="color:#8B0000"><b>unregisteredforvatcategory </b></span>/> - from list defined in ERP  
       <<span style="color:#8B0000"><b>caencode</b></span> /> - from list defined in ERP
+
       <<span style="color:#8B0000"><b>specialregimecategory </b></span>/> - from list defined in ERP
       &lt;!--<span style="color:green">identify partner</span>--&gt;
+
       <<span style="color:#8B0000"><b>partner</b></span>>
      <<span style="color:#8B0000"><b>partnerid</b></span> /> - id of partner in ERP. Partner is a madatory field. It can be determined from one of following elements: <span style="color:#8B0000">partnerid</span> , <span style="color:#8B0000">partnervatnumber</span> , <span style="color:#8B0000">partnername</span>. At least one of this elements must have value.
+
        &lt;!--<span style="color:green">identify partner</span>--&gt;
      <<span style="color:#8B0000"><b>partnervatnumber</b></span> /> - partner vat number
+
        <<span style="color:#8B0000"><b>partnerid </b></span>/> - id of partner in ERP. Partner is a madatory field. It can be determined from one of following elements: <span style="color:#8B0000">partnerid</span> , <span style="color:#8B0000">partnervatnumber</span> , <span style="color:#8B0000">partnername</span>. At least one of this elements must have value.
      <<span style="color:#8B0000"><b>partnername</b></span> /> - partner name
+
        <<span style="color:#8B0000"><b>partnervatnumber </b></span>/> - partner vat number
      &lt;!--<span style="color:green">info insert/update partner</span>--&gt;
+
        <<span style="color:#8B0000"><b>partnername </b></span>/> - partner name
      <<span style="color:#8B0000"><b>partnerinsert</b></span> /> - if value is 1 and partner was not identified based on criteria fields, it will be inserted in ERP. If value is 0 and partner was not identified an error will be returned.
+
        &lt;!--<span style="color:green">info insert/update partner</span>--&gt;
      <<span style="color:#8B0000"><b>partnerupdateinfo</b></span> /> - if value is 1 and partner was identified, next attributes will be updated, if elements exists in xml.
+
        <<span style="color:#8B0000"><b>partnerinsert </b></span>/> - if value is 1 and partner was not identified based on criteria fields, it will be inserted in ERP. If value is 0 and partner was not identified an error will be returned.
      <<span style="color:#8B0000"><b>partnervatnumberprefix</b></span> />
+
        <<span style="color:#8B0000"><b>partnerupdateinfo </b></span>/> - if value is 1 and partner was identified, next attributes will be updated, if elements exists in xml.
      <<span style="color:#8B0000"><b>partnertype</b></span> /> - from partner type list in ERP
+
        <<span style="color:#8B0000"><b>partnervatnumberprefix </b></span>/>
      <<span style="color:#8B0000"><b>partnertraderegisternumber</b></span> /> - number of registration in Trade Register
+
        <<span style="color:#8B0000"><b>partnertype </b></span>/> - from partner type list in ERP
      <<span style="color:#8B0000"><b>partnercountrycode</b></span> /> - country code (2 characters)
+
        <<span style="color:#8B0000"><b>partnertraderegisternumber </b></span>/> - number of registration in Trade Register
      <<span style="color:#8B0000"><b>partnercountycode</b></span> /> - county code (2 characters)
+
        <<span style="color:#8B0000"><b>partneraddress</b></span>>
      <<span style="color:#8B0000"><b>partnercountyname</b></span> /> - county name
+
          <<span style="color:#8B0000"><b>partnercountrycode </b></span>/> - country code (2 characters)
      <<span style="color:#8B0000"><b>partnerinsertcounty</b></span> /> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercountyname</span> has value and county is not found an error will be returned.
+
          <<span style="color:#8B0000"><b>partnercountycode </b></span>/> - county code (2 characters)
      <<span style="color:#8B0000"><b>partnerlocalityname</b></span> /> - from list defined in ERP
+
          <<span style="color:#8B0000"><b>partnercountyname </b></span>/> - county name
      <<span style="color:#8B0000"><b>partnerinsertlocality</b></span> /> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnerlocalityname</span> has value and locality is not found an error will be returned.  
+
          <<span style="color:#8B0000"><b>partnerinsertcounty </b></span>/> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercountyname</span> has value and county is not found an error will be returned.
      <<span style="color:#8B0000"><b>partnerstreet</b></span> />
+
          <<span style="color:#8B0000"><b>partnerlocalityname </b></span>/> - from list defined in ERP
      <<span style="color:#8B0000"><b>partnerstreetnumber</b></span> />  
+
          <<span style="color:#8B0000"><b>partnerinsertlocality </b></span>/> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnerlocalityname</span> has value and locality is not found an error will be returned.  
      <<span style="color:#8B0000"><b>partnerpostalcode</b></span> /> - partner postal code
+
          <<span style="color:#8B0000"><b>partnerstreet </b></span>/>
      &lt;!--<span style="color:green">partner bank account</span>--&gt;
+
          <<span style="color:#8B0000"><b>partnerstreetnumber </b></span>/>  
      <<span style="color:#8B0000"><b>partnerbankaccount</b></span> /> - bank account
+
          <<span style="color:#8B0000"><b>partnerpostalcode </b></span>/> - partner postal code
      <<span style="color:#8B0000"><b>partnerbankname</b></span> /> - bank name
+
        </<span style="color:#8B0000"><b>partneraddress </b></span>>
      <<span style="color:#8B0000"><b>partneraccountcurrency</b></span> /> - bank account currency
+
        &lt;!--<span style="color:green">partner bank account</span>--&gt;
      <<span style="color:#8B0000"><b>partnerbankaccountisdefault</b></span> /> - if value is 1, this account is configured in ERP as default account of partner
+
        <<span style="color:#8B0000"><b>partnerbank</b></span>>
      &lt;!--<span style="color:green">partner contact</span>--&gt;
+
          <<span style="color:#8B0000"><b>partnerbankaccount </b></span>/> - bank account
      <<span style="color:#8B0000"><b>partnercontactinsert</b></span> /> - if value is 1 and partner contact is not identified based on fields <span style="color:#8B0000">partnercontactsurname</span> and <span style="color:#8B0000">partnercontactfirstname</span> it will be inserted.
+
          <<span style="color:#8B0000"><b>partnerbankname </b></span>/> - bank name
      <<span style="color:#8B0000"><b>partnercontactupdateinfo</b></span> />- if value is 1 and partner contact is identified next attributes will be updated.
+
          <<span style="color:#8B0000"><b>partneraccountcurrency </b></span>/> - bank account currency
      <<span style="color:#8B0000"><b>partnercontactsurname</b></span> />
+
          <<span style="color:#8B0000"><b>partnerbankaccountisdefault </b></span>/> - if value is 1, this account is configured in ERP as default account of partner
      <<span style="color:#8B0000"><b>partnercontactfirstname</b></span> />
+
        </<span style="color:#8B0000"><b>partnerbank </b></span>>
      <<span style="color:#8B0000"><b>partnercontactemail</b></span> />
+
        &lt;!--<span style="color:green">partner contact</span>--&gt;  
      <<span style="color:#8B0000"><b>partnercontactemail2</b></span> />
+
        <<span style="color:#8B0000"><b>partnercontact</b></span>>
      <<span style="color:#8B0000"><b>partnercontactphonenumber</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactinsert </b></span>/> - if value is 1 and partner contact is not identified based on fields <span style="color:#8B0000">partnercontactsurname</span> and <span style="color:#8B0000">partnercontactfirstname</span> it will be inserted.
      <<span style="color:#8B0000"><b>partnercontactphonenumber2</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactupdateinfo </b></span>/>- if value is 1 and partner contact is identified next attributes will be updated.
      <<span style="color:#8B0000"><b>partnercontactaddress</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactsurname </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactobservations</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactfirstname </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountrycode</b></span> /> - country code (2 characters)
+
          <<span style="color:#8B0000"><b>partnercontactemail </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountycode</b></span> /> - county code (2 characters)
+
          <<span style="color:#8B0000"><b>partnercontactemail2 </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountyname</b></span> /> - from list defined in ERP
+
          <<span style="color:#8B0000"><b>partnercontactphonenumber </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactinsertcounty</b></span> /> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercontactcountyname</span> has value and county is not found an error will be returned.
+
          <<span style="color:#8B0000"><b>partnercontactphonenumber2 </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactlocalityname</b></span> /> - from list defined in ERP
+
          <<span style="color:#8B0000"><b>partnercontactaddress </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactinsertlocality</b></span> /> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercontactlocalityname</span> has value and locality is not found an error will be returned.
+
          <<span style="color:#8B0000"><b>partnercontactobservations </b></span>/>
      <<span style="color:#8B0000"><b>partnercontacttitle</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactcountrycode </b></span>/> - country code (2 characters)
      <<span style="color:#8B0000"><b>partnercontactposition</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactcountycode </b></span>/> - county code (2 characters)
      <<span style="color:#8B0000"><b>partnercontactcode</b></span> />
+
          <<span style="color:#8B0000"><b>partnercontactcountyname </b></span>/> - from list defined in ERP
      <<span style="color:#8B0000"><b>partnercontactisdefaul</b></span>t /> - if value is 1, this contact is configured in ERP as default contact of partner
+
          <<span style="color:#8B0000"><b>partnercontactinsertcounty </b></span>/> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercontactcountyname</span> has value and county is not found an error will be returned.
 +
          <<span style="color:#8B0000"><b>partnercontactlocalityname </b></span>/> - from list defined in ERP
 +
          <<span style="color:#8B0000"><b>partnercontactinsertlocality </b></span>/> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element <span style="color:#8B0000">partnercontactlocalityname</span> has value and locality is not found an error will be returned.
 +
          <<span style="color:#8B0000"><b>partnercontacttitle </b></span>/>
 +
          <<span style="color:#8B0000"><b>partnercontactposition </b></span>/>
 +
          <<span style="color:#8B0000"><b>partnercontactcode </b></span>/>
 +
          <<span style="color:#8B0000"><b>partnercontactisdefault </b></span>/> - if value is 1, this contact is configured in ERP as default contact of partner.  
 +
        </<span style="color:#8B0000"><b>partnercontact </b></span>>
 +
      </<span style="color:#8B0000"><b>partner </b></span>>
 
       &lt;!--<span style="color:green">transaction details</span>--&gt;
 
       &lt;!--<span style="color:green">transaction details</span>--&gt;
 
       <<span style="color:#8B0000"><b>records</b></span>>
 
       <<span style="color:#8B0000"><b>records</b></span>>
Line 91: Line 102:
 
           <<span style="color:#8B0000"><b>customeraccount</b></span> /> - account of customer
 
           <<span style="color:#8B0000"><b>customeraccount</b></span> /> - account of customer
 
           <<span style="color:#8B0000"><b>revenueaccount</b></span> /> - revenue account
 
           <<span style="color:#8B0000"><b>revenueaccount</b></span> /> - revenue account
           <<span style="color:#8B0000"><b>transactiontype</b></span> /> - values accepted: P or S. content of transaction: product (P), service (S)
+
           <<span style="color:#8B0000"><b>transactiontype </b></span>/> - values accepted: <b>P</b> or <b>S</b> . content of transaction: product (P), service (S)
           <<span style="color:#8B0000"><b>valuewithoutvat</b></span> />
+
           <<span style="color:#8B0000"><b>valuewithoutvat </b></span>/>
           <<span style="color:#8B0000"><b>vatvalue</b></span> />
+
           <<span style="color:#8B0000"><b>vatvalue </b></span>/>
           <<span style="color:#8B0000"><b>vatpercent</b></span> />
+
           <<span style="color:#8B0000"><b>vatpercent </b></span>/>
           <<span style="color:#8B0000"><b>valueincurrency</b></span> />
+
           <<span style="color:#8B0000"><b>valueincurrency </b></span>/>
           <<span style="color:#8B0000"><b>currencycode</b></span> />
+
           <<span style="color:#8B0000"><b>currencycode </b></span>/>
           <<span style="color:#8B0000"><b>exchangerate</b></span> />
+
           <<span style="color:#8B0000"><b>exchangerate </b></span>/>
           <<span style="color:#8B0000"><b>accountingmode</b></span> /> * - from list defined in ERP
+
           <<span style="color:#8B0000"><b>accountingmode </b></span>/> * - from list defined in ERP
 
           &lt;!--<span style="color:green">transaction dimensions</span>--&gt;
 
           &lt;!--<span style="color:green">transaction dimensions</span>--&gt;
           <<span style="color:#8B0000"><b>businesslinecode</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>businesslinecode </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>businesslinename</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>businesslinename </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>costcentercode</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>costcentercode </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>costcentername</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>costcentername </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>budgetitemname</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>budgetitemname </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>budgetitemcode</b></span> /> - from list defined in ERP
+
           <<span style="color:#8B0000"><b>budgetitemcode </b></span>/> - from list defined in ERP
           <<span style="color:#8B0000"><b>asset</b></span> /> - from list of assets in ERP
+
           <<span style="color:#8B0000"><b>asset </b></span>/> - from list of assets in ERP
           <<span style="color:#8B0000"><b>assetcode</b></span> /> - from list of assets in ERP
+
           <<span style="color:#8B0000"><b>assetcode </b></span>/> - from list of assets in ERP
           <<span style="color:#8B0000"><b>project</b></span> /> - from list of projects in ERP
+
           <<span style="color:#8B0000"><b>project </b></span>/> - from list of projects in ERP
           <<span style="color:#8B0000"><b>taskid</b></span> /> - from list of tasks in ERP
+
           <<span style="color:#8B0000"><b>taskid</b></span>/> - from list of tasks in ERP
           <<span style="color:#8B0000"><b>nccode</b></span> /> - from list of NC codes defined in ERP
+
           <<span style="color:#8B0000"><b>nccode</b></span>/> - from list of NC codes defined in ERP
         <<span style="color:#8B0000"><b>record</b></span>>
+
         </<span style="color:#8B0000"><b>record </b></span>>
       </<span style="color:#8B0000"><b>records</b></span>>
+
       </<span style="color:#8B0000"><b>records </b></span>>
 
       &lt;!--<span style="color:green">payment details</span>--&gt;
 
       &lt;!--<span style="color:green">payment details</span>--&gt;
       <<span style="color:#8B0000"><b>paymentdocid</b></span> /> - if payment document is identified (based on <span style="color:#8B0000">paymentdocid</span> or <span style="color:#8B0000">paymentdoccode</span>) and following fileds (<span style="color:#8B0000">paymentdate</span> , <span style="color:#8B0000">paymentnumber</span> , <span style="color:#8B0000">paymentvalue</span>) have value a payment accounting note will be inserted.
+
       <<span style="color:#8B0000"><b>payments</b></span>>
      <<span style="color:#8B0000"><b>paymentdoccode</b></span> />
+
        <<span style="color:#8B0000"><b>paymentdocid </b></span>/> - if payment document is identified (based on <span style="color:#8B0000">paymentdocid</span> or <span style="color:#8B0000">paymentdoccode</span>) and following fileds (<span style="color:#8B0000">paymentdate</span> , <span style="color:#8B0000">paymentnumber</span> , <span style="color:#8B0000">paymentvalue</span>) have value a payment accounting note will be inserted.
      <<span style="color:#8B0000"><b>paymentaccount</b></span> />
+
        <<span style="color:#8B0000"><b>paymentdoccode </b></span>/>
      <<span style="color:#8B0000"><b>paymentnumber</b></span> />
+
        <<span style="color:#8B0000"><b>paymentaccount </b></span>/>
      <<span style="color:#8B0000"><b>paymentdate</b></span> />
+
        <<span style="color:#8B0000"><b>paymentnumber </b></span>/>
      <<span style="color:#8B0000"><b>paymentexplanations</b></span> />
+
        <<span style="color:#8B0000"><b>paymentdate </b></span>/>
      <<span style="color:#8B0000"><b>paymentexplanations2</b></span> />
+
        <<span style="color:#8B0000"><b>paymentexplanations </b></span>/>
      <<span style="color:#8B0000"><b>paymentvalue</b></span> />
+
        <<span style="color:#8B0000"><b>paymentexplanations2 </b></span>/>
      <<span style="color:#8B0000"><b>paymentmode</b></span> /> - from list defined in ERP
+
        <<span style="color:#8B0000"><b>paymentvalue </b></span>/>
 +
        <<span style="color:#8B0000"><b>paymentmode </b></span>/> - from list defined in ERP
 +
      </<span style="color:#8B0000"><b>payments </b></span>>
 
     </<span style="color:#8B0000"><b>doc</b></span>>
 
     </<span style="color:#8B0000"><b>doc</b></span>>
 
   </<span style="color:#8B0000"><b>docs</b></span>>
 
   </<span style="color:#8B0000"><b>docs</b></span>>
 
  </<span style="color:#8B0000"><b>root</b></span>>
 
  </<span style="color:#8B0000"><b>root</b></span>>
 
  </span>
 
  </span>

Revision as of 11:52, 1 October 2019

Xml - Sales invoice with payment

*elements marked with this sign are mandatory

<root>
 <docs>
   <doc>
     <crtno />* - if xml contains more than one document this element is mandatory. Each document must have a unique value in this field.
     <!--identify company-->
     <companyunitcode /> * - company unit code defined in ERP.
     <companydivisioncode /> * - company division code defined in ERP.
     <!--document specific info-->
     <docid /> - document is a mandatory field. It can be determined from one of these elements: docid , doccode or docname. At least one of this elements must have value.
     <doccode />
     <docname />
     <doctype /> - document type – from list defined in ERP under the document identified from previous elements
     <docdate /> * - document date
     <docoriginaldate /> - document original date – for invoices with date in a closed period in what concerns reporting
     <docreportingdate /> - for companies wich use 2 reportings : one for state reporting and one for reporting to group
     <docnumber /> * - document number
     <grnnumber /> - Goods Received Note number
     <grndate /> - Goods Received Note date
     <duedate /> - due date
     <determineduedate /> - used if duedate field has no value. If value is 1 due date is determined based on number of days configured in commercial policy of customer.
     <explanations />
     <explanations2 />
     <docexternalimportid /> - identification number from another system
     <docexternalimportidcheckisunique /> - if value is 1, an error is returned if exists another document with this external id.
     <!--document context info-->
     <dociscancelled /> - document is marked as canceled
     <iscustomerreturn /> - set value to 1 if is customer return
     <companyvatuponcollection /> - set value to 1 if company is registered for VAT upon collection
     <companyvatuponcollectionfromconfig /> - if value is 1, the element companyvatuponcollection is decided based on fiscal configuration found in ERP (on company)
     <accountingregisternumber /> - found in Accounting register list. The accounting register is mandatory. It can be obtained from following elements: accountingregisternumber , accountingregistername , doctype (if document type has accounting register configured). At least one of the mentioned elements must have value.
     <accountingregistername />
     <reversechargecategory /> - from list defined in ERP
     <unregisteredforvatcategory /> - from list defined in ERP 
     <specialregimecategory /> - from list defined in ERP
     <partner>
       <!--identify partner-->
       <partnerid /> - id of partner in ERP. Partner is a madatory field. It can be determined from one of following elements: partnerid , partnervatnumber , partnername. At least one of this elements must have value.
       <partnervatnumber /> - partner vat number
       <partnername /> - partner name
       <!--info insert/update partner-->
       <partnerinsert /> - if value is 1 and partner was not identified based on criteria fields, it will be inserted in ERP. If value is 0 and partner was not identified an error will be returned.
       <partnerupdateinfo /> - if value is 1 and partner was identified, next attributes will be updated, if elements exists in xml.
       <partnervatnumberprefix />
       <partnertype /> - from partner type list in ERP
       <partnertraderegisternumber /> - number of registration in Trade Register
       <partneraddress>
         <partnercountrycode /> - country code (2 characters)
         <partnercountycode /> - county code (2 characters)
         <partnercountyname /> - county name
         <partnerinsertcounty /> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element partnercountyname has value and county is not found an error will be returned.
         <partnerlocalityname /> - from list defined in ERP
         <partnerinsertlocality /> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element partnerlocalityname has value and locality is not found an error will be returned. 
         <partnerstreet />
         <partnerstreetnumber /> 
         <partnerpostalcode /> - partner postal code
       </partneraddress >	 
       <!--partner bank account-->
       <partnerbank>
         <partnerbankaccount /> - bank account
         <partnerbankname /> - bank name
         <partneraccountcurrency /> - bank account currency
         <partnerbankaccountisdefault /> - if value is 1, this account is configured in ERP as default account of partner
       </partnerbank >	 
       <!--partner contact-->	  
       <partnercontact>
         <partnercontactinsert /> - if value is 1 and partner contact is not identified based on fields partnercontactsurname and partnercontactfirstname it will be inserted.
         <partnercontactupdateinfo />- if value is 1 and partner contact is identified next attributes will be updated.
         <partnercontactsurname />
         <partnercontactfirstname />
         <partnercontactemail />
         <partnercontactemail2 />
         <partnercontactphonenumber />
         <partnercontactphonenumber2 />
         <partnercontactaddress />
         <partnercontactobservations />
         <partnercontactcountrycode /> - country code (2 characters)
         <partnercontactcountycode /> - county code (2 characters)
         <partnercontactcountyname /> - from list defined in ERP
         <partnercontactinsertcounty /> - if value is 1 and county is not found in ERP list, it will be inserted. If value is 0 and element partnercontactcountyname has value and county is not found an error will be returned.
         <partnercontactlocalityname /> - from list defined in ERP
         <partnercontactinsertlocality /> - if value is 1 and locality is not found in ERP list, it will be inserted. If value is 0 and element partnercontactlocalityname has value and locality is not found an error will be returned.
         <partnercontacttitle />
         <partnercontactposition />
         <partnercontactcode />
         <partnercontactisdefault /> - if value is 1, this contact is configured in ERP as default contact of partner.	  
       </partnercontact >	 
     </partner >	 
     <!--transaction details-->
     <records>
       <record>
         <customeraccount /> - account of customer
         <revenueaccount /> - revenue account
         <transactiontype /> - values accepted: P or S . content of transaction: product (P), service (S)
         <valuewithoutvat />
         <vatvalue />
         <vatpercent />
         <valueincurrency />
         <currencycode />
         <exchangerate />
         <accountingmode /> * - from list defined in ERP
         <!--transaction dimensions-->
         <businesslinecode /> - from list defined in ERP
         <businesslinename /> - from list defined in ERP
         <costcentercode /> - from list defined in ERP
         <costcentername /> - from list defined in ERP
         <budgetitemname /> - from list defined in ERP
         <budgetitemcode /> - from list defined in ERP
         <asset /> - from list of assets in ERP
         <assetcode /> - from list of assets in ERP
         <project /> - from list of projects in ERP
         <taskid/> - from list of tasks in ERP
         <nccode/> - from list of NC codes defined in ERP
       </record >
     </records >
     <!--payment details-->
     <payments>
       <paymentdocid /> - if payment document is identified (based on paymentdocid or paymentdoccode) and following fileds (paymentdate , paymentnumber , paymentvalue) have value a payment accounting note will be inserted.
       <paymentdoccode />
       <paymentaccount />
       <paymentnumber />
       <paymentdate />
       <paymentexplanations />
       <paymentexplanations2 />
       <paymentvalue />
       <paymentmode /> - from list defined in ERP
     </payments >
   </doc>
 </docs>
</root>