# Visma schema ERD

Table and field reference for the Fivetran Visma connector.

## Table & Field Reference

### financial_period

| Column | Type | Keys |
| --- | --- | --- |
| period | String | PK |
| active | Unknown |  |
| closed_in_cash_management | Unknown |  |
| closed_in_customer_ledger | Unknown |  |
| closed_in_fixed_assets | Unknown |  |
| closed_in_general_ledger | Unknown |  |
| closed_in_inventory_management | Unknown |  |
| closed_in_supplier_ledger | Unknown |  |
| description | String |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| year | Unknown |  |

### inventory_issue_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_issue_id | String | PK, FK |
| inventory_issue_line_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### inventory_issue_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_issue_id | String | PK, FK |
| inventory_issue_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_issue_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_issue_id | String | PK, FK |
| branch_number | String | FK |
| warehouse_id | String | FK |
| description | String |  |
| expiration_date | Unknown |  |
| ext_cost | Unknown |  |
| ext_price | Unknown |  |
| inventory_item_description | String |  |
| inventory_item_number | String |  |
| line_number | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| purchase_order_receipt_number | String |  |
| quantity | Unknown |  |
| reason_code_description | String |  |
| reason_code_id | String |  |
| transaction_type | String |  |
| unit_cost | Unknown |  |
| unit_price | Unknown |  |
| uom | String |  |

### inventory_issue_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_issue_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| batch_number | String |  |
| control_amount | Unknown |  |
| control_quantity | Unknown |  |
| date | Unknown |  |
| description | String |  |
| external_reference | String |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| post_period | String |  |
| status | String |  |
| timestamps | String |  |
| total_amount | Unknown |  |
| total_quantity | Unknown |  |

### branch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| number | String | PK |
| currency_id | String | FK |
| organization_id | Unknown | FK |
| bank_settings_address_1 | String |  |
| bank_settings_address_2 | String |  |
| bank_settings_address_3 | String |  |
| bank_settings_bba_n_2 | String |  |
| bank_settings_bba_n_3 | String |  |
| bank_settings_bban | String |  |
| bank_settings_bic | String |  |
| bank_settings_country | String |  |
| bank_settings_creditor_id | String |  |
| bank_settings_iban | String |  |
| bank_settings_name | String |  |
| corporate_id | String |  |
| default_country_id | String |  |
| default_country_name | String |  |
| delivery_address_address_line_1 | String |  |
| delivery_address_address_line_2 | String |  |
| delivery_address_address_line_3 | String |  |
| delivery_address_city | String |  |
| delivery_address_country_id | String |  |
| delivery_address_country_name | String |  |
| delivery_address_county_id | String |  |
| delivery_address_county_name | String |  |
| delivery_address_id | Unknown |  |
| delivery_address_postal_code | String |  |
| delivery_contact_attention | String |  |
| delivery_contact_email | String |  |
| delivery_contact_fax | String |  |
| delivery_contact_id | Unknown |  |
| delivery_contact_name | String |  |
| delivery_contact_phone_1 | String |  |
| delivery_contact_phone_2 | String |  |
| delivery_contact_web | String |  |
| industry_code_description | String |  |
| industry_code_id | String |  |
| is_active | Unknown |  |
| is_main_branch | Unknown |  |
| last_modified_date_time | Unknown |  |
| ledger_description | String |  |
| ledger_id | String |  |
| main_address_city | String |  |
| main_address_country_id | String |  |
| main_address_country_name | String |  |
| main_address_county_id | String |  |
| main_address_county_name | String |  |
| main_address_id | Unknown |  |
| main_address_line_1 | String |  |
| main_address_line_2 | String |  |
| main_address_line_3 | String |  |
| main_address_postal_code | String |  |
| main_contact_attention | String |  |
| main_contact_email | String |  |
| main_contact_fax | String |  |
| main_contact_id | Unknown |  |
| main_contact_name | String |  |
| main_contact_phone_1 | String |  |
| main_contact_phone_2 | String |  |
| main_contact_web | String |  |
| name | String |  |
| vat_registration_id | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### supplier_location_payment_method_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supplier_location_baccount_internal_id | Unknown | PK, FK |
| supplier_location_location_id | String | PK, FK |
| banking_detail_type | String |  |
| description | String |  |
| value | String |  |

### supplier_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| baccount_internal_id | Unknown | PK, FK |
| active | Unknown |  |
| address_city | String |  |
| address_country_id | String |  |
| address_country_name | String |  |
| address_county_id | String |  |
| address_county_name | String |  |
| address_id | Unknown |  |
| address_line_1 | String |  |
| address_line_2 | String |  |
| address_line_3 | String |  |
| address_postal_code | String |  |
| contact_attention | String |  |
| contact_email | String |  |
| contact_fax | String |  |
| contact_id | Unknown |  |
| contact_name | String |  |
| contact_phone_1 | String |  |
| contact_phone_2 | String |  |
| contact_web | String |  |
| corporate_id | String |  |
| edi_code | String |  |
| gln | String |  |
| last_modified_date_time | Unknown |  |
| time_stamp | String |  |
| vat_registration_id | String |  |
| vat_zone_default_tax_category_description | String |  |
| vat_zone_default_tax_category_number | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### inventory_adjustment_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_adjustment_id | String | PK, FK |
| inventory_adjustment_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_adjustment_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_adjustment_id | String | PK, FK |
| branch_number | String | FK |
| location_id | String | FK |
| warehouse_id | String | FK |
| description | String |  |
| ext_cost | Unknown |  |
| inventory_item_description | String |  |
| inventory_item_number | String |  |
| line_number | Unknown |  |
| location_country_id | String |  |
| location_name | String |  |
| purchase_order_receipt_number | String |  |
| quantity | Unknown |  |
| reason_code_description | String |  |
| reason_code_id | String |  |
| receipt_number | String |  |
| unit_cost | Unknown |  |
| uom | String |  |

### inventory_adjustment_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_adjustment_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| batch_number | String |  |
| control_cost | Unknown |  |
| control_quantity | Unknown |  |
| date | Unknown |  |
| description | String |  |
| external_reference | String |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| post_period | String |  |
| status | String |  |
| timestamps | String |  |
| total_cost | Unknown |  |
| total_quantity | Unknown |  |

### inventory_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| inventory_id | String | FK |
| location_id | String | FK |
| warehouse_id | String | FK |
| available | Unknown |  |
| available_for_shipment | Unknown |  |
| base_unit | String |  |
| drop_ship_for_so | Unknown |  |
| drop_ship_for_so_prepared | Unknown |  |
| drop_ship_for_so_receipt | Unknown |  |
| estimated_total_cost | Unknown |  |
| estimated_unit_cost | Unknown |  |
| expired | Unknown |  |
| in_assembly_demand | Unknown |  |
| in_assembly_supply | Unknown |  |
| in_issues | Unknown |  |
| in_receipts | Unknown |  |
| in_transit | Unknown |  |
| location_name | String |  |
| not_available | Unknown |  |
| on_hand | Unknown |  |
| po_receipt | Unknown |  |
| purchase_for_so | Unknown |  |
| purchase_for_so_prepared | Unknown |  |
| purchase_for_so_receipt | Unknown |  |
| purchase_order | Unknown |  |
| purchase_prepared | Unknown |  |
| so_allocated | Unknown |  |
| so_back_ordered | Unknown |  |
| so_booked | Unknown |  |
| so_shipped | Unknown |  |
| so_to_drop_ship | Unknown |  |
| so_to_purchase | Unknown |  |

### supplier_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| supplier_id | Unknown | PK, FK |
| description | String |  |
| value | String |  |

### supplier_payment_method_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| supplier_id | Unknown | PK, FK |
| banking_detail_type | String |  |
| description | String |  |
| value | String |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| number | String | PK |
| cash_account | String | FK |
| currency_id | String | FK |
| gl_accounts_expense_sub_account_id | String | FK |
| gl_accounts_supplier_sub_account_id | String | FK |
| payment_method_id | String | FK |
| account_reference | String |  |
| account_used_for_payment | String |  |
| charge_bearer | String |  |
| corporate_id | String |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| document_language | String |  |
| gl_accounts_expense_account_description | String |  |
| gl_accounts_expense_account_import_description | String |  |
| gl_accounts_expense_account_import_number | String |  |
| gl_accounts_expense_account_import_type | String |  |
| gl_accounts_expense_account_non_tax_description | String |  |
| gl_accounts_expense_account_non_tax_number | String |  |
| gl_accounts_expense_account_non_tax_type | String |  |
| gl_accounts_expense_account_number | String |  |
| gl_accounts_expense_account_type | String |  |
| gl_accounts_expense_eu_account_description | String |  |
| gl_accounts_expense_eu_account_number | String |  |
| gl_accounts_expense_eu_account_type | String |  |
| gl_accounts_supplier_account_description | String |  |
| gl_accounts_supplier_account_number | String |  |
| gl_accounts_supplier_account_type | String |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| main_address_city | String |  |
| main_address_country_id | String |  |
| main_address_country_name | String |  |
| main_address_county_id | String |  |
| main_address_county_name | String |  |
| main_address_id | Unknown |  |
| main_address_line_1 | String |  |
| main_address_line_2 | String |  |
| main_address_line_3 | String |  |
| main_address_postal_code | String |  |
| main_contact_attention | String |  |
| main_contact_email | String |  |
| main_contact_fax | String |  |
| main_contact_id | Unknown |  |
| main_contact_name | String |  |
| main_contact_phone_1 | String |  |
| main_contact_phone_2 | String |  |
| main_contact_web | String |  |
| name | String |  |
| note | String |  |
| number_of_employee | Unknown |  |
| parent_record_name | String |  |
| parent_record_number | String |  |
| pay_separately | Unknown |  |
| payment_by | String |  |
| payment_lead_time | Unknown |  |
| payment_ref_display_mask | String |  |
| remit_address_city | String |  |
| remit_address_county_id | String |  |
| remit_address_county_name | String |  |
| remit_address_id | Unknown |  |
| remit_address_line_1 | String |  |
| remit_address_line_2 | String |  |
| remit_address_line_3 | String |  |
| remit_address_postal_code | String |  |
| remit_contact_attention | String |  |
| remit_contact_email | String |  |
| remit_contact_fax | String |  |
| remit_contact_id | Unknown |  |
| remit_contact_name | String |  |
| remit_contact_phone_1 | String |  |
| remit_contact_phone_2 | String |  |
| remit_contact_web | String |  |
| remit_sddress_country_id | String |  |
| remit_sddress_country_name | String |  |
| retainage_apply | Unknown |  |
| retainage_cash_account_id | String |  |
| retainage_pct | Unknown |  |
| status | String |  |
| supplier_address_city | String |  |
| supplier_address_country_id | String |  |
| supplier_address_country_name | String |  |
| supplier_address_county_id | String |  |
| supplier_address_county_name | String |  |
| supplier_address_id | Unknown |  |
| supplier_address_line_1 | String |  |
| supplier_address_line_2 | String |  |
| supplier_address_line_3 | String |  |
| supplier_address_postal_code | String |  |
| supplier_class_description | String |  |
| supplier_class_id | String |  |
| supplier_contact_attention | String |  |
| supplier_contact_email | String |  |
| supplier_contact_fax | String |  |
| supplier_contact_id | Unknown |  |
| supplier_contact_name | String |  |
| supplier_contact_phone_1 | String |  |
| supplier_contact_phone_2 | String |  |
| supplier_contact_web | String |  |
| vat_registration_id | String |  |
| vat_zone_default_tax_categorydescription | String |  |
| vat_zone_default_tax_categorynumber | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### kit_specification_stock_component_line

| Column | Type | Keys |
| --- | --- | --- |
| line_nbr | Unknown | PK |
| kit_specification_id | String | PK, FK |
| allow_component_qty_variance | Unknown |  |
| allow_component_substitution | Unknown |  |
| component_id | String |  |
| component_qty | Unknown |  |
| description | String |  |
| disassembly_coeff | Unknown |  |
| max_component_qty | Unknown |  |
| min_component_qty | Unknown |  |
| uom | String |  |

### kit_specification_non_stock_component_line

| Column | Type | Keys |
| --- | --- | --- |
| line_nbr | Unknown | PK |
| kit_specification_id | String | PK, FK |
| allow_component_qty_variance | Unknown |  |
| component_id | String |  |
| component_qty | Unknown |  |
| description | String |  |
| max_component_qty | Unknown |  |
| min_component_qty | Unknown |  |
| uom | String |  |

### kit_specification

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| allow_component_addition | Unknown |  |
| created_date_time | Unknown |  |
| description | String |  |
| is_active | Unknown |  |
| is_non_stock | Unknown |  |
| last_modified_date_time | Unknown |  |
| revision | String |  |
| timestamps | String |  |

### warehouse_location_attribute_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| warehouse_location_attribute_id | String | PK, FK |
| warehouse_location_attribute_warehouse_id | String | PK, FK |
| warehouse_location_attribute_warehouse_location_id | String | PK, FK |
| description | String |  |

### warehouse_location_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| warehouse_id | String | PK, FK |
| warehouse_location_id | String | PK, FK |
| default_value | String |  |
| description | String |  |
| required | Unknown |  |
| sort_order | Unknown |  |
| type | String |  |

### warehouse_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | String | PK |
| warehouse_id | String | PK, FK |
| active | Unknown |  |
| assembly_valid | Unknown |  |
| description | String |  |
| incl_qty_avail | Unknown |  |
| is_costed | Unknown |  |
| primary_item_class_description | String |  |
| primary_item_class_id | String |  |
| primary_item_class_type | String |  |
| primary_item_description | String |  |
| primary_item_number | String |  |
| primary_item_valid | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| receipts_valid | Unknown |  |
| sales_valid | Unknown |  |
| transfers_valid | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| active | Unknown |  |
| address_city | String |  |
| address_country_id | String |  |
| address_country_name | String |  |
| address_county_id | String |  |
| address_county_name | String |  |
| address_id | Unknown |  |
| address_line_1 | String |  |
| address_line_2 | String |  |
| address_type | String |  |
| address_validated | Unknown |  |
| avg_default_cost | String |  |
| contact_attention | String |  |
| contact_company_name | String |  |
| contact_email | String |  |
| contact_fax | String |  |
| contact_id | Unknown |  |
| contact_phone_1 | String |  |
| contact_phone_2 | String |  |
| contact_web | String |  |
| description | String |  |
| drop_ship_location_description | String |  |
| drop_ship_location_id | String |  |
| fifo_default_cost | String |  |
| location_entry | String |  |
| lock_site_pi_count_entry | Unknown |  |
| receipt_location_description | String |  |
| receipt_location_id | String |  |
| replenishment_class_description | String |  |
| replenishment_class_id | String |  |
| return_location_description | String |  |
| return_location_id | String |  |
| ship_location_description | String |  |
| ship_location_id | String |  |
| timestamps | String |  |

