Visma e-conomic Connector Reference

46 metrics124 dimensions

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.

IDTypeNameDescription
accounting_entries__accountOBJECTVisma Economic Accounting Entries: AccountThe account the entry is posted to, including its self link.
accounting_entries__accountingyearTEXTVisma Economic Accounting Entries: Accounting YearThe accounting year the entry belongs to (YYYY or YYYY/YYYY).
accounting_entries__accountnumberTEXTVisma Economic Accounting Entries: Account NumberThe number of the account the entry is posted to.
accounting_entries__amountNUMERICVisma Economic Accounting Entries: AmountThe total entry amount in the entry currency.
accounting_entries__amountinbasecurrencyNUMERICVisma Economic Accounting Entries: Amount In Base CurrencyThe total entry amount in the base currency.
accounting_entries__currencyTEXTVisma Economic Accounting Entries: CurrencyThe ISO 4217 currency code of the entry.
accounting_entries__dateTEXTVisma Economic Accounting Entries: DateThe entry issue date. Format according to ISO-8601 (YYYY-MM-DD).
accounting_entries__departmentaldistributionOBJECTVisma Economic Accounting Entries: Departmental DistributionThe departments this entry is distributed between.
accounting_entries__entrynumberTEXTVisma Economic Accounting Entries: Entry NumberThe unique numerical identifier of the entry.
accounting_entries__entrytypeTEXTVisma Economic Accounting Entries: Entry TypeThe type of the entry, e.g. customerInvoice or financeVoucher.
accounting_entries__textTEXTVisma Economic Accounting Entries: TextA short description of the entry.
accounting_entries__vouchernumberTEXTVisma Economic Accounting Entries: Voucher NumberThe 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.

IDTypeNameDescription
accounts__accountingyearsTEXTVisma Economic Accounts: Accounting YearsA link to a list of accounting years for which the account is usable.
accounts__accountnumberNUMERICVisma Economic Accounts: Account NumberThe account's number.
accounts__accountssummedOBJECTVisma Economic Accounts: Accounts SummedAn array of the account intervals used for calculating the total for this account.
accounts__accounttypeTEXTVisma Economic Accounts: Account TypeThe type of account in the chart of accounts.
accounts__balanceNUMERICVisma Economic Accounts: BalanceThe current balanace of the account.
accounts__barredBOOLEANVisma Economic Accounts: BarredShows if the account is barred from being used.
accounts__blockdirectentriesBOOLEANVisma Economic Accounts: Block Direct EntriesDetermines if the account can be manually updated with entries.
accounts__contraaccountOBJECTVisma Economic Accounts: Contra AccountThe default contra account of the account.
accounts__debitcreditTEXTVisma Economic Accounts: Debit CreditDescribes the default update type of the account.
accounts__departmentOBJECTVisma Economic Accounts: DepartmentThe department associated with this account.
accounts__departmentaldistributionOBJECTVisma Economic Accounts: Departmental DistributionInformation about a departmental distribution.
accounts__draftbalanceNUMERICVisma Economic Accounts: Draft BalanceThe current balance of the account including draft (not yet booked) entries.
accounts__nameTEXTVisma Economic Accounts: NameThe name of the account.
accounts__openingaccountOBJECTVisma Economic Accounts: Opening AccountOpening Account field returned by the Accounts endpoint in the e-conomic API.
accounts__selfTEXTVisma Economic Accounts: Self LinkThe unique self link of the contra account.
accounts__totalfromaccountOBJECTVisma Economic Accounts: Total From AccountThe account from which the sum total for this account is calculated.
accounts__vataccountOBJECTVisma Economic Accounts: VAT AccountVAT 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.

