Visma e-conomic Connector Reference
The Visma e-conomic connector exposes 170 fields (46 metrics, 124 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 | TEXT | 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 | TEXT | 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 | TEXT | 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 | NUMERIC | 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 | TEXT | 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 | TEXT | 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 | TEXT | 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 | TEXT | 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_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 | TEXT | 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 | TEXT | 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 5 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 |
|---|---|---|---|---|
| data_fetched_at | 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 | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
Windsor vs Coupler.io