### sales_order_type

| Column | Type | Keys |
| --- | --- | --- |
| order_type | String | PK |
| active | Unknown |  |
| behavior | String |  |
| customer_document_type | String |  |
| default_operation | String |  |
| description | String |  |

### purchase_order_discount_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | String | PK, FK |
| discount | Unknown |  |
| discount_amt | Unknown |  |
| discount_code | String |  |
| discountable_amt | Unknown |  |
| discountable_qty | Unknown |  |
| free_item | Unknown |  |
| free_item_qty | Unknown |  |
| line_nbr | Unknown |  |
| manual_discount | Unknown |  |
| sequance_id | String |  |
| skip_discount | Unknown |  |
| type | String |  |

### purchase_order_tax_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | String | PK, FK |
| id | String |  |
| record_id | Unknown |  |
| taxable_amount | Unknown |  |
| vat_amount | Unknown |  |
| vat_id_description | String |  |
| vat_id_number | String |  |
| vat_rate | Unknown |  |

### purchase_order_line_sub_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | String | PK, FK |
| purchase_order_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### purchase_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | String | PK, FK |
| account_number | Unknown | FK |
| branch_number | String | FK |
| inventory_number | String | FK |
| sub_account_id | Unknown | FK |
| warehouse_id | String | FK |
| alternate_id | String |  |
| amount | Unknown |  |
| canceled | Unknown |  |
| complete_on | Unknown |  |
| completed | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_code_description | String |  |
| discount_code_number | String |  |
| discount_percent | Unknown |  |
| ext_cost | Unknown |  |
| line_nbr | Unknown |  |
| manual_discount | Unknown |  |
| max_receipt | Unknown |  |
| min_receipt | Unknown |  |
| note | String |  |
| order_number | String |  |
| order_qty | Unknown |  |
| order_type | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| promised | Unknown |  |
| qty_on_receipt | Unknown |  |
| receipt_action | String |  |
| received_amt | Unknown |  |
| requested | Unknown |  |
| tax_category_description | String |  |
| tax_category_number | String |  |
| type | String |  |
| unit_cost | Unknown |  |
| unit_cost_in_base_currency | Unknown |  |
| uom | String |  |

### purchase_order_receipt

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | String | PK, FK |
| currency | String |  |
| number | String |  |
| status | String |  |
| supplier_name | String |  |
| total_amt | Unknown |  |
| total_qty | Unknown |  |
| type | String |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| currency_id | String | FK |
| sales_order_type | String | FK |
| supplier_internal_id | Unknown | FK |
| warehouse_id | String | FK |
| control_total | Unknown |  |
| control_total_in_base_currency | Unknown |  |
| date | Unknown |  |
| default_tax_category_description | String |  |
| default_tax_category_number | String |  |
| description | String |  |
| dont_email | Unknown |  |
| dont_print | Unknown |  |
| emailed | Unknown |  |
| exchange_rate | Unknown |  |
| fob_point | String |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| line_total | Unknown |  |
| line_total_in_base_currency | Unknown |  |
| location_id | Unknown |  |
| location_name | String |  |
| note | String |  |
| open_balance | Unknown |  |
| open_quantity | Unknown |  |
| order_total_in_base_currency | Unknown |  |
| order_type | String |  |
| owner_id | String |  |
| owner_name | String |  |
| payment_ref_nbr | String |  |
| printed | Unknown |  |
| promised_on | Unknown |  |
| remit_address_city | String |  |
| remit_address_country_id | String |  |
| remit_address_country_name | String |  |
| remit_address_county_id | String |  |
| remit_address_county_name | String |  |
| remit_address_id | Unknown |  |
| remit_address_line_1 | String |  |
| remit_address_line_2 | String |  |
| remit_address_line_3 | String |  |
| remit_address_override_address | Unknown |  |
| remit_address_postal_code | String |  |
| remit_contact_attention | String |  |
| remit_contact_email | String |  |
| remit_contact_fax | String |  |
| remit_contact_id | Unknown |  |
| remit_contact_name | String |  |
| remit_contact_override_contact | Unknown |  |
| remit_contact_phone_1 | String |  |
| remit_contact_phone_2 | String |  |
| remit_contact_web | String |  |
| requisition_ref_nbr | String |  |
| sales_order_nbr | String |  |
| ship_term | String |  |
| ship_to_internal_id | Unknown |  |
| ship_to_name | String |  |
| ship_to_number | String |  |
| ship_via | String |  |
| shipping_address_city | String |  |
| shipping_address_country_id | String |  |
| shipping_address_country_name | String |  |
| shipping_address_county_id | String |  |
| shipping_address_county_name | String |  |
| shipping_address_id | Unknown |  |
| shipping_address_line_1 | String |  |
| shipping_address_line_2 | String |  |
| shipping_address_line_3 | String |  |
| shipping_address_override_address | Unknown |  |
| shipping_address_postal_code | String |  |
| shipping_contact_attention | String |  |
| shipping_contact_email | String |  |
| shipping_contact_fax | String |  |
| shipping_contact_id | Unknown |  |
| shipping_contact_name | String |  |
| shipping_contact_override_contact | Unknown |  |
| shipping_contact_phone_1 | String |  |
| shipping_contact_phone_2 | String |  |
| shipping_contact_web | String |  |
| shipping_destination_type | String |  |
| shipping_location_id | Unknown |  |
| shipping_location_name | String |  |
| status | String |  |
| supplier_ref | String |  |
| supplier_vat_zone_default_vat_category | String |  |
| supplier_vat_zone_description | String |  |
| supplier_vat_zone_id | String |  |
| tax_total | Unknown |  |
| tax_total_in_base_currency | Unknown |  |
| terms_description | String |  |
| terms_id | String |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_base_currency | Unknown |  |
| work_group_id | Unknown |  |

### customer_invoice_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_invoice_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_invoice_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_invoice_tax_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_invoice_id | String | PK, FK |
| record_id | Unknown |  |
| taxable_amount | Unknown |  |
| vat_amount | Unknown |  |
| vat_description | String |  |
| vat_number | String |  |
| vat_rate | Unknown |  |

### customer_invoice_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | String | PK, FK |
| customer_invoice_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_invoice_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_invoice_id | String | PK, FK |
| customer_invoice_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_invoice_id | String | PK, FK |
| account_number | String | FK |
| branch_number | String | FK |
| sub_account_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| cost | Unknown |  |
| deductable_amount | Unknown |  |
| deferral_code | String |  |
| deferral_schedule | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_amount_in_currency | Unknown |  |
| discount_code | String |  |
| discount_percent | Unknown |  |
| end_date | Unknown |  |
| external_link | String |  |
| inventory_number | String |  |
| is_rot_rut_deductible | Unknown |  |
| item_type | String |  |
| line_number | Unknown |  |
| line_type | String |  |
| manual_amount | Unknown |  |
| manual_amount_in_currency | Unknown |  |
| manual_discount | Unknown |  |
| note | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| quantity | Unknown |  |
| s_0_order_nbr | String |  |
| seller_description | String |  |
| seller_id | String |  |
| so_order_type | String |  |
| so_shipment_nbr | String |  |
| start_date | Unknown |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| type_of_workdescription | String |  |
| type_of_workrut_rot_type | String |  |
| type_of_workxml_tag | String |  |
| unit_price | Unknown |  |
| unit_price_in_currency | Unknown |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### customer_invoice_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_invoice_id | String | PK, FK |
| amount_paid | Unknown |  |
| application_date | Unknown |  |
| application_period | String |  |
| balance | Unknown |  |
| cash_discount_taken | Unknown |  |
| customer_cd | String |  |
| doc_type | String |  |
| hold | Unknown |  |
| invoice_text | String |  |
| payment_ref | String |  |
| pending_ppd | Unknown |  |
| ppd_cr_memo_ref_nbr | String |  |
| ref_nbr | String |  |
| released | Unknown |  |
| status | String |  |
| unit_price_in_currency | Unknown |  |
| voided | Unknown |  |

### customer_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_number | String | FK |
| branch_number | Unknown | FK |
| cash_account | String | FK |
| closed_financial_period | String | FK |
| currency_id | String | FK |
| customer_id | String | FK |
| financial_period | String | FK |
| payment_method_id | String | FK |
| sub_account_id | Unknown | FK |
| accounting_cost_ref | String |  |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| balance | Unknown |  |
| balance_in_currency | Unknown |  |
| branch_name | String |  |
| cash_discount | Unknown |  |
| cash_discount_in_currency | Unknown |  |
| cash_discount_rate | Unknown |  |
| child_record_name | String |  |
| child_record_number | String |  |
| contact_id | Unknown |  |
| contact_name | String |  |
| contract_doc_ref | String |  |
| created_date_time | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| customer_project | String |  |
| customer_reference | String |  |
| customer_vat_zone_description | String |  |
| customer_vat_zone_id | String |  |
| detail_total | Unknown |  |
| detail_total_in_currency | Unknown |  |
| direct_debit_mandate_description | String |  |
| direct_debit_mandate_mandate_id | String |  |
| direct_debit_mandate_uid | String |  |
| document_date | Unknown |  |
| document_due_date | Unknown |  |
| document_type | String |  |
| dont_email | Unknown |  |
| dont_print | Unknown |  |
| dunning_letter_date | Unknown |  |
| dunning_letter_level | Unknown |  |
| end_date | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | String |  |
| hold | Unknown |  |
| invoice_address_city | String |  |
| invoice_address_country_id | String |  |
| invoice_address_country_name | String |  |
| invoice_address_county_id | String |  |
| invoice_address_county_name | String |  |
| invoice_address_id | Unknown |  |
| invoice_address_line_1 | String |  |
| invoice_address_line_2 | String |  |
| invoice_address_line_3 | String |  |
| invoice_address_override_address | Unknown |  |
| invoice_address_postal_code | String |  |
| invoice_contact_attention | String |  |
| invoice_contact_business_name | String |  |
| invoice_contact_email | String |  |
| invoice_contact_id | Unknown |  |
| invoice_contact_override_contact | Unknown |  |
| invoice_contact_phone_1 | String |  |
| invoice_contact_web | String |  |
| invoice_text | String |  |
| is_rot_rut_deductible | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| note | String |  |
| orig_invoice_date | Unknown |  |
| originator_doc_ref | String |  |
| payment_reference | String |  |
| post_period | String |  |
| project_description | String |  |
| project_id | String |  |
| revoked | Unknown |  |
| rounding_diff | Unknown |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| send_to_auto_invoice | Unknown |  |
| start_date | Unknown |  |
| status | String |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_currency | Unknown |  |
| vat_taotal | Unknown |  |
| vat_taxable_total | Unknown |  |
| vat_taxable_total_in_currency | Unknown |  |
| vat_total_in_currency | Unknown |  |

### inventory_receipt_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_receipt_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_receipt_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| index | Unknown | PK, FK |
| inventory_receipt_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_receipt_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_receipt_id | String | PK, FK |
| inventory_receipt_line_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### inventory_receipt_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_receipt_id | String | PK, FK |
| branch_number | String | FK |
| warehouse_id | String | FK |
| description | String |  |
| ext_cost | Unknown |  |
| inventory_item_description | String |  |
| inventory_item_number | String |  |
| line_number | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| purchase_order_receipt_number | String |  |
| quantity | Unknown |  |
| reason_code_description | String |  |
| reason_code_id | String |  |
| unit_cost | Unknown |  |
| uom | String |  |

### inventory_receipt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| batch_number | String |  |
| control_cost | Unknown |  |
| control_quantity | Unknown |  |
| date | Unknown |  |
| description | String |  |
| external_reference | String |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| post_period | String |  |
| status | String |  |
| timestamps | String |  |
| total_cost | Unknown |  |
| total_quantity | Unknown |  |
| transfer_number | String |  |

### general_ledger_transaction

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_number | String | FK |
| branch_number | String | FK |
| currency_id | String | FK |
| ledger_id | String | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| account_gl_consol_account_cd | String |  |
| batch_number | String |  |
| beg_balance | Unknown |  |
| credit_amount | Unknown |  |
| curr_beg_balance | Unknown |  |
| curr_credit_amount | Unknown |  |
| curr_debit_amount | Unknown |  |
| curr_ending_balance | Unknown |  |
| debit_amount | Unknown |  |
| description | String |  |
| ending_balance | Unknown |  |
| last_modified_date_time | Unknown |  |
| ledger_description | String |  |
| line_number | Unknown |  |
| period | String |  |
| ref_number | String |  |
| sub_account | String |  |
| tran_date | Unknown |  |

### currency_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_currency_id | String | FK |
| to_currency_id | String | FK |
| effective_date | Unknown |  |
| mult_div | String |  |
| rate | Unknown |  |
| rate_reciprocal | Unknown |  |
| rate_type | String |  |

### kit_assembly_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| kit_assembly_id | String | PK, FK |
| expiration_date | Unknown |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### kit_assembly_non_stock_component_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| kit_assembly_id | String | PK, FK |
| allow_component_qty_variance | Unknown |  |
| component_qty | Unknown |  |
| description | String |  |
| line_nbr | Unknown |  |
| max_component_qty | Unknown |  |
| min_component_qty | Unknown |  |
| quantity | Unknown |  |
| reason_code | String |  |
| unit_cost | Unknown |  |
| uom | String |  |

### kit_assembly_stock_component_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| kit_assembly_id | String | PK, FK |
| kit_assembly_stock_component_line_id | String | PK, FK |
| expiration_date | Unknown |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### kit_assembly_stock_component_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| kit_assembly_id | String | PK, FK |
| allow_component_qty_variance | Unknown |  |
| allow_component_substitution | Unknown |  |
| component_qty | Unknown |  |
| description | String |  |
| disassembly_coeff | Unknown |  |
| line_nbr | Unknown |  |
| location | String |  |
| max_component_qty | Unknown |  |
| min_component_qty | Unknown |  |
| quantity | Unknown |  |
| reason_code | String |  |
| unit_cost | Unknown |  |
| uo_m | String |  |

