Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your FastBill data to
FastBill Connector Reference
10 metrics186 dimensions
The FastBill connector exposes 196 fields (10 metrics, 186 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
FastBill Fields
FastBill customers fields
The customers report of the FastBill connector includes 40 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers__ACADEMIC_DEGREE | TEXT | customers.ACADEMIC_DEGREE | customers.ACADEMIC_DEGREE |
| customers__ADDRESS | TEXT | customers.ADDRESS | customers.ADDRESS |
| customers__ADDRESS_2 | TEXT | customers.ADDRESS_2 | customers.ADDRESS_2 |
| customers__BANK_ACCOUNT_MANDATE_REFERENCE | TEXT | customers.BANK_ACCOUNT_MANDATE_REFERENCE | customers.BANK_ACCOUNT_MANDATE_REFERENCE |
| customers__BANK_ACCOUNT_NUMBER | TEXT | customers.BANK_ACCOUNT_NUMBER | customers.BANK_ACCOUNT_NUMBER |
| customers__BANK_ACCOUNT_OWNER | TEXT | customers.BANK_ACCOUNT_OWNER | customers.BANK_ACCOUNT_OWNER |
| customers__BANK_BIC | TEXT | customers.BANK_BIC | customers.BANK_BIC |
| customers__BANK_CODE | TEXT | customers.BANK_CODE | customers.BANK_CODE |
| customers__BANK_IBAN | TEXT | customers.BANK_IBAN | customers.BANK_IBAN |
| customers__BANK_NAME | TEXT | customers.BANK_NAME | customers.BANK_NAME |
| customers__CITY | TEXT | customers.CITY | customers.CITY |
| customers__COUNTRY_CODE | TEXT | customers.COUNTRY_CODE | customers.COUNTRY_CODE |
| customers__CREATED | TEXT | customers.CREATED | customers.CREATED |
| customers__CURRENCY_CODE | TEXT | customers.CURRENCY_CODE | customers.CURRENCY_CODE |
| customers__CUSTOMER_ACCOUNT | TEXT | customers.CUSTOMER_ACCOUNT | customers.CUSTOMER_ACCOUNT |
| customers__CUSTOMER_ID | TEXT | customers.CUSTOMER_ID | customers.CUSTOMER_ID |
| customers__CUSTOMER_NUMBER | TEXT | customers.CUSTOMER_NUMBER | customers.CUSTOMER_NUMBER |
| customers__CUSTOMER_TYPE | TEXT | customers.CUSTOMER_TYPE | customers.CUSTOMER_TYPE |
| customers__DAYS_FOR_PAYMENT | TEXT | customers.DAYS_FOR_PAYMENT | customers.DAYS_FOR_PAYMENT |
| customers__DOCUMENT_HISTORY_URL | TEXT | customers.DOCUMENT_HISTORY_URL | customers.DOCUMENT_HISTORY_URL |
| customers__EMAIL | TEXT | customers.EMAIL | customers.EMAIL |
| customers__FAX | TEXT | customers.FAX | customers.FAX |
| customers__FIRST_NAME | TEXT | customers.FIRST_NAME | customers.FIRST_NAME |
| customers__LAST_NAME | TEXT | customers.LAST_NAME | customers.LAST_NAME |
| customers__LASTUPDATE | TEXT | customers.LASTUPDATE | customers.LASTUPDATE |
| customers__MOBILE | TEXT | customers.MOBILE | customers.MOBILE |
| customers__NEWSLETTER_OPTIN | TEXT | customers.NEWSLETTER_OPTIN | customers.NEWSLETTER_OPTIN |
| customers__ORGANIZATION | TEXT | customers.ORGANIZATION | customers.ORGANIZATION |
| customers__PAYMENT_TYPE | TEXT | customers.PAYMENT_TYPE | customers.PAYMENT_TYPE |
| customers__PHONE | TEXT | customers.PHONE | customers.PHONE |
| customers__PHONE_2 | TEXT | customers.PHONE_2 | customers.PHONE_2 |
| customers__POSITION | TEXT | customers.POSITION | customers.POSITION |
| customers__SALUTATION | TEXT | customers.SALUTATION | customers.SALUTATION |
| customers__SECONDARY_ADDRESS | TEXT | customers.SECONDARY_ADDRESS | customers.SECONDARY_ADDRESS |
| customers__SHOW_PAYMENT_NOTICE | TEXT | customers.SHOW_PAYMENT_NOTICE | customers.SHOW_PAYMENT_NOTICE |
| customers__TAGS | TEXT | customers.TAGS | customers.TAGS |
| customers__TOP | TEXT | customers.TOP | customers.TOP |
| customers__VAT_ID | TEXT | customers.VAT_ID | customers.VAT_ID |
| customers__WEBSITE | TEXT | customers.WEBSITE | customers.WEBSITE |
| customers__ZIPCODE | TEXT | customers.ZIPCODE | customers.ZIPCODE |
FastBill invoices fields
The invoices report of the FastBill connector includes 49 fields.
FastBill invoices fields (invoices__ADDRESS to invoices__SERVICE_PERIOD_START)
| ID | Type | Name | Description |
|---|---|---|---|
| invoices__ADDRESS | TEXT | invoices.ADDRESS | invoices.ADDRESS |
| invoices__ADDRESS_2 | TEXT | invoices.ADDRESS_2 | invoices.ADDRESS_2 |
| invoices__BANK_ACCOUNT_NUMBER | TEXT | invoices.BANK_ACCOUNT_NUMBER | invoices.BANK_ACCOUNT_NUMBER |
| invoices__BANK_ACCOUNT_OWNER | TEXT | invoices.BANK_ACCOUNT_OWNER | invoices.BANK_ACCOUNT_OWNER |
| invoices__BANK_BIC | TEXT | invoices.BANK_BIC | invoices.BANK_BIC |
| invoices__BANK_CODE | TEXT | invoices.BANK_CODE | invoices.BANK_CODE |
| invoices__BANK_IBAN | TEXT | invoices.BANK_IBAN | invoices.BANK_IBAN |
| invoices__BANK_NAME | TEXT | invoices.BANK_NAME | invoices.BANK_NAME |
| invoices__CASH_DISCOUNT_DAYS | TEXT | invoices.CASH_DISCOUNT_DAYS | invoices.CASH_DISCOUNT_DAYS |
| invoices__CASH_DISCOUNT_PERCENT | TEXT | invoices.CASH_DISCOUNT_PERCENT | invoices.CASH_DISCOUNT_PERCENT |
| invoices__CITY | TEXT | invoices.CITY | invoices.CITY |
| invoices__CONTACT_ID | TEXT | invoices.CONTACT_ID | invoices.CONTACT_ID |
| invoices__COUNTRY_CODE | TEXT | invoices.COUNTRY_CODE | invoices.COUNTRY_CODE |
| invoices__CURRENCY_CODE | TEXT | invoices.CURRENCY_CODE | invoices.CURRENCY_CODE |
| invoices__CUSTOMER_COSTCENTER_ID | TEXT | invoices.CUSTOMER_COSTCENTER_ID | invoices.CUSTOMER_COSTCENTER_ID |
| invoices__CUSTOMER_ID | TEXT | invoices.CUSTOMER_ID | invoices.CUSTOMER_ID |
| invoices__CUSTOMER_NUMBER | TEXT | invoices.CUSTOMER_NUMBER | invoices.CUSTOMER_NUMBER |
| invoices__DELIVERY_DATE | TEXT | invoices.DELIVERY_DATE | invoices.DELIVERY_DATE |
| invoices__DOCUMENT_URL | TEXT | invoices.DOCUMENT_URL | invoices.DOCUMENT_URL |
| invoices__DUE_DATE | TEXT | invoices.DUE_DATE | invoices.DUE_DATE |
| invoices__FIRST_NAME | TEXT | invoices.FIRST_NAME | invoices.FIRST_NAME |
| invoices__INTROTEXT | TEXT | invoices.INTROTEXT | invoices.INTROTEXT |
| invoices__INVOICE_DATE | TEXT | invoices.INVOICE_DATE | invoices.INVOICE_DATE |
| invoices__INVOICE_ID | TEXT | invoices.INVOICE_ID | invoices.INVOICE_ID |
| invoices__INVOICE_NUMBER | TEXT | invoices.INVOICE_NUMBER | invoices.INVOICE_NUMBER |
| invoices__INVOICE_TITLE | TEXT | invoices.INVOICE_TITLE | invoices.INVOICE_TITLE |
| invoices__IS_CANCELED | TEXT | invoices.IS_CANCELED | invoices.IS_CANCELED |
| invoices__ITEMS | OBJECT | invoices.ITEMS | invoices.ITEMS |
| invoices__LAST_NAME | TEXT | invoices.LAST_NAME | invoices.LAST_NAME |
| invoices__LASTUPDATE | TEXT | invoices.LASTUPDATE | invoices.LASTUPDATE |
| invoices__NOTE | TEXT | invoices.NOTE | invoices.NOTE |
| invoices__ORGANIZATION | TEXT | invoices.ORGANIZATION | invoices.ORGANIZATION |
| invoices__PAID_DATE | TEXT | invoices.PAID_DATE | invoices.PAID_DATE |
| invoices__PAYMENT_INFO | TEXT | invoices.PAYMENT_INFO | invoices.PAYMENT_INFO |
| invoices__PAYMENT_TYPE | TEXT | invoices.PAYMENT_TYPE | invoices.PAYMENT_TYPE |
| invoices__PAYMENTS | OBJECT | invoices.PAYMENTS | invoices.PAYMENTS |
| invoices__PROJECT_ID | TEXT | invoices.PROJECT_ID | invoices.PROJECT_ID |
| invoices__SALUTATION | TEXT | invoices.SALUTATION | invoices.SALUTATION |
| invoices__SERVICE_PERIOD_END | TEXT | invoices.SERVICE_PERIOD_END | invoices.SERVICE_PERIOD_END |
| invoices__SERVICE_PERIOD_START | TEXT | invoices.SERVICE_PERIOD_START | invoices.SERVICE_PERIOD_START |
FastBill invoices fields (invoices__SUB_TOTAL to invoices__ZIPCODE)
| ID | Type | Name | Description |
|---|---|---|---|
| invoices__SUB_TOTAL | NUMERIC | invoices.SUB_TOTAL | invoices.SUB_TOTAL |
| invoices__TEMPLATE_ID | TEXT | invoices.TEMPLATE_ID | invoices.TEMPLATE_ID |
| invoices__TOTAL | NUMERIC | invoices.TOTAL | invoices.TOTAL |
| invoices__TYPE | TEXT | invoices.TYPE | invoices.TYPE |
| invoices__VAT_CASE | TEXT | invoices.VAT_CASE | invoices.VAT_CASE |
| invoices__VAT_ID | TEXT | invoices.VAT_ID | invoices.VAT_ID |
| invoices__VAT_ITEMS | OBJECT | invoices.VAT_ITEMS | invoices.VAT_ITEMS |
| invoices__VAT_TOTAL | NUMERIC | invoices.VAT_TOTAL | invoices.VAT_TOTAL |
| invoices__ZIPCODE | TEXT | invoices.ZIPCODE | invoices.ZIPCODE |
FastBill products fields
The products report of the FastBill connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| products__ARTICLE_ID | TEXT | products.ARTICLE_ID | products.ARTICLE_ID |
| products__ARTICLE_NUMBER | TEXT | products.ARTICLE_NUMBER | products.ARTICLE_NUMBER |
| products__CURRENCY_CODE | TEXT | products.CURRENCY_CODE | products.CURRENCY_CODE |
| products__DESCRIPTION | TEXT | products.DESCRIPTION | products.DESCRIPTION |
| products__IS_GROSS | NUMERIC | products.IS_GROSS | products.IS_GROSS |
| products__TAGS | TEXT | products.TAGS | products.TAGS |
| products__TITLE | TEXT | products.TITLE | products.TITLE |
| products__UNIT | TEXT | products.UNIT | products.UNIT |
| products__UNIT_PRICE | TEXT | products.UNIT_PRICE | products.UNIT_PRICE |
| products__VAT_PERCENT | TEXT | products.VAT_PERCENT | products.VAT_PERCENT |
FastBill recurring_invoices fields
The recurring_invoices report of the FastBill connector includes 43 fields.
FastBill recurring_invoices fields (recurring_invoices__ADDRESS to recurring_invoices__VAT_CASE)
| ID | Type | Name | Description |
|---|---|---|---|
| recurring_invoices__ADDRESS | TEXT | recurring_invoices.ADDRESS | recurring_invoices.ADDRESS |
| recurring_invoices__ADDRESS_2 | TEXT | recurring_invoices.ADDRESS_2 | recurring_invoices.ADDRESS_2 |
| recurring_invoices__BANK_ACCOUNT_NUMBER | TEXT | recurring_invoices.BANK_ACCOUNT_NUMBER | recurring_invoices.BANK_ACCOUNT_NUMBER |
| recurring_invoices__BANK_ACCOUNT_OWNER | TEXT | recurring_invoices.BANK_ACCOUNT_OWNER | recurring_invoices.BANK_ACCOUNT_OWNER |
| recurring_invoices__BANK_BIC | TEXT | recurring_invoices.BANK_BIC | recurring_invoices.BANK_BIC |
| recurring_invoices__BANK_CODE | TEXT | recurring_invoices.BANK_CODE | recurring_invoices.BANK_CODE |
| recurring_invoices__BANK_IBAN | TEXT | recurring_invoices.BANK_IBAN | recurring_invoices.BANK_IBAN |
| recurring_invoices__BANK_NAME | TEXT | recurring_invoices.BANK_NAME | recurring_invoices.BANK_NAME |
| recurring_invoices__CASH_DISCOUNT_DAYS | TEXT | recurring_invoices.CASH_DISCOUNT_DAYS | recurring_invoices.CASH_DISCOUNT_DAYS |
| recurring_invoices__CASH_DISCOUNT_PERCENT | TEXT | recurring_invoices.CASH_DISCOUNT_PERCENT | recurring_invoices.CASH_DISCOUNT_PERCENT |
| recurring_invoices__CITY | TEXT | recurring_invoices.CITY | recurring_invoices.CITY |
| recurring_invoices__CONTACT_ID | TEXT | recurring_invoices.CONTACT_ID | recurring_invoices.CONTACT_ID |
| recurring_invoices__CURRENCY_CODE | TEXT | recurring_invoices.CURRENCY_CODE | recurring_invoices.CURRENCY_CODE |
| recurring_invoices__CUSTOMER_COSTCENTER_ID | TEXT | recurring_invoices.CUSTOMER_COSTCENTER_ID | recurring_invoices.CUSTOMER_COSTCENTER_ID |
| recurring_invoices__CUSTOMER_ID | TEXT | recurring_invoices.CUSTOMER_ID | recurring_invoices.CUSTOMER_ID |
| recurring_invoices__CUSTOMER_NUMBER | TEXT | recurring_invoices.CUSTOMER_NUMBER | recurring_invoices.CUSTOMER_NUMBER |
| recurring_invoices__DELIVERY_DATE | TEXT | recurring_invoices.DELIVERY_DATE | recurring_invoices.DELIVERY_DATE |
| recurring_invoices__EMAIL_NOTIFY | TEXT | recurring_invoices.EMAIL_NOTIFY | recurring_invoices.EMAIL_NOTIFY |
| recurring_invoices__FIRST_NAME | TEXT | recurring_invoices.FIRST_NAME | recurring_invoices.FIRST_NAME |
| recurring_invoices__FREQUENCY | TEXT | recurring_invoices.FREQUENCY | recurring_invoices.FREQUENCY |
| recurring_invoices__INTROTEXT | TEXT | recurring_invoices.INTROTEXT | recurring_invoices.INTROTEXT |
| recurring_invoices__INVOICE_ID | TEXT | recurring_invoices.INVOICE_ID | recurring_invoices.INVOICE_ID |
| recurring_invoices__INVOICE_TITLE | TEXT | recurring_invoices.INVOICE_TITLE | recurring_invoices.INVOICE_TITLE |
| recurring_invoices__ITEMS | OBJECT | recurring_invoices.ITEMS | recurring_invoices.ITEMS |
| recurring_invoices__LAST_NAME | TEXT | recurring_invoices.LAST_NAME | recurring_invoices.LAST_NAME |
| recurring_invoices__NOTE | TEXT | recurring_invoices.NOTE | recurring_invoices.NOTE |
| recurring_invoices__OCCURENCES | TEXT | recurring_invoices.OCCURENCES | recurring_invoices.OCCURENCES |
| recurring_invoices__ORGANIZATION | TEXT | recurring_invoices.ORGANIZATION | recurring_invoices.ORGANIZATION |
| recurring_invoices__OUTPUT_TYPE | TEXT | recurring_invoices.OUTPUT_TYPE | recurring_invoices.OUTPUT_TYPE |
| recurring_invoices__PAYMENT_TYPE | TEXT | recurring_invoices.PAYMENT_TYPE | recurring_invoices.PAYMENT_TYPE |
| recurring_invoices__PROJECT_ID | TEXT | recurring_invoices.PROJECT_ID | recurring_invoices.PROJECT_ID |
| recurring_invoices__SALUTATION | TEXT | recurring_invoices.SALUTATION | recurring_invoices.SALUTATION |
| recurring_invoices__SERVICE_PERIOD_END | TEXT | recurring_invoices.SERVICE_PERIOD_END | recurring_invoices.SERVICE_PERIOD_END |
| recurring_invoices__SERVICE_PERIOD_START | TEXT | recurring_invoices.SERVICE_PERIOD_START | recurring_invoices.SERVICE_PERIOD_START |
| recurring_invoices__START_DATE | TEXT | recurring_invoices.START_DATE | recurring_invoices.START_DATE |
| recurring_invoices__SUB_TOTAL | NUMERIC | recurring_invoices.SUB_TOTAL | recurring_invoices.SUB_TOTAL |
| recurring_invoices__TEMPLATE_ID | TEXT | recurring_invoices.TEMPLATE_ID | recurring_invoices.TEMPLATE_ID |
| recurring_invoices__TOTAL | NUMERIC | recurring_invoices.TOTAL | recurring_invoices.TOTAL |
| recurring_invoices__TYPE | TEXT | recurring_invoices.TYPE | recurring_invoices.TYPE |
| recurring_invoices__VAT_CASE | TEXT | recurring_invoices.VAT_CASE | recurring_invoices.VAT_CASE |
FastBill recurring_invoices fields (recurring_invoices__VAT_ITEMS to recurring_invoices__ZIPCODE)
| ID | Type | Name | Description |
|---|---|---|---|
| recurring_invoices__VAT_ITEMS | OBJECT | recurring_invoices.VAT_ITEMS | recurring_invoices.VAT_ITEMS |
| recurring_invoices__VAT_TOTAL | NUMERIC | recurring_invoices.VAT_TOTAL | recurring_invoices.VAT_TOTAL |
| recurring_invoices__ZIPCODE | TEXT | recurring_invoices.ZIPCODE | recurring_invoices.ZIPCODE |
FastBill revenues fields
The revenues report of the FastBill connector includes 49 fields.
FastBill revenues fields (revenues__ADDRESS to revenues__SERVICE_PERIOD_START)
| ID | Type | Name | Description |
|---|---|---|---|
| revenues__ADDRESS | TEXT | revenues.ADDRESS | revenues.ADDRESS |
| revenues__ADDRESS_2 | TEXT | revenues.ADDRESS_2 | revenues.ADDRESS_2 |
| revenues__BANK_ACCOUNT_NUMBER | TEXT | revenues.BANK_ACCOUNT_NUMBER | revenues.BANK_ACCOUNT_NUMBER |
| revenues__BANK_ACCOUNT_OWNER | TEXT | revenues.BANK_ACCOUNT_OWNER | revenues.BANK_ACCOUNT_OWNER |
| revenues__BANK_BIC | TEXT | revenues.BANK_BIC | revenues.BANK_BIC |
| revenues__BANK_CODE | TEXT | revenues.BANK_CODE | revenues.BANK_CODE |
| revenues__BANK_IBAN | TEXT | revenues.BANK_IBAN | revenues.BANK_IBAN |
| revenues__BANK_NAME | TEXT | revenues.BANK_NAME | revenues.BANK_NAME |
| revenues__CASH_DISCOUNT_DAYS | TEXT | revenues.CASH_DISCOUNT_DAYS | revenues.CASH_DISCOUNT_DAYS |
| revenues__CASH_DISCOUNT_PERCENT | TEXT | revenues.CASH_DISCOUNT_PERCENT | revenues.CASH_DISCOUNT_PERCENT |
| revenues__CITY | TEXT | revenues.CITY | revenues.CITY |
| revenues__CONTACT_ID | TEXT | revenues.CONTACT_ID | revenues.CONTACT_ID |
| revenues__COUNTRY_CODE | TEXT | revenues.COUNTRY_CODE | revenues.COUNTRY_CODE |
| revenues__CURRENCY_CODE | TEXT | revenues.CURRENCY_CODE | revenues.CURRENCY_CODE |
| revenues__CUSTOMER_COSTCENTER_ID | TEXT | revenues.CUSTOMER_COSTCENTER_ID | revenues.CUSTOMER_COSTCENTER_ID |
| revenues__CUSTOMER_ID | TEXT | revenues.CUSTOMER_ID | revenues.CUSTOMER_ID |
| revenues__CUSTOMER_NUMBER | TEXT | revenues.CUSTOMER_NUMBER | revenues.CUSTOMER_NUMBER |
| revenues__DELIVERY_DATE | TEXT | revenues.DELIVERY_DATE | revenues.DELIVERY_DATE |
| revenues__DOCUMENT_URL | TEXT | revenues.DOCUMENT_URL | revenues.DOCUMENT_URL |
| revenues__DUE_DATE | TEXT | revenues.DUE_DATE | revenues.DUE_DATE |
| revenues__FIRST_NAME | TEXT | revenues.FIRST_NAME | revenues.FIRST_NAME |
| revenues__INTROTEXT | TEXT | revenues.INTROTEXT | revenues.INTROTEXT |
| revenues__INVOICE_DATE | TEXT | revenues.INVOICE_DATE | revenues.INVOICE_DATE |
| revenues__INVOICE_ID | TEXT | revenues.INVOICE_ID | revenues.INVOICE_ID |
| revenues__INVOICE_NUMBER | TEXT | revenues.INVOICE_NUMBER | revenues.INVOICE_NUMBER |
| revenues__INVOICE_TITLE | TEXT | revenues.INVOICE_TITLE | revenues.INVOICE_TITLE |
| revenues__IS_CANCELED | TEXT | revenues.IS_CANCELED | revenues.IS_CANCELED |
| revenues__ITEMS | OBJECT | revenues.ITEMS | revenues.ITEMS |
| revenues__LAST_NAME | TEXT | revenues.LAST_NAME | revenues.LAST_NAME |
| revenues__LASTUPDATE | TEXT | revenues.LASTUPDATE | revenues.LASTUPDATE |
| revenues__NOTE | TEXT | revenues.NOTE | revenues.NOTE |
| revenues__ORGANIZATION | TEXT | revenues.ORGANIZATION | revenues.ORGANIZATION |
| revenues__PAID_DATE | TEXT | revenues.PAID_DATE | revenues.PAID_DATE |
| revenues__PAYMENT_INFO | TEXT | revenues.PAYMENT_INFO | revenues.PAYMENT_INFO |
| revenues__PAYMENT_TYPE | TEXT | revenues.PAYMENT_TYPE | revenues.PAYMENT_TYPE |
| revenues__PAYMENTS | OBJECT | revenues.PAYMENTS | revenues.PAYMENTS |
| revenues__PROJECT_ID | TEXT | revenues.PROJECT_ID | revenues.PROJECT_ID |
| revenues__SALUTATION | TEXT | revenues.SALUTATION | revenues.SALUTATION |
| revenues__SERVICE_PERIOD_END | TEXT | revenues.SERVICE_PERIOD_END | revenues.SERVICE_PERIOD_END |
| revenues__SERVICE_PERIOD_START | TEXT | revenues.SERVICE_PERIOD_START | revenues.SERVICE_PERIOD_START |
FastBill revenues fields (revenues__SUB_TOTAL to revenues__ZIPCODE)
| ID | Type | Name | Description |
|---|---|---|---|
| revenues__SUB_TOTAL | NUMERIC | revenues.SUB_TOTAL | revenues.SUB_TOTAL |
| revenues__TEMPLATE_ID | TEXT | revenues.TEMPLATE_ID | revenues.TEMPLATE_ID |
| revenues__TOTAL | NUMERIC | revenues.TOTAL | revenues.TOTAL |
| revenues__TYPE | TEXT | revenues.TYPE | revenues.TYPE |
| revenues__VAT_CASE | TEXT | revenues.VAT_CASE | revenues.VAT_CASE |
| revenues__VAT_ID | TEXT | revenues.VAT_ID | revenues.VAT_ID |
| revenues__VAT_ITEMS | OBJECT | revenues.VAT_ITEMS | revenues.VAT_ITEMS |
| revenues__VAT_TOTAL | NUMERIC | revenues.VAT_TOTAL | revenues.VAT_TOTAL |
| revenues__ZIPCODE | TEXT | revenues.ZIPCODE | revenues.ZIPCODE |
FastBill other fields
The FastBill 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 |