Windsor brings all your FastBill data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
FastBill Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| customers__ACADEMIC_DEGREE | TEXT | customers.ACADEMIC_DEGREE | customers.ACADEMIC_DEGREE | customers |
| customers__ADDRESS | TEXT | customers.ADDRESS | customers.ADDRESS | customers |
| customers__ADDRESS_2 | TEXT | customers.ADDRESS_2 | customers.ADDRESS_2 | customers |
| customers__BANK_ACCOUNT_MANDATE_REFERENCE | TEXT | customers.BANK_ACCOUNT_MANDATE_REFERENCE | customers.BANK_ACCOUNT_MANDATE_REFERENCE | customers |
| customers__BANK_ACCOUNT_NUMBER | TEXT | customers.BANK_ACCOUNT_NUMBER | customers.BANK_ACCOUNT_NUMBER | customers |
| customers__BANK_ACCOUNT_OWNER | TEXT | customers.BANK_ACCOUNT_OWNER | customers.BANK_ACCOUNT_OWNER | customers |
| customers__BANK_BIC | TEXT | customers.BANK_BIC | customers.BANK_BIC | customers |
| customers__BANK_CODE | TEXT | customers.BANK_CODE | customers.BANK_CODE | customers |
| customers__BANK_IBAN | TEXT | customers.BANK_IBAN | customers.BANK_IBAN | customers |
| customers__BANK_NAME | TEXT | customers.BANK_NAME | customers.BANK_NAME | customers |
| customers__CITY | TEXT | customers.CITY | customers.CITY | customers |
| customers__COUNTRY_CODE | TEXT | customers.COUNTRY_CODE | customers.COUNTRY_CODE | customers |
| customers__CREATED | TEXT | customers.CREATED | customers.CREATED | customers |
| customers__CURRENCY_CODE | TEXT | customers.CURRENCY_CODE | customers.CURRENCY_CODE | customers |
| customers__CUSTOMER_ACCOUNT | TEXT | customers.CUSTOMER_ACCOUNT | customers.CUSTOMER_ACCOUNT | customers |
| customers__CUSTOMER_ID | TEXT | customers.CUSTOMER_ID | customers.CUSTOMER_ID | customers |
| customers__CUSTOMER_NUMBER | TEXT | customers.CUSTOMER_NUMBER | customers.CUSTOMER_NUMBER | customers |
| customers__CUSTOMER_TYPE | TEXT | customers.CUSTOMER_TYPE | customers.CUSTOMER_TYPE | customers |
| customers__DAYS_FOR_PAYMENT | TEXT | customers.DAYS_FOR_PAYMENT | customers.DAYS_FOR_PAYMENT | customers |
| customers__DOCUMENT_HISTORY_URL | TEXT | customers.DOCUMENT_HISTORY_URL | customers.DOCUMENT_HISTORY_URL | customers |
| customers__EMAIL | TEXT | customers.EMAIL | customers.EMAIL | customers |
| customers__FAX | TEXT | customers.FAX | customers.FAX | customers |
| customers__FIRST_NAME | TEXT | customers.FIRST_NAME | customers.FIRST_NAME | customers |
| customers__LASTUPDATE | TEXT | customers.LASTUPDATE | customers.LASTUPDATE | customers |
| customers__LAST_NAME | TEXT | customers.LAST_NAME | customers.LAST_NAME | customers |
| customers__MOBILE | TEXT | customers.MOBILE | customers.MOBILE | customers |
| customers__NEWSLETTER_OPTIN | TEXT | customers.NEWSLETTER_OPTIN | customers.NEWSLETTER_OPTIN | customers |
| customers__ORGANIZATION | TEXT | customers.ORGANIZATION | customers.ORGANIZATION | customers |
| customers__PAYMENT_TYPE | TEXT | customers.PAYMENT_TYPE | customers.PAYMENT_TYPE | customers |
| customers__PHONE | TEXT | customers.PHONE | customers.PHONE | customers |
| customers__PHONE_2 | TEXT | customers.PHONE_2 | customers.PHONE_2 | customers |
| customers__POSITION | TEXT | customers.POSITION | customers.POSITION | customers |
| customers__SALUTATION | TEXT | customers.SALUTATION | customers.SALUTATION | customers |
| customers__SECONDARY_ADDRESS | TEXT | customers.SECONDARY_ADDRESS | customers.SECONDARY_ADDRESS | customers |
| customers__SHOW_PAYMENT_NOTICE | TEXT | customers.SHOW_PAYMENT_NOTICE | customers.SHOW_PAYMENT_NOTICE | customers |
| customers__TAGS | TEXT | customers.TAGS | customers.TAGS | customers |
| customers__TOP | TEXT | customers.TOP | customers.TOP | customers |
| customers__VAT_ID | TEXT | customers.VAT_ID | customers.VAT_ID | customers |
| customers__WEBSITE | TEXT | customers.WEBSITE | customers.WEBSITE | customers |
| customers__ZIPCODE | TEXT | customers.ZIPCODE | customers.ZIPCODE | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| invoices__ADDRESS | TEXT | invoices.ADDRESS | invoices.ADDRESS | invoices |
| invoices__ADDRESS_2 | TEXT | invoices.ADDRESS_2 | invoices.ADDRESS_2 | invoices |
| invoices__BANK_ACCOUNT_NUMBER | TEXT | invoices.BANK_ACCOUNT_NUMBER | invoices.BANK_ACCOUNT_NUMBER | invoices |
| invoices__BANK_ACCOUNT_OWNER | TEXT | invoices.BANK_ACCOUNT_OWNER | invoices.BANK_ACCOUNT_OWNER | invoices |
| invoices__BANK_BIC | TEXT | invoices.BANK_BIC | invoices.BANK_BIC | invoices |
| invoices__BANK_CODE | TEXT | invoices.BANK_CODE | invoices.BANK_CODE | invoices |
| invoices__BANK_IBAN | TEXT | invoices.BANK_IBAN | invoices.BANK_IBAN | invoices |
| invoices__BANK_NAME | TEXT | invoices.BANK_NAME | invoices.BANK_NAME | invoices |
| invoices__CASH_DISCOUNT_DAYS | TEXT | invoices.CASH_DISCOUNT_DAYS | invoices.CASH_DISCOUNT_DAYS | invoices |
| invoices__CASH_DISCOUNT_PERCENT | TEXT | invoices.CASH_DISCOUNT_PERCENT | invoices.CASH_DISCOUNT_PERCENT | invoices |
| invoices__CITY | TEXT | invoices.CITY | invoices.CITY | invoices |
| invoices__CONTACT_ID | TEXT | invoices.CONTACT_ID | invoices.CONTACT_ID | invoices |
| invoices__COUNTRY_CODE | TEXT | invoices.COUNTRY_CODE | invoices.COUNTRY_CODE | invoices |
| invoices__CURRENCY_CODE | TEXT | invoices.CURRENCY_CODE | invoices.CURRENCY_CODE | invoices |
| invoices__CUSTOMER_COSTCENTER_ID | TEXT | invoices.CUSTOMER_COSTCENTER_ID | invoices.CUSTOMER_COSTCENTER_ID | invoices |
| invoices__CUSTOMER_ID | TEXT | invoices.CUSTOMER_ID | invoices.CUSTOMER_ID | invoices |
| invoices__CUSTOMER_NUMBER | TEXT | invoices.CUSTOMER_NUMBER | invoices.CUSTOMER_NUMBER | invoices |
| invoices__DELIVERY_DATE | TEXT | invoices.DELIVERY_DATE | invoices.DELIVERY_DATE | invoices |
| invoices__DOCUMENT_URL | TEXT | invoices.DOCUMENT_URL | invoices.DOCUMENT_URL | invoices |
| invoices__DUE_DATE | TEXT | invoices.DUE_DATE | invoices.DUE_DATE | invoices |
| invoices__FIRST_NAME | TEXT | invoices.FIRST_NAME | invoices.FIRST_NAME | invoices |
| invoices__INTROTEXT | TEXT | invoices.INTROTEXT | invoices.INTROTEXT | invoices |
| invoices__INVOICE_DATE | TEXT | invoices.INVOICE_DATE | invoices.INVOICE_DATE | invoices |
| invoices__INVOICE_ID | TEXT | invoices.INVOICE_ID | invoices.INVOICE_ID | invoices |
| invoices__INVOICE_NUMBER | TEXT | invoices.INVOICE_NUMBER | invoices.INVOICE_NUMBER | invoices |
| invoices__INVOICE_TITLE | TEXT | invoices.INVOICE_TITLE | invoices.INVOICE_TITLE | invoices |
| invoices__IS_CANCELED | TEXT | invoices.IS_CANCELED | invoices.IS_CANCELED | invoices |
| invoices__ITEMS | OBJECT | invoices.ITEMS | invoices.ITEMS | invoices |
| invoices__LASTUPDATE | TEXT | invoices.LASTUPDATE | invoices.LASTUPDATE | invoices |
| invoices__LAST_NAME | TEXT | invoices.LAST_NAME | invoices.LAST_NAME | invoices |
| invoices__NOTE | TEXT | invoices.NOTE | invoices.NOTE | invoices |
| invoices__ORGANIZATION | TEXT | invoices.ORGANIZATION | invoices.ORGANIZATION | invoices |
| invoices__PAID_DATE | TEXT | invoices.PAID_DATE | invoices.PAID_DATE | invoices |
| invoices__PAYMENTS | OBJECT | invoices.PAYMENTS | invoices.PAYMENTS | invoices |
| invoices__PAYMENT_INFO | TEXT | invoices.PAYMENT_INFO | invoices.PAYMENT_INFO | invoices |
| invoices__PAYMENT_TYPE | TEXT | invoices.PAYMENT_TYPE | invoices.PAYMENT_TYPE | invoices |
| invoices__PROJECT_ID | TEXT | invoices.PROJECT_ID | invoices.PROJECT_ID | invoices |
| invoices__SALUTATION | TEXT | invoices.SALUTATION | invoices.SALUTATION | invoices |
| invoices__SERVICE_PERIOD_END | TEXT | invoices.SERVICE_PERIOD_END | invoices.SERVICE_PERIOD_END | invoices |
| invoices__SERVICE_PERIOD_START | TEXT | invoices.SERVICE_PERIOD_START | invoices.SERVICE_PERIOD_START | invoices |
| invoices__SUB_TOTAL | NUMERIC | invoices.SUB_TOTAL | invoices.SUB_TOTAL | invoices |
| invoices__TEMPLATE_ID | TEXT | invoices.TEMPLATE_ID | invoices.TEMPLATE_ID | invoices |
| invoices__TOTAL | NUMERIC | invoices.TOTAL | invoices.TOTAL | invoices |
| invoices__TYPE | TEXT | invoices.TYPE | invoices.TYPE | invoices |
| invoices__VAT_CASE | TEXT | invoices.VAT_CASE | invoices.VAT_CASE | invoices |
| invoices__VAT_ID | TEXT | invoices.VAT_ID | invoices.VAT_ID | invoices |
| invoices__VAT_ITEMS | OBJECT | invoices.VAT_ITEMS | invoices.VAT_ITEMS | invoices |
| invoices__VAT_TOTAL | NUMERIC | invoices.VAT_TOTAL | invoices.VAT_TOTAL | invoices |
| invoices__ZIPCODE | TEXT | invoices.ZIPCODE | invoices.ZIPCODE | invoices |
| products__ARTICLE_ID | TEXT | products.ARTICLE_ID | products.ARTICLE_ID | products |
| products__ARTICLE_NUMBER | TEXT | products.ARTICLE_NUMBER | products.ARTICLE_NUMBER | products |
| products__CURRENCY_CODE | TEXT | products.CURRENCY_CODE | products.CURRENCY_CODE | products |
| products__DESCRIPTION | TEXT | products.DESCRIPTION | products.DESCRIPTION | products |
| products__IS_GROSS | NUMERIC | products.IS_GROSS | products.IS_GROSS | products |
| products__TAGS | TEXT | products.TAGS | products.TAGS | products |
| products__TITLE | TEXT | products.TITLE | products.TITLE | products |
| products__UNIT | TEXT | products.UNIT | products.UNIT | products |
| products__UNIT_PRICE | TEXT | products.UNIT_PRICE | products.UNIT_PRICE | products |
| products__VAT_PERCENT | TEXT | products.VAT_PERCENT | products.VAT_PERCENT | products |
| recurring_invoices__ADDRESS | TEXT | recurring_invoices.ADDRESS | recurring_invoices.ADDRESS | recurring_invoices |
| recurring_invoices__ADDRESS_2 | TEXT | recurring_invoices.ADDRESS_2 | recurring_invoices.ADDRESS_2 | recurring_invoices |
| recurring_invoices__BANK_ACCOUNT_NUMBER | TEXT | recurring_invoices.BANK_ACCOUNT_NUMBER | recurring_invoices.BANK_ACCOUNT_NUMBER | recurring_invoices |
| recurring_invoices__BANK_ACCOUNT_OWNER | TEXT | recurring_invoices.BANK_ACCOUNT_OWNER | recurring_invoices.BANK_ACCOUNT_OWNER | recurring_invoices |
| recurring_invoices__BANK_BIC | TEXT | recurring_invoices.BANK_BIC | recurring_invoices.BANK_BIC | recurring_invoices |
| recurring_invoices__BANK_CODE | TEXT | recurring_invoices.BANK_CODE | recurring_invoices.BANK_CODE | recurring_invoices |
| recurring_invoices__BANK_IBAN | TEXT | recurring_invoices.BANK_IBAN | recurring_invoices.BANK_IBAN | recurring_invoices |
| recurring_invoices__BANK_NAME | TEXT | recurring_invoices.BANK_NAME | recurring_invoices.BANK_NAME | recurring_invoices |
| recurring_invoices__CASH_DISCOUNT_DAYS | TEXT | recurring_invoices.CASH_DISCOUNT_DAYS | recurring_invoices.CASH_DISCOUNT_DAYS | recurring_invoices |
| recurring_invoices__CASH_DISCOUNT_PERCENT | TEXT | recurring_invoices.CASH_DISCOUNT_PERCENT | recurring_invoices.CASH_DISCOUNT_PERCENT | recurring_invoices |
| recurring_invoices__CITY | TEXT | recurring_invoices.CITY | recurring_invoices.CITY | recurring_invoices |
| recurring_invoices__CONTACT_ID | TEXT | recurring_invoices.CONTACT_ID | recurring_invoices.CONTACT_ID | recurring_invoices |
| recurring_invoices__CURRENCY_CODE | TEXT | recurring_invoices.CURRENCY_CODE | recurring_invoices.CURRENCY_CODE | recurring_invoices |
| recurring_invoices__CUSTOMER_COSTCENTER_ID | TEXT | recurring_invoices.CUSTOMER_COSTCENTER_ID | recurring_invoices.CUSTOMER_COSTCENTER_ID | recurring_invoices |
| recurring_invoices__CUSTOMER_ID | TEXT | recurring_invoices.CUSTOMER_ID | recurring_invoices.CUSTOMER_ID | recurring_invoices |
| recurring_invoices__CUSTOMER_NUMBER | TEXT | recurring_invoices.CUSTOMER_NUMBER | recurring_invoices.CUSTOMER_NUMBER | recurring_invoices |
| recurring_invoices__DELIVERY_DATE | TEXT | recurring_invoices.DELIVERY_DATE | recurring_invoices.DELIVERY_DATE | recurring_invoices |
| recurring_invoices__EMAIL_NOTIFY | TEXT | recurring_invoices.EMAIL_NOTIFY | recurring_invoices.EMAIL_NOTIFY | recurring_invoices |
| recurring_invoices__FIRST_NAME | TEXT | recurring_invoices.FIRST_NAME | recurring_invoices.FIRST_NAME | recurring_invoices |
| recurring_invoices__FREQUENCY | TEXT | recurring_invoices.FREQUENCY | recurring_invoices.FREQUENCY | recurring_invoices |
| recurring_invoices__INTROTEXT | TEXT | recurring_invoices.INTROTEXT | recurring_invoices.INTROTEXT | recurring_invoices |
| recurring_invoices__INVOICE_ID | TEXT | recurring_invoices.INVOICE_ID | recurring_invoices.INVOICE_ID | recurring_invoices |
| recurring_invoices__INVOICE_TITLE | TEXT | recurring_invoices.INVOICE_TITLE | recurring_invoices.INVOICE_TITLE | recurring_invoices |
| recurring_invoices__ITEMS | OBJECT | recurring_invoices.ITEMS | recurring_invoices.ITEMS | recurring_invoices |
| recurring_invoices__LAST_NAME | TEXT | recurring_invoices.LAST_NAME | recurring_invoices.LAST_NAME | recurring_invoices |
| recurring_invoices__NOTE | TEXT | recurring_invoices.NOTE | recurring_invoices.NOTE | recurring_invoices |
| recurring_invoices__OCCURENCES | TEXT | recurring_invoices.OCCURENCES | recurring_invoices.OCCURENCES | recurring_invoices |
| recurring_invoices__ORGANIZATION | TEXT | recurring_invoices.ORGANIZATION | recurring_invoices.ORGANIZATION | recurring_invoices |
| recurring_invoices__OUTPUT_TYPE | TEXT | recurring_invoices.OUTPUT_TYPE | recurring_invoices.OUTPUT_TYPE | recurring_invoices |
| recurring_invoices__PAYMENT_TYPE | TEXT | recurring_invoices.PAYMENT_TYPE | recurring_invoices.PAYMENT_TYPE | recurring_invoices |
| recurring_invoices__PROJECT_ID | TEXT | recurring_invoices.PROJECT_ID | recurring_invoices.PROJECT_ID | recurring_invoices |
| recurring_invoices__SALUTATION | TEXT | recurring_invoices.SALUTATION | recurring_invoices.SALUTATION | recurring_invoices |
| recurring_invoices__SERVICE_PERIOD_END | TEXT | recurring_invoices.SERVICE_PERIOD_END | recurring_invoices.SERVICE_PERIOD_END | recurring_invoices |
| recurring_invoices__SERVICE_PERIOD_START | TEXT | recurring_invoices.SERVICE_PERIOD_START | recurring_invoices.SERVICE_PERIOD_START | recurring_invoices |
| recurring_invoices__START_DATE | TEXT | recurring_invoices.START_DATE | recurring_invoices.START_DATE | recurring_invoices |
| recurring_invoices__SUB_TOTAL | NUMERIC | recurring_invoices.SUB_TOTAL | recurring_invoices.SUB_TOTAL | recurring_invoices |
| recurring_invoices__TEMPLATE_ID | TEXT | recurring_invoices.TEMPLATE_ID | recurring_invoices.TEMPLATE_ID | recurring_invoices |
| recurring_invoices__TOTAL | NUMERIC | recurring_invoices.TOTAL | recurring_invoices.TOTAL | recurring_invoices |
| recurring_invoices__TYPE | TEXT | recurring_invoices.TYPE | recurring_invoices.TYPE | recurring_invoices |
| recurring_invoices__VAT_CASE | TEXT | recurring_invoices.VAT_CASE | recurring_invoices.VAT_CASE | recurring_invoices |
| recurring_invoices__VAT_ITEMS | OBJECT | recurring_invoices.VAT_ITEMS | recurring_invoices.VAT_ITEMS | recurring_invoices |
| recurring_invoices__VAT_TOTAL | NUMERIC | recurring_invoices.VAT_TOTAL | recurring_invoices.VAT_TOTAL | recurring_invoices |
| recurring_invoices__ZIPCODE | TEXT | recurring_invoices.ZIPCODE | recurring_invoices.ZIPCODE | recurring_invoices |
| revenues__ADDRESS | TEXT | revenues.ADDRESS | revenues.ADDRESS | revenues |
| revenues__ADDRESS_2 | TEXT | revenues.ADDRESS_2 | revenues.ADDRESS_2 | revenues |
| revenues__BANK_ACCOUNT_NUMBER | TEXT | revenues.BANK_ACCOUNT_NUMBER | revenues.BANK_ACCOUNT_NUMBER | revenues |
| revenues__BANK_ACCOUNT_OWNER | TEXT | revenues.BANK_ACCOUNT_OWNER | revenues.BANK_ACCOUNT_OWNER | revenues |
| revenues__BANK_BIC | TEXT | revenues.BANK_BIC | revenues.BANK_BIC | revenues |
| revenues__BANK_CODE | TEXT | revenues.BANK_CODE | revenues.BANK_CODE | revenues |
| revenues__BANK_IBAN | TEXT | revenues.BANK_IBAN | revenues.BANK_IBAN | revenues |
| revenues__BANK_NAME | TEXT | revenues.BANK_NAME | revenues.BANK_NAME | revenues |
| revenues__CASH_DISCOUNT_DAYS | TEXT | revenues.CASH_DISCOUNT_DAYS | revenues.CASH_DISCOUNT_DAYS | revenues |
| revenues__CASH_DISCOUNT_PERCENT | TEXT | revenues.CASH_DISCOUNT_PERCENT | revenues.CASH_DISCOUNT_PERCENT | revenues |
| revenues__CITY | TEXT | revenues.CITY | revenues.CITY | revenues |
| revenues__CONTACT_ID | TEXT | revenues.CONTACT_ID | revenues.CONTACT_ID | revenues |
| revenues__COUNTRY_CODE | TEXT | revenues.COUNTRY_CODE | revenues.COUNTRY_CODE | revenues |
| revenues__CURRENCY_CODE | TEXT | revenues.CURRENCY_CODE | revenues.CURRENCY_CODE | revenues |
| revenues__CUSTOMER_COSTCENTER_ID | TEXT | revenues.CUSTOMER_COSTCENTER_ID | revenues.CUSTOMER_COSTCENTER_ID | revenues |
| revenues__CUSTOMER_ID | TEXT | revenues.CUSTOMER_ID | revenues.CUSTOMER_ID | revenues |
| revenues__CUSTOMER_NUMBER | TEXT | revenues.CUSTOMER_NUMBER | revenues.CUSTOMER_NUMBER | revenues |
| revenues__DELIVERY_DATE | TEXT | revenues.DELIVERY_DATE | revenues.DELIVERY_DATE | revenues |
| revenues__DOCUMENT_URL | TEXT | revenues.DOCUMENT_URL | revenues.DOCUMENT_URL | revenues |
| revenues__DUE_DATE | TEXT | revenues.DUE_DATE | revenues.DUE_DATE | revenues |
| revenues__FIRST_NAME | TEXT | revenues.FIRST_NAME | revenues.FIRST_NAME | revenues |
| revenues__INTROTEXT | TEXT | revenues.INTROTEXT | revenues.INTROTEXT | revenues |
| revenues__INVOICE_DATE | TEXT | revenues.INVOICE_DATE | revenues.INVOICE_DATE | revenues |
| revenues__INVOICE_ID | TEXT | revenues.INVOICE_ID | revenues.INVOICE_ID | revenues |
| revenues__INVOICE_NUMBER | TEXT | revenues.INVOICE_NUMBER | revenues.INVOICE_NUMBER | revenues |
| revenues__INVOICE_TITLE | TEXT | revenues.INVOICE_TITLE | revenues.INVOICE_TITLE | revenues |
| revenues__IS_CANCELED | TEXT | revenues.IS_CANCELED | revenues.IS_CANCELED | revenues |
| revenues__ITEMS | OBJECT | revenues.ITEMS | revenues.ITEMS | revenues |
| revenues__LASTUPDATE | TEXT | revenues.LASTUPDATE | revenues.LASTUPDATE | revenues |
| revenues__LAST_NAME | TEXT | revenues.LAST_NAME | revenues.LAST_NAME | revenues |
| revenues__NOTE | TEXT | revenues.NOTE | revenues.NOTE | revenues |
| revenues__ORGANIZATION | TEXT | revenues.ORGANIZATION | revenues.ORGANIZATION | revenues |
| revenues__PAID_DATE | TEXT | revenues.PAID_DATE | revenues.PAID_DATE | revenues |
| revenues__PAYMENTS | OBJECT | revenues.PAYMENTS | revenues.PAYMENTS | revenues |
| revenues__PAYMENT_INFO | TEXT | revenues.PAYMENT_INFO | revenues.PAYMENT_INFO | revenues |
| revenues__PAYMENT_TYPE | TEXT | revenues.PAYMENT_TYPE | revenues.PAYMENT_TYPE | revenues |
| revenues__PROJECT_ID | TEXT | revenues.PROJECT_ID | revenues.PROJECT_ID | revenues |
| revenues__SALUTATION | TEXT | revenues.SALUTATION | revenues.SALUTATION | revenues |
| revenues__SERVICE_PERIOD_END | TEXT | revenues.SERVICE_PERIOD_END | revenues.SERVICE_PERIOD_END | revenues |
| revenues__SERVICE_PERIOD_START | TEXT | revenues.SERVICE_PERIOD_START | revenues.SERVICE_PERIOD_START | revenues |
| revenues__SUB_TOTAL | NUMERIC | revenues.SUB_TOTAL | revenues.SUB_TOTAL | revenues |
| revenues__TEMPLATE_ID | TEXT | revenues.TEMPLATE_ID | revenues.TEMPLATE_ID | revenues |
| revenues__TOTAL | NUMERIC | revenues.TOTAL | revenues.TOTAL | revenues |
| revenues__TYPE | TEXT | revenues.TYPE | revenues.TYPE | revenues |
| revenues__VAT_CASE | TEXT | revenues.VAT_CASE | revenues.VAT_CASE | revenues |
| revenues__VAT_ID | TEXT | revenues.VAT_ID | revenues.VAT_ID | revenues |
| revenues__VAT_ITEMS | OBJECT | revenues.VAT_ITEMS | revenues.VAT_ITEMS | revenues |
| revenues__VAT_TOTAL | NUMERIC | revenues.VAT_TOTAL | revenues.VAT_TOTAL | revenues |
| revenues__ZIPCODE | TEXT | revenues.ZIPCODE | revenues.ZIPCODE | revenues |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |