Fivetran documentation

Search the docs

/

Planful

Explore the interactive ERD

Table & Field Reference

gl_data

Column	Type	Keys
`_fivetran_id`	String	PK
`fiscal_month`	Unknown
`fiscal_year`	Unknown
`month_name`	Unknown
`mtd_amount`	Unknown
`qtd_amount`	Unknown
`reporting`	Unknown
`scenario`	Unknown
`segment_1`	Unknown
`segment_2`	Unknown
`segment_3`	Unknown
`segment_4`	Unknown
`segment_5`	Unknown
`segment_6`	Unknown
`segment_7`	Unknown
`segment_8`	Unknown
`ytd_amount`	Unknown

segment_3_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_3_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_3_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

segment_7_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_7_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_7_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

segment_5_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_5_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_5_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

segment_2_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_2_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_2_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`currency_code`	Unknown
`currency_name`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

rule_gl

Column	Type	Keys
`id`	Unknown	PK
`load_item`	Unknown
`name`	Unknown

segment_1_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_1_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_1_data

Column	Type	Keys
`member_id`	Unknown	PK
`account_group`	Unknown
`account_type`	Unknown
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`credit_debit`	Unknown
`currency_type_code`	Unknown
`currency_type_name`	Unknown
`member_type`	Unknown
`name`	Unknown
`normal_data_input`	Unknown
`parent_code`	Unknown
`parent_member_code`	Unknown
`parent_member_id`	Unknown
`parent_member_label`	Unknown
`parent_member_name`	Unknown
`report_category_name`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown
`trial_balance_account`	Unknown
`variance`	Unknown

segment_8_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_8_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_8_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

segment_4_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_4_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_4_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown

segment_6_data_rollup_level

Column	Type	Keys
`index`	Unknown	PK
`segment_6_data_member_id`	Unknown	PKFK
`code`	Unknown
`id`	Unknown
`level`	Unknown
`name`	Unknown

segment_6_data

Column	Type	Keys
`member_id`	Unknown	PK
`active_status`	Unknown
`attributes`	Unknown
`code`	Unknown
`member_type`	Unknown
`name`	Unknown
`parent_code`	Unknown
`parent_id`	Unknown
`rollup_operator`	Unknown
`sort`	Unknown