Netvisor schema

6 tables

About the connector Start free

6 tables

Joins between these tables aren't mapped yet.

Loading diagram…

accounting_ledger

11

status

string

netvisor_key

int

voucher_date

string

voucher_number

double

voucher_description

string

voucher_class

string

linked_source_netvisor_key_value

int

linked_source_netvisor_key_attr_type

string

voucher_netvisor_uri

string

voucher_line

string

_weld_synced

date

customer

46

netvisor_key

int

customer_base_information_internal_identifier

string

customer_base_information_external_identifier

string

customer_base_information_name_extension

string

customer_base_information_street_address

string

customer_base_information_additional_street_address

string

customer_base_information_post_number

string

customer_base_information_phone_number

string

product

37

netvisor_key

int

product_codes_product_code

string

product_codes_product_primary_ean_code

string

product_codes_product_secondary_ean_code

string

product_name_translations_translation_value

string

product_name_translations_translation_language

string

product_description_translations_translation_value

string

product_description_translations_translation_language

string

purchase_invoice

37

netvisor_key

int

purchase_invoice_number

string

purchase_invoice_date_value

date

purchase_invoice_date_attr_format

string

purchase_invoice_due_date_value

date

purchase_invoice_due_date_attr_format

string

purchase_invoice_reference_number

string

purchase_invoice_agreement_identifier

string

sales_invoice

58

netvisor_key

int

sales_invoice_number

double

sales_invoice_date_value

date

sales_invoice_date_attr_format

string

sales_invoice_event_date_value

date

sales_invoice_event_date_attr_format

string

sales_invoice_value_date_value

date

sales_invoice_value_date_attr_format

string

vendor

14

netvisor_key

int

vendor_base_information_name

string

vendor_base_information_address

string

vendor_base_information_post_code

string

vendor_base_information_city

string

vendor_base_information_country_value

string

vendor_base_information_country_attr_type

string

vendor_base_information_organization_id

string