Fivaldi laskutusaineisto XML

Tiedostomuoto

Siirtotiedosto on XML-muotoista tietoa.

Rajaukset 

• Fivaldi Business ID tulee olla syötetty Nepton-palveluun valikossa Työaika - Hallinta - Työyhteisön asetukset - Liittymät - Palkanlaskentajärjestelmän tunniste.
• Työntekijät työntekijänumerolla 0 eivät tule osaksi aineistoa

Aineiston rakenne 

Aineiston esimerkki

Tuetut kentät listattu esimerkissä:

<?xml version="1.0" encoding="ISO-8859-15"?>
<FivaldiXML>
  <!-- Fivaldi business id setting is used. Can be overridden with SQL rule. -->
  <FVBusinessId>01010ÄÄ1-1</FVBusinessId>
  <SalesOrder>
    <!-- Unique identifier for the SalesOrder generated in export. -->
    <SalesOrderNo>1234567890</SalesOrderNo> 
    <SalesOrderExecutor>
      <!-- First name(s) last name of the employee whose data is exported. -->
      <FVSalesmanName>Frankie Employee</FVSalesmanName>
      <FVSalesmanTelephone/>
      <FVSalesmanEmail/>
    </SalesOrderExecutor>
    <!-- ProjectCode1, can be overridden. Max length 10 characters. -->
    <SalesOrderCompanyId>12345</SalesOrderCompanyId>
    <!-- optional, may be set with SQL -->
    <SalesOrderName1>Name 1</SalesOrderName1>
    <!-- optional, may be set with SQL -->
    <SalesOrderName2>Name 2</SalesOrderName2>
    <!-- optional, may be set with SQL -->
    <SalesOrderStreetAddress>Street Address</SalesOrderStreetAddress>
    <!-- optional, may be set with SQL -->
    <SalesOrderStreetAddress2>Street Address 2</SalesOrderStreetAddress2>
    <!-- optional, may be set with SQL -->
    <SalesOrderPostalAddress>Postal Address</SalesOrderPostalAddress>
    <!-- optional, may be set with SQL -->
    <SalesOrderCountry>FI</SalesOrderCountry>
    <!-- optional, may be set with SQL -->
    <SalesOrderReference>REF</SalesOrderReference>
    <!-- Salary rendering date of the exported event -->
    <SalesOrderDate>2021-04-31</SalesOrderDate>
    <!-- optional, may be set with SQL -->
    <SalesOrderWarehouseCode>12</SalesOrderWarehouseCode>
    <!-- optional, may be set with SQL -->
    <SalesOrderWarehouseName>Name</SalesOrderWarehouseName>
    <!-- Exported event's notes, can be overridden. -->
    <SalesOrderAdditionalInfo>example note</SalesOrderAdditionalInfo>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryDate>2021-11-12</SalesOrderDeliveryDate>
    <!-- optional, may be set with SQL --> 
    <SalesOrderTaxableTotal>1400000000.1511</SalesOrderTaxableTotal>
    <!-- optional, may be set with SQL --> 
    <SalesOrderTotalIncludingTax>10.12</SalesOrderTotalIncludingTax>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryName1>Name</SalesOrderDeliveryName1>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryName2>Name</SalesOrderDeliveryName2>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryStreetAddr>Street Address</SalesOrderDeliveryStreetAddr>
    <!-- optional, may be set with SQL -->
    <SalesOrderDeliveryStreetAddr2>Street Address 2</SalesOrderDeliveryStreetAddr2>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryPostalAddr>Postal Address</SalesOrderDeliveryPostalAddr>
    <!-- optional, may be set with SQL --> 
    <SalesOrderDeliveryCountry>SE</SalesOrderDeliveryCountry>
    <!-- optional, may be set with SQL --> 
    <SalesOrderCurrency>EUR</SalesOrderCurrency>
    <!-- optional, may be set with SQL --> 
    <SalesOrderExchangeRate>1.1</SalesOrderExchangeRate>
    <!-- optional, may be set with SQL --> 
    <SalesOrderCashDate>2021-11-10</SalesOrderCashDate>
    <!-- optional, may be set with SQL --> 
    <SalesOrderCashPercent>12</SalesOrderCashPercent>
    <!-- optional, may be set with SQL --> 
    <SalesOrderNetDate>2021-11-15</SalesOrderNetDate>
    <!-- optional, may be set with SQL, value 0 or 1 -->
    <SalesOrderInvoicingPermit Value="1"/>
    <!-- optional, may be set with SQL --> 
    <SalesOrderOfferEffectiveDate>2021-11-14</SalesOrderOfferEffectiveDate>
    <!-- optional, may be set with SQL --> 
    <SalesOrderOrderer>Orderer</SalesOrderOrderer>
    <!-- optional, may be set with SQL --> 
    <SalesOrderPostingGroupId>GroupID</SalesOrderPostingGroupId>
    <!-- optional, may be set with SQL --> 
    <SalesOrderInternalInfo>Internal Info</SalesOrderInternalInfo>
    <SalesOrderRow>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowNo>13</SalesOrderRowNo>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowProductId>ID12314</SalesOrderRowProductId>
      <!-- Hours / pcs from the exported event / supplement etc. Can be overridden -->
      <SalesOrderRowQuantity>9</SalesOrderRowQuantity>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowProductType>23</SalesOrderRowProductType>
      <!-- Salary code -->
      <SalesOrderRowProductName>Example987654321</SalesOrderRowProductName>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowDiscountPercent1>13.45</SalesOrderRowDiscountPercent1>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowDiscountPercent2>55.65</SalesOrderRowDiscountPercent2>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowTaxableUnitPrice>1234.234</SalesOrderRowTaxableUnitPrice>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowUnitPriceInclTax>23453.23</SalesOrderRowUnitPriceInclTax>
      <!-- Salary rendering date of the exported event -->
      <SalesOrderRowDeliveryDate>2021-05-31</SalesOrderRowDeliveryDate>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowVatDate>2021-12-22</SalesOrderRowVatDate>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowProductSupplierCompanyId>ID</SalesOrderRowProductSupplierCompanyId>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowTaxableCostPrice>342.56</SalesOrderRowTaxableCostPrice>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowTaxableTotal>342.23</SalesOrderRowTaxableTotal>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowTotalIncludingTax>2343.23</SalesOrderRowTotalIncludingTax>
      <!-- optional, may be set with SQL, value 0 or 1 -->
      <SalesOrderRowInvoicingChoice Value="1"/>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowWarehouseCode>23</SalesOrderRowWarehouseCode>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowWarehouseName>Name</SalesOrderRowWarehouseName>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowWarehouseBatchId>BatchId</SalesOrderRowWarehouseBatchId>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowAdditionalInfo>Additional Info</SalesOrderRowAdditionalInfo>
      <!-- optional, may be set with SQL, value 0 or 1 -->
      <SalesOrderRowStatisticsRow Value="0"/>
      <!-- optional, may be set with SQL --> 
      <SalesOrderRowDeliveredQuantity>23.54</SalesOrderRowDeliveredQuantity>
    </SalesOrderRow>
  </SalesOrder>
</FivaldiXML>