### kit_assembly

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| warehouse | String | FK |
| created_date_time | Unknown |  |
| date | Unknown |  |
| description | String |  |
| hold | Unknown |  |
| item_id | String |  |
| last_modified_date_time | Unknown |  |
| location | String |  |
| post_period | String |  |
| quantity | Unknown |  |
| reason_code | String |  |
| revision | String |  |
| sales_order_link | String |  |
| status | String |  |
| timestamps | String |  |
| type | String |  |
| uo_m | String |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| decimal_precision | Unknown |  |
| description | String |  |
| is_base_currency | Unknown |  |
| is_used_for_accounting | Unknown |  |
| symbol | String |  |

### attribute_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| attribute_id | String | PK, FK |
| description | String |  |
| disabled | Unknown |  |
| sort_order | Unknown |  |

### attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| control_type | String |  |
| created_date_time | Unknown |  |
| description | String |  |
| entry_mask | String |  |
| internal | Unknown |  |
| last_modified_date_time | Unknown |  |
| reg_exp | String |  |

### journal_transaction_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| financial_period_id | String | PK, FK |
| journal_transaction_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### journal_transaction_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| financial_period_id | String | PK, FK |
| journal_transaction_id | String | PK, FK |
| journal_transaction_line_number | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### journal_transaction_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| financial_period_id | String | PK, FK |
| journal_transaction_id | String | PK, FK |
| journal_transaction_line_number | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### journal_transaction_line

| Column | Type | Keys |
| --- | --- | --- |
| line_number | Unknown | PK |
| financial_period_id | String | PK, FK |
| journal_transaction_id | String | PK, FK |
| account_number | String | FK |
| inventory_number | String | FK |
| sub_account_id | Unknown | FK |
| branch | String |  |
| credit_amount | Unknown |  |
| credit_amount_in_currency | Unknown |  |
| customer_supplier | String |  |
| debit_amount | Unknown |  |
| debit_amount_in_currency | Unknown |  |
| description | String |  |
| module | String |  |
| note | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| quantity | Unknown |  |
| reference_number | String |  |
| transaction_description | String |  |
| transaction_type | String |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |
| vat_description | String |  |
| vat_id | String |  |

### journal_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| financial_period_id | String | PK, FK |
| currency_id | String | FK |
| ledger_id | String | FK |
| auto_reversing | Unknown |  |
| branch | String |  |
| control_total | Unknown |  |
| control_total_in_currency | Unknown |  |
| create_vat_transaction | Unknown |  |
| description | String |  |
| exchange_rate | Unknown |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| ledger_description | String |  |
| module | String |  |
| original_batch_number | String |  |
| post_period | String |  |
| reversing_entry | Unknown |  |
| skip_vat_amount_validation | Unknown |  |
| status | String |  |
| transaction_code | String |  |
| transaction_code_description | String |  |
| transaction_date | Unknown |  |

### ledger

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| currency_id | String | FK |
| balance_type | String |  |
| branch_accounting | Unknown |  |
| consol_branch_name | String |  |
| consol_branch_number | String |  |
| consolidation_source | Unknown |  |
| description | String |  |
| internal_id | Unknown |  |
| last_modified_date_time | Unknown |  |
| post_inter_company | Unknown |  |

### organization_branch

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | String | PK, FK |
| name | String |  |
| number | String |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| currency_id | String | FK |
| ledger_id | String | FK |
| bank_settings_address_1 | String |  |
| bank_settings_address_2 | String |  |
| bank_settings_address_3 | String |  |
| bank_settings_bba_n_2 | String |  |
| bank_settings_bba_n_3 | String |  |
| bank_settings_bban | String |  |
| bank_settings_bic | String |  |
| bank_settings_country | String |  |
| bank_settings_creditor_id | String |  |
| bank_settings_iban | String |  |
| bank_settings_name | String |  |
| base_currency | String |  |
| corporate_id | String |  |
| default_country_id | String |  |
| default_country_name | String |  |
| delivery_address_city | String |  |
| delivery_address_country_id | String |  |
| delivery_address_country_name | String |  |
| delivery_address_county_id | String |  |
| delivery_address_county_name | String |  |
| delivery_address_id | Unknown |  |
| delivery_address_line_1 | String |  |
| delivery_address_line_2 | String |  |
| delivery_address_line_3 | String |  |
| delivery_address_postal_code | String |  |
| delivery_contact_attention | String |  |
| delivery_contact_email | String |  |
| delivery_contact_fax | String |  |
| delivery_contact_id | Unknown |  |
| delivery_contact_name | String |  |
| delivery_contact_phone_1 | String |  |
| delivery_contact_phone_2 | String |  |
| delivery_contact_web | String |  |
| file_tax_by_branches | Unknown |  |
| industry_code_description | String |  |
| industry_code_id | String |  |
| last_modified_date_time | String |  |
| main_address_city | String |  |
| main_address_country_id | String |  |
| main_address_country_name | String |  |
| main_address_county_id | String |  |
| main_address_county_name | String |  |
| main_address_id | Unknown |  |
| main_address_line_1 | String |  |
| main_address_line_2 | String |  |
| main_address_line_3 | String |  |
| main_address_postal_code | String |  |
| main_contact_attention | String |  |
| main_contact_email | String |  |
| main_contact_fax | String |  |
| main_contact_id | Unknown |  |
| main_contact_name | String |  |
| main_contact_phone_1 | String |  |
| main_contact_phone_2 | String |  |
| main_contact_web | String |  |
| name | String |  |
| time_stamp | Unknown |  |
| type | String |  |
| vat_registration_id | String |  |
| vat_zone_default_tax_category_description | String |  |
| vat_zone_default_tax_category_number | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### sales_order_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| inventory_id | String | PK |
| split_line_number | Unknown | PK |
| sales_order_id | String | PK, FK |
| sales_order_line_id | Unknown | PK, FK |
| allocated | Unknown |  |
| completed | Unknown |  |
| expiration_date | Unknown |  |
| lot_serial_number | String |  |
| purchase_order_number | String |  |
| purchase_receipt_number | String |  |
| quantity | Unknown |  |
| received_quantity | Unknown |  |
| ship_date | Unknown |  |
| shipment_number | String |  |
| shipped_quantity | Unknown |  |
| unit_of_measure | String |  |

### sales_order_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_order_id | String | PK, FK |
| sales_order_line_id | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### sales_order_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | String | PK, FK |
| inventory_id | String | FK |
| supplier_id | String | FK |
| warehouse_id | String | FK |
| amount_not_invoiced | Unknown |  |
| auto_create_issue | Unknown |  |
| base_order_quantity | Unknown |  |
| billed_quantity | Unknown |  |
| commissionable | Unknown |  |
| completed | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_code | String |  |
| discount_percent | Unknown |  |
| discount_sequence_id | String |  |
| discounted_unit_price | Unknown |  |
| excise_duty | Unknown |  |
| extended_price | Unknown |  |
| external_link | String |  |
| free_item | Unknown |  |
| has_manual_discount | Unknown |  |
| has_manual_price | Unknown |  |
| inventory_alternate_id | String |  |
| inventory_base_unit | String |  |
| inventory_description | String |  |
| invoice_line_number | Unknown |  |
| invoice_number | String |  |
| invoice_type | String |  |
| is_rot_rut_deductible | Unknown |  |
| kit_assembly_reference_number | String |  |
| line_total_before_discount | Unknown |  |
| line_type | String |  |
| note | String |  |
| open_line | Unknown |  |
| open_quantity | Unknown |  |
| operation | String |  |
| order_date | Unknown |  |
| overship_threshold | Unknown |  |
| project_task_id | String |  |
| purchase_order_number | Json |  |
| purchase_order_source | String |  |
| quantity | Unknown |  |
| quantity_on_shipment | Unknown |  |
| reason_code | String |  |
| replacement_unit_cost | Unknown |  |
| request_date | Unknown |  |
| rot_rut_deductible_amount | Unknown |  |
| rot_rut_item_type_description | String |  |
| rot_rut_item_type_id | String |  |
| rot_rut_work_type | String |  |
| sales_account_id | String |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| ship_date | Unknown |  |
| shipping_rule | String |  |
| sort_order | Unknown |  |
| supplier_price | Unknown |  |
| tax_category_id | String |  |
| undership_threshold | Unknown |  |
| unit_cost | Unknown |  |
| unit_of_measure | String |  |
| unit_price | Unknown |  |
| warehouse_location_description | String |  |
| warehouse_location_id | String |  |
| custom_field_** |  |  |
| subaccount_** |  |  |

### sales_order_commission

| Column | Type | Keys |
| --- | --- | --- |
| sales_person_id | String | PK |
| sales_order_id | String | PK, FK |
| amount | Unknown |  |
| commissionable_amount | Unknown |  |
| percentage | Unknown |  |

### sales_order_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_order_id | String | PK, FK |
| amount | Unknown |  |
| exempt_tax | Unknown |  |
| include_in_taxable | Unknown |  |
| is_pending_tax | Unknown |  |
| is_reverse_tax | Unknown |  |
| is_statistical_tax | Unknown |  |
| rate | Unknown |  |
| taxable_amount | Unknown |  |
| type | String |  |

### sales_order_shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| sales_order_id | String | PK, FK |
| date | Unknown |  |
| inventory_correction_document_type | String |  |
| inventory_correction_reference_id | String |  |
| inventory_document_type | String |  |
| inventory_reference_id | String |  |
| invoice_id | String |  |
| invoice_type | String |  |
| quantity | Unknown |  |
| shipment_number | String |  |
| status | String |  |
| volume | Unknown |  |
| weight | Unknown |  |

### sales_order_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_order_id | String | PK, FK |
| discount_amount | Unknown |  |
| discount_percent | Unknown |  |
| discount_sequence_id | String |  |
| discountable_amount | Unknown |  |
| discountable_quantity | Unknown |  |
| free_item_description | String |  |
| free_item_id | String |  |
| free_item_quantity | Unknown |  |
| is_manual | Unknown |  |
| manual_order_index | Unknown |  |
| skip_discount | Unknown |  |
| type | String |  |

### sales_order_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_order_id | String | PK, FK |
| currency_id | String | FK |
| amount_applied_to_order | Unknown |  |
| balance | Unknown |  |
| billed_amount | Unknown |  |
| cash_account | String |  |
| document_type | String |  |
| payment_method | String |  |
| reference | String |  |
| reference_number | String |  |
| status | String |  |
| total_amount | Unknown |  |

### sales_order_rot_rut_distribution

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK |
| sales_order_id | String | PK, FK |
| amount | Unknown |  |
| extra | Unknown |  |
| personal_id | String |  |

### sales_order_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_order_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_id | String | FK |
| currency | String | FK |
| customer_id | String | FK |
| payment_settings_cash_account_id | String | FK |
| payment_settings_payment_method_id | String | FK |
| shipping_preferred_warehouse_id | String | FK |
| shipping_ship_via_id | String | FK |
| billing_address_city | String |  |
| billing_address_country_id | String |  |
| billing_address_country_name | String |  |
| billing_address_county_id | String |  |
| billing_address_county_name | String |  |
| billing_address_id | Unknown |  |
| billing_address_line_1 | String |  |
| billing_address_line_2 | String |  |
| billing_address_line_3 | String |  |
| billing_address_overrides_default | Unknown |  |
| billing_address_postal_code | String |  |
| billing_contact_attention | String |  |
| billing_contact_email | String |  |
| billing_contact_fax | String |  |
| billing_contact_id | Unknown |  |
| billing_contact_name | String |  |
| billing_contact_overrides_default | Unknown |  |
| billing_contact_phone_1 | String |  |
| billing_contact_phone_2 | String |  |
| cancel_by | Unknown |  |
| cost_total | Unknown |  |
| cost_total_in_base_currency | Unknown |  |
| created_by | String |  |
| customer_order | String |  |
| customer_ref_no | String |  |
| date | Unknown |  |
| description | String |  |
| discount_total | Unknown |  |
| discount_total_in_base_currency | Unknown |  |
| emailed | Unknown |  |
| excise_duty_total | Unknown |  |
| excise_duty_total_in_base_currency | Unknown |  |
| financial_information_cash_discount_date | Unknown |  |
| financial_information_due_date | Unknown |  |
| financial_information_invoice_date | Unknown |  |
| financial_information_invoice_id | String |  |
| financial_information_invoice_separately | Unknown |  |
| financial_information_post_period | String |  |
| financial_information_term_description | String |  |
| financial_information_term_id | String |  |
| freight_amount | Unknown |  |
| freight_amount_in_base_currency | Unknown |  |
| freight_cost | Unknown |  |
| freight_cost_in_base_currency | Unknown |  |
| freight_premium_amount | Unknown |  |
| freight_premium_amount_in_base_currency | Unknown |  |
| freight_tax_category_id | String |  |
| freight_total | Unknown |  |
| freight_total_in_base_currency | Unknown |  |
| freight_volume | Unknown |  |
| freight_weight | Unknown |  |
| is_rot_rut_deductible | Unknown |  |
| last_modified | Unknown |  |
| location | String |  |
| note | String |  |
| order_total | Unknown |  |
| order_total_in_base_currency | Unknown |  |
| origin_link_additional_prop_1_href | String |  |
| origin_link_additional_prop_2_href | String |  |
| origin_link_additional_prop_3_href | String |  |
| origin_order_id | String |  |
| origin_order_type | String |  |
| original_order_id | String |  |
| original_order_type | String |  |
| owner_id | String |  |
| owner_internal_id | String |  |
| parent_customer_id | String |  |
| parent_customer_internal_id | Unknown |  |
| parent_customer_name | String |  |
| payment_settings_payment_method_description | String |  |
| payment_settings_payment_reference | String |  |
| payment_total | Unknown |  |
| payment_total_in_base_currency | Unknown |  |
| print_description_on_invoice | Unknown |  |
| print_note_on_external_document | Unknown |  |
| print_note_on_internal_document | Unknown |  |
| project_description | String |  |
| project_id | String |  |
| project_internal_id | Unknown |  |
| request_on | Unknown |  |
| rot_rut_apartment | String |  |
| rot_rut_distributed_automatically | Unknown |  |
| rot_rut_estate | String |  |
| rot_rut_material_cost_amount | Unknown |  |
| rot_rut_organization_number | String |  |
| rot_rut_other_cost_amount | Unknown |  |
| rot_rut_total_deductable_amount | Unknown |  |
| rot_rut_type | String |  |
| rot_rut_work_price_amount | Unknown |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| shipping_address_city | String |  |
| shipping_address_country_id | String |  |
| shipping_address_country_name | String |  |
| shipping_address_county_id | String |  |
| shipping_address_county_name | String |  |
| shipping_address_id | Unknown |  |
| shipping_address_line_1 | String |  |
| shipping_address_line_2 | String |  |
| shipping_address_line_3 | String |  |
| shipping_address_override_default | Unknown |  |
| shipping_address_postal_code | String |  |
| shipping_contact_attention | String |  |
| shipping_contact_email | String |  |
| shipping_contact_fax | String |  |
| shipping_contact_id | Unknown |  |
| shipping_contact_name | String |  |
| shipping_contact_overrides_default | Unknown |  |
| shipping_contact_phone_1 | String |  |
| shipping_contact_phone_2 | String |  |
| shipping_fob_point_description | String |  |
| shipping_fob_point_id | String |  |
| shipping_insurance | Unknown |  |
| shipping_intrastat_transaction_type_description | String |  |
| shipping_intrastat_transaction_type_id | Unknown |  |
| shipping_preferred_warehouse_description | String |  |
| shipping_priority | Unknown |  |
| shipping_residential_delivery | Unknown |  |
| shipping_rule | String |  |
| shipping_saturday_delivery | Unknown |  |
| shipping_scheduled_date | Unknown |  |
| shipping_ship_separately | Unknown |  |
| shipping_ship_via_description | String |  |
| shipping_term_description | String |  |
| shipping_term_id | String |  |
| shipping_zone_description | String |  |
| shipping_zone_id | String |  |
| status | String |  |
| status_details_cancelled | Unknown |  |
| status_details_description | String |  |
| status_details_hold | Unknown |  |
| tax_exempt_total | Unknown |  |
| tax_exempt_total_in_base_currency | Unknown |  |
| tax_total | Unknown |  |
| tax_total_in_base_currency | Unknown |  |
| taxable_total | Unknown |  |
| taxable_total_in_base_currency | Unknown |  |
| type | String |  |
| unbilled_amount | Unknown |  |
| unbilled_amount_in_base_currency | Unknown |  |
| unshipped_amount | Unknown |  |
| unshipped_amount_in_base_currency | Unknown |  |
| use_replacement_cost_for_margin_and_profit | Unknown |  |
| version | String |  |
| custom_field_** |  |  |