IDTypeNameDescription
customers__addressTEXTVisma Economic Customers: AddressAddress for the customer including street and number.
customers__attentionOBJECTVisma Economic Customers: AttentionThe customer's person of attention.
customers__balanceNUMERICVisma Economic Customers: BalanceThe outstanding amount for this customer.
customers__barredBOOLEANVisma Economic Customers: BarredBoolean indication of whether the customer is barred from invoicing.
customers__cityTEXTVisma Economic Customers: CityThe customer's city.
customers__contactsTEXTVisma Economic Customers: ContactsA unique link reference to the customer contacts items.
customers__corporateidentificationnumberTEXTVisma Economic Customers: Corporate Identification NumberCorporate Identification Number. For example CVR in Denmark.
customers__countryTEXTVisma Economic Customers: CountryThe customer's country.
customers__creditlimitNUMERICVisma Economic Customers: Credit LimitA 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__currencyTEXTVisma Economic Customers: CurrencyDefault payment currency.
customers__customercontactOBJECTVisma Economic Customers: Customer ContactReference to main contact employee at customer.
customers__customergroupOBJECTVisma Economic Customers: Customer GroupReference to the customer group this customer is attached to.
customers__customernumberNUMERICVisma Economic Customers: Customer NumberThe customer number is a positive unique numerical identifier with a maximum of 9 digits.
customers__defaultdeliverylocationOBJECTVisma Economic Customers: Default Delivery LocationCustomer's default delivery location.
customers__deliverylocationsTEXTVisma Economic Customers: Delivery LocationsA unique link reference to the customer delivery locations items.
customers__dueamountNUMERICVisma Economic Customers: Due AmountDue amount that the customer needs to pay.
customers__eanTEXTVisma Economic Customers: EANEuropean Article Number. EAN is used for invoicing the Danish public sector.
customers__einvoicingdisabledbydefaultBOOLEANVisma Economic Customers: E Invoicing Disabled By DefaultBoolean 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__emailTEXTVisma Economic Customers: EmailCustomer 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__invoicesOBJECTVisma Economic Customers: InvoicesInvoices field returned by the Customers endpoint in the e-conomic API.
customers__lastupdatedTEXTVisma Economic Customers: Last UpdatedThe date this customer was last updated. The date is formatted according to ISO-8601.
customers__layoutOBJECTVisma Economic Customers: LayoutLayout to be applied for invoices and other documents for this customer.
customers__mobilephoneTEXTVisma Economic Customers: Mobile PhoneThe customer's mobile phone number.
customers__nameTEXTVisma Economic Customers: NameThe customer name.
customers__paymenttermsOBJECTVisma Economic Customers: Payment TermsThe default payment terms for the customer.
customers__pnumberTEXTVisma Economic Customers: P NumberExtension of corporate identification number (CVR). Identifying separate production unit (p-nummer).
customers__publicentrynumberTEXTVisma Economic Customers: Public Entry NumberThe public entry number is used for electronic invoicing, to define the account invoices will be registered on at the customer.
customers__salespersonOBJECTVisma Economic Customers: Sales PersonReference to the employee responsible for contact with this customer.
customers__selfTEXTVisma Economic Customers: Self LinkA unique link reference to the delivery location.
customers__telephoneandfaxnumberTEXTVisma Economic Customers: Telephone And Fax NumberThe customer's telephone and/or fax number.
customers__templatesOBJECTVisma Economic Customers: TemplatesTemplates available for the given customer
customers__totalsOBJECTVisma Economic Customers: TotalsTemplates available for the given customer
customers__vatnumberTEXTVisma Economic Customers: VAT NumberThe 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__vatzoneOBJECTVisma Economic Customers: VAT ZoneIndicates in which VAT-zone the customer is located (e.g.: domestically, in Europe or elsewhere abroad).
customers__websiteTEXTVisma Economic Customers: WebsiteCustomer website, if applicable.
customers__zipTEXTVisma Economic Customers: ZIPThe customer's postcode.

Visma e-conomic invoices_booked fields

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

