Visma e-conomic Connector Reference

52 metrics154 dimensions

The Visma e-conomic connector exposes 206 fields (52 metrics, 154 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Visma e-conomic Fields

Visma e-conomic accounting_entries fields

The accounting_entries report of the Visma e-conomic connector includes 12 fields.

ID Type Name Description
accounting_entries__account OBJECT Visma Economic Accounting Entries: Account The account the entry is posted to, including its self link.
accounting_entries__accountingyear TEXT Visma Economic Accounting Entries: Accounting Year The accounting year the entry belongs to (YYYY or YYYY/YYYY).
accounting_entries__accountnumber TEXT Visma Economic Accounting Entries: Account Number The number of the account the entry is posted to.
accounting_entries__amount NUMERIC Visma Economic Accounting Entries: Amount The total entry amount in the entry currency.
accounting_entries__amountinbasecurrency NUMERIC Visma Economic Accounting Entries: Amount In Base Currency The total entry amount in the base currency.
accounting_entries__currency TEXT Visma Economic Accounting Entries: Currency The ISO 4217 currency code of the entry.
accounting_entries__date DATE Visma Economic Accounting Entries: Date The entry issue date. Format according to ISO-8601 (YYYY-MM-DD).
accounting_entries__departmentaldistribution OBJECT Visma Economic Accounting Entries: Departmental Distribution The departments this entry is distributed between.
accounting_entries__entrynumber TEXT Visma Economic Accounting Entries: Entry Number The unique numerical identifier of the entry.
accounting_entries__entrytype TEXT Visma Economic Accounting Entries: Entry Type The type of the entry, e.g. customerInvoice or financeVoucher.
accounting_entries__text TEXT Visma Economic Accounting Entries: Text A short description of the entry.
accounting_entries__vouchernumber TEXT Visma Economic Accounting Entries: Voucher Number The number of the voucher the entry belongs to.

Visma e-conomic accounts fields

The accounts report of the Visma e-conomic connector includes 17 fields.

ID Type Name Description
accounts__accountingyears TEXT Visma Economic Accounts: Accounting Years A link to a list of accounting years for which the account is usable.
accounts__accountnumber NUMERIC Visma Economic Accounts: Account Number The account's number.
accounts__accountssummed OBJECT Visma Economic Accounts: Accounts Summed An array of the account intervals used for calculating the total for this account.
accounts__accounttype TEXT Visma Economic Accounts: Account Type The type of account in the chart of accounts.
accounts__balance NUMERIC Visma Economic Accounts: Balance The current balanace of the account.
accounts__barred BOOLEAN Visma Economic Accounts: Barred Shows if the account is barred from being used.
accounts__blockdirectentries BOOLEAN Visma Economic Accounts: Block Direct Entries Determines if the account can be manually updated with entries.
accounts__contraaccount OBJECT Visma Economic Accounts: Contra Account The default contra account of the account.
accounts__debitcredit TEXT Visma Economic Accounts: Debit Credit Describes the default update type of the account.
accounts__department OBJECT Visma Economic Accounts: Department The department associated with this account.
accounts__departmentaldistribution OBJECT Visma Economic Accounts: Departmental Distribution Information about a departmental distribution.
accounts__draftbalance NUMERIC Visma Economic Accounts: Draft Balance The current balance of the account including draft (not yet booked) entries.
accounts__name TEXT Visma Economic Accounts: Name The name of the account.
accounts__openingaccount OBJECT Visma Economic Accounts: Opening Account Opening Account field returned by the Accounts endpoint in the e-conomic API.
accounts__self TEXT Visma Economic Accounts: Self Link The unique self link of the contra account.
accounts__totalfromaccount OBJECT Visma Economic Accounts: Total From Account The account from which the sum total for this account is calculated.
accounts__vataccount OBJECT Visma Economic Accounts: VAT Account VAT Account field returned by the Accounts endpoint in the e-conomic API.

Visma e-conomic customers fields

The customers report of the Visma e-conomic connector includes 36 fields.

ID Type Name Description
customers__address TEXT Visma Economic Customers: Address Address for the customer including street and number.
customers__attention OBJECT Visma Economic Customers: Attention The customer's person of attention.
customers__balance NUMERIC Visma Economic Customers: Balance The outstanding amount for this customer.
customers__barred BOOLEAN Visma Economic Customers: Barred Boolean indication of whether the customer is barred from invoicing.
customers__city CITY Visma Economic Customers: City The customer's city.
customers__contacts TEXT Visma Economic Customers: Contacts A unique link reference to the customer contacts items.
customers__corporateidentificationnumber TEXT Visma Economic Customers: Corporate Identification Number Corporate Identification Number. For example CVR in Denmark.
customers__country COUNTRY Visma Economic Customers: Country The customer's country.
customers__creditlimit NUMERIC Visma Economic Customers: Credit Limit A maximum credit for this customer. Once the maximum is reached or passed in connection with an order/quotation/invoice for this customer you see a warning in e-conomic.
customers__currency TEXT Visma Economic Customers: Currency Default payment currency.
customers__customercontact OBJECT Visma Economic Customers: Customer Contact Reference to main contact employee at customer.
customers__customergroup OBJECT Visma Economic Customers: Customer Group Reference to the customer group this customer is attached to.
customers__customernumber TEXT Visma Economic Customers: Customer Number The customer number is a positive unique numerical identifier with a maximum of 9 digits.
customers__defaultdeliverylocation OBJECT Visma Economic Customers: Default Delivery Location Customer's default delivery location.
customers__deliverylocations TEXT Visma Economic Customers: Delivery Locations A unique link reference to the customer delivery locations items.
customers__dueamount NUMERIC Visma Economic Customers: Due Amount Due amount that the customer needs to pay.
customers__ean TEXT Visma Economic Customers: EAN European Article Number. EAN is used for invoicing the Danish public sector.
customers__einvoicingdisabledbydefault BOOLEAN Visma Economic Customers: E Invoicing Disabled By Default Boolean indication of whether the default sending method should be email instead of e-invoice. This property is updatable only by using PATCH to /customers/:customerNumber
customers__email TEXT Visma Economic Customers: Email Customer e-mail address where e-conomic invoices should be emailed. Note: you can specify multiple email addresses in this field, separated by a space. If you need to send a copy of the invoice or write to other e-mail addresses, you can also create one or more customer contacts.
customers__invoices OBJECT Visma Economic Customers: Invoices Invoices field returned by the Customers endpoint in the e-conomic API.
customers__lastupdated TEXT Visma Economic Customers: Last Updated The date this customer was last updated. The date is formatted according to ISO-8601.
customers__layout OBJECT Visma Economic Customers: Layout Layout to be applied for invoices and other documents for this customer.
customers__mobilephone TEXT Visma Economic Customers: Mobile Phone The customer's mobile phone number.
customers__name TEXT Visma Economic Customers: Name The customer name.
customers__paymentterms OBJECT Visma Economic Customers: Payment Terms The default payment terms for the customer.
customers__pnumber TEXT Visma Economic Customers: P Number Extension of corporate identification number (CVR). Identifying separate production unit (p-nummer).
customers__publicentrynumber TEXT Visma Economic Customers: Public Entry Number The public entry number is used for electronic invoicing, to define the account invoices will be registered on at the customer.
customers__salesperson OBJECT Visma Economic Customers: Sales Person Reference to the employee responsible for contact with this customer.
customers__self TEXT Visma Economic Customers: Self Link A unique link reference to the delivery location.
customers__telephoneandfaxnumber TEXT Visma Economic Customers: Telephone And Fax Number The customer's telephone and/or fax number.
customers__templates OBJECT Visma Economic Customers: Templates Templates available for the given customer
customers__totals OBJECT Visma Economic Customers: Totals Templates available for the given customer
customers__vatnumber TEXT Visma Economic Customers: VAT Number The customer's value added tax identification number. This field is only available to agreements in Sweden, UK, Germany, Poland and Finland. Not to be mistaken for the danish CVR number, which is defined on the corporateIdentificationNumber property.
customers__vatzone OBJECT Visma Economic Customers: VAT Zone Indicates in which VAT-zone the customer is located (e.g.: domestically, in Europe or elsewhere abroad).
customers__website TEXT Visma Economic Customers: Website Customer website, if applicable.
customers__zip TEXT Visma Economic Customers: ZIP The customer's postcode.

Visma e-conomic invoices_booked fields

The invoices_booked report of the Visma e-conomic connector includes 26 fields.

ID Type Name Description
invoices_booked__bookedinvoicenumber NUMERIC Visma Economic Invoices Booked: Booked Invoice Number A reference number for the booked invoice document.
invoices_booked__currency TEXT Visma Economic Invoices Booked: Currency The ISO 4217 currency code of the invoice.
invoices_booked__customer OBJECT Visma Economic Invoices Booked: Customer The customer being invoiced.
invoices_booked__date DATE Visma Economic Invoices Booked: Date Invoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked__delivery OBJECT Visma Economic Invoices Booked: Delivery The actual place of delivery for the goods on the invoice. This is usually the same place as the one referenced in the deliveryLocation property, but may be edited as required.
invoices_booked__deliverylocation OBJECT Visma Economic Invoices Booked: Delivery Location A reference to the place of delivery for the goods on the invoice
invoices_booked__duedate DATE Visma Economic Invoices Booked: Due Date The date the invoice is due for payment. Only used if the terms of payment is of type 'duedate', in which case it is mandatory. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked__exchangerate NUMERIC Visma Economic Invoices Booked: Exchange Rate The exchange rate between the invoice currency and the base currency of the agreement. The exchange rate expresses how much it will cost in base currency to buy 100 units of the invoice currency.
invoices_booked__grossamount NUMERIC Visma Economic Invoices Booked: Gross Amount The total invoice amount in the invoice currency after all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked__grossamountinbasecurrency NUMERIC Visma Economic Invoices Booked: Gross Amount In Base Currency The total invoice amount in the base currency of the agreement after all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked__layout OBJECT Visma Economic Invoices Booked: Layout Layout to be applied for this invoice.
invoices_booked__netamount NUMERIC Visma Economic Invoices Booked: Net Amount The total invoice amount in the invoice currency before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked__netamountinbasecurrency NUMERIC Visma Economic Invoices Booked: Net Amount In Base Currency The total invoice amount in the base currency of the agreement before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked__notes OBJECT Visma Economic Invoices Booked: Notes Notes on the invoice.
invoices_booked__ordernumber NUMERIC Visma Economic Invoices Booked: Order Number Order Number field returned by the Invoices Booked endpoint in the e-conomic API.
invoices_booked__paymentterms OBJECT Visma Economic Invoices Booked: Payment Terms The terms of payment for the invoice.
invoices_booked__pdf OBJECT Visma Economic Invoices Booked: PDF Link References a pdf representation of this invoice.
invoices_booked__project OBJECT Visma Economic Invoices Booked: Project A reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_booked__recipient OBJECT Visma Economic Invoices Booked: Recipient The actual recipient of the invoice. This may be the same info found on the customer (and will probably be so in most cases) but it may also be a different recipient. For instance, the customer placing the order may be ACME Headquarters, but the recipient of the invoice may be ACME IT.
invoices_booked__references OBJECT Visma Economic Invoices Booked: References Customer and company references related to this invoice.
invoices_booked__remainder NUMERIC Visma Economic Invoices Booked: Remainder Remaining amount to be paid.
invoices_booked__remainderinbasecurrency NUMERIC Visma Economic Invoices Booked: Remainder In Base Currency Remaining amount to be paid in base currency.
invoices_booked__roundingamount NUMERIC Visma Economic Invoices Booked: Rounding Amount The total rounding error, if any, on the invoice in base currency.
invoices_booked__self TEXT Visma Economic Invoices Booked: Self Link A unique reference to the payment term resource.
invoices_booked__sent TEXT Visma Economic Invoices Booked: Sent Status A convenience link to see if the invoice has been sent or not.
invoices_booked__vatamount NUMERIC Visma Economic Invoices Booked: VAT Amount The total amount of VAT on the invoice in the invoice currency. This will have the same sign as net amount

Visma e-conomic invoices_booked_document fields

The invoices_booked_document report of the Visma e-conomic connector includes 27 fields.

ID Type Name Description
invoices_booked_document__bookedinvoicenumber NUMERIC Visma Economic Invoices Booked Document: Booked Invoice Number A reference number for the booked invoice document.
invoices_booked_document__currency TEXT Visma Economic Invoices Booked Document: Currency The ISO 4217 currency code of the invoice.
invoices_booked_document__customer OBJECT Visma Economic Invoices Booked Document: Customer The customer being invoiced.
invoices_booked_document__date DATE Visma Economic Invoices Booked Document: Date Invoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked_document__delivery OBJECT Visma Economic Invoices Booked Document: Delivery The actual place of delivery for the goods on the invoice. This is usually the same place as the one referenced in the deliveryLocation property, but may be edited as required.
invoices_booked_document__deliverylocation OBJECT Visma Economic Invoices Booked Document: Delivery Location A reference to the place of delivery for the goods on the invoice
invoices_booked_document__duedate DATE Visma Economic Invoices Booked Document: Due Date The date the invoice is due for payment. Only used if the terms of payment is of type 'duedate', in which case it is mandatory. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked_document__exchangerate NUMERIC Visma Economic Invoices Booked Document: Exchange Rate The exchange rate between the invoice currency and the base currency of the agreement. The exchange rate expresses how much it will cost in base currency to buy 100 units of the invoice currency.
invoices_booked_document__grossamount NUMERIC Visma Economic Invoices Booked Document: Gross Amount The total invoice amount in the invoice currency after all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked_document__grossamountinbasecurrency NUMERIC Visma Economic Invoices Booked Document: Gross Amount In Base Currency The total invoice amount in the base currency of the agreement after all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked_document__layout OBJECT Visma Economic Invoices Booked Document: Layout Layout to be applied for this invoice.
invoices_booked_document__lines OBJECT Visma Economic Invoices Booked Document: Lines An array containing the specific invoice lines.
invoices_booked_document__netamount NUMERIC Visma Economic Invoices Booked Document: Net Amount The total invoice amount in the invoice currency before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked_document__netamountinbasecurrency NUMERIC Visma Economic Invoices Booked Document: Net Amount In Base Currency The total invoice amount in the base currency of the agreement before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_booked_document__notes OBJECT Visma Economic Invoices Booked Document: Notes Notes on the invoice.
invoices_booked_document__ordernumber NUMERIC Visma Economic Invoices Booked Document: Order Number Order Number field returned by the Invoices Booked Document endpoint in the e-conomic API.
invoices_booked_document__paymentterms OBJECT Visma Economic Invoices Booked Document: Payment Terms The terms of payment for the invoice.
invoices_booked_document__pdf OBJECT Visma Economic Invoices Booked Document: PDF Link References a pdf representation of this invoice.
invoices_booked_document__project OBJECT Visma Economic Invoices Booked Document: Project A reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_booked_document__recipient OBJECT Visma Economic Invoices Booked Document: Recipient The actual recipient of the invoice. This may be the same info found on the customer (and will probably be so in most cases) but it may also be a different recipient. For instance, the customer placing the order may be ACME Headquarters, but the recipient of the invoice may be ACME IT.
invoices_booked_document__references OBJECT Visma Economic Invoices Booked Document: References Customer and company references related to this invoice.
invoices_booked_document__remainder NUMERIC Visma Economic Invoices Booked Document: Remainder Remaining amount to be paid.
invoices_booked_document__remainderinbasecurrency NUMERIC Visma Economic Invoices Booked Document: Remainder In Base Currency Remaining amount to be paid in base currency.
invoices_booked_document__roundingamount NUMERIC Visma Economic Invoices Booked Document: Rounding Amount The total rounding error, if any, on the invoice in base currency.
invoices_booked_document__self TEXT Visma Economic Invoices Booked Document: Self Link A unique reference to the payment term resource.
invoices_booked_document__sent TEXT Visma Economic Invoices Booked Document: Sent Status A convenience link to see if the invoice has been sent or not.
invoices_booked_document__vatamount NUMERIC Visma Economic Invoices Booked Document: VAT Amount The total amount of VAT on the invoice in the invoice currency. This will have the same sign as net amount

Visma e-conomic invoices_booked_lines fields

The invoices_booked_lines report of the Visma e-conomic connector includes 20 fields.

ID Type Name Description
invoices_booked_lines__bookedinvoicenumber TEXT Visma Economic Invoices Booked Lines: Booked Invoice Number The number of the booked invoice the line belongs to.
invoices_booked_lines__currency TEXT Visma Economic Invoices Booked Lines: Currency The ISO 4217 currency code of the invoice.
invoices_booked_lines__customernumber TEXT Visma Economic Invoices Booked Lines: Customer Number The number of the customer being invoiced.
invoices_booked_lines__deliverydate DATE Visma Economic Invoices Booked Lines: Delivery Date Invoice line delivery date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked_lines__departmentaldistribution OBJECT Visma Economic Invoices Booked Lines: Departmental Distribution The departments this invoice line is distributed between. This requires the departments module to be enabled.
invoices_booked_lines__description TEXT Visma Economic Invoices Booked Lines: Description A description of the product or service sold.
invoices_booked_lines__discountpercentage NUMERIC Visma Economic Invoices Booked Lines: Discount Percentage A line discount expressed as a percentage.
invoices_booked_lines__invoicedate DATE Visma Economic Invoices Booked Lines: Invoice Date Issue date of the invoice the line belongs to. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked_lines__linenumber TEXT Visma Economic Invoices Booked Lines: Line Number The line number, unique within the invoice.
invoices_booked_lines__product OBJECT Visma Economic Invoices Booked Lines: Product The product or service offered on the invoice line.
invoices_booked_lines__productnumber TEXT Visma Economic Invoices Booked Lines: Product Number The unique product number of the product or service on the line. This can be a stock keeping unit identifier (SKU).
invoices_booked_lines__quantity NUMERIC Visma Economic Invoices Booked Lines: Quantity The number of units of goods on the invoice line.
invoices_booked_lines__sortkey TEXT Visma Economic Invoices Booked Lines: Sort Key A sort key used to sort the lines in ascending order within the invoice.
invoices_booked_lines__totalnetamount NUMERIC Visma Economic Invoices Booked Lines: Total Net Amount The total invoice line amount in the invoice currency before taxes. For a credit note this amount will be negative.
invoices_booked_lines__unit OBJECT Visma Economic Invoices Booked Lines: Unit The unit of measure applied to the invoice line.
invoices_booked_lines__unitcostprice NUMERIC Visma Economic Invoices Booked Lines: Unit Cost Price The cost price of 1 unit of the goods or services in the invoice currency.
invoices_booked_lines__unitname TEXT Visma Economic Invoices Booked Lines: Unit Name The name of the unit of measure applied to the line (e.g. 'kg' for weight or 'l' for volume).
invoices_booked_lines__unitnetprice NUMERIC Visma Economic Invoices Booked Lines: Unit Net Price The price of 1 unit of the goods or services on the invoice line in the invoice currency.
invoices_booked_lines__vatamount NUMERIC Visma Economic Invoices Booked Lines: VAT Amount The total amount of VAT on the invoice line in the invoice currency. This will have the same sign as total net amount.
invoices_booked_lines__vatrate NUMERIC Visma Economic Invoices Booked Lines: VAT Rate The VAT rate in % used to calculate the VAT amount on this line.

Visma e-conomic invoices_paid fields

The invoices_paid report of the Visma e-conomic connector includes 26 fields.

ID Type Name Description
invoices_paid__bookedinvoicenumber NUMERIC Visma Economic Invoices Paid: Booked Invoice Number A reference number for the booked invoice document.
invoices_paid__currency TEXT Visma Economic Invoices Paid: Currency The ISO 4217 currency code of the invoice.
invoices_paid__customer OBJECT Visma Economic Invoices Paid: Customer The customer being invoiced.
invoices_paid__date DATE Visma Economic Invoices Paid: Date Invoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_paid__delivery OBJECT Visma Economic Invoices Paid: Delivery The actual place of delivery for the goods on the invoice. This is usually the same place as the one referenced in the deliveryLocation property, but may be edited as required.
invoices_paid__deliverylocation OBJECT Visma Economic Invoices Paid: Delivery Location A reference to the place of delivery for the goods on the invoice
invoices_paid__duedate DATE Visma Economic Invoices Paid: Due Date The date the invoice is due for payment. Format according to ISO-8601 (YYYY-MM-DD). This is only used if the terms of payment is of type 'duedate'.
invoices_paid__exchangerate NUMERIC Visma Economic Invoices Paid: Exchange Rate Exchange Rate field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__grossamount NUMERIC Visma Economic Invoices Paid: Gross Amount The total invoice amount in the invoice currency after all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_paid__grossamountinbasecurrency NUMERIC Visma Economic Invoices Paid: Gross Amount In Base Currency Gross Amount In Base Currency field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__layout OBJECT Visma Economic Invoices Paid: Layout Layout to be applied for this invoice.
invoices_paid__netamount NUMERIC Visma Economic Invoices Paid: Net Amount The total invoice amount in the invoice currency before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_paid__netamountinbasecurrency NUMERIC Visma Economic Invoices Paid: Net Amount In Base Currency The total invoice amount in the base currency of the agreement before all taxes and discounts have been applied. For a credit note this amount will be negative.
invoices_paid__notes OBJECT Visma Economic Invoices Paid: Notes Notes on the invoice.
invoices_paid__ordernumber NUMERIC Visma Economic Invoices Paid: Order Number Order Number field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__paymentterms OBJECT Visma Economic Invoices Paid: Payment Terms The terms of payment for the invoice.
invoices_paid__pdf OBJECT Visma Economic Invoices Paid: PDF Link References a pdf representation of this invoice.
invoices_paid__project OBJECT Visma Economic Invoices Paid: Project A reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_paid__recipient OBJECT Visma Economic Invoices Paid: Recipient The actual recipient of the invoice. This may be the same info found on the customer (and will probably be so in most cases) but it may also be a different recipient. For instance, the customer placing the order may be ACME Headquarters, but the recipient of the invoice may be ACME IT.
invoices_paid__references OBJECT Visma Economic Invoices Paid: References Customer and company references related to this invoice.
invoices_paid__remainder NUMERIC Visma Economic Invoices Paid: Remainder Remaining amount to be paid.
invoices_paid__remainderinbasecurrency NUMERIC Visma Economic Invoices Paid: Remainder In Base Currency Remaining amount to be paid in base currency.
invoices_paid__roundingamount NUMERIC Visma Economic Invoices Paid: Rounding Amount The total rounding error, if any, on the invoice in base currency.
invoices_paid__self TEXT Visma Economic Invoices Paid: Self Link A unique reference to the payment term resource.
invoices_paid__sent TEXT Visma Economic Invoices Paid: Sent Status A convenience link to see if the invoice has been sent or not.
invoices_paid__vatamount NUMERIC Visma Economic Invoices Paid: VAT Amount The total amount of VAT on the invoice in the invoice currency. This will have the same sign as net amount

Visma e-conomic invoices_total fields

The invoices_total report of the Visma e-conomic connector includes 4 fields.

ID Type Name Description
invoices_total__booked OBJECT Visma Economic Invoices Total: Booked The totals for booked invoices.
invoices_total__drafts OBJECT Visma Economic Invoices Total: Drafts The totals for draft invoices.
invoices_total__predefinedperiodfilters OBJECT Visma Economic Invoices Total: Predefined Period Filters The totals for draft invoices.
invoices_total__self TEXT Visma Economic Invoices Total: Self Link A reference to the invoices totals draft resource.

Visma e-conomic products fields

The products report of the Visma e-conomic connector includes 17 fields.

ID Type Name Description
products__barcode TEXT Visma Economic Products: Bar Code String representation of a machine readable barcode symbol that represents this product.
products__barred BOOLEAN Visma Economic Products: Barred If this value is true, then the product can no longer be sold, and trying to book an invoice with this product will not be possible.
products__costprice NUMERIC Visma Economic Products: Cost Price The cost of the goods. If you have the inventory module enabled, this is read-only and will just be ignored.
products__departmentaldistribution OBJECT Visma Economic Products: Departmental Distribution A departmental distribution defines which departments this entry is distributed between. This requires the departments module to be enabled.
products__description TEXT Visma Economic Products: Description Free text description of product.
products__inventory OBJECT Visma Economic Products: Inventory A collection of properties that are only applicable if the inventory module is enabled.
products__invoices OBJECT Visma Economic Products: Invoices A collection of convenience links to invoices that contains this product.
products__lastupdated TEXT Visma Economic Products: Last Updated The last time the product was updated, either directly or through inventory changed. The date is formatted according to ISO-8601.
products__minimumstock NUMERIC Visma Economic Products: Minimum Stock Minimum Stock field returned by the Products endpoint in the e-conomic API.
products__name TEXT Visma Economic Products: Name Descriptive name of the product.
products__pricing OBJECT Visma Economic Products: Pricing Pricing field returned by the Products endpoint in the e-conomic API.
products__productgroup OBJECT Visma Economic Products: Product Group A reference to the product group this product is contained within.
products__productnumber TEXT Visma Economic Products: Product Number Unique alphanumeric product number.
products__recommendedprice NUMERIC Visma Economic Products: Recommended Price Recommended retail price of the goods.
products__salesprice NUMERIC Visma Economic Products: Sales Price This is the unit net price that will appear on invoice lines when a product is added to an invoice line.
products__self TEXT Visma Economic Products: Self Link A unique reference to the unit resource.
products__unit OBJECT Visma Economic Products: Unit A reference to the unit this product is counted in.

Visma e-conomic other fields

The Visma e-conomic connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID.
account_name TEXT Account Name Account name.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date Date.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20