### supplier_invoice_tax_detail_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supplier_invoice_fivetran_id | Unknown | PK, FK |
| record_id | Unknown |  |
| taxable_amount | Unknown |  |
| vat_amount | Unknown |  |
| vat_id_description | String |  |
| vat_id_number | String |  |
| vat_rate | Unknown |  |

### supplier_invoice_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supplier_invoice_fivetran_id | Unknown | PK, FK |
| supplier_invoice_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### supplier_invoice_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_invoice_fivetran_id | Unknown | PK, FK |
| supplier_invoice_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### supplier_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_invoice_fivetran_id | Unknown | PK, FK |
| account_number | String | FK |
| branch_number | String | FK |
| inventory_number | String | FK |
| sub_account_id | Unknown | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| account_type | String |  |
| cost | Unknown |  |
| cost_in_currency | Unknown |  |
| cury_retainage_amt | Unknown |  |
| deferral_code | String |  |
| deferral_schedule | Unknown |  |
| deferral_schedule_nbr | String |  |
| discount_amount | Unknown |  |
| discount_amount_in_currency | Unknown |  |
| discount_percent | Unknown |  |
| discount_unit_cost | Unknown |  |
| discount_unit_cost_in_currency | Unknown |  |
| external_inventory_id | String |  |
| line_number | Unknown |  |
| manual_discount | Unknown |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| quantity | Unknown |  |
| retainage_pct | Unknown |  |
| split_hierarchy | String |  |
| stock_item | Unknown |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| transaction_description | String |  |
| unit_cost | Unknown |  |
| unit_cost_in_currency | Unknown |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### supplier_invoice_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supplier_invoice_fivetran_id | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### supplier_invoice

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| branch_number | String | FK |
| cash_account | String | FK |
| closed_financial_period | String | FK |
| currency_id | String | FK |
| financial_period | String | FK |
| payment_method_id | String | FK |
| supplier_number | String | FK |
| amount | Unknown |  |
| approval_detail_attachment_id | String |  |
| approval_detail_comment | String |  |
| approval_status | String |  |
| balance | Unknown |  |
| balance_in_currency | Unknown |  |
| buyer_reference | String |  |
| cash_discount | Unknown |  |
| cash_discount_date | Unknown |  |
| cash_discount_in_currency | Unknown |  |
| created_date_time | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| cury_retainage_total | Unknown |  |
| cury_retainage_unreleased_amt | Unknown |  |
| date | Unknown |  |
| description | String |  |
| detail_total | Unknown |  |
| detail_total_in_currency | Unknown |  |
| document_type | String |  |
| document_version_number | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| note | String |  |
| orig_invoice_date | Unknown |  |
| pay_date | Unknown |  |
| pay_selected | Unknown |  |
| payment_message | String |  |
| payment_ref_no | String |  |
| post_period | String |  |
| reference_number | String |  |
| retainage_apply | Unknown |  |
| rounding_diff | Unknown |  |
| rounding_diff_in_currency | Unknown |  |
| status | String |  |
| supplier_reference | String |  |
| supplier_tax_zone_default_tax_category_description | String |  |
| supplier_tax_zone_default_tax_category_number | String |  |
| supplier_tax_zone_default_vat_category | String |  |
| supplier_tax_zone_description | String |  |
| supplier_tax_zone_id | String |  |
| tax_calculation_mode | String |  |
| time_stamp | String |  |
| vat_amount | Unknown |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_currency | Unknown |  |
| vat_taxable_total | Unknown |  |
| vat_taxable_total_in_currency | Unknown |  |
| vat_total | Unknown |  |
| vat_total_in_currency | Unknown |  |
| withholding_tax | Unknown |  |
| withholding_tax_in_currency | Unknown |  |

### customer_debit_note_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_debit_note_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_debit_note_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_debit_note_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_debit_note_tax_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_debit_note_id | String | PK, FK |
| record_id | Unknown |  |
| taxable_amount | Unknown |  |
| vat_amount | Unknown |  |
| vat_description | String |  |
| vat_number | String |  |
| vat_rate | Unknown |  |

### customer_debit_note_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_debit_note_id | String | PK, FK |
| customer_debit_note_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_debit_note_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_debit_note_id | String | PK, FK |
| customer_debit_note_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_debit_note_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_debit_note_id | String | PK, FK |
| account_number | String | FK |
| branch_number | String | FK |
| sub_account_id | Unknown | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| cost | Unknown |  |
| deductable_amount | Unknown |  |
| deferral_code | String |  |
| deferral_schedule | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_amount_in_currency | Unknown |  |
| discount_code | String |  |
| discount_percent | Unknown |  |
| external_link | String |  |
| inventory_number | String |  |
| is_rot_rut_deductible | Unknown |  |
| item_type | String |  |
| line_number | Unknown |  |
| manual_amount | Unknown |  |
| manual_amount_in_currency | Unknown |  |
| manual_discount | Unknown |  |
| note | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| quantity | Unknown |  |
| s_0_order_nbr | String |  |
| seller_description | String |  |
| seller_id | String |  |
| so_order_type | String |  |
| so_shipment_nbr | String |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| type_of_workdescription | String |  |
| type_of_workrut_rot_type | String |  |
| type_of_workxml_tag | String |  |
| unit_price | Unknown |  |
| unit_price_in_currency | Unknown |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### customer_debit_note_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_debit_note_id | String | PK, FK |
| amount_paid | Unknown |  |
| application_date | Unknown |  |
| application_period | String |  |
| balance | Unknown |  |
| cash_discount_taken | Unknown |  |
| customer_cd | String |  |
| doc_type | String |  |
| hold | Unknown |  |
| invoice_text | String |  |
| payment_ref | String |  |
| pending_ppd | Unknown |  |
| ppd_cr_memo_ref_nbr | String |  |
| ref_nbr | String |  |
| released | Unknown |  |
| status | String |  |
| unit_price_in_currency | Unknown |  |
| voided | Unknown |  |

### customer_debit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_number | String | FK |
| branch_number | String | FK |
| cash_account | String | FK |
| closed_financial_period | String | FK |
| currency_id | String | FK |
| customer_id | String | FK |
| financial_period | String | FK |
| payment_method_id | String | FK |
| sub_account_id | Unknown | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| balance | Unknown |  |
| balance_in_currency | Unknown |  |
| cash_discount | Unknown |  |
| cash_discount_in_currency | Unknown |  |
| cash_discount_rate | Unknown |  |
| child_record_name | String |  |
| child_record_number | String |  |
| contact_id | Unknown |  |
| contact_name | String |  |
| created_date_time | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| customer_project | String |  |
| customer_reference | String |  |
| customer_vat_zone_description | String |  |
| customer_vat_zone_id | String |  |
| detail_total | Unknown |  |
| detail_total_in_currency | Unknown |  |
| document_date | Unknown |  |
| document_due_date | Unknown |  |
| document_type | String |  |
| dont_email | Unknown |  |
| dont_print | Unknown |  |
| dunning_letter_date | Unknown |  |
| dunning_letter_level | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | String |  |
| hold | Unknown |  |
| invoice_address_city | String |  |
| invoice_address_country_id | String |  |
| invoice_address_country_name | String |  |
| invoice_address_county_id | String |  |
| invoice_address_county_name | String |  |
| invoice_address_id | Unknown |  |
| invoice_address_line_1 | String |  |
| invoice_address_line_2 | String |  |
| invoice_address_line_3 | String |  |
| invoice_address_override_address | Unknown |  |
| invoice_address_postal_code | String |  |
| invoice_contact_attention | String |  |
| invoice_contact_business_name | Unknown |  |
| invoice_contact_email | String |  |
| invoice_contact_id | Unknown |  |
| invoice_contact_override_contact | Unknown |  |
| invoice_contact_phone_1 | String |  |
| invoice_contact_web | String |  |
| invoice_text | Unknown |  |
| is_rot_rut_deductible | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| note | String |  |
| orig_invoice_date | Unknown |  |
| payment_reference | String |  |
| post_period | String |  |
| project_description | String |  |
| project_id | String |  |
| revoked | Unknown |  |
| rounding_diff | Unknown |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| send_to_auto_invoice | Unknown |  |
| status | String |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_currency | Unknown |  |
| vat_taotal | Unknown |  |
| vat_taxable_total | Unknown |  |
| vat_taxable_total_in_currency | Unknown |  |
| vat_total_in_currency | Unknown |  |

### purchase_receipt_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_receipt_id | String | PK, FK |
| purchase_receipt_line_index | Unknown | PK, FK |
| description | String |  |
| expiration_date | Unknown |  |
| item_id | String |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### purchase_receipt_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_receipt_id | String | PK, FK |
| account_number | String | FK |
| actual_account_number | String | FK |
| branch_number | String | FK |
| inventory_number | String | FK |
| warehouse_id | String | FK |
| account_description | String |  |
| actual_account_description | String |  |
| actual_account_type | String |  |
| actual_sub_description | String |  |
| actual_sub_id | String |  |
| amount | Unknown |  |
| complete_po_line | Unknown |  |
| discount_amount | Unknown |  |
| discount_code_description | String |  |
| discount_code_number | String |  |
| discount_percent | Unknown |  |
| expiration_date | Unknown |  |
| ext_cost | Unknown |  |
| inventory_description | String |  |
| location_country_id | Unknown |  |
| location_id | String |  |
| location_location | Unknown |  |
| location_name | String |  |
| lot_serial_number | String |  |
| manual_discount | Unknown |  |
| nbr | Unknown |  |
| open_qty | Unknown |  |
| order_qty | Unknown |  |
| po_order_line_nbr | Unknown |  |
| po_order_nbr | String |  |
| po_order_type | String |  |
| project_description | String |  |
| project_id | String |  |
| project_task_description | Unknown |  |
| project_task_id | String |  |
| project_task_location | Unknown |  |
| receipt_qty | Unknown |  |
| sub_description | String |  |
| sub_id | String |  |
| tax_category_description | String |  |
| tax_category_number | String |  |
| transaction_description | String |  |
| transfer_order_line_nbr | Unknown |  |
| transfer_order_nbr | String |  |
| transfer_order_type | String |  |
| type | String |  |
| unit_cost | Unknown |  |
| uom | String |  |

### purchase_receipt_landed_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_receipt_id | String | PK, FK |
| internal_id | Unknown | FK |
| amount | Unknown |  |
| ap_bill_date | Unknown |  |
| ap_doc_type | String |  |
| ap_ref_nbr | String |  |
| currency | String |  |
| description | String |  |
| in_doc_type | String |  |
| in_ref_nbr | String |  |
| inventory_description | String |  |
| inventory_number | String |  |
| landed_cost_code | String |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| postpone_purchase_invoice_creation | Unknown |  |
| purchase_invoice_nbr | String |  |
| tax_category_description | String |  |
| tax_category_number | String |  |
| terms_description | String |  |
| terms_id | String |  |

### purchase_receipt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| internal_id | Unknown | FK |
| warehouse_id | String | FK |
| control_qty | Unknown |  |
| control_total | Unknown |  |
| create_bill | Unknown |  |
| currency | String |  |
| date | Unknown |  |
| exchange_rate | Unknown |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| post_period | String |  |
| receipt_type | String |  |
| status | String |  |
| supplier_ref | String |  |
| total_amt | Unknown |  |
| total_qty | Unknown |  |
| vat_exempt_total | Unknown |  |
| vat_taxable_total | Unknown |  |

### customer_payment_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_payment_id | String | PK, FK |
| currency_id | String | FK |
| amount_paid | Unknown |  |
| balance | Unknown |  |
| balance_write_off | Unknown |  |
| cash_discount_balance | Unknown |  |
| cash_discount_date | Unknown |  |
| cash_discount_taken | Unknown |  |
| cross_rate | Unknown |  |
| customer_order | String |  |
| date | Unknown |  |
| description | String |  |
| document_type | String |  |
| due_date | Unknown |  |
| post_period | String |  |
| ref_nbr | String |  |
| write_off_reason_code_description | String |  |
| write_off_reason_code_id | String |  |

