Kataloginformationen Katalog-Dateiname: C:\GlobalCube\System\LOCOSOFT\Catalogs\Locosoft.cat Beschreibung: Datenbankinformationen Datenbankname: GC_LOCOSOFT Verbindungszeichenkette: DSN=GC_LOCOSOFT;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ= Datenbankstruktur Table: accounts_characteristics Spalte: skr51_branch (longint) Spalte: skr51_make (longint) Spalte: skr51_cost_center (longint) Spalte: skr51_sales_channel (longint) Spalte: skr51_cost_unit (longint) Spalte: skr51_brach_name (varchar) Spalte: skr51_make_description (varchar) Spalte: skr51_cost_center_name (varchar) Spalte: skr51_sales_channel_name (varchar) Spalte: skr51_cost_unit_name (varchar) Spalte: subsidiary_to_company_ref (longint) Table: customers_suppliers Spalte: customer_number (int) Spalte: is_supplier (varchar) Spalte: is_natural_person (varchar) Spalte: name_prefix (varchar) Spalte: first_name (varchar) Spalte: family_name (varchar) Spalte: name_postfix (varchar) Spalte: country_iso3166_alpha2 (varchar) Spalte: zip_code (varchar) Spalte: home_city (varchar) Spalte: parts_rebate_group_buy (int) Spalte: parts_rebate_group_sell (int) Spalte: rebate_labour_percent (decimal) Spalte: rebate_material_percent (decimal) Spalte: rebate_new_vehicles_percent (decimal) Spalte: cash_discount_percent (decimal) Spalte: vat_id_number (varchar) Table: document_types Spalte: document_type_in_journal (varchar) Spalte: document_type_description (varchar) Table: journal_accountings Spalte: accounting_date (date) Spalte: document_type (varchar) Spalte: document_number (longint) Spalte: position_in_document (longint) Spalte: customer_number (longint) Spalte: nominal_account_number (longint) Spalte: is_balanced (varchar) Spalte: clearing_number (longint) Spalte: document_date (date) Spalte: posted_value (longint) Spalte: debit_or_credit (varchar) Spalte: posted_count (longint) Spalte: branch_number (longint) Spalte: customer_contra_account (longint) Spalte: nominal_contra_account (longint) Spalte: contra_account_text (varchar) Spalte: account_form_page_number (longint) Spalte: account_form_page_line (longint) Spalte: serial_number_each_month (longint) Spalte: employee_number (longint) Spalte: invoice_date (date) Spalte: invoice_number (varchar) Spalte: dunning_level (varchar) Spalte: last_dunning_date (date) Spalte: journal_page (longint) Spalte: journal_line (longint) Spalte: cash_discount (longint) Spalte: term_of_payment (longint) Spalte: posting_text (varchar) Spalte: vehicle_reference (varchar) Spalte: vat_id_number (varchar) Spalte: account_statement_number (longint) Spalte: account_statement_page (longint) Spalte: vat_key (varchar) Spalte: days_for_cash_discount (longint) Spalte: day_of_actual_accounting (date) Spalte: skr51_branch (longint) Spalte: skr51_make (longint) Spalte: skr51_cost_center (longint) Spalte: skr51_sales_channel (longint) Spalte: skr51_cost_unit (longint) Spalte: previously_used_account_no (varchar) Spalte: free_form_accounting_text (varchar) Spalte: free_form_document_text (varchar) Spalte: subsidiary_to_company_ref (longint) Table: nominal_accounts Spalte: nominal_account_number (longint) Spalte: account_description (varchar) Spalte: is_profit_loss_account (varchar) Spalte: vat_key (varchar) Spalte: create_date (date) Spalte: create_employee_number (longint) Spalte: oldest_accountable_month (date) Spalte: subsidiary_to_company_ref (longint) Table: parts_rebate_groups_buy Spalte: code (int) Spalte: description (varchar) Table: parts_rebate_groups_sell Spalte: code (int) Spalte: description (varchar) Table: vat_keys Spalte: vat_key (varchar) Spalte: key_validity_date (date) Spalte: branch (longint) Spalte: description (varchar) Spalte: vat_rate (longint) Spalte: create_date (date) Spalte: vat_account (longint) Spalte: advanced_turnover_tax_pos (longint) Katalogordner Ordner: Accounts Characteristics Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch], Zahl) Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make], Zahl) Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center], Zahl) Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel], Zahl) Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit], Zahl) Spalte: Skr51 Brach Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_brach_name], Zeichenkette) Spalte: Skr51 Make Description ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make_description], Zeichenkette) Spalte: Skr51 Cost Center Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center_name], Zeichenkette) Spalte: Skr51 Sales Channel Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel_name], Zeichenkette) Spalte: Skr51 Cost Unit Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit_name], Zeichenkette) Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref], Zahl) Ordner: Customers Suppliers Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number], Zahl) Spalte: Is Supplier ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_supplier], Zeichenkette) Spalte: Is Natural Person ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_natural_person], Zeichenkette) Spalte: Name Prefix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_prefix], Zeichenkette) Spalte: First Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.first_name], Zeichenkette) Spalte: Family Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.family_name], Zeichenkette) Spalte: Name Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_postfix], Zeichenkette) Spalte: Country Iso3166 Alpha2 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.country_iso3166_alpha2], Zeichenkette) Spalte: Zip Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.zip_code], Zeichenkette) Spalte: Home City ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.home_city], Zeichenkette) Spalte: Parts Rebate Group Buy ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_buy], Zahl) Spalte: Parts Rebate Group Sell ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_sell], Zahl) Spalte: Rebate Labour Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_labour_percent], Zahl) Spalte: Rebate Material Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_material_percent], Zahl) Spalte: Rebate New Vehicles Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_new_vehicles_percent], Zahl) Spalte: Cash Discount Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.cash_discount_percent], Zahl) Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.vat_id_number], Zeichenkette) Ordner: Document Types Spalte: Document Type In Journal ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_in_journal], Zeichenkette) Spalte: Document Type Description ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_description], Zeichenkette) Ordner: Journal Accountings Spalte: Accounting Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.accounting_date], Datum) Spalte: Document Type ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_type], Zeichenkette) Spalte: Document Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_number], Zahl) Spalte: Position In Document ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.position_in_document], Zahl) Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_number], Zahl) Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number], Zahl) Spalte: Is Balanced ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.is_balanced], Zeichenkette) Spalte: Clearing Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.clearing_number], Zahl) Spalte: Document Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_date], Datum) Spalte: Posted Value ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_value], Zahl) Spalte: Debit Or Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.debit_or_credit], Zeichenkette) Spalte: Posted Count ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_count], Zahl) Spalte: Branch Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.branch_number], Zahl) Spalte: Customer Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_contra_account], Zahl) Spalte: Nominal Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_contra_account], Zahl) Spalte: Contra Account Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.contra_account_text], Zeichenkette) Spalte: Account Form Page Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_number], Zahl) Spalte: Account Form Page Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_line], Zahl) Spalte: Serial Number Each Month ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.serial_number_each_month], Zahl) Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.employee_number], Zahl) Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_date], Datum) Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_number], Zeichenkette) Spalte: Dunning Level ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.dunning_level], Zeichenkette) Spalte: Last Dunning Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.last_dunning_date], Datum) Spalte: Journal Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_page], Zahl) Spalte: Journal Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_line], Zahl) Spalte: Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.cash_discount], Zahl) Spalte: Term Of Payment ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.term_of_payment], Zahl) Spalte: Posting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posting_text], Zeichenkette) Spalte: Vehicle Reference ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vehicle_reference], Zeichenkette) Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_id_number], Zeichenkette) Spalte: Account Statement Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_number], Zahl) Spalte: Account Statement Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_page], Zahl) Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_key], Zeichenkette) Spalte: Days For Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.days_for_cash_discount], Zahl) Spalte: Day Of Actual Accounting ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.day_of_actual_accounting], Datum) Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch], Zahl) Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make], Zahl) Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center], Zahl) Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel], Zahl) Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit], Zahl) Spalte: Previously Used Account No ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.previously_used_account_no], Zeichenkette) Spalte: Free Form Accounting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_accounting_text], Zeichenkette) Spalte: Free Form Document Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_document_text], Zeichenkette) Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref], Zahl) Ordner: Nominal Accounts Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number], Zahl) Spalte: Account Description ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.account_description], Zeichenkette) Spalte: Is Profit Loss Account ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.is_profit_loss_account], Zeichenkette) Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.vat_key], Zeichenkette) Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_date], Datum) Spalte: Create Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_employee_number], Zahl) Spalte: Oldest Accountable Month ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.oldest_accountable_month], Datum) Ordner: Parts Rebate Groups Buy Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.code], Zahl) Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.description], Zeichenkette) Ordner: Parts Rebate Groups Sell Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.code], Zahl) Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.description], Zeichenkette) Ordner: Vat Keys Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_key], Zeichenkette) Spalte: Key Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.key_validity_date], Datum) Spalte: Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.branch], Zahl) Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.description], Zeichenkette) Spalte: Vat Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_rate], Zahl) Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.create_date], Datum) Spalte: Vat Account ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_account], Zahl) Spalte: Advanced Turnover Tax Pos ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.advanced_turnover_tax_pos], Zahl) Tabellenverbindungen: nominal_accounts - journal_accountings: Geschlossene Verbindung [GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.subsidiary_to_company_ref] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref] accounts_characteristics - journal_accountings: Rechte offene Verbindung [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit] 'Benutzerklasseninformationen Benutzerklasse: Ersteller Client/Server-Informationen Abfrageverarbeitung: Flexible Verarbeitung Verbindungsdauer minimieren: False Gouverneur-Informationen Neue Berichte erstellen: True Ordner hinzufügen/ändern: True Benutzerklassen hinzufügen/ändern: True SQL-Direkteingabe: True 'Über-Kreuz'-Produktabfragen: Verhindern Offene Verbindungen zulassen: Zulassen Sortieren an nicht-indizierten Spalten: Zulassen 'Select Distinct' zulassen: Zulassen Abruf der Zeilen aus der Datenbank beschränken Warnen bei: 0 Stoppen bei: 0 Abfrageausführungs-Zeitlimits Warnen bei: 0 Stoppen bei: 0 Tabellen-Limit je Bericht Warnen bei: 0 Stoppen bei: 0 Text-Blob-Limit: False Max. Text-Blob-Zeichen: nv