IDTypeNameDescription
invoices_booked__bookedinvoicenumberNUMERICVisma Economic Invoices Booked: Booked Invoice NumberA reference number for the booked invoice document.
invoices_booked__currencyTEXTVisma Economic Invoices Booked: CurrencyThe ISO 4217 currency code of the invoice.
invoices_booked__customerOBJECTVisma Economic Invoices Booked: CustomerThe customer being invoiced.
invoices_booked__dateTEXTVisma Economic Invoices Booked: DateInvoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked__deliveryOBJECTVisma Economic Invoices Booked: DeliveryThe 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__deliverylocationOBJECTVisma Economic Invoices Booked: Delivery LocationA reference to the place of delivery for the goods on the invoice
invoices_booked__duedateTEXTVisma Economic Invoices Booked: Due DateThe 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__exchangerateNUMERICVisma Economic Invoices Booked: Exchange RateThe 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__grossamountNUMERICVisma Economic Invoices Booked: Gross AmountThe 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__grossamountinbasecurrencyNUMERICVisma Economic Invoices Booked: Gross Amount In Base CurrencyThe 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__layoutOBJECTVisma Economic Invoices Booked: LayoutLayout to be applied for this invoice.
invoices_booked__netamountNUMERICVisma Economic Invoices Booked: Net AmountThe 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__netamountinbasecurrencyNUMERICVisma Economic Invoices Booked: Net Amount In Base CurrencyThe 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__notesOBJECTVisma Economic Invoices Booked: NotesNotes on the invoice.
invoices_booked__ordernumberNUMERICVisma Economic Invoices Booked: Order NumberOrder Number field returned by the Invoices Booked endpoint in the e-conomic API.
invoices_booked__paymenttermsOBJECTVisma Economic Invoices Booked: Payment TermsThe terms of payment for the invoice.
invoices_booked__pdfOBJECTVisma Economic Invoices Booked: PDF LinkReferences a pdf representation of this invoice.
invoices_booked__projectOBJECTVisma Economic Invoices Booked: ProjectA reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_booked__recipientOBJECTVisma Economic Invoices Booked: RecipientThe 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__referencesOBJECTVisma Economic Invoices Booked: ReferencesCustomer and company references related to this invoice.
invoices_booked__remainderNUMERICVisma Economic Invoices Booked: RemainderRemaining amount to be paid.
invoices_booked__remainderinbasecurrencyNUMERICVisma Economic Invoices Booked: Remainder In Base CurrencyRemaining amount to be paid in base currency.
invoices_booked__roundingamountNUMERICVisma Economic Invoices Booked: Rounding AmountThe total rounding error, if any, on the invoice in base currency.
invoices_booked__selfTEXTVisma Economic Invoices Booked: Self LinkA unique reference to the payment term resource.
invoices_booked__sentTEXTVisma Economic Invoices Booked: Sent StatusA convenience link to see if the invoice has been sent or not.
invoices_booked__vatamountNUMERICVisma Economic Invoices Booked: VAT AmountThe 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.