### customer_payment_order_to_apply

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_payment_id | String | PK, FK |
| currency_id | String | FK |
| applied_to_order | Unknown |  |
| balance | Unknown |  |
| cash_discount_date | Unknown |  |
| date | Unknown |  |
| description | String |  |
| due_date | Unknown |  |
| invoice_date | Unknown |  |
| invoice_nbr | String |  |
| order_no | String |  |
| order_total | Unknown |  |
| order_type | String |  |
| status | String |  |
| transferred_to_invoice | Unknown |  |

### customer_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cash_account | String | FK |
| currency_id | String | FK |
| customer_id | String | FK |
| payment_method_id | String | FK |
| application_date | Unknown |  |
| application_period | String |  |
| applied_to_document | Unknown |  |
| applied_to_order | Unknown |  |
| available_balance | Unknown |  |
| available_balance_in_currency | Unknown |  |
| branch | String |  |
| deducted_charges | Unknown |  |
| finance_charges | Unknown |  |
| hold | Unknown |  |
| invoice_text | String |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| payment_amount | Unknown |  |
| payment_amount_in_currency | Unknown |  |
| payment_date | Unknown |  |
| payment_ref | String |  |
| status | String |  |
| type | String |  |
| write_off_amount | Unknown |  |

### general_ledger_balance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_number | String | FK |
| branch_number | String | FK |
| currency_id | String | FK |
| financial_period | String | FK |
| ledger_id | String | FK |
| sub_account_id | String | FK |
| account_external_code_1 | String |  |
| account_external_code_1_info_description | String |  |
| account_external_code_1_info_number | String |  |
| account_external_code_2 | String |  |
| account_external_code_2_info_description | String |  |
| account_external_code_2_info_number | String |  |
| account_gl_consol_account_cd | String |  |
| account_type | String |  |
| balance_type | String |  |
| beginning_balance | Unknown |  |
| beginning_balance_in_currency | Unknown |  |
| last_modified_date_time | Unknown |  |
| period_to_date_credit | Unknown |  |
| period_to_date_credit_in_currency | Unknown |  |
| period_to_date_debit | Unknown |  |
| period_to_date_debit_in_currency | Unknown |  |
| sub_account_cd | String |  |
| year_closed | Unknown |  |
| year_to_date_balance | Unknown |  |
| year_to_date_balance_in_currency | Unknown |  |

### supplier_payment_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_payment_id | String | PK, FK |
| amount_paid | Unknown |  |
| application_period | String |  |
| balance | Unknown |  |
| batch_number | String |  |
| branch | String |  |
| cash_discount_balance | Unknown |  |
| cash_discount_date | Unknown |  |
| cash_discount_taken | Unknown |  |
| currency | String |  |
| date | Unknown |  |
| description | String |  |
| doc_type | String |  |
| due_date | Unknown |  |
| invoice_ref_nbr | String |  |
| post_period | String |  |
| supplier_ref | String |  |
| withholding_tax | Unknown |  |

### supplier_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cash_account | String | FK |
| currency_id | String | FK |
| internal_id | Unknown | FK |
| payment_method | String | FK |
| application_date | Unknown |  |
| application_period | String |  |
| applied_amount | Unknown |  |
| branch | String |  |
| description | String |  |
| document_type | String |  |
| finance_charges | Unknown |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| payment_amount | Unknown |  |
| payment_ref | String |  |
| released | Unknown |  |
| status | String |  |
| type | String |  |
| unapplied_balance | Unknown |  |

### payment_method_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_method_id | String | PK, FK |
| banking_detail_type | String |  |
| description | String |  |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| active | Unknown |  |
| description | String |  |
| means_of_payment | String |  |
| use_in_ap | Unknown |  |

### shipment_detail_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_detail_line_index | Unknown | PK, FK |
| shipment_id | String | PK, FK |
| description | String |  |
| expiration_date | Unknown |  |
| item_id | String |  |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |
| uom | String |  |

### shipment_detail_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | String | PK, FK |
| warehouse_id | String | FK |
| alternate_id | String |  |
| description | String |  |
| expiration_date | Unknown |  |
| external_link | String |  |
| free_item | Unknown |  |
| inventory_number | String |  |
| line_number | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_nbr | String |  |
| note | String |  |
| open_qty | Unknown |  |
| order_line_nbr | Unknown |  |
| order_nbr | String |  |
| order_type | String |  |
| ordered_qty | Unknown |  |
| reason_code | String |  |
| shipped_qty | Unknown |  |
| uom | String |  |

### shipment_package_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | String | PK, FK |
| box_id | String |  |
| cash_amount | Unknown |  |
| confirmed | Unknown |  |
| custom_ref_nbr_1 | String |  |
| custom_ref_nbr_2 | String |  |
| declared_value | Unknown |  |
| description | String |  |
| line_number | Unknown |  |
| tracking_number | String |  |
| type | String |  |
| uom | String |  |
| volume | Unknown |  |
| volume_uom | String |  |
| weight | Unknown |  |

### shipment_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | String | PK, FK |
| inventory_doc_type | String |  |
| inventory_ref_nbr | String |  |
| invoice_nbr | String |  |
| invoice_type | String |  |
| note | String |  |
| order_nbr | String |  |
| order_type | String |  |
| shipped_qty | Unknown |  |
| shipped_volume | Unknown |  |
| shipped_weight | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| currency_id | String | FK |
| customer_id | String | FK |
| from_warehouse_id | String | FK |
| to_warehouse_id | String | FK |
| container | Unknown |  |
| control_quantity | Unknown |  |
| date | Unknown |  |
| delivery_address_city | String |  |
| delivery_address_country | Unknown |  |
| delivery_address_country_id | String |  |
| delivery_address_country_name | String |  |
| delivery_address_county_id | String |  |
| delivery_address_county_name | String |  |
| delivery_address_id | Unknown |  |
| delivery_address_line_1 | String |  |
| delivery_address_line_2 | String |  |
| delivery_address_line_3 | String |  |
| delivery_address_override_address | Unknown |  |
| delivery_address_postal_code | String |  |
| delivery_contact_attention | String |  |
| delivery_contact_email | String |  |
| delivery_contact_fax | String |  |
| delivery_contact_id | Unknown |  |
| delivery_contact_name | String |  |
| delivery_contact_override_contact | Unknown |  |
| delivery_contact_phone_1 | String |  |
| delivery_contact_phone_2 | String |  |
| delivery_contact_web | String |  |
| fob_point_description | String |  |
| fob_point_id | String |  |
| freight_amt | Unknown |  |
| freight_cost | Unknown |  |
| hold | Unknown |  |
| insurance | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| mode_of_transport_description | String |  |
| mode_of_transport_id | Unknown |  |
| note | String |  |
| operation | String |  |
| owner_id | String |  |
| owner_name | String |  |
| packages | Unknown |  |
| packages_volume | Unknown |  |
| packages_weight | Unknown |  |
| residential_delivery | Unknown |  |
| saturday_delivery | Unknown |  |
| ship_via_description | String |  |
| ship_via_id | String |  |
| shipped_quantity | Unknown |  |
| shipped_volume | Unknown |  |
| shipped_weight | Unknown |  |
| shipping_terms_description | String |  |
| shipping_terms_id | String |  |
| shipping_zone_description | String |  |
| shipping_zone_id | String |  |
| status | String |  |
| transaction_type_description | String |  |
| transaction_type_id | Unknown |  |
| type | String |  |
| use_customer_account | Unknown |  |

### cash_account_entry_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| number | String | PK, FK |
| business_account_description | String |  |
| business_account_external_code_1 | String |  |
| business_account_external_code_2 | String |  |
| business_account_number | String |  |
| business_account_type | String |  |
| default_offset_account_branch_name | String |  |
| default_offset_account_branch_number | String |  |
| default_offset_account_description | String |  |
| default_offset_account_external_code_1 | String |  |
| default_offset_account_external_code_2 | String |  |
| default_offset_account_number | String |  |
| default_offset_account_type | String |  |
| default_offset_sub_account_description | String |  |
| default_offset_sub_account_id | String |  |
| description | String |  |
| disable_receipt | String |  |
| last_modified_date_time | Unknown |  |
| module | String |  |
| offset_account_branch_name | String |  |
| offset_account_branch_number | String |  |
| offset_account_override_description | String |  |
| offset_account_override_external_code_1 | String |  |
| offset_account_override_external_code_2 | String |  |
| offset_account_override_number | String |  |
| offset_account_override_type | String |  |
| offset_sub_account_override_description | String |  |
| offset_sub_account_override_id | String |  |
| reclasification_account_description | String |  |
| reclasification_account_external_code_1 | String |  |
| reclasification_account_external_code_2 | String |  |
| reclasification_account_number | String |  |
| reclasification_account_override_description | String |  |
| reclasification_account_override_external_code_1 | String |  |
| reclasification_account_override_external_code_2 | String |  |
| reclasification_account_override_number | String |  |
| reclasification_account_override_type | String |  |
| reclasification_account_type | String |  |
| tax_calculation_mode | String |  |
| use_for_payments_reclasification | Unknown |  |
| vat_zone_default_tax_category_description | String |  |
| vat_zone_default_tax_category_number | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### cash_account

| Column | Type | Keys |
| --- | --- | --- |
| number | String | PK |
| currency_id | String | FK |
| description | String |  |
| last_modified_date_time | Unknown |  |

### customer_credit_note_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_credit_note_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_credit_note_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_credit_note_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_credit_note_tax_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_credit_note_id | String | PK, FK |
| record_id | Unknown |  |
| taxable_amount | Unknown |  |
| vat_amount | Unknown |  |
| vat_description | String |  |
| vat_number | String |  |
| vat_rate | Unknown |  |

### customer_credit_note_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_credit_note_id | String | PK, FK |
| customer_credit_note_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_credit_note_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_credit_note_id | String | PK, FK |
| customer_credit_note_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### customer_credit_note_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_credit_note_id | String | PK, FK |
| account_number | String | FK |
| branch_number | String | FK |
| sub_account_id | Unknown | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| cost | Unknown |  |
| deductable_amount | Unknown |  |
| deferral_code | String |  |
| deferral_schedule | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_amount_in_currency | Unknown |  |
| discount_code | String |  |
| discount_percent | Unknown |  |
| external_link | String |  |
| inventory_number | String |  |
| is_rot_rut_deductible | Unknown |  |
| item_type | String |  |
| line_number | Unknown |  |
| manual_amount | Unknown |  |
| manual_amount_in_currency | Unknown |  |
| manual_discount | Unknown |  |
| note | String |  |
| project_task_description | String |  |
| project_task_id | String |  |
| quantity | Unknown |  |
| s_0_order_nbr | String |  |
| seller_description | String |  |
| seller_id | String |  |
| so_order_type | String |  |
| so_shipment_nbr | String |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| type_of_workdescription | String |  |
| type_of_workrut_rot_type | Unknown |  |
| type_of_workxml_tag | String |  |
| unit_price | Unknown |  |
| unit_price_in_currency | Unknown |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### customer_credit_note_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_credit_note_id | String | PK, FK |
| amount_paid | Unknown |  |
| application_date | Unknown |  |
| application_period | String |  |
| balance | Unknown |  |
| cash_discount_taken | Unknown |  |
| customer_cd | String |  |
| doc_type | String |  |
| hold | Unknown |  |
| invoice_text | String |  |
| payment_ref | String |  |
| pending_ppd | Unknown |  |
| ppd_cr_memo_ref_nbr | String |  |
| ref_nbr | String |  |
| released | Unknown |  |
| status | String |  |
| unit_price_in_currency | Unknown |  |
| voided | Unknown |  |

### customer_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_number | String | FK |
| branch_number | String | FK |
| cash_account | String | FK |
| closed_financial_period | String | FK |
| currency_id | String | FK |
| customer_id | String | FK |
| financial_period | String | FK |
| payment_method_id | String | FK |
| sub_account_id | Unknown | FK |
| account_external_code_1 | String |  |
| account_external_code_2 | String |  |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| balance | Unknown |  |
| balance_in_currency | Unknown |  |
| cash_discount | Unknown |  |
| cash_discount_in_currency | Unknown |  |
| cash_discount_rate | Unknown |  |
| child_record_name | String |  |
| child_record_number | String |  |
| contact_id | Unknown |  |
| contact_name | String |  |
| created_date_time | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| customer_project | String |  |
| customer_reference | String |  |
| customer_vat_zone_description | String |  |
| customer_vat_zone_id | String |  |
| detail_total | Unknown |  |
| detail_total_in_currency | Unknown |  |
| document_date | Unknown |  |
| document_due_date | Unknown |  |
| document_type | String |  |
| dont_email | Unknown |  |
| dont_print | Unknown |  |
| dunning_letter_date | Unknown |  |
| dunning_letter_level | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | String |  |
| hold | Unknown |  |
| invoice_address_city | String |  |
| invoice_address_country_id | String |  |
| invoice_address_country_name | String |  |
| invoice_address_county_id | String |  |
| invoice_address_county_name | String |  |
| invoice_address_id | Unknown |  |
| invoice_address_line_1 | String |  |
| invoice_address_line_2 | String |  |
| invoice_address_line_3 | String |  |
| invoice_address_override_address | Unknown |  |
| invoice_address_postal_code | String |  |
| invoice_contact_attention | String |  |
| invoice_contact_business_name | Unknown |  |
| invoice_contact_email | String |  |
| invoice_contact_id | Unknown |  |
| invoice_contact_override_contact | Unknown |  |
| invoice_contact_phone_1 | String |  |
| invoice_contact_web | String |  |
| invoice_text | String |  |
| is_rot_rut_deductible | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| note | String |  |
| orig_invoice_date | Unknown |  |
| payment_reference | String |  |
| post_period | String |  |
| project_description | String |  |
| project_id | String |  |
| revoked | Unknown |  |
| rounding_diff | Unknown |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| send_to_auto_invoice | Unknown |  |
| status | String |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_currency | Unknown |  |
| vat_taotal | Unknown |  |
| vat_taxable_total | Unknown |  |
| vat_taxable_total_in_currency | Unknown |  |
| vat_total_in_currency | Unknown |  |

### sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sub_account_id | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### sub_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| description | String |  |
| last_modified_date_time | Unknown |  |
| number | String |  |

### inventory_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_supplier_detail

