# Planful schema ERD

Table and field reference for the Fivetran Planful connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- segment_3_data_rollup_level(segment_3_data_member_id) → segment_3_data(member_id)
- segment_7_data_rollup_level(segment_7_data_member_id) → segment_7_data(member_id)
- segment_5_data_rollup_level(segment_5_data_member_id) → segment_5_data(member_id)
- segment_2_data_rollup_level(segment_2_data_member_id) → segment_2_data(member_id)
- segment_1_data_rollup_level(segment_1_data_member_id) → segment_1_data(member_id)
- segment_8_data_rollup_level(segment_8_data_member_id) → segment_8_data(member_id)
- segment_4_data_rollup_level(segment_4_data_member_id) → segment_4_data(member_id)
- segment_6_data_rollup_level(segment_6_data_member_id) → segment_6_data(member_id)