IDTypeNameDescription
invoices_booked_document__bookedinvoicenumberNUMERICVisma Economic Invoices Booked Document: Booked Invoice NumberA reference number for the booked invoice document.
invoices_booked_document__currencyTEXTVisma Economic Invoices Booked Document: CurrencyThe ISO 4217 currency code of the invoice.
invoices_booked_document__customerOBJECTVisma Economic Invoices Booked Document: CustomerThe customer being invoiced.
invoices_booked_document__dateTEXTVisma Economic Invoices Booked Document: DateInvoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_booked_document__deliveryOBJECTVisma Economic Invoices Booked Document: DeliveryThe 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__deliverylocationOBJECTVisma Economic Invoices Booked Document: Delivery LocationA reference to the place of delivery for the goods on the invoice
invoices_booked_document__duedateTEXTVisma Economic Invoices Booked Document: Due DateThe 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__exchangerateNUMERICVisma Economic Invoices Booked Document: Exchange RateThe 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__grossamountNUMERICVisma Economic Invoices Booked Document: Gross AmountThe 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__grossamountinbasecurrencyNUMERICVisma Economic Invoices Booked Document: Gross Amount In Base CurrencyThe 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__layoutOBJECTVisma Economic Invoices Booked Document: LayoutLayout to be applied for this invoice.
invoices_booked_document__linesOBJECTVisma Economic Invoices Booked Document: LinesAn array containing the specific invoice lines.
invoices_booked_document__netamountNUMERICVisma Economic Invoices Booked Document: Net AmountThe 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__netamountinbasecurrencyNUMERICVisma Economic Invoices Booked Document: Net Amount In Base CurrencyThe 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__notesOBJECTVisma Economic Invoices Booked Document: NotesNotes on the invoice.
invoices_booked_document__ordernumberNUMERICVisma Economic Invoices Booked Document: Order NumberOrder Number field returned by the Invoices Booked Document endpoint in the e-conomic API.
invoices_booked_document__paymenttermsOBJECTVisma Economic Invoices Booked Document: Payment TermsThe terms of payment for the invoice.
invoices_booked_document__pdfOBJECTVisma Economic Invoices Booked Document: PDF LinkReferences a pdf representation of this invoice.
invoices_booked_document__projectOBJECTVisma Economic Invoices Booked Document: ProjectA reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_booked_document__recipientOBJECTVisma Economic Invoices Booked Document: RecipientThe 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__referencesOBJECTVisma Economic Invoices Booked Document: ReferencesCustomer and company references related to this invoice.
invoices_booked_document__remainderNUMERICVisma Economic Invoices Booked Document: RemainderRemaining amount to be paid.
invoices_booked_document__remainderinbasecurrencyNUMERICVisma Economic Invoices Booked Document: Remainder In Base CurrencyRemaining amount to be paid in base currency.
invoices_booked_document__roundingamountNUMERICVisma Economic Invoices Booked Document: Rounding AmountThe total rounding error, if any, on the invoice in base currency.
invoices_booked_document__selfTEXTVisma Economic Invoices Booked Document: Self LinkA unique reference to the payment term resource.
invoices_booked_document__sentTEXTVisma Economic Invoices Booked Document: Sent StatusA convenience link to see if the invoice has been sent or not.
invoices_booked_document__vatamountNUMERICVisma Economic Invoices Booked Document: VAT AmountThe 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.

IDTypeNameDescription
invoices_paid__bookedinvoicenumberNUMERICVisma Economic Invoices Paid: Booked Invoice NumberA reference number for the booked invoice document.
invoices_paid__currencyTEXTVisma Economic Invoices Paid: CurrencyThe ISO 4217 currency code of the invoice.
invoices_paid__customerOBJECTVisma Economic Invoices Paid: CustomerThe customer being invoiced.
invoices_paid__dateTEXTVisma Economic Invoices Paid: DateInvoice issue date. Format according to ISO-8601 (YYYY-MM-DD).
invoices_paid__deliveryOBJECTVisma Economic Invoices Paid: DeliveryThe 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__deliverylocationOBJECTVisma Economic Invoices Paid: Delivery LocationA reference to the place of delivery for the goods on the invoice
invoices_paid__duedateTEXTVisma Economic Invoices Paid: Due DateThe 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__exchangerateNUMERICVisma Economic Invoices Paid: Exchange RateExchange Rate field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__grossamountNUMERICVisma Economic Invoices Paid: Gross AmountThe 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__grossamountinbasecurrencyNUMERICVisma Economic Invoices Paid: Gross Amount In Base CurrencyGross Amount In Base Currency field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__layoutOBJECTVisma Economic Invoices Paid: LayoutLayout to be applied for this invoice.
invoices_paid__netamountNUMERICVisma Economic Invoices Paid: Net AmountThe 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__netamountinbasecurrencyNUMERICVisma Economic Invoices Paid: Net Amount In Base CurrencyThe 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__notesOBJECTVisma Economic Invoices Paid: NotesNotes on the invoice.
invoices_paid__ordernumberNUMERICVisma Economic Invoices Paid: Order NumberOrder Number field returned by the Invoices Paid endpoint in the e-conomic API.
invoices_paid__paymenttermsOBJECTVisma Economic Invoices Paid: Payment TermsThe terms of payment for the invoice.
invoices_paid__pdfOBJECTVisma Economic Invoices Paid: PDF LinkReferences a pdf representation of this invoice.
invoices_paid__projectOBJECTVisma Economic Invoices Paid: ProjectA reference to any project this entry might be related to. This requires the projects module to be enabled.
invoices_paid__recipientOBJECTVisma Economic Invoices Paid: RecipientThe 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__referencesOBJECTVisma Economic Invoices Paid: ReferencesCustomer and company references related to this invoice.
invoices_paid__remainderNUMERICVisma Economic Invoices Paid: RemainderRemaining amount to be paid.
invoices_paid__remainderinbasecurrencyNUMERICVisma Economic Invoices Paid: Remainder In Base CurrencyRemaining amount to be paid in base currency.
invoices_paid__roundingamountNUMERICVisma Economic Invoices Paid: Rounding AmountThe total rounding error, if any, on the invoice in base currency.
invoices_paid__selfTEXTVisma Economic Invoices Paid: Self LinkA unique reference to the payment term resource.
invoices_paid__sentTEXTVisma Economic Invoices Paid: Sent StatusA convenience link to see if the invoice has been sent or not.
invoices_paid__vatamountNUMERICVisma Economic Invoices Paid: VAT AmountThe 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.