| Column | Type | Keys |
| --- | --- | --- |
| inventory_id | String | PK, FK |
| supplier_id | String | PK, FK |
| currency_id | String | FK |
| active | Unknown |  |
| eoq | Unknown |  |
| is_default | Unknown |  |
| item_id | String |  |
| last_supplier_price | Unknown |  |
| lead_time | Unknown |  |
| location | String |  |
| lot_size | Unknown |  |
| max_order_qty | Unknown |  |
| min_order_freq | Unknown |  |
| min_order_qty | Unknown |  |
| override | Unknown |  |
| purchase_unit | String |  |
| shipment_lead_time | Unknown |  |
| warehouse | String |  |

### inventory_sale_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| inventory_id | String | PK, FK |
| description | String |  |

### inventory_unit_attribute_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_id | String | PK, FK |
| inventory_unit_attribute_id | String | PK, FK |
| inventory_unit_index | Unknown | PK, FK |
| description | String |  |

### inventory_unit_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_id | String | PK, FK |
| inventory_unit_index | Unknown | PK, FK |
| default_value | String |  |
| description | String |  |
| required | Unknown |  |
| sort_order | Unknown |  |
| type | String |  |

### inventory_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_id | String | PK, FK |
| from_unit | String |  |
| item_class_description | String |  |
| item_class_id | String |  |
| item_class_type | String |  |
| price_adjustment_multiplier | Unknown |  |
| record_id | Unknown |  |
| sample_to_unit | String |  |
| to_unit | String |  |
| type | Unknown |  |
| unit_mult_div | String |  |
| unit_rate | Unknown |  |

### inventory_warehouse_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_id | String | PK, FK |
| warehouse | String | FK |
| available | Unknown |  |
| available_for_shipment | Unknown |  |
| is_default | Unknown |  |
| last_modified_date_time | Unknown |  |
| quantity_on_hand | Unknown |  |

### inventory_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_id | String | PK, FK |
| description | String |  |
| value | String |  |

### inventory_item_class_attribute_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_id | String | PK, FK |
| inventory_item_class_attribute_id | String | PK, FK |
| description | String |  |

### inventory_item_class_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| inventory_id | String | PK, FK |
| default_value | String |  |
| description | String |  |
| required | Unknown |  |
| sort_order | Unknown |  |
| type | String |  |

### inventory_cross_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_id | String | PK, FK |
| alternate_id | String |  |
| alternate_type | String |  |
| b_account_internal_id | Unknown |  |
| b_account_name | String |  |
| b_account_number | String |  |
| description | String |  |
| timestamps | String |  |
| uom | String |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_information_cogs_sub_account_id | String | FK |
| account_information_expense_sub_account_id | String | FK |
| account_information_sales_sub_account_id | String | FK |
| default_warehouse_id | String | FK |
| account_information_cogs_account_description | String |  |
| account_information_cogs_account_number | String |  |
| account_information_cogs_account_type | String |  |
| account_information_expense_account_description | String |  |
| account_information_expense_account_number | String |  |
| account_information_expense_account_type | String |  |
| account_information_expense_accrual_account_description | String |  |
| account_information_expense_accrual_account_number | String |  |
| account_information_expense_accrual_account_type | String |  |
| account_information_expense_eu_account_description | String |  |
| account_information_expense_eu_account_number | String |  |
| account_information_expense_eu_account_type | String |  |
| account_information_expense_import_account_description | String |  |
| account_information_expense_import_account_number | String |  |
| account_information_expense_import_account_type | String |  |
| account_information_expense_non_taxable_account_description | String |  |
| account_information_expense_non_taxable_account_number | String |  |
| account_information_expense_non_taxable_account_type | String |  |
| account_information_inventory_account_description | String |  |
| account_information_inventory_account_number | String |  |
| account_information_inventory_account_type | String |  |
| account_information_sales_account_description | String |  |
| account_information_sales_account_number | String |  |
| account_information_sales_account_type | String |  |
| account_information_sales_eu_account_description | String |  |
| account_information_sales_eu_account_number | String |  |
| account_information_sales_eu_account_type | String |  |
| account_information_sales_export_account_description | String |  |
| account_information_sales_export_account_number | String |  |
| account_information_sales_export_account_type | String |  |
| account_information_sales_non_taxable_account_description | String |  |
| account_information_sales_non_taxable_account_number | String |  |
| account_information_sales_non_taxable_account_type | String |  |
| base_unit | String |  |
| body | String |  |
| cost_price_statistics_average_cost | Unknown |  |
| cost_price_statistics_last_cost | Unknown |  |
| cost_price_statistics_max_cost | Unknown |  |
| cost_price_statistics_min_cost | Unknown |  |
| current_cost | Unknown |  |
| default_issue_from_description | String |  |
| default_issue_from_id | String |  |
| default_price | Unknown |  |
| default_receipt_to_description | String |  |
| default_receipt_to_id | String |  |
| description | String |  |
| effective_date | Unknown |  |
| intrastat_cn_8 | String |  |
| intrastat_country_of_origin | String |  |
| intrastat_supplementary_measure_unit | String |  |
| item_class_description | String |  |
| item_class_id | String |  |
| item_class_type | String |  |
| kit_item | Unknown |  |
| last_cost | Unknown |  |
| last_modified_date_time | Unknown |  |
| lot_serial_class_description | String |  |
| lot_serial_class_id | String |  |
| note | String |  |
| packaging_base_item_volume | Unknown |  |
| packaging_base_item_weight | Unknown |  |
| packaging_volume_uom | String |  |
| packaging_weight_uom | String |  |
| pending_cost | Unknown |  |
| pending_cost_date | Unknown |  |
| posting_class_description | String |  |
| posting_class_id | String |  |
| price_class_description | String |  |
| price_class_id | String |  |
| price_manager_id | String |  |
| price_manager_name | String |  |
| price_workgroup_id | Unknown |  |
| purchase_unit | String |  |
| recommended_price | Unknown |  |
| sales_unit | String |  |
| status | String |  |
| stock_item | Unknown |  |
| timestamps | String |  |
| type | String |  |
| uid | Unknown |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### cash_sale_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cash_sale_id | String | PK, FK |
| amount_paid | Unknown |  |
| application_date | Unknown |  |
| application_period | String |  |
| balance | Unknown |  |
| cash_discount_taken | Unknown |  |
| customer_cd | String |  |
| doc_type | String |  |
| hold | Unknown |  |
| invoice_text | String |  |
| payment_ref | String |  |
| pending_ppd | Unknown |  |
| ppd_cr_memo_ref_nbr | String |  |
| ref_nbr | String |  |
| released | Unknown |  |
| status | String |  |
| voided | Unknown |  |

### cash_sale_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cash_sale_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### cash_sale_line_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cash_sale_id | String | PK, FK |
| cash_sale_line_index | Unknown | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### cash_sale_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cash_sale_id | String | PK, FK |
| account_number | String | FK |
| branch_number | String | FK |
| inventory_number | String | FK |
| sub_account_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| cost | Unknown |  |
| deferral_code | String |  |
| deferral_schedule | Unknown |  |
| description | String |  |
| discount_amount | Unknown |  |
| discount_amount_in_currency | Unknown |  |
| discount_code | String |  |
| discount_percent | Unknown |  |
| external_link | String |  |
| line_number | Unknown |  |
| manual_amount | Unknown |  |
| manual_amount_in_currency | Unknown |  |
| manual_discount | Unknown |  |
| note | String |  |
| quantity | Unknown |  |
| salesperson | String |  |
| seller_description | String |  |
| seller_id | String |  |
| unit_price | Unknown |  |
| unit_price_in_currency | Unknown |  |
| uom | String |  |
| vat_code_description | String |  |
| vat_code_id | String |  |

### cash_sale

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_number | String | FK |
| branch_number | String | FK |
| cash_account | String | FK |
| closed_financial_period | String | FK |
| currency_id | String | FK |
| customer_id | String | FK |
| financial_period | String | FK |
| payment_method_id | String | FK |
| sub_account_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_currency | Unknown |  |
| balance | Unknown |  |
| balance_in_currency | Unknown |  |
| cash_discount | Unknown |  |
| cash_discount_in_currency | Unknown |  |
| created_date_time | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| customer_project | String |  |
| customer_ref_number | String |  |
| detail_total | Unknown |  |
| detail_total_in_currency | Unknown |  |
| document_date | Unknown |  |
| document_type | String |  |
| dont_email | Unknown |  |
| dont_print | Unknown |  |
| hold | Unknown |  |
| invoice_address_city | String |  |
| invoice_address_country_id | String |  |
| invoice_address_country_name | String |  |
| invoice_address_county_id | String |  |
| invoice_address_county_name | String |  |
| invoice_address_id | Unknown |  |
| invoice_address_line_1 | String |  |
| invoice_address_line_2 | String |  |
| invoice_address_line_3 | String |  |
| invoice_address_override_address | Unknown |  |
| invoice_address_postal_code | String |  |
| invoice_contact_attention | String |  |
| invoice_contact_business_name | String |  |
| invoice_contact_email | String |  |
| invoice_contact_id | Unknown |  |
| invoice_contact_override_contact | Unknown |  |
| invoice_contact_phone_1 | String |  |
| invoice_text | String |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| note | String |  |
| orig_invoice_date | Unknown |  |
| payment_reference | String |  |
| post_period | String |  |
| project_description | String |  |
| project_id | String |  |
| revoked | Unknown |  |
| sales_person_description | String |  |
| sales_person_id | String |  |
| status | String |  |
| vat_exempt_total | Unknown |  |
| vat_exempt_total_in_currency | Unknown |  |
| vat_taxable_total | Unknown |  |
| vat_taxable_total_in_currency | Unknown |  |
| vat_total | Unknown |  |
| vat_total_in_currency | Unknown |  |

### customer_payment_method_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | PK, FK |
| payment_method_id | String | PK, FK |
| description | String |  |
| value | String |  |

### customer_payment_method

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | String | PK, FK |
| payment_method_id | String | PK, FK |
| cash_account_id | String | FK |
| active | Unknown |  |
| card_or_account_no | String |  |

### inventory_transfer_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_transfer_id | String | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_transfer_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_transfer_id | String | PK, FK |
| transfer_line_index | Unknown | PK, FK |
| line_nbr | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| quantity | Unknown |  |

### inventory_transfer_line_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| inventory_transfer_id | String | PK, FK |
| transfer_line_index | Unknown | PK, FK |
| name | String |  |
| revision | Unknown |  |

### inventory_transfer_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| inventory_transfer_id | String | PK, FK |
| branch_number | String | FK |
| description | String |  |
| expiration_date | Unknown |  |
| inventory_item_description | String |  |
| inventory_item_number | String |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| lot_serial_number | String |  |
| number | Unknown |  |
| quantity | Unknown |  |
| reason_code_description | String |  |
| reason_code_id | String |  |
| to_location_country_id | String |  |
| to_location_id | String |  |
| to_location_name | String |  |
| uom | String |  |

### inventory_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| branch_number | String | FK |
| to_warehouse_id | String | FK |
| warehouse_id | String | FK |
| batch_number | String |  |
| control_quantity | Unknown |  |
| date | Unknown |  |
| description | String |  |
| external_reference | String |  |
| hold | Unknown |  |
| last_modified_date_time | Unknown |  |
| post_period | String |  |
| status | String |  |
| total_quantity | Unknown |  |

### carrier

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| last_modified_date_time | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| internal_id | String | PK |
| active | Unknown |  |
| address_city | String |  |
| address_id | Unknown |  |
| address_line_1 | String |  |
| address_line_2 | String |  |
| address_line_3 | String |  |
| address_postal_code | String |  |
| baccount_name | String |  |
| baccount_number | String |  |
| contact_attention | String |  |
| contact_email | String |  |
| contact_fax | String |  |
| contact_id | Unknown |  |
| contact_name | String |  |
| contact_phone_1 | String |  |
| contact_phone_2 | String |  |
| contact_web | String |  |
| corporate_id | String |  |
| country_id | String |  |
| country_name | String |  |
| county_id | String |  |
| county_name | String |  |
| default_tax_category_description | String |  |
| default_tax_category_number | String |  |
| edi_code | String |  |
| gln | String |  |
| last_modified_date_time | Unknown |  |
| name | String |  |
| peppol_scheme_endpoint | String |  |
| peppol_scheme_party_identification | String |  |
| peppol_scheme_party_legal | String |  |
| vat_registration_id | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| account_number | String | PK |
| id | Unknown | PK |
| currency_id | String | FK |
| active | Unknown |  |
| allow_manual_entry | Unknown |  |
| analisys_code_info_description | String |  |
| analisys_code_info_number | String |  |
| cash_account | Unknown |  |
| class | String |  |
| control_account_module | String |  |
| description | String |  |
| external_code_1_info_description | String |  |
| external_code_1_info_number | String |  |
| external_code_2_info_description | String |  |
| external_code_2_info_number | String |  |
| group_cd | String |  |
| last_modified_date_time | Unknown |  |
| post_option | String |  |
| public_code_1 | String |  |
| tax_category | String |  |
| type | String |  |
| use_default_sub | Unknown |  |

### customer_attribute

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | String | PK, FK |
| id | String | PK, FK |
| description | String |  |
| value | String |  |

### customer_direct_debit_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| bic | String |  |
| branch | String |  |
| date_of_signature | Unknown |  |
| expiration_date | Unknown |  |
| iban | String |  |
| is_default | Unknown |  |
| last_collection_date | Unknown |  |
| mandate_description | String |  |
| mandate_id | String |  |
| max_amount | Unknown |  |
| one_time | Unknown |  |

### customer_ledger_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_sales_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_discount_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_freight_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_pre_payment_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### customer_cash_discount_sub_account_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | String | PK, FK |
| description | String |  |
| value | String |  |
| value_description | String |  |

