Fivetran documentation

Search the docs

/

Brightflag

Explore the interactive ERD

Table & Field Reference

allocation

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`name`	Unknown
`order_number`	Unknown

resource

Column	Type	Keys
`_fivetran_id`	String	PK
`attributes`	Json
`endpoint`	Unknown
`id`	Unknown
`name`	Unknown
`schema`	Unknown

trading_entity

Column	Type	Keys
`id`	Unknown	PK
`city`	Unknown
`code`	Unknown
`country`	Unknown
`enabled`	Unknown
`name`	Unknown
`state`	Unknown
`street`	Unknown
`tax_id`	Unknown
`zip`	Unknown

matter_custom_attribute

Column	Type	Keys
`index`	Unknown	PK
`matter_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

matter_internal_user

Column	Type	Keys
`index`	Unknown	PK
`matter_id`	Unknown	PKFK
`internal_matter_user`	Unknown

matter

Column	Type	Keys
`id`	Unknown	PK
`budget`	Unknown
`category`	Unknown
`change_timestamp`	Unknown
`closed_date`	Unknown
`country`	Unknown
`country_name`	Unknown
`currency`	Unknown
`department`	Unknown
`description`	Unknown
`entity`	Unknown
`internal_matter_lead_user`	Unknown
`is_open`	Unknown
`iso_code`	Unknown
`lead_outside_counsel_username`	Unknown
`open_date`	Unknown
`ref`	Unknown
`region_name`	Unknown
`remove_excluded_internal_matter_participants`	Unknown
`remove_excluded_vendors`	Unknown

user_role

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`role`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`department`	Unknown
`email`	Unknown
`employee_level`	Unknown
`employee_number`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`last_name`	Unknown
`manager`	Unknown
`schema`	Json
`username`	Unknown

tax_rate

Column	Type	Keys
`_fivetran_id`	String	PK
`code`	Unknown
`jurisdiction_iso_code`	Unknown
`percentage`	Unknown
`type_name`	Unknown

allocation_option

Column	Type	Keys
`id`	Unknown	PK
`allocation_id`	Unknown	PKFK
`active`	Unknown
`ap_code`	Unknown
`name`	Unknown

paysite

Column	Type	Keys
`id`	Unknown	PK
`vendor_ref`	Unknown	FK
`active`	Unknown
`billing_legal_entity`	Unknown
`billing_legal_entity_code`	Unknown
`code`	Unknown
`currency`	Unknown
`vendor_office_ref`	Unknown

invoice_summary

Column	Type	Keys
`id`	Unknown	PK
`vendor_ref`	Unknown	FK
`adjustments`	Unknown
`approved_gross_total`	Unknown
`blended_tax_rate`	Unknown
`currency_details_customer_default_currency_fx_rate`	Unknown
`currency_details_customer_default_currency_iso_code`	Unknown
`currency_details_matter_currency_fx_rate`	Unknown
`currency_details_matter_currency_iso_code`	Unknown
`currency_iso_code`	Unknown
`date`	LocalDateTime
`discount`	Unknown
`expenses`	Unknown
`exposure_percentage`	Unknown
`fees_total`	Unknown
`group_id`	Unknown
`matter_ref`	Unknown
`number`	Unknown
`original_gross_total`	Unknown
`po_number`	Unknown
`status`	Unknown
`status_change_timestamp`	Unknown
`tax_total`	Unknown

account_payable_batch

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`customer_batch_id`	Unknown
`customer_id`	Unknown
`recipient_email`	Unknown
`recipient_id`	Unknown
`text`	Unknown

vendor

Column	Type	Keys
`id`	Unknown	PK
`ref`	Unknown	PK
`contact_email`	Unknown
`firm_name`	Unknown
`name`	Unknown
`payment_method`	Unknown
`preferred_flag`	Unknown

vendor_office

Column	Type	Keys
`id`	Unknown	PK
`vendor_ref`	Unknown	FK
`address_city`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`address_street_and_building`	Unknown
`admin_user_email`	Unknown
`admin_user_forename`	Unknown
`admin_user_surname`	Unknown
`bank_account_name`	Unknown
`bank_account_no`	Unknown
`bank_address`	Unknown
`bank_iban`	Unknown
`bank_name`	Unknown
`bank_sort_code`	Unknown
`bank_swift_or_bic`	Unknown
`country`	Unknown
`country_iso_code`	Unknown
`name`	Unknown
`office_vendor_id`	Unknown
`payment_method`	Unknown
`ref`	Unknown
`tax_id`	Unknown