IDTypeNameDescription
invoices_total__bookedOBJECTVisma Economic Invoices Total: BookedThe totals for booked invoices.
invoices_total__draftsOBJECTVisma Economic Invoices Total: DraftsThe totals for draft invoices.
invoices_total__predefinedperiodfiltersOBJECTVisma Economic Invoices Total: Predefined Period FiltersThe totals for draft invoices.
invoices_total__selfTEXTVisma Economic Invoices Total: Self LinkA reference to the invoices totals draft resource.

Visma e-conomic products fields

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

IDTypeNameDescription
products__barcodeTEXTVisma Economic Products: Bar CodeString representation of a machine readable barcode symbol that represents this product.
products__barredBOOLEANVisma Economic Products: BarredIf 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__costpriceNUMERICVisma Economic Products: Cost PriceThe cost of the goods. If you have the inventory module enabled, this is read-only and will just be ignored.
products__departmentaldistributionOBJECTVisma Economic Products: Departmental DistributionA departmental distribution defines which departments this entry is distributed between. This requires the departments module to be enabled.
products__descriptionTEXTVisma Economic Products: DescriptionFree text description of product.
products__inventoryOBJECTVisma Economic Products: InventoryA collection of properties that are only applicable if the inventory module is enabled.
products__invoicesOBJECTVisma Economic Products: InvoicesA collection of convenience links to invoices that contains this product.
products__lastupdatedTEXTVisma Economic Products: Last UpdatedThe last time the product was updated, either directly or through inventory changed. The date is formatted according to ISO-8601.
products__minimumstockNUMERICVisma Economic Products: Minimum StockMinimum Stock field returned by the Products endpoint in the e-conomic API.
products__nameTEXTVisma Economic Products: NameDescriptive name of the product.
products__pricingOBJECTVisma Economic Products: PricingPricing field returned by the Products endpoint in the e-conomic API.
products__productgroupOBJECTVisma Economic Products: Product GroupA reference to the product group this product is contained within.
products__productnumberTEXTVisma Economic Products: Product NumberUnique alphanumeric product number.
products__recommendedpriceNUMERICVisma Economic Products: Recommended PriceRecommended retail price of the goods.
products__salespriceNUMERICVisma Economic Products: Sales PriceThis is the unit net price that will appear on invoice lines when a product is added to an invoice line.
products__selfTEXTVisma Economic Products: Self LinkA unique reference to the unit resource.
products__unitOBJECTVisma Economic Products: UnitA 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.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date