### payment_method_customer

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | String | PK, FK |
| id | String | PK, FK |
| is_default | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| currency_id | String | FK |
| default_payment_method_id | String | FK |
| accept_auto_invoices | Unknown |  |
| account_reference | String |  |
| consolidate_invoices | Unknown |  |
| corporate_id | String |  |
| created_date_time | Unknown |  |
| credit_days_past_due | Unknown |  |
| credit_limit | Unknown |  |
| credit_terms_description | String |  |
| credit_terms_id | String |  |
| credit_verification | String |  |
| customer_class_description | String |  |
| customer_class_id | String |  |
| default_tax_category_description | String |  |
| default_tax_category_number | String |  |
| delivery_address_city | String |  |
| delivery_address_country_id | String |  |
| delivery_address_country_name | String |  |
| delivery_address_county_id | String |  |
| delivery_address_county_name | String |  |
| delivery_address_id | Unknown |  |
| delivery_address_line_1 | String |  |
| delivery_address_line_2 | String |  |
| delivery_address_line_3 | String |  |
| delivery_address_postal_code | String |  |
| delivery_contact_attention | String |  |
| delivery_contact_email | String |  |
| delivery_contact_fax | String |  |
| delivery_contact_id | Unknown |  |
| delivery_contact_name | String |  |
| delivery_contact_phone_1 | String |  |
| delivery_contact_phone_2 | String |  |
| delivery_contact_web | String |  |
| e_invoice_contract_f_invoice_contract_id | String |  |
| e_invoice_contract_f_invoice_intermediator_id | String |  |
| gl_accounts_cash_discount_account_description | String |  |
| gl_accounts_cash_discount_account_number | String |  |
| gl_accounts_cash_discount_account_type | String |  |
| gl_accounts_cash_discount_sub_account_active | Unknown |  |
| gl_accounts_cash_discount_sub_account_description | String |  |
| gl_accounts_cash_discount_sub_account_id | Unknown |  |
| gl_accounts_cash_discount_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_cash_discount_sub_account_number | String |  |
| gl_accounts_customer_ledger_account_description | String |  |
| gl_accounts_customer_ledger_account_number | String |  |
| gl_accounts_customer_ledger_account_type | String |  |
| gl_accounts_customer_ledger_sub_account_active | Unknown |  |
| gl_accounts_customer_ledger_sub_account_description | String |  |
| gl_accounts_customer_ledger_sub_account_id | Unknown |  |
| gl_accounts_customer_ledger_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_customer_ledger_sub_account_number | String |  |
| gl_accounts_discount_account_description | String |  |
| gl_accounts_discount_account_number | String |  |
| gl_accounts_discount_account_type | String |  |
| gl_accounts_discount_sub_account_active | Unknown |  |
| gl_accounts_discount_sub_account_description | String |  |
| gl_accounts_discount_sub_account_id | Unknown |  |
| gl_accounts_discount_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_discount_sub_account_number | String |  |
| gl_accounts_freight_account_description | String |  |
| gl_accounts_freight_account_number | String |  |
| gl_accounts_freight_account_type | String |  |
| gl_accounts_freight_sub_account_active | Unknown |  |
| gl_accounts_freight_sub_account_description | String |  |
| gl_accounts_freight_sub_account_id | Unknown |  |
| gl_accounts_freight_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_freight_sub_account_number | String |  |
| gl_accounts_prepayment_account_description | String |  |
| gl_accounts_prepayment_account_number | String |  |
| gl_accounts_prepayment_account_type | String |  |
| gl_accounts_prepayment_sub_account_active | Unknown |  |
| gl_accounts_prepayment_sub_account_description | String |  |
| gl_accounts_prepayment_sub_account_id | Unknown |  |
| gl_accounts_prepayment_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_prepayment_sub_account_number | String |  |
| gl_accounts_sales_account_description | String |  |
| gl_accounts_sales_account_number | String |  |
| gl_accounts_sales_account_type | String |  |
| gl_accounts_sales_eu_account_description | String |  |
| gl_accounts_sales_eu_account_number | String |  |
| gl_accounts_sales_eu_account_type | String |  |
| gl_accounts_sales_export_account_description | String |  |
| gl_accounts_sales_export_account_number | String |  |
| gl_accounts_sales_export_account_type | String |  |
| gl_accounts_sales_non_taxable_account_description | String |  |
| gl_accounts_sales_non_taxable_account_number | String |  |
| gl_accounts_sales_non_taxable_account_type | String |  |
| gl_accounts_sales_sub_account_active | Unknown |  |
| gl_accounts_sales_sub_account_description | String |  |
| gl_accounts_sales_sub_account_id | Unknown |  |
| gl_accounts_sales_sub_account_last_modified_date_time | Unknown |  |
| gl_accounts_sales_sub_account_number | String |  |
| gln | String |  |
| internal_id | Unknown |  |
| invoice_address_city | String |  |
| invoice_address_country_id | String |  |
| invoice_address_country_name | String |  |
| invoice_address_county_id | String |  |
| invoice_address_county_name | String |  |
| invoice_address_id | Unknown |  |
| invoice_address_line_1 | String |  |
| invoice_address_line_2 | String |  |
| invoice_address_line_3 | String |  |
| invoice_address_postal_code | String |  |
| invoice_contact_attention | String |  |
| invoice_contact_email | String |  |
| invoice_contact_fax | String |  |
| invoice_contact_id | Unknown |  |
| invoice_contact_name | String |  |
| invoice_contact_phone_1 | String |  |
| invoice_contact_phone_2 | String |  |
| invoice_contact_web | String |  |
| invoice_to_default_location | Unknown |  |
| last_modified_date_time | Unknown |  |
| location_country_id | String |  |
| location_id | String |  |
| location_name | String |  |
| main_address_city | String |  |
| main_address_country_id | String |  |
| main_address_country_name | String |  |
| main_address_county_id | String |  |
| main_address_county_name | String |  |
| main_address_id | Unknown |  |
| main_address_line_1 | String |  |
| main_address_line_2 | String |  |
| main_address_line_3 | String |  |
| main_address_postal_code | String |  |
| main_contact_attention | String |  |
| main_contact_email | String |  |
| main_contact_fax | String |  |
| main_contact_id | Unknown |  |
| main_contact_name | String |  |
| main_contact_phone_1 | String |  |
| main_contact_phone_2 | String |  |
| main_contact_web | String |  |
| name | String |  |
| parent_record_name | String |  |
| parent_record_number | String |  |
| price_class_description | String |  |
| price_class_id | String |  |
| print_invoices | Unknown |  |
| print_multi_currency_statements | Unknown |  |
| print_statements | Unknown |  |
| send_invoices_by_email | Unknown |  |
| send_statements_by_email | Unknown |  |
| statement_type | String |  |
| status | String |  |
| vat_registration_id | String |  |
| vat_zone_default_vat_category | String |  |
| vat_zone_description | String |  |
| vat_zone_id | String |  |

## Relationships

