Difference between revisions of "Import:Cumparare cu plata XML"

From docs
Jump to: navigation, search
(Xml - Purchase invoice with payment)
Line 48: Line 48:
 
       <<span style="color:#8B0000"><b>specialregimecategory </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;
 
       &lt;!--<span style="color:green">identify partner</span>--&gt;
       <<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>partner</b></span>>
      <<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>partnercountrycode </b></span>/> - country code (2 characters)
      <<span style="color:#8B0000"><b>partnercountyname </b></span>/> - county name
+
        <<span style="color:#8B0000"><b>partnercountycode </b></span>/> - county 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>partnercountyname </b></span>/> - county name
      <<span style="color:#8B0000"><b>partnerlocalityname </b></span>/> - from list defined in ERP
+
        <<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>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>partnerlocalityname </b></span>/> - from list defined in ERP
      <<span style="color:#8B0000"><b>partnerstreet </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>partnerstreetnumber </b></span>/>  
+
        <<span style="color:#8B0000"><b>partnerstreet </b></span>/>
      <<span style="color:#8B0000"><b>partnerpostalcode </b></span>/> - partner postal code
+
        <<span style="color:#8B0000"><b>partnerstreetnumber </b></span>/>  
      &lt;!--<span style="color:green">partner bank account</span>--&gt;
+
        <<span style="color:#8B0000"><b>partnerpostalcode </b></span>/> - partner postal code
      <<span style="color:#8B0000"><b>partnerbankaccount </b></span>/> - bank account
+
        &lt;!--<span style="color:green">partner bank account</span>--&gt;
      <<span style="color:#8B0000"><b>partnerbankname </b></span>/> - bank name
+
        <<span style="color:#8B0000"><b>partnerbank</b></span>>
      <<span style="color:#8B0000"><b>partneraccountcurrency </b></span>/> - bank account currency
+
  <<span style="color:#8B0000"><b>partnerbankaccount </b></span>/> - bank account
      <<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>partnerbankname </b></span>/> - bank name
      &lt;!--<span style="color:green">partner contact</span>--&gt;
+
          <<span style="color:#8B0000"><b>partneraccountcurrency </b></span>/> - bank account currency
      <<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>partnerbankaccountisdefault </b></span>/> - if value is 1, this account is configured in ERP as default account of partner
      <<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>partnerbank </b></span>>
      <<span style="color:#8B0000"><b>partnercontactsurname </b></span>/>
+
        &lt;!--<span style="color:green">partner contact</span>--&gt;
      <<span style="color:#8B0000"><b>partnercontactfirstname </b></span>/>
+
        <<span style="color:#8B0000"><b>partnercontact </b></span>>
      <<span style="color:#8B0000"><b>partnercontactemail </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>partnercontactemail2 </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>partnercontactphonenumber </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactsurname </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactphonenumber2 </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactfirstname </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactaddress </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactemail </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactobservations </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactemail2 </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountrycode </b></span>/> - country code (2 characters)
+
          <<span style="color:#8B0000"><b>partnercontactphonenumber </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountycode </b></span>/> - county code (2 characters)
+
          <<span style="color:#8B0000"><b>partnercontactphonenumber2 </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactcountyname </b></span>/> - from list defined in ERP
+
          <<span style="color:#8B0000"><b>partnercontactaddress </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>partnercontactobservations </b></span>/>
      <<span style="color:#8B0000"><b>partnercontactlocalityname </b></span>/> - from list defined in ERP
+
          <<span style="color:#8B0000"><b>partnercontactcountrycode </b></span>/> - country code (2 characters)
      <<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>partnercontactcountycode </b></span>/> - county code (2 characters)
      <<span style="color:#8B0000"><b>partnercontacttitle </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactcountyname </b></span>/> - from list defined in ERP
      <<span style="color:#8B0000"><b>partnercontactposition </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>partnercontactcode </b></span>/>
+
          <<span style="color:#8B0000"><b>partnercontactlocalityname </b></span>/> - from list defined in ERP
      <<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>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.
      &lt;!--<span style="color:green">transaction details</span>--&gt;
+
          <<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;
 
       <<span style="color:#8B0000"><b>records</b></span>>
 
       <<span style="color:#8B0000"><b>records</b></span>>
 
         <<span style="color:#8B0000"><b>record</b></span>>
 
         <<span style="color:#8B0000"><b>record</b></span>>

Revision as of 09:19, 1 October 2019

Xml - Purchase 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 supplier, or based on number of days configured on supplier.
     <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-->
     <isreturnpurchase /> - set value to 1 if is return purchase
     <simplifiedinvoice /> - set value to 1 if is simplified invoice
     <companynotregisteredforvat /> - set value to 1 if company is not registered for vat purpose
     <companyvatuponcollection /> - set value to 1 if company is registered for VAT upon collection
     <partnervatuponcollection /> - set value to 1 if partner 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)
     <partnervatuponcollectionfromconfig /> - if value is 1, the element partnervatuponcollection is decided based on fiscal configuration found in ERP (on partner)
     <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
     <!--identify partner-->
     <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
       <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
       <!--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>
         <nondeductible /> - if value is 1, this position is marked as nondeductible.
         <supplieraccount /> - account of supplier
         <productaccount /> - account of product/service
         <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 defined in ERP
         <assetcode /> - from list defined in ERP
         <project /> - from list defined in ERP
       </record >
     </records >
     <!--payment details-->
     <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
   </doc>
 </docs>
</root>