Difference between revisions of "Import:Vanzare cu incasare XML"
(→Xml - Sales invoice with payment) |
(→Xml - Sales invoice with payment) |
||
Line 12: | Line 12: | ||
<docs> | <docs> | ||
<doc> | <doc> | ||
− | <<span style="color:red">nrcrt</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:red"><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:green">identify company</span>--> | <!--<span style="color:green">identify company</span>--> | ||
− | <<span style="color:red">companyunitcode</span> /> * - company unit code defined in ERP. | + | <<span style="color:red"><b>companyunitcode</b></span> /> * - company unit code defined in ERP. |
− | <<span style="color:red">companydivisioncode</span> /> * - company division code defined in ERP. | + | <<span style="color:red"><b>companydivisioncode</b></span> /> * - company division code defined in ERP. |
<!--<span style="color:green">document specific info</span>--> | <!--<span style="color:green">document specific info</span>--> | ||
− | <docid /> * - one of elements docid , doccode or docname is mandatory | + | <<span style="color:red"><b>docid</b></span> /> * - one of elements docid , doccode or docname is mandatory |
− | <doccode /> | + | <<span style="color:red"><b>doccode</b></span> /> |
− | <docname /> | + | <<span style="color:red"><b>docname</b></span> /> |
− | <doctype /> - document type – from list defined in ERP under the document identified from previous elements | + | <<span style="color:red"><b>doctype</b></span> /> - document type – from list defined in ERP under the document identified from previous elements |
− | <docdate /> * - document date | + | <<span style="color:red"><b>docdate</b></span> /> * - document date |
− | <docreportingdate /> - for companies wich use 2 reportings : one for state reporting and one for reporting to group | + | <<span style="color:red"><b>docreportingdate</b></span> /> - for companies wich use 2 reportings : one for state reporting and one for reporting to group |
− | <docnumber /> * - document number | + | <<span style="color:red"><b>docnumber</b></span> /> * - document number |
− | <duedate /> - due date | + | <<span style="color:red"><b>duedate</b></span> /> - 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. | + | <<span style="color:red"><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. |
− | <explanations /> | + | <<span style="color:red"><b>explanations</b></span> /> |
− | <explanations2 /> | + | <<span style="color:red"><b>explanations2</b></span> /> |
− | <docexternalimportid /> - identification number from another system | + | <<span style="color:red"><b>docexternalimportid</b></span> /> - identification number from another system |
− | <docexternalimportidcheckisunique /> - if value is 1, an error is returned if exists another document with this external id. | + | <<span style="color:red"><b>docexternalimportidcheckisunique</b></span> /> - if value is 1, an error is returned if exists another document with this external id. |
− | + | <!--<span style="color:green">document context info</span>--> | |
<dociscancelled /> - document is marked as canceled | <dociscancelled /> - document is marked as canceled | ||
<iscustomerreturn /> - set value to 1 if is customer return | <iscustomerreturn /> - set value to 1 if is customer return |
Revision as of 07:39, 1 October 2019
- Financiar si contabilitate
- Contabilitate
- Configurare
- Import
- Import:Vanzare cu incasare
- Vanzare cu incasare XML
- Import:Vanzare cu incasare
- Import
- Configurare
- Contabilitate
Xml - Sales invoice with payment
*elements marked with this sign are mandatory
<root>
<docs>
<doc>
<nrcrt />* 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 /> * - one of elements docid , doccode or docname is mandatory
<doccode />
<docname />
<doctype /> - document type – from list defined in ERP under the document identified from previous elements
<docdate /> * - document date
<docreportingdate /> - for companies wich use 2 reportings : one for state reporting and one for reporting to group
<docnumber /> * - document number
<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).
<accountingregistername />
<reversechargecategory /> - from list defined in ERP
<specialregimecategory /> - from list defined in ERP
<caencode /> - from list defined in ERP
<partnerid /> * - id of partner in ERP Partner is a madatory field. It can be determined from one of following elements: partnerid , partnervatnumber , partnername.
<partnervatnumber /> - partner vat number
<partnername /> - partner name
<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
<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
<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
<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
<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>
<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>