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 Invoice, Credit note, Delivery note, Order confirmation, Offer and Pick list.
Useful field names in the report generator
| Field name |
Database name English |
Database 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%)
- Moms -
- 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 DebtorInfo you will find all the information for the debtor that is available in the report generator.
The subfolders contain references to the directories that Debtor 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.