Loading
Uniconta
  • Search
  • Uniconta
    • Functions
      • General ledger
      • Orders & Purchase
      • Inventory & Logistics
      • Project
      • Production
      • Dashboard
      • Business Rules
      • ODATA ikonCustomisation
      • See all →
    • Apps
      • Invoice App Create Invoices
      • Upload App Submit reciepts & expenses
      • Assistant App Project Management
      • Work App Time Tracking
      • Authenticator App Two-Factor Authentication
    • Integrations
      • Add-on Store
    • Download & Login
      • Download Uniconta
      • Web Login
  • Developers
    • Build & Integrate
      • Get API Key
      • Download for Developers
      • Documentation
    • Resources & Code
      • Samples
      • Add-on solutions and users
    • Partner Ecosystem
      • Become an integration partner
      • Partner Portal
  • Insights
    • News
      • Latest News
      • Release Notes
      • Customer Stories
    • Get started
      • Try Uniconta
      • Book a Demo
  • Contact
  • Get Uniconta
  • Contact us
  • Find a reseller
Free trial signup

Unipedia

  • Get started
  • Chart of accounts
  • Customer
  • Vendor
  • Tools
  • Project
  • Purchase
  • General
  • CRM
  • Inventory
  • Company
  • Reports Reports under Project
  • Tools
  • Report generator
  • User-defined fields User-defined fields under Tools
  • User-defined tables User-defined tables under Tools
  • WebPortal
  • Data accesses
  • UC Menu – Addon store

Fields in special reports

2,666 views 25 January 2019 4 September 2025 4 minutes
Print Friendly, PDF & Email

Learn more about:

  • Layouts - global
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attaching documents and notes
September 4th, 2025

When working in the report generator, you often need fields other than the default ones in the report.

Below is a description of how the Field List is structured, where to find the desired fields and which fields should be used.

The Description belongs to the special reports Invoices, Credit note, Delivery note, Order confirmation, Quotation and Pick list.

 

Useful field names in the report generator

Field nameDatabase name EnglishDatabase name Danish
Company information
CVR no.[CompanyInfo][ID].[CompanyInfo][CVR no.]
Phone no.[CompanyInfo.Phone][CompanyInfo][Phone]
WWW/homepage[CompanyInfo][WWW].[CompanyInfo][WWW]
Order header
Payment, the long description[InvoiceInfo], [PaymentTermRef], [Name][InvoiceInfo][PaymentTermRef][Name]
FIK code[InvoiceInfo.FIKCode][InvoiceInfo][FIK Code]
Comment (from Sales Orders)[InvoiceInfo.Remark][InvoiceInfo][Comments]
Requisition No.[InvoiceInfo.Requisition][InvoiceInfo].[Requisition]
Our reference[InvoiceInfo.OurRef][InvoiceInfo][OurRef]
Your reference[InvoiceInfo.YourRef][InvoiceInfo][YourRef]
Delivery name[InvoiceInfo.DeliveryName][InvoiceInfo][DeliveryName]
DeliveryAddress1[InvoiceInfo.DeliveryAddress1][InvoiceInfo][DeliveryAddress1]
DeliveryAddress2[InvoiceInfo.DeliveryAddress2][InvoiceInfo][DeliveryAddress2]
Delivery zip code and city[InvoiceInfo.DeliveryZipCode]
[InvoiceInfo.DeliveryCity]
[InvoiceInfo][DeliveryCity]
[InvoiceInfo][DeliveryPostNumber]
Delivery date[InvoiceInfo][Delivery date]
Customer’s CVR no.[DebtorInfo][CompanyRegNo][DebtorInfo][CVR-no]
Are there any documents attached to the order? A check mark field.[OrderInfo][HasDocs].[OrderInfo][HasDocs].
Are there notes attached to the order? A check mark field.[OrderInfo][HasNotes].[OrderInfo][HasNotes].
Order lines
Delivery date from the order header
NB! This field can be overwritten on the order lines and will appear in the same field.
[DataOnOrder][Order date]
Delivery date from the order header[InvoiceInfo].[Delivery date]
Date from the order line (Order date)[DataOnOrder][Order Date]

 

We have 2 ‘heads’ in our reports: Invoice head and Order/Purchase head.

Noticed! The order/purchase header does not exist in the reprint.

But the invoice header has almost all the same fields as the order, including the custom fields.

Fields should therefore be taken from the Invoice header [InvoiceInfo] as far as possible.

Field list

Field list consists of all the tables and fields that our custom report can contain.

It is divided as shown below and there will be a description next to each screenshot.

InvoiceSumFields
InvoiceSumFields contains pre-calculated fields that can be used anywhere in the report.

  • Basic amount – Contains the net amount
  • Label – Contains label for % (VAT amount/Final discount)
  • Label % – Contains label for VAT amount (25%) or Final discount (10%)
  • VAT –
  • Percentage – Contains the VAT percentage (In Denmark 25)
  • Total – Contains the VAT amount

CompanyInfo

Under CompanyInfo you will find all the information for the company/account that is available in the report generator.

This is information that can be changed under Company/Company details

DebtorInfo

Under CustomerInfo you will find all the information for the Customer that is available in the report generator.

The subfolders contain references to the directories that Customer has a reference to, e.g. DebtorGroup

DebtorInfo/InventoryTransInvoice

Under DebtorInfo/InventoryTransInvoice you will find all the information that is on the order lines and can be listed in the report.

By default, only a few information is shown on the lines, but if you need additional fields, these can be found here and dragged out on the report.

DebtorInfo/InventoryTransInvoice/InvItem

Under DebtorInfo/InventoryTransInvoice/InvItem you can find the remaining information about the goods. If all the information you want is not available in InventoryTransInvoice, you can go a step further and look in the item list itself (InvItem)

InvoiceInfo

Under InvoiceInfo you will find all the information that is stored on the invoice itself. These fields must be used if you want to be able to reprint your invoice, credit note, etc. InvoiceInfo contains the posted data. Unlike OrderInfo, which only contains the order information as long as the order is in the order archive.

OrderInfo

Under OrderInfo you will find all the information for the order that is available in the report generator.

Note: If you want to reprint an invoice etc. you must use the InvoiceInfo table instead of OrderInfo.

Table browser

An overview of all fields can be found under Tools/Report generator/Table browser.

Here you will find all the tables that Uniconta contains, as well as all the field names. If you cannot find a field in the report generator, you can look it up in the table browser, find the current table/index and see what the field is called in both English and Danish.

To find the folder button, click on the current tab/screen and press the F12 key. This will give you the name of the folder the selected date is in and you can find the folder in the table browser.

 

  • Was this Helpful ?
  • YesNo
Categories: Report generator, Tools, Unipedia
Home » Unipedia » Fields in special reports

Get in touch with us

Uniconta

  • Uniconta
  • Modules
  • Downloads
  • Free trial signup
  • Subscription Terms
  • Privacy Policy
  • System Status

PARTNER

  • Resellers
  • For Developers
  • Uniconta API key application
  • Uniconta Partner info

Info

  • News
  • Updates
  • Customer cases
  • Video
  • IT Security
  • Backup procedure – global
  • About us

Support

  • Unipedia
  • API information
  • Contacts
© Uniconta  2026

facebook linkedin youtube

  • Visit a Country Site
    • Dansk
    • Uniconta GermanyDeutsch
    • Eesti
    • Uniconta GermanyÍslenska
    • Lietuva
    • Uniconta NetherlandsNederlands
    • Norsk
    • English