- inventory_issue_line_allocation(inventory_issue_line_index) → inventory_issue_line(index)
- inventory_issue_line_allocation(inventory_issue_id) → inventory_issue_line(inventory_issue_id)
- inventory_issue_line_attachment(inventory_issue_line_index) → inventory_issue_line(index)
- inventory_issue_line_attachment(inventory_issue_id) → inventory_issue_line(inventory_issue_id)
- inventory_issue_line(warehouse_id) → warehouse(id)
- inventory_issue_line(branch_number) → branch(number)
- inventory_issue_line(inventory_issue_id) → inventory_issue(id)
- inventory_issue_attachment(inventory_issue_id) → inventory_issue(id)
- inventory_issue(branch_number) → branch(number)
- branch(currency_id) → currency(id)
- branch(organization_id) → organization(id)
- supplier_location_payment_method_detail(supplier_location_location_id) → supplier_location(location_id)
- supplier_location_payment_method_detail(supplier_location_baccount_internal_id) → supplier_location(baccount_internal_id)
- supplier_location(baccount_internal_id) → supplier(id)
- inventory_adjustment_line_attachment(inventory_adjustment_id) → inventory_adjustment_line(inventory_adjustment_id)
- inventory_adjustment_line_attachment(inventory_adjustment_line_index) → inventory_adjustment_line(index)
- inventory_adjustment_line(warehouse_id) → warehouse(id)
- inventory_adjustment_line(branch_number) → branch(number)
- inventory_adjustment_line(location_id) → location(id)
- inventory_adjustment_line(inventory_adjustment_id) → inventory_adjustment(id)
- inventory_adjustment_attachment(inventory_adjustment_id) → inventory_adjustment(id)
- inventory_adjustment(branch_number) → branch(number)
- inventory_summary(warehouse_id) → warehouse(id)
- inventory_summary(location_id) → location(id)
- inventory_summary(inventory_id) → inventory(id)
- supplier_attribute(id) → attribute(id)
- supplier_attribute(supplier_id) → supplier(id)
- supplier_payment_method_detail(id) → payment_method(id)
- supplier_payment_method_detail(supplier_id) → supplier(id)
- supplier(payment_method_id) → payment_method(id)
- supplier(currency_id) → currency(id)
- supplier(cash_account) → cash_account(number)
- supplier(gl_accounts_expense_sub_account_id) → sub_account(id)
- supplier(gl_accounts_supplier_sub_account_id) → sub_account(id)
- kit_specification_stock_component_line(kit_specification_id) → kit_specification(id)
- kit_specification_non_stock_component_line(kit_specification_id) → kit_specification(id)
- warehouse_location_attribute_detail(warehouse_location_attribute_id) → warehouse_location_attribute(id)
- warehouse_location_attribute_detail(warehouse_location_attribute_warehouse_id) → warehouse_location_attribute(warehouse_id)
- warehouse_location_attribute_detail(warehouse_location_attribute_warehouse_location_id) → warehouse_location_attribute(warehouse_location_id)
- warehouse_location_attribute(id) → attribute(id)
- warehouse_location_attribute(warehouse_location_id) → warehouse_location(location_id)
- warehouse_location_attribute(warehouse_id) → warehouse_location(warehouse_id)
- warehouse_location(warehouse_id) → warehouse(id)
- warehouse(branch_number) → branch(number)
- purchase_order_discount_detail(purchase_order_id) → purchase_order(id)
- purchase_order_tax_detail(purchase_order_id) → purchase_order(id)
- purchase_order_line_sub_segment(purchase_order_line_index) → purchase_order_line(index)
- purchase_order_line_sub_segment(purchase_order_id) → purchase_order_line(purchase_order_id)
- purchase_order_line(sub_account_id) → sub_account(id)
- purchase_order_line(warehouse_id) → warehouse(id)
- purchase_order_line(inventory_number) → inventory(id)
- purchase_order_line(branch_number) → branch(number)
- purchase_order_line(account_number) → account(account_number)
- purchase_order_line(purchase_order_id) → purchase_order(id)
- purchase_order_receipt(purchase_order_id) → purchase_order(id)
- purchase_order(currency_id) → currency(id)
- purchase_order(warehouse_id) → warehouse(id)
- purchase_order(sales_order_type) → sales_order_type(order_type)
- purchase_order(supplier_internal_id) → supplier(id)
- purchase_order(branch_number) → branch(number)
- customer_invoice_sub_account_segment(customer_invoice_id) → customer_invoice(id)
- customer_invoice_attachment(customer_invoice_id) → customer_invoice(id)
- customer_invoice_tax_detail(customer_invoice_id) → customer_invoice(id)
- customer_invoice_line_sub_account_segment(customer_invoice_id) → customer_invoice_line(customer_invoice_id)
- customer_invoice_line_sub_account_segment(customer_invoice_line_index) → customer_invoice_line(index)
- customer_invoice_line_attachment(customer_invoice_id) → customer_invoice_line(customer_invoice_id)
- customer_invoice_line_attachment(customer_invoice_line_index) → customer_invoice_line(index)
- customer_invoice_line(account_number) → account(account_number)
- customer_invoice_line(sub_account_id) → sub_account(id)
- customer_invoice_line(branch_number) → branch(number)
- customer_invoice_line(customer_invoice_id) → customer_invoice(id)
- customer_invoice_application(customer_invoice_id) → customer_invoice(id)
- customer_invoice(payment_method_id) → payment_method(id)
- customer_invoice(financial_period) → financial_period(period)
- customer_invoice(currency_id) → currency(id)
- customer_invoice(account_number) → account(account_number)
- customer_invoice(sub_account_id) → sub_account(id)
- customer_invoice(closed_financial_period) → financial_period(period)
- customer_invoice(cash_account) → cash_account(number)
- customer_invoice(customer_id) → customer(id)
- customer_invoice(branch_number) → branch(number)
- inventory_receipt_attachment(inventory_receipt_id) → inventory_receipt(id)
- inventory_receipt_line_attachment(inventory_receipt_id) → inventory_receipt_line(inventory_receipt_id)
- inventory_receipt_line_attachment(index) → inventory_receipt_line(index)
- inventory_receipt_line_allocation(inventory_receipt_id) → inventory_receipt_line(inventory_receipt_id)
- inventory_receipt_line_allocation(inventory_receipt_line_index) → inventory_receipt_line(index)
- inventory_receipt_line(warehouse_id) → warehouse(id)
- inventory_receipt_line(branch_number) → branch(number)
- inventory_receipt_line(inventory_receipt_id) → inventory_receipt(id)
- inventory_receipt(branch_number) → branch(number)
- general_ledger_transaction(currency_id) → currency(id)
- general_ledger_transaction(account_number) → account(account_number)
- general_ledger_transaction(branch_number) → branch(number)
- general_ledger_transaction(ledger_id) → ledger(id)
- currency_rate(from_currency_id) → currency(id)
- currency_rate(to_currency_id) → currency(id)
- kit_assembly_allocation(kit_assembly_id) → kit_assembly(id)
- kit_assembly_non_stock_component_line(kit_assembly_id) → kit_assembly(id)
- kit_assembly_stock_component_line_allocation(kit_assembly_stock_component_line_id) → kit_assembly_stock_component_line(id)
- kit_assembly_stock_component_line_allocation(kit_assembly_id) → kit_assembly_stock_component_line(kit_assembly_id)
- kit_assembly_stock_component_line(kit_assembly_id) → kit_assembly(id)
- kit_assembly(warehouse) → warehouse(id)
- attribute_detail(attribute_id) → attribute(id)
- journal_transaction_attachment(journal_transaction_id) → journal_transaction(id)
- journal_transaction_attachment(financial_period_id) → journal_transaction(financial_period_id)
- journal_transaction_line_attachment(journal_transaction_line_number) → journal_transaction_line(line_number)
- journal_transaction_line_attachment(journal_transaction_id) → journal_transaction_line(journal_transaction_id)
- journal_transaction_line_attachment(financial_period_id) → journal_transaction_line(financial_period_id)
- journal_transaction_line_sub_account_segment(journal_transaction_line_number) → journal_transaction_line(line_number)
- journal_transaction_line_sub_account_segment(journal_transaction_id) → journal_transaction_line(journal_transaction_id)
- journal_transaction_line_sub_account_segment(financial_period_id) → journal_transaction_line(financial_period_id)
- journal_transaction_line(account_number) → account(account_number)
- journal_transaction_line(sub_account_id) → sub_account(id)
- journal_transaction_line(inventory_number) → inventory(id)
- journal_transaction_line(journal_transaction_id) → journal_transaction(id)
- journal_transaction_line(financial_period_id) → journal_transaction(financial_period_id)
- journal_transaction(ledger_id) → ledger(id)
- journal_transaction(currency_id) → currency(id)
- journal_transaction(financial_period_id) → financial_period(period)
- ledger(currency_id) → currency(id)
- organization_branch(organization_id) → organization(id)
- organization(ledger_id) → ledger(id)
- organization(currency_id) → currency(id)
- sales_order_line_allocation(sales_order_id) → sales_order_line(sales_order_id)
- sales_order_line_allocation(sales_order_line_id) → sales_order_line(id)
- sales_order_line_attachment(sales_order_id) → sales_order_line(sales_order_id)
- sales_order_line_attachment(sales_order_line_id) → sales_order_line(id)
- sales_order_line(warehouse_id) → warehouse(id)
- sales_order_line(supplier_id) → supplier(id)
- sales_order_line(inventory_id) → inventory(id)
- sales_order_line(sales_order_id) → sales_order(id)
- sales_order_commission(sales_order_id) → sales_order(id)
- sales_order_tax(sales_order_id) → sales_order(id)
- sales_order_shipment(id) → shipment(id)
- sales_order_shipment(sales_order_id) → sales_order(id)
- sales_order_discount(sales_order_id) → sales_order(id)
- sales_order_payment(currency_id) → currency(id)
- sales_order_payment(sales_order_id) → sales_order(id)
- sales_order_rot_rut_distribution(sales_order_id) → sales_order(id)
- sales_order_attachment(sales_order_id) → sales_order(id)
- sales_order(currency) → currency(id)
- sales_order(customer_id) → customer(id)
- sales_order(branch_id) → branch(id)
- sales_order(payment_settings_cash_account_id) → cash_account(number)
- sales_order(payment_settings_payment_method_id) → payment_method(id)
- sales_order(shipping_ship_via_id) → carrier(id)
- sales_order(shipping_preferred_warehouse_id) → warehouse(id)
- supplier_invoice_tax_detail_line(supplier_invoice_fivetran_id) → supplier_invoice(_fivetran_id)
- supplier_invoice_line_attachment(supplier_invoice_fivetran_id) → supplier_invoice_line(supplier_invoice_fivetran_id)
- supplier_invoice_line_attachment(supplier_invoice_line_index) → supplier_invoice_line(index)
- supplier_invoice_line_sub_account_segment(supplier_invoice_line_index) → supplier_invoice_line(index)
- supplier_invoice_line_sub_account_segment(supplier_invoice_fivetran_id) → supplier_invoice_line(supplier_invoice_fivetran_id)
- supplier_invoice_line(account_number) → account(account_number)
- supplier_invoice_line(sub_account_id) → sub_account(id)
- supplier_invoice_line(inventory_number) → inventory(id)
- supplier_invoice_line(branch_number) → branch(number)
- supplier_invoice_line(supplier_invoice_fivetran_id) → supplier_invoice(_fivetran_id)
- supplier_invoice_attachment(supplier_invoice_fivetran_id) → supplier_invoice(_fivetran_id)
- supplier_invoice(payment_method_id) → payment_method(id)
- supplier_invoice(financial_period) → financial_period(period)
- supplier_invoice(currency_id) → currency(id)
- supplier_invoice(supplier_number) → supplier(number)
- supplier_invoice(closed_financial_period) → financial_period(period)
- supplier_invoice(cash_account) → cash_account(number)
- supplier_invoice(branch_number) → branch(number)
- customer_debit_note_sub_account_segment(customer_debit_note_id) → customer_debit_note(id)
- customer_debit_note_attachment(customer_debit_note_id) → customer_debit_note(id)
- customer_debit_note_tax_detail(customer_debit_note_id) → customer_debit_note(id)
- customer_debit_note_line_sub_account_segment(customer_debit_note_id) → customer_debit_note_line(customer_debit_note_id)
- customer_debit_note_line_sub_account_segment(customer_debit_note_line_index) → customer_debit_note_line(index)
- customer_debit_note_line_attachment(customer_debit_note_id) → customer_debit_note_line(customer_debit_note_id)
- customer_debit_note_line_attachment(customer_debit_note_line_index) → customer_debit_note_line(index)
- customer_debit_note_line(account_number) → account(account_number)
- customer_debit_note_line(sub_account_id) → sub_account(id)
- customer_debit_note_line(branch_number) → branch(number)
- customer_debit_note_line(customer_debit_note_id) → customer_debit_note(id)
- customer_debit_note_application(customer_debit_note_id) → customer_debit_note(id)
- customer_debit_note(payment_method_id) → payment_method(id)
- customer_debit_note(financial_period) → financial_period(period)
- customer_debit_note(currency_id) → currency(id)
- customer_debit_note(account_number) → account(account_number)
- customer_debit_note(sub_account_id) → sub_account(id)
- customer_debit_note(closed_financial_period) → financial_period(period)
- customer_debit_note(cash_account) → cash_account(number)
- customer_debit_note(customer_id) → customer(id)
- customer_debit_note(branch_number) → branch(number)
- purchase_receipt_line_allocation(purchase_receipt_id) → purchase_receipt_line(purchase_receipt_id)
- purchase_receipt_line_allocation(purchase_receipt_line_index) → purchase_receipt_line(index)
- purchase_receipt_line(account_number) → account(account_number)
- purchase_receipt_line(actual_account_number) → account(account_number)
- purchase_receipt_line(warehouse_id) → warehouse(id)
- purchase_receipt_line(inventory_number) → inventory(id)
- purchase_receipt_line(branch_number) → branch(number)
- purchase_receipt_line(purchase_receipt_id) → purchase_receipt(id)
- purchase_receipt_landed_cost(internal_id) → supplier(id)
- purchase_receipt_landed_cost(purchase_receipt_id) → purchase_receipt(id)
- purchase_receipt(warehouse_id) → warehouse(id)
- purchase_receipt(internal_id) → supplier(id)
- purchase_receipt(branch_number) → branch(number)
- customer_payment_line(currency_id) → currency(id)
- customer_payment_line(customer_payment_id) → customer_payment(id)
- customer_payment_order_to_apply(currency_id) → currency(id)
- customer_payment_order_to_apply(customer_payment_id) → customer_payment(id)
- customer_payment(payment_method_id) → payment_method(id)
- customer_payment(currency_id) → currency(id)
- customer_payment(cash_account) → cash_account(number)
- customer_payment(customer_id) → customer(id)
- general_ledger_balance(ledger_id) → ledger(id)
- general_ledger_balance(financial_period) → financial_period(period)
- general_ledger_balance(currency_id) → currency(id)
- general_ledger_balance(account_number) → account(account_number)
- general_ledger_balance(sub_account_id) → sub_account(id)
- general_ledger_balance(branch_number) → branch(number)
- supplier_payment_line(supplier_payment_id) → supplier_payment(id)
- supplier_payment(currency_id) → currency(id)
- supplier_payment(payment_method) → payment_method(id)
- supplier_payment(cash_account) → cash_account(number)
- supplier_payment(internal_id) → supplier(id)
- payment_method_detail(payment_method_id) → payment_method(id)
- shipment_detail_line_allocation(shipment_id) → shipment_detail_line(shipment_id)
- shipment_detail_line_allocation(shipment_detail_line_index) → shipment_detail_line(index)
- shipment_detail_line(warehouse_id) → warehouse(id)
- shipment_detail_line(shipment_id) → shipment(id)
- shipment_package_line(shipment_id) → shipment(id)
- shipment_order_line(shipment_id) → shipment(id)
- shipment(currency_id) → currency(id)
- shipment(customer_id) → customer(id)
- shipment(from_warehouse_id) → warehouse(id)
- shipment(to_warehouse_id) → warehouse(id)
- cash_account_entry_type(number) → cash_account(number)
- cash_account(currency_id) → currency(id)
- customer_credit_note_sub_account_segment(customer_credit_note_id) → customer_credit_note(id)
- customer_credit_note_attachment(customer_credit_note_id) → customer_credit_note(id)
- customer_credit_note_tax_detail(customer_credit_note_id) → customer_credit_note(id)
- customer_credit_note_line_sub_account_segment(customer_credit_note_id) → customer_credit_note_line(customer_credit_note_id)
- customer_credit_note_line_sub_account_segment(customer_credit_note_line_index) → customer_credit_note_line(index)
- customer_credit_note_line_attachment(customer_credit_note_id) → customer_credit_note_line(customer_credit_note_id)
- customer_credit_note_line_attachment(customer_credit_note_line_index) → customer_credit_note_line(index)
- customer_credit_note_line(account_number) → account(account_number)
- customer_credit_note_line(sub_account_id) → sub_account(id)
- customer_credit_note_line(branch_number) → branch(number)
- customer_credit_note_line(customer_credit_note_id) → customer_credit_note(id)
- customer_credit_note_application(customer_credit_note_id) → customer_credit_note(id)
- customer_credit_note(payment_method_id) → payment_method(id)
- customer_credit_note(financial_period) → financial_period(period)
- customer_credit_note(currency_id) → currency(id)
- customer_credit_note(account_number) → account(account_number)
- customer_credit_note(sub_account_id) → sub_account(id)
- customer_credit_note(closed_financial_period) → financial_period(period)
- customer_credit_note(cash_account) → cash_account(number)
- customer_credit_note(customer_id) → customer(id)
- customer_credit_note(branch_number) → branch(number)
- sub_account_segment(sub_account_id) → sub_account(id)
- inventory_attachment(inventory_id) → inventory(id)
- inventory_supplier_detail(currency_id) → currency(id)
- inventory_supplier_detail(supplier_id) → supplier(id)
- inventory_supplier_detail(inventory_id) → inventory(id)
- inventory_sale_category(inventory_id) → inventory(id)
- inventory_unit_attribute_detail(inventory_unit_index) → inventory_unit_attribute(inventory_unit_index)
- inventory_unit_attribute_detail(inventory_id) → inventory_unit_attribute(inventory_id)
- inventory_unit_attribute_detail(inventory_unit_attribute_id) → inventory_unit_attribute(id)
- inventory_unit_attribute(inventory_unit_index) → inventory_unit(index)
- inventory_unit_attribute(inventory_id) → inventory_unit(inventory_id)
- inventory_unit(inventory_id) → inventory(id)
- inventory_warehouse_detail(warehouse) → warehouse(id)
- inventory_warehouse_detail(inventory_id) → inventory(id)
- inventory_attribute(inventory_id) → inventory(id)
- inventory_item_class_attribute_detail(inventory_id) → inventory_item_class_attribute(inventory_id)
- inventory_item_class_attribute_detail(inventory_item_class_attribute_id) → inventory_item_class_attribute(id)
- inventory_item_class_attribute(id) → attribute(id)
- inventory_item_class_attribute(inventory_id) → inventory(id)
- inventory_cross_reference(inventory_id) → inventory(id)
- inventory(default_warehouse_id) → warehouse(id)
- inventory(account_information_sales_sub_account_id) → sub_account(id)
- inventory(account_information_cogs_sub_account_id) → sub_account(id)
- inventory(account_information_expense_sub_account_id) → sub_account(id)
- cash_sale_application(cash_sale_id) → cash_sale(id)
- cash_sale_sub_account_segment(cash_sale_id) → cash_sale(id)
- cash_sale_line_sub_account_segment(cash_sale_line_index) → cash_sale_line(index)
- cash_sale_line_sub_account_segment(cash_sale_id) → cash_sale_line(cash_sale_id)
- cash_sale_line(account_number) → account(account_number)
- cash_sale_line(sub_account_id) → sub_account(id)
- cash_sale_line(inventory_number) → inventory(id)
- cash_sale_line(branch_number) → branch(number)
- cash_sale_line(cash_sale_id) → cash_sale(id)
- cash_sale(payment_method_id) → payment_method(id)
- cash_sale(financial_period) → financial_period(period)
- cash_sale(currency_id) → currency(id)
- cash_sale(account_number) → account(account_number)
- cash_sale(sub_account_id) → sub_account(id)
- cash_sale(closed_financial_period) → financial_period(period)
- cash_sale(cash_account) → cash_account(number)
- cash_sale(customer_id) → customer(id)
- cash_sale(branch_number) → branch(number)
- customer_payment_method_detail(customer_id) → customer_payment_method(customer_id)
- customer_payment_method_detail(payment_method_id) → customer_payment_method(payment_method_id)
- customer_payment_method(customer_id) → customer(id)
- customer_payment_method(payment_method_id) → payment_method(id)
- customer_payment_method(cash_account_id) → cash_account(number)
- inventory_transfer_attachment(inventory_transfer_id) → inventory_transfer(id)
- inventory_transfer_line_allocation(inventory_transfer_id) → inventory_transfer_line(inventory_transfer_id)
- inventory_transfer_line_allocation(transfer_line_index) → inventory_transfer_line(index)
- inventory_transfer_line_attachment(inventory_transfer_id) → inventory_transfer_line(inventory_transfer_id)
- inventory_transfer_line_attachment(transfer_line_index) → inventory_transfer_line(index)
- inventory_transfer_line(branch_number) → branch(number)
- inventory_transfer_line(inventory_transfer_id) → inventory_transfer(id)
- inventory_transfer(warehouse_id) → warehouse(id)
- inventory_transfer(to_warehouse_id) → warehouse(id)
- inventory_transfer(branch_number) → branch(number)
- account(currency_id) → currency(id)
- customer_attribute(id) → attribute(id)
- customer_attribute(customer_id) → customer(id)
- customer_direct_debit_line(customer_id) → customer(id)
- customer_ledger_sub_account_segment(customer_id) → customer(id)
- customer_sales_sub_account_segment(customer_id) → customer(id)
- customer_discount_sub_account_segment(customer_id) → customer(id)
- customer_freight_sub_account_segment(customer_id) → customer(id)
- customer_pre_payment_sub_account_segment(customer_id) → customer(id)
- customer_cash_discount_sub_account_segment(customer_id) → customer(id)
- payment_method_customer(id) → payment_method(id)
- payment_method_customer(customer_id) → customer(id)
- customer(currency_id) → currency(id)
- customer(default_payment_method_id) → payment_method(id)