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 |