Kataloginformationen Katalog-Dateiname: C:\GlobalCube\System\LOCOSOFT\Catalogs\Locosoft_operativ.cat Beschreibung: Datenbankinformationen Datenbankname: Locosoft_GC 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) Spalte: is_dummy_customer (varchar) Spalte: salutation (varchar) Spalte: home_street (varchar) Spalte: birthday (date) Spalte: last_contact (date) Spalte: created_date (date) Spalte: created_employee_no (int) Spalte: updated_date (date) Spalte: updated_employee_no (int) Spalte: name_updated_date (date) Spalte: name_updated_employee_no (int) 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) Table: employees Spalte: employee_number (int) Spalte: validity_date (date) Spalte: is_latest_record (varchar) Spalte: subsidiary (int) Spalte: has_constant_salary (varchar) Spalte: name (varchar) Spalte: initials (varchar) Spalte: customer_number (int) Spalte: mechanic_number (int) Spalte: salesman_number (int) Spalte: is_business_executive (varchar) Spalte: is_master_craftsman (varchar) Spalte: employment_date (date) Spalte: termination_date (date) Spalte: leave_date (date) Spalte: is_flextime (tinyint) Spalte: break_time_registration (varchar) Spalte: mdate (datetime) Spalte: cdate (datetime) Spalte: productivity_factor (decimal) Table: vehicles Spalte: internal_number (int) Spalte: vin (varchar) Spalte: license_plate (varchar) Spalte: license_plate_country (varchar) Spalte: license_plate_season (varchar) Spalte: make_number (int) Spalte: free_form_make_text (varchar) Spalte: model_code (varchar) Spalte: free_form_model_text (varchar) Spalte: is_roadworthy (varchar) Spalte: is_customer_vehicle (varchar) Spalte: dealer_vehicle_type (varchar) Spalte: dealer_vehicle_number (int) Spalte: first_registration_date (date) Spalte: readmission_date (date) Spalte: next_service_date (date) Spalte: next_service_km (int) Spalte: next_service_miles (int) Spalte: production_year (decimal) Spalte: owner_number (int) Spalte: holder_number (int) Spalte: previous_owner_number (int) Spalte: previous_owner_counter (int) Spalte: last_holder_change_date (date) Spalte: german_kba_hsn (varchar) Spalte: german_kba_tsn (varchar) Spalte: austria_nat_code (varchar) Spalte: is_prefer_km (varchar) Spalte: mileage_km (int) Spalte: mileage_miles (int) Spalte: odometer_reading_date (date) Spalte: engine_number (varchar) Spalte: gear_number (varchar) Spalte: unloaded_weight (int) Spalte: gross_vehicle_weight (int) Spalte: power_kw (int) Spalte: cubic_capacity (int) Spalte: is_all_accidents_repaired (varchar) Spalte: accidents_counter (int) Spalte: has_tyre_pressure_sensor (varchar) Spalte: carkey_number (varchar) Spalte: internal_source_flag (varchar) Spalte: emission_code (varchar) Spalte: first_sold_country (varchar) Spalte: first_sold_dealer_code (int) Spalte: body_paint_code (varchar) Spalte: body_paint_description (varchar) Spalte: is_body_paint_metallic (varchar) Spalte: interior_paint_code (varchar) Spalte: interior_paint_description (varchar) Spalte: trim_code (varchar) Spalte: trim_description (varchar) Spalte: fine_dust_label (varchar) Spalte: internal_assignment (varchar) Spalte: ricambi_free_input (varchar) Spalte: document_number (varchar) Spalte: salesman_number (int) Spalte: sale_date (date) Spalte: next_emission_test_date (date) Spalte: next_general_inspection_date (date) Spalte: next_rust_inspection_date (date) Spalte: next_exceptional_inspection_da (date) Spalte: last_change_date (date) Spalte: last_change_employee_no (int) Spalte: created_date (date) Spalte: created_employee_no (int) Spalte: last_change_subsidiary (int) Table: absence_calendar Spalte: employee_number (int) Spalte: date (date) Spalte: unique_dummy (int) Spalte: type (varchar) Spalte: is_payed (varchar) Spalte: day_contingent (decimal) Spalte: reason (varchar) Spalte: booking_flag (varchar) Table: absence_reasons Spalte: id (varchar) Spalte: description (varchar) Spalte: is_annual_vacation (varchar) Table: absence_types Spalte: type (varchar) Spalte: description (varchar) Table: charge_type_descriptions Spalte: type (int) Spalte: description (varchar) Table: charge_types Spalte: type (int) Spalte: subsidiary (int) Spalte: timeunit_rate (decimal) Spalte: department (int) Table: com_number_types Spalte: typ (varchar) Spalte: description (varchar) Spalte: is_office_number (varchar) Table: customer_codes Spalte: code (int) Spalte: description (varchar) Table: customer_com_numbers Spalte: customer_number (int) Spalte: counter (longint) Spalte: com_type (varchar) Spalte: is_reference (varchar) Spalte: is_from_1st_tab (varchar) Spalte: address (varchar) Spalte: has_contact_person_fields (varchar) Spalte: contact_salutation (varchar) Spalte: contact_firstname (varchar) Spalte: contact_lastname (varchar) Spalte: contact_description (varchar) Spalte: note (varchar) Table: customer_to_customercodes Spalte: customer_number (int) Spalte: customer_code (int) Table: employees_history Spalte: employee_number (int) Spalte: validity_date (date) Spalte: is_latest_record (varchar) Spalte: subsidiary (int) Spalte: has_constant_salary (varchar) Spalte: name (varchar) Spalte: initials (varchar) Spalte: customer_number (int) Spalte: mechanic_number (int) Spalte: salesman_number (int) Spalte: is_business_executive (varchar) Spalte: is_master_craftsman (varchar) Spalte: employment_date (date) Spalte: termination_date (date) Spalte: leave_date (date) Table: fuels Spalte: code (varchar) Spalte: description (varchar) Table: invoice_types Spalte: type (int) Spalte: description (varchar) Table: invoices Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: subsidiary (int) Spalte: paying_customer (int) Spalte: order_customer (int) Spalte: invoice_date (date) Spalte: service_date (date) Spalte: cancelation_number (int) Spalte: cancelation_date (date) Spalte: cancelation_employee (int) Spalte: credit_invoice_type (int) Spalte: credit_invoice_number (int) Spalte: odometer_reading (int) Spalte: creating_employee (int) Spalte: internal_cost_account (int) Spalte: vehicle_number (int) Spalte: full_vat_basevalue (decimal) Spalte: full_vat_percentage (decimal) Spalte: full_vat_value (decimal) Spalte: reduced_vat_basevalue (decimal) Spalte: reduced_vat_percentage (decimal) Spalte: reduced_vat_value (decimal) Spalte: used_part_vat_value (decimal) Spalte: job_amount_net (decimal) Spalte: job_amount_gross (decimal) Spalte: job_rebate (decimal) Spalte: part_amount_net (decimal) Spalte: part_amount_gross (decimal) Spalte: part_rebate (decimal) Spalte: part_disposal (decimal) Spalte: total_gross (decimal) Spalte: total_net (decimal) Spalte: is_canceled (tinyint) Spalte: is_own_vehicle (tinyint) Spalte: is_credit (tinyint) Spalte: invtype_invnr (varchar) Spalte: order_number (int) Table: labour_types Spalte: code (varchar) Spalte: description (varchar) Table: labours Spalte: order_number (int) Spalte: order_position (int) Spalte: order_position_line (int) Spalte: subsidiary (int) Spalte: is_invoiced (varchar) Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: employee_no (int) Spalte: mechanic_no (int) Spalte: labour_operation_id (varchar) Spalte: is_nominal (varchar) Spalte: net_price_in_order (decimal) Spalte: rebate_percent (decimal) Spalte: goodwill_percent (decimal) Spalte: charge_type (int) Spalte: text_line (varchar) Spalte: time_units (varchar) Table: makes Spalte: make_number (int) Spalte: is_actual_make (varchar) Spalte: description (varchar) Spalte: group_name (varchar) Spalte: make_id_in_group (varchar) Spalte: internal_labour_group (int) Spalte: is_production_year_visible (varchar) Spalte: is_transmission_no_visible (varchar) Spalte: is_engine_no_visible (varchar) Spalte: is_ricambi_no_visible (varchar) Spalte: ricambi_label (varchar) Spalte: is_preset_finance_stock_rate (varchar) Spalte: rate_free_days_new_vehicle (int) Spalte: rate_free_days_demo_vehicle (int) Spalte: special_service_2_interval (decimal) Spalte: special_service_3_interval (decimal) Table: model_to_fuels Spalte: make_number (int) Spalte: model_code (varchar) Spalte: code (varchar) Table: models Spalte: make_number (int) Spalte: model_code (varchar) Spalte: is_actual_model (varchar) Spalte: model_currently_available (varchar) Spalte: replacing_model_code (varchar) Spalte: description (varchar) Spalte: gear_count (int) Spalte: seat_count (int) Spalte: door_count (int) Spalte: cylinder_count (int) Spalte: vehicle_body (varchar) Spalte: model_labour_group (varchar) Spalte: has_hour_meter (varchar) Spalte: source_extern (varchar) Spalte: free_form_vehicle_class (varchar) Spalte: vin_begin (varchar) Spalte: vehicle_pool_code (varchar) Spalte: vehicle_pool_engine_code (varchar) Spalte: is_manual_transmission (varchar) Spalte: is_all_wheel_drive (varchar) Spalte: is_plugin_hybride (varchar) Spalte: unloaded_weight (int) Spalte: gross_vehicle_weight (int) Spalte: power_kw (int) Spalte: power_kw_at_rotation (int) Spalte: cubic_capacity (int) Spalte: german_kba_hsn (varchar) Spalte: german_kba_tsn (varchar) Spalte: annual_tax (decimal) Spalte: model_year (decimal) Spalte: model_year_postfix (varchar) Spalte: suggested_net_retail_price (decimal) Spalte: suggested_net_shipping_cost (decimal) Spalte: european_pollutant_class (varchar) Spalte: efficiency_class (varchar) Spalte: emission_code (varchar) Spalte: carbondioxid_emission (int) Spalte: nox_exhoust (decimal) Spalte: particle_exhoust (decimal) Spalte: external_schwacke_code (varchar) Spalte: skr_carrier_flag (int) Spalte: free_form_model_specification (varchar) Spalte: external_technical_type (varchar) Spalte: european_fuel_consumption_over (decimal) Spalte: european_fuel_consumption_coun (decimal) Spalte: european_fuel_consumption_city (decimal) Spalte: energy_consumption (decimal) Spalte: insurance_class_liability (int) Spalte: insurance_class_part_comprehen (int) Spalte: insurance_class_full_comprehen (int) Table: order_positions Spalte: order_number (int) Spalte: order_position (int) Spalte: labour_type (varchar) Spalte: subsidiary (int) Spalte: is_invoiced (tinyint) Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: order_date (datetime) Spalte: estimated_inbound_time (datetime) Spalte: estimated_outbound_time (datetime) Spalte: order_print_date (datetime) Spalte: order_taking_employee_no (int) Spalte: order_delivery_employee_no (int) Spalte: vehicle_number (int) Spalte: order_mileage (int) Spalte: order_customer (int) Spalte: paying_customer (int) Spalte: holder_number (int) Spalte: parts_rebate_group_sell (int) Spalte: clearing_delay_type (varchar) Spalte: mdate (datetime) Spalte: cdate (datetime) Table: part_types Spalte: type (int) Spalte: description (varchar) Table: parts Spalte: order_number (int) Spalte: order_position (int) Spalte: order_position_line (int) Spalte: subsidiary (int) Spalte: is_invoiced (varchar) Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: employee_no (int) Spalte: mechanic_no (int) Spalte: part_number (varchar) Spalte: stock_no (int) Spalte: stock_removal_date (date) Spalte: amount (decimal) Spalte: sum (decimal) Spalte: rebate_percent (decimal) Spalte: goodwill_percent (decimal) Spalte: parts_type (int) Spalte: text_line (varchar) Table: time_types Spalte: type (int) Spalte: description (varchar) Table: times Spalte: employee_number (int) Spalte: order_number (int) Spalte: start_time (datetime) Spalte: type (int) Spalte: order_positions (varchar) Spalte: end_time (datetime) Spalte: duration_minutes (int) Spalte: exact_duration_seconds (longint) Table: vehicle_bodys Spalte: code (varchar) Spalte: description (varchar) Table: year_calendar Spalte: calendar_id (int) Spalte: date (date) Spalte: day_off_declaration (int) Spalte: is_school_holid (varchar) Spalte: is_public_holid (varchar) Spalte: day_note (varchar) Table: year_calendar_day_off_codes Spalte: code (int) Spalte: description (varchar) Table: year_calendar_subsidiary_mapping Spalte: subsidiary (int) Spalte: year (int) Spalte: calendar_id (int) Table: Invoices_Gutschriften Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: subsidiary (int) Spalte: paying_customer (int) Spalte: order_customer (int) Spalte: invoice_date (date) Spalte: service_date (date) Spalte: is_canceled (varchar) Spalte: cancelation_number (int) Spalte: cancelation_date (date) Spalte: cancelation_employee (int) Spalte: is_own_vehicle (varchar) Spalte: is_credit (varchar) Spalte: credit_invoice_type (int) Spalte: credit_invoice_number (int) Spalte: odometer_reading (int) Spalte: creating_employee (int) Spalte: internal_cost_account (int) Spalte: vehicle_number (int) Spalte: full_vat_basevalue (decimal) Spalte: full_vat_percentage (decimal) Spalte: full_vat_value (decimal) Spalte: reduced_vat_basevalue (decimal) Spalte: reduced_vat_percentage (decimal) Spalte: reduced_vat_value (decimal) Spalte: used_part_vat_value (decimal) Spalte: job_amount_net (decimal) Spalte: job_amount_gross (decimal) Spalte: job_rebate (decimal) Spalte: part_amount_net (decimal) Spalte: part_amount_gross (decimal) Spalte: part_rebate (decimal) Spalte: part_disposal (decimal) Spalte: total_gross (decimal) Spalte: total_net (decimal) Spalte: invtype_invnr (varchar) Spalte: order_number (int) Table: customers_für_vehicle Spalte: customer_number (int) Spalte: is_supplier (varchar) Spalte: is_natural_person (varchar) Spalte: is_dummy_customer (varchar) Spalte: salutation (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: home_street (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) Spalte: birthday (date) Spalte: last_contact (date) Spalte: created_date (date) Spalte: created_employee_no (int) Spalte: updated_date (date) Spalte: updated_employee_no (int) Spalte: name_updated_date (date) Spalte: name_updated_employee_no (int) Table: Kontenrahmen Spalte: Konto_Nr (varchar) Spalte: Konto_Bezeichnung (varchar) Spalte: Konto_Art (varchar) Spalte: Kostenstelle (varchar) Spalte: STK (varchar) Spalte: Konto_1 (varchar) Spalte: Konto_2 (varchar) Spalte: Konto_3 (varchar) Spalte: Konto_4 (varchar) Spalte: Konto_5 (varchar) Spalte: Ebene1 (varchar) Spalte: Ebene2 (varchar) Spalte: Ebene3 (varchar) Spalte: Ebene4 (varchar) Spalte: Ebene5 (varchar) Spalte: Ebene6 (varchar) Spalte: Ebene7 (varchar) Spalte: Ebene8 (varchar) Spalte: Ebene9 (varchar) Spalte: Ebene10 (varchar) Spalte: Ebene11 (varchar) Spalte: Ebene12 (varchar) Spalte: Ebene13 (varchar) Spalte: Ebene14 (varchar) Spalte: Ebene15 (varchar) Spalte: Ebene16 (varchar) Spalte: Ebene17 (varchar) Spalte: Ebene18 (varchar) Spalte: Ebene19 (varchar) Spalte: Ebene20 (varchar) Spalte: Ebene21 (varchar) Spalte: Ebene22 (varchar) Spalte: Ebene23 (varchar) Spalte: Ebene24 (varchar) Spalte: Ebene25 (varchar) Spalte: Ebene26 (varchar) Spalte: Ebene27 (varchar) Spalte: Ebene28 (varchar) Spalte: Ebene29 (varchar) Spalte: Ebene30 (varchar) Spalte: Ebene31 (varchar) Spalte: Ebene32 (varchar) Spalte: Ebene33 (varchar) Spalte: Ebene34 (varchar) Spalte: Ebene35 (varchar) Spalte: Ebene36 (varchar) Spalte: Ebene37 (varchar) Spalte: Ebene38 (varchar) Spalte: Ebene39 (varchar) Spalte: Ebene40 (varchar) Spalte: Ebene41 (varchar) Spalte: Ebene42 (varchar) Spalte: Ebene43 (varchar) Spalte: Ebene44 (varchar) Spalte: Ebene45 (varchar) Spalte: Ebene46 (varchar) Spalte: Ebene47 (varchar) Spalte: Ebene48 (varchar) Spalte: Ebene49 (varchar) Spalte: Ebene50 (varchar) Spalte: Ebene51 (varchar) Spalte: Ebene52 (varchar) Spalte: Ebene53 (varchar) Spalte: Ebene54 (varchar) Spalte: Ebene55 (varchar) Spalte: Ebene56 (varchar) Spalte: Ebene57 (varchar) Spalte: Ebene58 (varchar) Spalte: Ebene59 (varchar) Spalte: Ebene60 (varchar) Spalte: Ebene61 (varchar) Spalte: Ebene62 (varchar) Spalte: Ebene63 (varchar) Spalte: Ebene64 (varchar) Spalte: Ebene65 (varchar) Spalte: Ebene66 (varchar) Spalte: Ebene67 (varchar) Spalte: Ebene68 (varchar) Spalte: Ebene69 (varchar) Spalte: Ebene70 (varchar) Spalte: Ebene71 (varchar) Spalte: Ebene72 (varchar) Spalte: Ebene73 (varchar) Spalte: Ebene74 (varchar) Spalte: Ebene75 (varchar) Spalte: Ebene76 (varchar) Spalte: Ebene77 (varchar) Spalte: Ebene78 (varchar) Spalte: Ebene79 (varchar) Spalte: Ebene80 (varchar) Spalte: Ebene81 (varchar) Spalte: Ebene82 (varchar) Spalte: Ebene83 (varchar) Spalte: Ebene84 (varchar) Spalte: Ebene85 (varchar) Spalte: Ebene86 (varchar) Spalte: Ebene87 (varchar) Spalte: Ebene88 (varchar) Spalte: Ebene89 (varchar) Spalte: Ebene90 (varchar) Table: order_positions_fuer_Serviceberater Spalte: order_number (int) Spalte: order_position (int) Spalte: labour_type (varchar) Spalte: subsidiary (int) Spalte: is_invoiced (tinyint) Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: order_date (datetime) Spalte: estimated_inbound_time (datetime) Spalte: estimated_outbound_time (datetime) Spalte: order_print_date (datetime) Spalte: order_taking_employee_no (int) Spalte: order_delivery_employee_no (int) Spalte: vehicle_number (int) Spalte: order_mileage (int) Spalte: order_customer (int) Spalte: paying_customer (int) Spalte: holder_number (int) Spalte: parts_rebate_group_sell (int) Spalte: clearing_delay_type (varchar) Spalte: mdate (datetime) Spalte: cdate (datetime) Table: employees_breaktimes Spalte: is_latest_record (tinyint) Spalte: employee_number (int) Spalte: validity_date (datetime) Spalte: dayofweek (int) Spalte: break_start (decimal) Spalte: break_end (decimal) Spalte: mdate (datetime) Spalte: cdate (datetime) Table: employees_worktimes Spalte: is_latest_record (tinyint) Spalte: employee_number (int) Spalte: validity_date (datetime) Spalte: dayofweek (int) Spalte: work_duration (decimal) Spalte: worktime_start (decimal) Spalte: worktime_end (decimal) Spalte: mdate (datetime) Spalte: cdate (datetime) Table: times_für_LG_Monteure Spalte: employee_number (int) Spalte: order_number (int) Spalte: start_time (datetime) Spalte: type (int) Spalte: order_positions (varchar) Spalte: end_time (datetime) Spalte: duration_minutes (int) Spalte: exact_duration_seconds (longint) Spalte: mdate (datetime) Spalte: cdate (datetime) Table: Invoices_neu Spalte: invoice_type (int) Spalte: invoice_number (int) Spalte: subsidiary (int) Spalte: order_number (int) Spalte: paying_customer (int) Spalte: order_customer (int) Spalte: invoice_date (datetime) Spalte: service_date (datetime) Spalte: is_canceled (tinyint) Spalte: cancelation_number (int) Spalte: cancelation_date (datetime) Spalte: cancelation_employee (int) Spalte: is_own_vehicle (tinyint) Spalte: is_credit (tinyint) Spalte: credit_invoice_type (int) Spalte: credit_invoice_number (int) Spalte: odometer_reading (int) Spalte: creating_employee (int) Spalte: internal_cost_account (int) Spalte: vehicle_number (int) Spalte: full_vat_basevalue (decimal) Spalte: full_vat_percentage (decimal) Spalte: full_vat_value (decimal) Spalte: reduced_vat_basevalue (decimal) Spalte: reduced_vat_percentage (decimal) Spalte: reduced_vat_value (decimal) Spalte: used_part_vat_value (decimal) Spalte: job_amount_net (decimal) Spalte: job_amount_gross (decimal) Spalte: job_rebate (decimal) Spalte: part_amount_net (decimal) Spalte: part_amount_gross (decimal) Spalte: part_rebate (decimal) Spalte: part_disposal (decimal) Spalte: total_gross (decimal) Spalte: total_net (decimal) Spalte: invtype_invnr (varchar) Table: employees_fuer_serviceberater Spalte: employee_number (int) Spalte: validity_date (datetime) Spalte: is_latest_record (tinyint) Spalte: subsidiary (int) Spalte: has_constant_salary (tinyint) Spalte: name (varchar) Spalte: initials (varchar) Spalte: customer_number (int) Spalte: mechanic_number (int) Spalte: salesman_number (int) Spalte: is_business_executive (tinyint) Spalte: is_master_craftsman (tinyint) Spalte: employment_date (datetime) Spalte: termination_date (datetime) Spalte: leave_date (datetime) Spalte: is_flextime (tinyint) Spalte: break_time_registration (varchar) Spalte: productivity_factor (decimal) Katalogordner Ordner: Accounts Characteristics Spalte: Skr51 Branch ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_branch], Zahl) Spalte: Skr51 Make ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_make], Zahl) Spalte: Skr51 Cost Center ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center], Zahl) Spalte: Skr51 Sales Channel ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel], Zahl) Spalte: Skr51 Cost Unit ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit], Zahl) Spalte: Skr51 Brach Name ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_brach_name], Zeichenkette) Spalte: Skr51 Make Description ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_make_description], Zeichenkette) Spalte: Skr51 Cost Center Name ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center_name], Zeichenkette) Spalte: Skr51 Sales Channel Name ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel_name], Zeichenkette) Spalte: Skr51 Cost Unit Name ([Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit_name], Zeichenkette) Ordner: Customers Suppliers Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.customer_number], Zahl) Spalte: Is Supplier ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.is_supplier], Zeichenkette) Spalte: Is Natural Person ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.is_natural_person], Zeichenkette) Spalte: Name Prefix ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.name_prefix], Zeichenkette) Spalte: First Name ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.first_name], Zeichenkette) Spalte: Family Name ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.family_name], Zeichenkette) Spalte: Name Postfix ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.name_postfix], Zeichenkette) Spalte: Country Iso3166 Alpha2 ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.country_iso3166_alpha2], Zeichenkette) Spalte: Zip Code ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.zip_code], Zeichenkette) Spalte: Home City ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.home_city], Zeichenkette) Spalte: Parts Rebate Group Buy ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_buy], Zahl) Spalte: Parts Rebate Group Sell ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_sell], Zahl) Spalte: Rebate Labour Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.rebate_labour_percent], Zahl) Spalte: Rebate Material Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.rebate_material_percent], Zahl) Spalte: Rebate New Vehicles Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.rebate_new_vehicles_percent], Zahl) Spalte: Cash Discount Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.cash_discount_percent], Zahl) Spalte: Vat Id Number ([Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.vat_id_number], Zeichenkette) Ordner: Document Types Spalte: Document Type In Journal ([Locosoft_GC.LOCOSOFT.dbo.document_types.document_type_in_journal], Zeichenkette) Spalte: Document Type Description ([Locosoft_GC.LOCOSOFT.dbo.document_types.document_type_description], Zeichenkette) Ordner: Journal Accountings Spalte: Accounting Date ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.accounting_date], Datum) Spalte: Document Type ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.document_type], Zeichenkette) Spalte: Document Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.document_number], Zahl) Spalte: Position In Document ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.position_in_document], Zahl) Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.customer_number], Zahl) Spalte: Nominal Account Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.nominal_account_number], Zahl) Spalte: Is Balanced ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.is_balanced], Zeichenkette) Spalte: Clearing Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.clearing_number], Zahl) Spalte: Document Date ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.document_date], Datum) Spalte: Posted Value ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.posted_value], Zahl) Spalte: Debit Or Credit ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.debit_or_credit], Zeichenkette) Spalte: Posted Count ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.posted_count], Zahl) Spalte: Branch Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.branch_number], Zahl) Spalte: Customer Contra Account ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.customer_contra_account], Zahl) Spalte: Nominal Contra Account ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.nominal_contra_account], Zahl) Spalte: Contra Account Text ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.contra_account_text], Zeichenkette) Spalte: Account Form Page Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.account_form_page_number], Zahl) Spalte: Account Form Page Line ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.account_form_page_line], Zahl) Spalte: Serial Number Each Month ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.serial_number_each_month], Zahl) Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.employee_number], Zahl) Spalte: Invoice Date ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.invoice_date], Datum) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.invoice_number], Zeichenkette) Spalte: Dunning Level ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.dunning_level], Zeichenkette) Spalte: Last Dunning Date ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.last_dunning_date], Datum) Spalte: Journal Page ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.journal_page], Zahl) Spalte: Journal Line ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.journal_line], Zahl) Spalte: Cash Discount ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.cash_discount], Zahl) Spalte: Term Of Payment ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.term_of_payment], Zahl) Spalte: Posting Text ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.posting_text], Zeichenkette) Spalte: Vehicle Reference ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.vehicle_reference], Zeichenkette) Spalte: Vat Id Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.vat_id_number], Zeichenkette) Spalte: Account Statement Number ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.account_statement_number], Zahl) Spalte: Account Statement Page ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.account_statement_page], Zahl) Spalte: Vat Key ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.vat_key], Zeichenkette) Spalte: Days For Cash Discount ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.days_for_cash_discount], Zahl) Spalte: Day Of Actual Accounting ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.day_of_actual_accounting], Datum) Spalte: Skr51 Branch ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_branch], Zahl) Spalte: Skr51 Make ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_make], Zahl) Spalte: Skr51 Cost Center ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_cost_center], Zahl) Spalte: Skr51 Sales Channel ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel], Zahl) Spalte: Skr51 Cost Unit ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit], Zahl) Spalte: Previously Used Account No ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.previously_used_account_no], Zeichenkette) Spalte: Free Form Accounting Text ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.free_form_accounting_text], Zeichenkette) Spalte: Free Form Document Text ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.free_form_document_text], Zeichenkette) Spalte: Subsidiary To Company Ref ([Locosoft_GC.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref], Zahl) Ordner: Nominal Accounts Spalte: Nominal Account Number ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.nominal_account_number], Zahl) Spalte: Account Description ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.account_description], Zeichenkette) Spalte: Is Profit Loss Account ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.is_profit_loss_account], Zeichenkette) Spalte: Vat Key ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.vat_key], Zeichenkette) Spalte: Create Date ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.create_date], Datum) Spalte: Create Employee Number ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.create_employee_number], Zahl) Spalte: Oldest Accountable Month ([Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.oldest_accountable_month], Datum) Ordner: Parts Rebate Groups Buy Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.parts_rebate_groups_buy.code], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.parts_rebate_groups_buy.description], Zeichenkette) Ordner: Parts Rebate Groups Sell Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.parts_rebate_groups_sell.code], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.parts_rebate_groups_sell.description], Zeichenkette) Ordner: Vat Keys Spalte: Vat Key ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.vat_key], Zeichenkette) Spalte: Key Validity Date ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.key_validity_date], Datum) Spalte: Branch ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.branch], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.description], Zeichenkette) Spalte: Vat Rate ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.vat_rate], Zahl) Spalte: Create Date ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.create_date], Datum) Spalte: Vat Account ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.vat_account], Zahl) Spalte: Advanced Turnover Tax Pos ([Locosoft_GC.LOCOSOFT.dbo.vat_keys.advanced_turnover_tax_pos], Zahl) Ordner: Employees Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.employees.employee_number], Zahl) Spalte: Validity Date ([Locosoft_GC.LOCOSOFT.dbo.employees.validity_date], Datum) Spalte: Is Latest Record ([Locosoft_GC.LOCOSOFT.dbo.employees.is_latest_record], Zeichenkette) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.employees.subsidiary], Zahl) Spalte: Has Constant Salary ([Locosoft_GC.LOCOSOFT.dbo.employees.has_constant_salary], Zeichenkette) Spalte: Name ([Locosoft_GC.LOCOSOFT.dbo.employees.name], Zeichenkette) Spalte: Initials ([Locosoft_GC.LOCOSOFT.dbo.employees.initials], Zeichenkette) Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.employees.customer_number], Zahl) Spalte: Mechanic Number ([Locosoft_GC.LOCOSOFT.dbo.employees.mechanic_number], Zahl) Spalte: Salesman Number ([Locosoft_GC.LOCOSOFT.dbo.employees.salesman_number], Zahl) Spalte: Is Business Executive ([Locosoft_GC.LOCOSOFT.dbo.employees.is_business_executive], Zeichenkette) Spalte: Is Master Craftsman ([Locosoft_GC.LOCOSOFT.dbo.employees.is_master_craftsman], Zeichenkette) Spalte: Employment Date ([Locosoft_GC.LOCOSOFT.dbo.employees.employment_date], Datum) Spalte: Termination Date ([Locosoft_GC.LOCOSOFT.dbo.employees.termination_date], Datum) Spalte: Leave Date ([Locosoft_GC.LOCOSOFT.dbo.employees.leave_date], Datum) Spalte: Is Flextime ([Locosoft_GC.LOCOSOFT.dbo.employees.is_flextime], Zahl) Spalte: Break Time Registration ([Locosoft_GC.LOCOSOFT.dbo.employees.break_time_registration], Zeichenkette) Spalte: Productivity Factor ([Locosoft_GC.LOCOSOFT.dbo.employees.productivity_factor], Zahl) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.employees.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.employees.cdate], Datum/Uhrzeit) Ordner: Vehicles Spalte: Internal Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.internal_number], Zahl) Spalte: Vin ([Locosoft_GC.LOCOSOFT.dbo.vehicles.vin], Zeichenkette) Spalte: License Plate ([Locosoft_GC.LOCOSOFT.dbo.vehicles.license_plate], Zeichenkette) Spalte: License Plate Country ([Locosoft_GC.LOCOSOFT.dbo.vehicles.license_plate_country], Zeichenkette) Spalte: License Plate Season ([Locosoft_GC.LOCOSOFT.dbo.vehicles.license_plate_season], Zeichenkette) Spalte: Make Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.make_number], Zahl) Spalte: Free Form Make Text ([Locosoft_GC.LOCOSOFT.dbo.vehicles.free_form_make_text], Zeichenkette) Spalte: Model Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.model_code], Zeichenkette) Spalte: Free Form Model Text ([Locosoft_GC.LOCOSOFT.dbo.vehicles.free_form_model_text], Zeichenkette) Spalte: Is Roadworthy ([Locosoft_GC.LOCOSOFT.dbo.vehicles.is_roadworthy], Zeichenkette) Spalte: Is Customer Vehicle ([Locosoft_GC.LOCOSOFT.dbo.vehicles.is_customer_vehicle], Zeichenkette) Spalte: Dealer Vehicle Type ([Locosoft_GC.LOCOSOFT.dbo.vehicles.dealer_vehicle_type], Zeichenkette) Spalte: Dealer Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.dealer_vehicle_number], Zahl) Spalte: First Registration Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.first_registration_date], Datum) Spalte: Readmission Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.readmission_date], Datum) Spalte: Next Service Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_service_date], Datum) Spalte: Next Service Km ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_service_km], Zahl) Spalte: Next Service Miles ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_service_miles], Zahl) Spalte: Production Year ([Locosoft_GC.LOCOSOFT.dbo.vehicles.production_year], Zahl) Spalte: Owner Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.owner_number], Zahl) Spalte: Holder Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.holder_number], Zahl) Spalte: Previous Owner Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.previous_owner_number], Zahl) Spalte: Previous Owner Counter ([Locosoft_GC.LOCOSOFT.dbo.vehicles.previous_owner_counter], Zahl) Spalte: Last Holder Change Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.last_holder_change_date], Datum) Spalte: German Kba Hsn ([Locosoft_GC.LOCOSOFT.dbo.vehicles.german_kba_hsn], Zeichenkette) Spalte: German Kba Tsn ([Locosoft_GC.LOCOSOFT.dbo.vehicles.german_kba_tsn], Zeichenkette) Spalte: Austria Nat Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.austria_nat_code], Zeichenkette) Spalte: Is Prefer Km ([Locosoft_GC.LOCOSOFT.dbo.vehicles.is_prefer_km], Zeichenkette) Spalte: Mileage Km ([Locosoft_GC.LOCOSOFT.dbo.vehicles.mileage_km], Zahl) Spalte: Mileage Miles ([Locosoft_GC.LOCOSOFT.dbo.vehicles.mileage_miles], Zahl) Spalte: Odometer Reading Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.odometer_reading_date], Datum) Spalte: Engine Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.engine_number], Zeichenkette) Spalte: Gear Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.gear_number], Zeichenkette) Spalte: Unloaded Weight ([Locosoft_GC.LOCOSOFT.dbo.vehicles.unloaded_weight], Zahl) Spalte: Gross Vehicle Weight ([Locosoft_GC.LOCOSOFT.dbo.vehicles.gross_vehicle_weight], Zahl) Spalte: Power Kw ([Locosoft_GC.LOCOSOFT.dbo.vehicles.power_kw], Zahl) Spalte: Cubic Capacity ([Locosoft_GC.LOCOSOFT.dbo.vehicles.cubic_capacity], Zahl) Spalte: Is All Accidents Repaired ([Locosoft_GC.LOCOSOFT.dbo.vehicles.is_all_accidents_repaired], Zeichenkette) Spalte: Accidents Counter ([Locosoft_GC.LOCOSOFT.dbo.vehicles.accidents_counter], Zahl) Spalte: Has Tyre Pressure Sensor ([Locosoft_GC.LOCOSOFT.dbo.vehicles.has_tyre_pressure_sensor], Zeichenkette) Spalte: Carkey Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.carkey_number], Zeichenkette) Spalte: Internal Source Flag ([Locosoft_GC.LOCOSOFT.dbo.vehicles.internal_source_flag], Zeichenkette) Spalte: Emission Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.emission_code], Zeichenkette) Spalte: First Sold Country ([Locosoft_GC.LOCOSOFT.dbo.vehicles.first_sold_country], Zeichenkette) Spalte: First Sold Dealer Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.first_sold_dealer_code], Zahl) Spalte: Body Paint Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.body_paint_code], Zeichenkette) Spalte: Body Paint Description ([Locosoft_GC.LOCOSOFT.dbo.vehicles.body_paint_description], Zeichenkette) Spalte: Is Body Paint Metallic ([Locosoft_GC.LOCOSOFT.dbo.vehicles.is_body_paint_metallic], Zeichenkette) Spalte: Interior Paint Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.interior_paint_code], Zeichenkette) Spalte: Interior Paint Description ([Locosoft_GC.LOCOSOFT.dbo.vehicles.interior_paint_description], Zeichenkette) Spalte: Trim Code ([Locosoft_GC.LOCOSOFT.dbo.vehicles.trim_code], Zeichenkette) Spalte: Trim Description ([Locosoft_GC.LOCOSOFT.dbo.vehicles.trim_description], Zeichenkette) Spalte: Fine Dust Label ([Locosoft_GC.LOCOSOFT.dbo.vehicles.fine_dust_label], Zeichenkette) Spalte: Internal Assignment ([Locosoft_GC.LOCOSOFT.dbo.vehicles.internal_assignment], Zeichenkette) Spalte: Ricambi Free Input ([Locosoft_GC.LOCOSOFT.dbo.vehicles.ricambi_free_input], Zeichenkette) Spalte: Document Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.document_number], Zeichenkette) Spalte: Salesman Number ([Locosoft_GC.LOCOSOFT.dbo.vehicles.salesman_number], Zahl) Spalte: Sale Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.sale_date], Datum) Spalte: Next Emission Test Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_emission_test_date], Datum) Spalte: Next General Inspection Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_general_inspection_date], Datum) Spalte: Next Rust Inspection Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_rust_inspection_date], Datum) Spalte: Next Exceptional Inspection Da ([Locosoft_GC.LOCOSOFT.dbo.vehicles.next_exceptional_inspection_da], Datum) Spalte: Last Change Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.last_change_date], Datum) Spalte: Last Change Employee No ([Locosoft_GC.LOCOSOFT.dbo.vehicles.last_change_employee_no], Zahl) Spalte: Created Date ([Locosoft_GC.LOCOSOFT.dbo.vehicles.created_date], Datum) Spalte: Created Employee No ([Locosoft_GC.LOCOSOFT.dbo.vehicles.created_employee_no], Zahl) Spalte: Last Change Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.vehicles.last_change_subsidiary], Zahl) Ordner: Absence Calendar Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.employee_number], Zahl) Spalte: Date ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.date], Datum) Spalte: Unique Dummy ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.unique_dummy], Zahl) Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.type], Zeichenkette) Spalte: Is Payed ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.is_payed], Zeichenkette) Spalte: Day Contingent ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.day_contingent], Zahl) Spalte: Reason ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.reason], Zeichenkette) Spalte: Booking Flag ([Locosoft_GC.LOCOSOFT.dbo.absence_calendar.booking_flag], Zeichenkette) Ordner: Absence Reasons Spalte: Id ([Locosoft_GC.LOCOSOFT.dbo.absence_reasons.id], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.absence_reasons.description], Zeichenkette) Spalte: Is Annual Vacation ([Locosoft_GC.LOCOSOFT.dbo.absence_reasons.is_annual_vacation], Zeichenkette) Ordner: Absence Types Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.absence_types.type], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.absence_types.description], Zeichenkette) Ordner: Charge Type Descriptions Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.charge_type_descriptions.type], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.charge_type_descriptions.description], Zeichenkette) Ordner: Charge Types Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.charge_types.type], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.charge_types.subsidiary], Zahl) Spalte: Timeunit Rate ([Locosoft_GC.LOCOSOFT.dbo.charge_types.timeunit_rate], Zahl) Spalte: Department ([Locosoft_GC.LOCOSOFT.dbo.charge_types.department], Zahl) Ordner: Com Number Types Spalte: Typ ([Locosoft_GC.LOCOSOFT.dbo.com_number_types.typ], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.com_number_types.description], Zeichenkette) Spalte: Is Office Number ([Locosoft_GC.LOCOSOFT.dbo.com_number_types.is_office_number], Zeichenkette) Ordner: Customer Codes Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.customer_codes.code], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.customer_codes.description], Zeichenkette) Ordner: Customer Com Numbers Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.customer_number], Zahl) Spalte: Counter ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.counter], Zahl) Spalte: Com Type ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.com_type], Zeichenkette) Spalte: Is Reference ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.is_reference], Zeichenkette) Spalte: Is From 1st Tab ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.is_from_1st_tab], Zeichenkette) Spalte: Address ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.address], Zeichenkette) Spalte: Has Contact Person Fields ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.has_contact_person_fields], Zeichenkette) Spalte: Contact Salutation ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.contact_salutation], Zeichenkette) Spalte: Contact Firstname ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.contact_firstname], Zeichenkette) Spalte: Contact Lastname ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.contact_lastname], Zeichenkette) Spalte: Contact Description ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.contact_description], Zeichenkette) Spalte: Note ([Locosoft_GC.LOCOSOFT.dbo.customer_com_numbers.note], Zeichenkette) Ordner: Customer To Customercodes Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.customer_to_customercodes.customer_number], Zahl) Spalte: Customer Code ([Locosoft_GC.LOCOSOFT.dbo.customer_to_customercodes.customer_code], Zahl) Ordner: Employees History Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.employees_history.employee_number], Zahl) Spalte: Validity Date ([Locosoft_GC.LOCOSOFT.dbo.employees_history.validity_date], Datum) Spalte: Is Latest Record ([Locosoft_GC.LOCOSOFT.dbo.employees_history.is_latest_record], Zeichenkette) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.employees_history.subsidiary], Zahl) Spalte: Has Constant Salary ([Locosoft_GC.LOCOSOFT.dbo.employees_history.has_constant_salary], Zeichenkette) Spalte: Name ([Locosoft_GC.LOCOSOFT.dbo.employees_history.name], Zeichenkette) Spalte: Initials ([Locosoft_GC.LOCOSOFT.dbo.employees_history.initials], Zeichenkette) Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.employees_history.customer_number], Zahl) Spalte: Mechanic Number ([Locosoft_GC.LOCOSOFT.dbo.employees_history.mechanic_number], Zahl) Spalte: Salesman Number ([Locosoft_GC.LOCOSOFT.dbo.employees_history.salesman_number], Zahl) Spalte: Is Business Executive ([Locosoft_GC.LOCOSOFT.dbo.employees_history.is_business_executive], Zeichenkette) Spalte: Is Master Craftsman ([Locosoft_GC.LOCOSOFT.dbo.employees_history.is_master_craftsman], Zeichenkette) Spalte: Employment Date ([Locosoft_GC.LOCOSOFT.dbo.employees_history.employment_date], Datum) Spalte: Termination Date ([Locosoft_GC.LOCOSOFT.dbo.employees_history.termination_date], Datum) Spalte: Leave Date ([Locosoft_GC.LOCOSOFT.dbo.employees_history.leave_date], Datum) Ordner: Fuels Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.fuels.code], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.fuels.description], Zeichenkette) Ordner: Invoice Types Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.invoice_types.type], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.invoice_types.description], Zeichenkette) Ordner: Invoices Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_number], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.invoices.subsidiary], Zahl) Spalte: Paying Customer ([Locosoft_GC.LOCOSOFT.dbo.invoices.paying_customer], Zahl) Spalte: Order Customer ([Locosoft_GC.LOCOSOFT.dbo.invoices.order_customer], Zahl) Spalte: Invoice Date ([Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_date], Datum) Spalte: Service Date ([Locosoft_GC.LOCOSOFT.dbo.invoices.service_date], Datum) Spalte: Is Canceled ([Locosoft_GC.LOCOSOFT.dbo.invoices.is_canceled], Zahl) Spalte: Cancelation Number ([Locosoft_GC.LOCOSOFT.dbo.invoices.cancelation_number], Zahl) Spalte: Cancelation Date ([Locosoft_GC.LOCOSOFT.dbo.invoices.cancelation_date], Datum) Spalte: Cancelation Employee ([Locosoft_GC.LOCOSOFT.dbo.invoices.cancelation_employee], Zahl) Spalte: Is Own Vehicle ([Locosoft_GC.LOCOSOFT.dbo.invoices.is_own_vehicle], Zahl) Spalte: Is Credit ([Locosoft_GC.LOCOSOFT.dbo.invoices.is_credit], Zahl) Spalte: Credit Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.invoices.credit_invoice_type], Zahl) Spalte: Credit Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.invoices.credit_invoice_number], Zahl) Spalte: Odometer Reading ([Locosoft_GC.LOCOSOFT.dbo.invoices.odometer_reading], Zahl) Spalte: Creating Employee ([Locosoft_GC.LOCOSOFT.dbo.invoices.creating_employee], Zahl) Spalte: Internal Cost Account ([Locosoft_GC.LOCOSOFT.dbo.invoices.internal_cost_account], Zahl) Spalte: Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.invoices.vehicle_number], Zahl) Spalte: Full Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.invoices.full_vat_basevalue], Zahl) Spalte: Full Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.invoices.full_vat_percentage], Zahl) Spalte: Full Vat Value ([Locosoft_GC.LOCOSOFT.dbo.invoices.full_vat_value], Zahl) Spalte: Reduced Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.invoices.reduced_vat_basevalue], Zahl) Spalte: Reduced Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.invoices.reduced_vat_percentage], Zahl) Spalte: Reduced Vat Value ([Locosoft_GC.LOCOSOFT.dbo.invoices.reduced_vat_value], Zahl) Spalte: Used Part Vat Value ([Locosoft_GC.LOCOSOFT.dbo.invoices.used_part_vat_value], Zahl) Spalte: Job Amount Net ([Locosoft_GC.LOCOSOFT.dbo.invoices.job_amount_net], Zahl) Spalte: Job Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.invoices.job_amount_gross], Zahl) Spalte: Job Rebate ([Locosoft_GC.LOCOSOFT.dbo.invoices.job_rebate], Zahl) Spalte: Part Amount Net ([Locosoft_GC.LOCOSOFT.dbo.invoices.part_amount_net], Zahl) Spalte: Part Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.invoices.part_amount_gross], Zahl) Spalte: Part Rebate ([Locosoft_GC.LOCOSOFT.dbo.invoices.part_rebate], Zahl) Spalte: Part Disposal ([Locosoft_GC.LOCOSOFT.dbo.invoices.part_disposal], Zahl) Spalte: Total Gross ([Locosoft_GC.LOCOSOFT.dbo.invoices.total_gross], Zahl) Spalte: Total Net ([Locosoft_GC.LOCOSOFT.dbo.invoices.total_net], Zahl) Spalte: Invtype Invnr ([Locosoft_GC.LOCOSOFT.dbo.invoices.invtype_invnr], Zeichenkette) Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.invoices.order_number], Zahl) Ordner: Labour Types Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.labour_types.code], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.labour_types.description], Zeichenkette) Ordner: Labours Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.labours.order_number], Zahl) Spalte: Order Position ([Locosoft_GC.LOCOSOFT.dbo.labours.order_position], Zahl) Spalte: Order Position Line ([Locosoft_GC.LOCOSOFT.dbo.labours.order_position_line], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.labours.subsidiary], Zahl) Spalte: Is Invoiced ([Locosoft_GC.LOCOSOFT.dbo.labours.is_invoiced], Zeichenkette) Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.labours.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.labours.invoice_number], Zahl) Spalte: Employee No ([Locosoft_GC.LOCOSOFT.dbo.labours.employee_no], Zahl) Spalte: Mechanic No ([Locosoft_GC.LOCOSOFT.dbo.labours.mechanic_no], Zahl) Spalte: Labour Operation Id ([Locosoft_GC.LOCOSOFT.dbo.labours.labour_operation_id], Zeichenkette) Spalte: Is Nominal ([Locosoft_GC.LOCOSOFT.dbo.labours.is_nominal], Zeichenkette) Spalte: Net Price In Order ([Locosoft_GC.LOCOSOFT.dbo.labours.net_price_in_order], Zahl) Spalte: Rebate Percent ([Locosoft_GC.LOCOSOFT.dbo.labours.rebate_percent], Zahl) Spalte: Goodwill Percent ([Locosoft_GC.LOCOSOFT.dbo.labours.goodwill_percent], Zahl) Spalte: Charge Type ([Locosoft_GC.LOCOSOFT.dbo.labours.charge_type], Zahl) Spalte: Time Units ([Locosoft_GC.LOCOSOFT.dbo.labours.time_units], Zeichenkette) Spalte: Text Line ([Locosoft_GC.LOCOSOFT.dbo.labours.text_line], Zeichenkette) Ordner: Makes Spalte: Make Number ([Locosoft_GC.LOCOSOFT.dbo.makes.make_number], Zahl) Spalte: Is Actual Make ([Locosoft_GC.LOCOSOFT.dbo.makes.is_actual_make], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.makes.description], Zeichenkette) Spalte: Group Name ([Locosoft_GC.LOCOSOFT.dbo.makes.group_name], Zeichenkette) Spalte: Make Id In Group ([Locosoft_GC.LOCOSOFT.dbo.makes.make_id_in_group], Zeichenkette) Spalte: Internal Labour Group ([Locosoft_GC.LOCOSOFT.dbo.makes.internal_labour_group], Zahl) Spalte: Is Production Year Visible ([Locosoft_GC.LOCOSOFT.dbo.makes.is_production_year_visible], Zeichenkette) Spalte: Is Transmission No Visible ([Locosoft_GC.LOCOSOFT.dbo.makes.is_transmission_no_visible], Zeichenkette) Spalte: Is Engine No Visible ([Locosoft_GC.LOCOSOFT.dbo.makes.is_engine_no_visible], Zeichenkette) Spalte: Is Ricambi No Visible ([Locosoft_GC.LOCOSOFT.dbo.makes.is_ricambi_no_visible], Zeichenkette) Spalte: Ricambi Label ([Locosoft_GC.LOCOSOFT.dbo.makes.ricambi_label], Zeichenkette) Spalte: Is Preset Finance Stock Rate ([Locosoft_GC.LOCOSOFT.dbo.makes.is_preset_finance_stock_rate], Zeichenkette) Spalte: Rate Free Days New Vehicle ([Locosoft_GC.LOCOSOFT.dbo.makes.rate_free_days_new_vehicle], Zahl) Spalte: Rate Free Days Demo Vehicle ([Locosoft_GC.LOCOSOFT.dbo.makes.rate_free_days_demo_vehicle], Zahl) Spalte: Special Service 2 Interval ([Locosoft_GC.LOCOSOFT.dbo.makes.special_service_2_interval], Zahl) Spalte: Special Service 3 Interval ([Locosoft_GC.LOCOSOFT.dbo.makes.special_service_3_interval], Zahl) Ordner: Model To Fuels Spalte: Make Number ([Locosoft_GC.LOCOSOFT.dbo.model_to_fuels.make_number], Zahl) Spalte: Model Code ([Locosoft_GC.LOCOSOFT.dbo.model_to_fuels.model_code], Zeichenkette) Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.model_to_fuels.code], Zeichenkette) Ordner: Models Spalte: Make Number ([Locosoft_GC.LOCOSOFT.dbo.models.make_number], Zahl) Spalte: Model Code ([Locosoft_GC.LOCOSOFT.dbo.models.model_code], Zeichenkette) Spalte: Is Actual Model ([Locosoft_GC.LOCOSOFT.dbo.models.is_actual_model], Zeichenkette) Spalte: Model Currently Available ([Locosoft_GC.LOCOSOFT.dbo.models.model_currently_available], Zeichenkette) Spalte: Replacing Model Code ([Locosoft_GC.LOCOSOFT.dbo.models.replacing_model_code], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.models.description], Zeichenkette) Spalte: Gear Count ([Locosoft_GC.LOCOSOFT.dbo.models.gear_count], Zahl) Spalte: Seat Count ([Locosoft_GC.LOCOSOFT.dbo.models.seat_count], Zahl) Spalte: Door Count ([Locosoft_GC.LOCOSOFT.dbo.models.door_count], Zahl) Spalte: Cylinder Count ([Locosoft_GC.LOCOSOFT.dbo.models.cylinder_count], Zahl) Spalte: Vehicle Body ([Locosoft_GC.LOCOSOFT.dbo.models.vehicle_body], Zeichenkette) Spalte: Model Labour Group ([Locosoft_GC.LOCOSOFT.dbo.models.model_labour_group], Zeichenkette) Spalte: Has Hour Meter ([Locosoft_GC.LOCOSOFT.dbo.models.has_hour_meter], Zeichenkette) Spalte: Source Extern ([Locosoft_GC.LOCOSOFT.dbo.models.source_extern], Zeichenkette) Spalte: Free Form Vehicle Class ([Locosoft_GC.LOCOSOFT.dbo.models.free_form_vehicle_class], Zeichenkette) Spalte: Vin Begin ([Locosoft_GC.LOCOSOFT.dbo.models.vin_begin], Zeichenkette) Spalte: Vehicle Pool Code ([Locosoft_GC.LOCOSOFT.dbo.models.vehicle_pool_code], Zeichenkette) Spalte: Vehicle Pool Engine Code ([Locosoft_GC.LOCOSOFT.dbo.models.vehicle_pool_engine_code], Zeichenkette) Spalte: Is Manual Transmission ([Locosoft_GC.LOCOSOFT.dbo.models.is_manual_transmission], Zeichenkette) Spalte: Is All Wheel Drive ([Locosoft_GC.LOCOSOFT.dbo.models.is_all_wheel_drive], Zeichenkette) Spalte: Is Plugin Hybride ([Locosoft_GC.LOCOSOFT.dbo.models.is_plugin_hybride], Zeichenkette) Spalte: Unloaded Weight ([Locosoft_GC.LOCOSOFT.dbo.models.unloaded_weight], Zahl) Spalte: Gross Vehicle Weight ([Locosoft_GC.LOCOSOFT.dbo.models.gross_vehicle_weight], Zahl) Spalte: Power Kw ([Locosoft_GC.LOCOSOFT.dbo.models.power_kw], Zahl) Spalte: Power Kw At Rotation ([Locosoft_GC.LOCOSOFT.dbo.models.power_kw_at_rotation], Zahl) Spalte: Cubic Capacity ([Locosoft_GC.LOCOSOFT.dbo.models.cubic_capacity], Zahl) Spalte: German Kba Hsn ([Locosoft_GC.LOCOSOFT.dbo.models.german_kba_hsn], Zeichenkette) Spalte: German Kba Tsn ([Locosoft_GC.LOCOSOFT.dbo.models.german_kba_tsn], Zeichenkette) Spalte: Annual Tax ([Locosoft_GC.LOCOSOFT.dbo.models.annual_tax], Zahl) Spalte: Model Year ([Locosoft_GC.LOCOSOFT.dbo.models.model_year], Zahl) Spalte: Model Year Postfix ([Locosoft_GC.LOCOSOFT.dbo.models.model_year_postfix], Zeichenkette) Spalte: Suggested Net Retail Price ([Locosoft_GC.LOCOSOFT.dbo.models.suggested_net_retail_price], Zahl) Spalte: Suggested Net Shipping Cost ([Locosoft_GC.LOCOSOFT.dbo.models.suggested_net_shipping_cost], Zahl) Spalte: European Pollutant Class ([Locosoft_GC.LOCOSOFT.dbo.models.european_pollutant_class], Zeichenkette) Spalte: Efficiency Class ([Locosoft_GC.LOCOSOFT.dbo.models.efficiency_class], Zeichenkette) Spalte: Emission Code ([Locosoft_GC.LOCOSOFT.dbo.models.emission_code], Zeichenkette) Spalte: Carbondioxid Emission ([Locosoft_GC.LOCOSOFT.dbo.models.carbondioxid_emission], Zahl) Spalte: Nox Exhoust ([Locosoft_GC.LOCOSOFT.dbo.models.nox_exhoust], Zahl) Spalte: Particle Exhoust ([Locosoft_GC.LOCOSOFT.dbo.models.particle_exhoust], Zahl) Spalte: External Schwacke Code ([Locosoft_GC.LOCOSOFT.dbo.models.external_schwacke_code], Zeichenkette) Spalte: Skr Carrier Flag ([Locosoft_GC.LOCOSOFT.dbo.models.skr_carrier_flag], Zahl) Spalte: Free Form Model Specification ([Locosoft_GC.LOCOSOFT.dbo.models.free_form_model_specification], Zeichenkette) Spalte: External Technical Type ([Locosoft_GC.LOCOSOFT.dbo.models.external_technical_type], Zeichenkette) Spalte: European Fuel Consumption Over ([Locosoft_GC.LOCOSOFT.dbo.models.european_fuel_consumption_over], Zahl) Spalte: European Fuel Consumption Coun ([Locosoft_GC.LOCOSOFT.dbo.models.european_fuel_consumption_coun], Zahl) Spalte: European Fuel Consumption City ([Locosoft_GC.LOCOSOFT.dbo.models.european_fuel_consumption_city], Zahl) Spalte: Energy Consumption ([Locosoft_GC.LOCOSOFT.dbo.models.energy_consumption], Zahl) Spalte: Insurance Class Liability ([Locosoft_GC.LOCOSOFT.dbo.models.insurance_class_liability], Zahl) Spalte: Insurance Class Part Comprehen ([Locosoft_GC.LOCOSOFT.dbo.models.insurance_class_part_comprehen], Zahl) Spalte: Insurance Class Full Comprehen ([Locosoft_GC.LOCOSOFT.dbo.models.insurance_class_full_comprehen], Zahl) Ordner: Order Positions Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_number], Zahl) Spalte: Order Position ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_position], Zahl) Spalte: Labour Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions.labour_type], Zeichenkette) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.order_positions.subsidiary], Zahl) Spalte: Is Invoiced ([Locosoft_GC.LOCOSOFT.dbo.order_positions.is_invoiced], Zahl) Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions.invoice_number], Zahl) Spalte: Order Date ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_date], Datum/Uhrzeit) Spalte: Estimated Inbound Time ([Locosoft_GC.LOCOSOFT.dbo.order_positions.estimated_inbound_time], Datum/Uhrzeit) Spalte: Estimated Outbound Time ([Locosoft_GC.LOCOSOFT.dbo.order_positions.estimated_outbound_time], Datum/Uhrzeit) Spalte: Order Print Date ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_print_date], Datum/Uhrzeit) Spalte: Order Taking Employee No ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_taking_employee_no], Zahl) Spalte: Order Delivery Employee No ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_delivery_employee_no], Zahl) Spalte: Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions.vehicle_number], Zahl) Spalte: Order Mileage ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_mileage], Zahl) Spalte: Order Customer ([Locosoft_GC.LOCOSOFT.dbo.order_positions.order_customer], Zahl) Spalte: Paying Customer ([Locosoft_GC.LOCOSOFT.dbo.order_positions.paying_customer], Zahl) Spalte: Holder Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions.holder_number], Zahl) Spalte: Parts Rebate Group Sell ([Locosoft_GC.LOCOSOFT.dbo.order_positions.parts_rebate_group_sell], Zahl) Spalte: Clearing Delay Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions.clearing_delay_type], Zeichenkette) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.order_positions.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.order_positions.cdate], Datum/Uhrzeit) Ordner: Part Types Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.part_types.type], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.part_types.description], Zeichenkette) Ordner: Parts Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.parts.order_number], Zahl) Spalte: Order Position ([Locosoft_GC.LOCOSOFT.dbo.parts.order_position], Zahl) Spalte: Order Position Line ([Locosoft_GC.LOCOSOFT.dbo.parts.order_position_line], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.parts.subsidiary], Zahl) Spalte: Is Invoiced ([Locosoft_GC.LOCOSOFT.dbo.parts.is_invoiced], Zeichenkette) Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.parts.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.parts.invoice_number], Zahl) Spalte: Employee No ([Locosoft_GC.LOCOSOFT.dbo.parts.employee_no], Zahl) Spalte: Mechanic No ([Locosoft_GC.LOCOSOFT.dbo.parts.mechanic_no], Zahl) Spalte: Part Number ([Locosoft_GC.LOCOSOFT.dbo.parts.part_number], Zeichenkette) Spalte: Stock No ([Locosoft_GC.LOCOSOFT.dbo.parts.stock_no], Zahl) Spalte: Stock Removal Date ([Locosoft_GC.LOCOSOFT.dbo.parts.stock_removal_date], Datum) Spalte: Amount ([Locosoft_GC.LOCOSOFT.dbo.parts.amount], Zahl) Spalte: Sum ([Locosoft_GC.LOCOSOFT.dbo.parts.sum], Zahl) Spalte: Rebate Percent ([Locosoft_GC.LOCOSOFT.dbo.parts.rebate_percent], Zahl) Spalte: Goodwill Percent ([Locosoft_GC.LOCOSOFT.dbo.parts.goodwill_percent], Zahl) Spalte: Parts Type ([Locosoft_GC.LOCOSOFT.dbo.parts.parts_type], Zahl) Spalte: Text Line ([Locosoft_GC.LOCOSOFT.dbo.parts.text_line], Zeichenkette) Ordner: Time Types Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.time_types.type], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.time_types.description], Zeichenkette) Ordner: Times Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.times.employee_number], Zahl) Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.times.order_number], Zahl) Spalte: Start Time ([Locosoft_GC.LOCOSOFT.dbo.times.start_time], Datum/Uhrzeit) Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.times.type], Zahl) Spalte: Order Positions ([Locosoft_GC.LOCOSOFT.dbo.times.order_positions], Zeichenkette) Spalte: End Time ([Locosoft_GC.LOCOSOFT.dbo.times.end_time], Datum/Uhrzeit) Spalte: Duration Minutes ([Locosoft_GC.LOCOSOFT.dbo.times.duration_minutes], Zahl) Spalte: Exact Duration Seconds ([Locosoft_GC.LOCOSOFT.dbo.times.exact_duration_seconds], Zahl) Ordner: Vehicle Bodys Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.vehicle_bodys.code], Zeichenkette) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.vehicle_bodys.description], Zeichenkette) Ordner: Year Calendar Spalte: Calendar Id ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.calendar_id], Zahl) Spalte: Date ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.date], Datum) Spalte: Day Off Declaration ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.day_off_declaration], Zahl) Spalte: Is School Holid ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.is_school_holid], Zeichenkette) Spalte: Is Public Holid ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.is_public_holid], Zeichenkette) Spalte: Day Note ([Locosoft_GC.LOCOSOFT.dbo.year_calendar.day_note], Zeichenkette) Ordner: Year Calendar Day Off Codes Spalte: Code ([Locosoft_GC.LOCOSOFT.dbo.year_calendar_day_off_codes.code], Zahl) Spalte: Description ([Locosoft_GC.LOCOSOFT.dbo.year_calendar_day_off_codes.description], Zeichenkette) Ordner: Year Calendar Subsidiary Mapping Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.year_calendar_subsidiary_mapping.subsidiary], Zahl) Spalte: Year ([Locosoft_GC.LOCOSOFT.dbo.year_calendar_subsidiary_mapping.year], Zahl) Spalte: Calendar Id ([Locosoft_GC.LOCOSOFT.dbo.year_calendar_subsidiary_mapping.calendar_id], Zahl) Ordner: Kontenrahmen Gc Struct Skr.ims Spalte: Konto Nr ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_NR], Zeichenkette) Spalte: Konto Bezeichnung ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_BEZEICHNUNG], Zeichenkette) Spalte: Konto Art ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_ART], Zeichenkette) Spalte: Kostenstelle ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KOSTENSTELLE], Zeichenkette) Spalte: Stk ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.STK], Zeichenkette) Spalte: Konto 1 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_1], Zeichenkette) Spalte: Konto 2 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_2], Zeichenkette) Spalte: Konto 3 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_3], Zeichenkette) Spalte: Konto 4 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_4], Zeichenkette) Spalte: Konto 5 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_5], Zeichenkette) Spalte: Ebene1 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE1], Zeichenkette) Spalte: Ebene2 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE2], Zeichenkette) Spalte: Ebene3 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE3], Zeichenkette) Spalte: Ebene4 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE4], Zeichenkette) Spalte: Ebene5 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE5], Zeichenkette) Spalte: Ebene6 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE6], Zeichenkette) Spalte: Ebene7 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE7], Zeichenkette) Spalte: Ebene8 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE8], Zeichenkette) Spalte: Ebene9 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE9], Zeichenkette) Spalte: Ebene10 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE10], Zeichenkette) Spalte: Ebene11 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE11], Zeichenkette) Spalte: Ebene12 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE12], Zeichenkette) Spalte: Ebene13 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE13], Zeichenkette) Spalte: Ebene14 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE14], Zeichenkette) Spalte: Ebene15 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE15], Zeichenkette) Spalte: Ebene16 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE16], Zeichenkette) Spalte: Ebene17 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE17], Zeichenkette) Spalte: Ebene18 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE18], Zeichenkette) Spalte: Ebene19 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE19], Zeichenkette) Spalte: Ebene20 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE20], Zeichenkette) Spalte: Ebene21 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE21], Zeichenkette) Spalte: Ebene22 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE22], Zeichenkette) Spalte: Ebene23 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE23], Zeichenkette) Spalte: Ebene24 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE24], Zeichenkette) Spalte: Ebene25 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE25], Zeichenkette) Spalte: Ebene26 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE26], Zeichenkette) Spalte: Ebene27 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE27], Zeichenkette) Spalte: Ebene28 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE28], Zeichenkette) Spalte: Ebene29 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE29], Zeichenkette) Spalte: Ebene30 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE30], Zeichenkette) Spalte: Ebene31 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE31], Zeichenkette) Spalte: Ebene32 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE32], Zeichenkette) Spalte: Ebene33 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE33], Zeichenkette) Spalte: Ebene34 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE34], Zeichenkette) Spalte: Ebene35 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE35], Zeichenkette) Spalte: Ebene36 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE36], Zeichenkette) Spalte: Ebene37 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE37], Zeichenkette) Spalte: Ebene38 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE38], Zeichenkette) Spalte: Ebene39 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE39], Zeichenkette) Spalte: Ebene40 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE40], Zeichenkette) Spalte: Ebene41 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE41], Zeichenkette) Spalte: Ebene42 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE42], Zeichenkette) Spalte: Ebene43 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE43], Zeichenkette) Spalte: Ebene44 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE44], Zeichenkette) Spalte: Ebene45 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE45], Zeichenkette) Spalte: Ebene46 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE46], Zeichenkette) Spalte: Ebene47 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE47], Zeichenkette) Spalte: Ebene48 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE48], Zeichenkette) Spalte: Ebene49 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE49], Zeichenkette) Spalte: Ebene50 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE50], Zeichenkette) Spalte: Ebene51 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE51], Zeichenkette) Spalte: Ebene52 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE52], Zeichenkette) Spalte: Ebene53 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE53], Zeichenkette) Spalte: Ebene54 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE54], Zeichenkette) Spalte: Ebene55 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE55], Zeichenkette) Spalte: Ebene56 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE56], Zeichenkette) Spalte: Ebene57 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE57], Zeichenkette) Spalte: Ebene58 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE58], Zeichenkette) Spalte: Ebene59 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE59], Zeichenkette) Spalte: Ebene60 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE60], Zeichenkette) Spalte: Ebene61 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE61], Zeichenkette) Spalte: Ebene62 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE62], Zeichenkette) Spalte: Ebene63 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE63], Zeichenkette) Spalte: Ebene64 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE64], Zeichenkette) Spalte: Ebene65 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE65], Zeichenkette) Spalte: Ebene66 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE66], Zeichenkette) Spalte: Ebene67 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE67], Zeichenkette) Spalte: Ebene68 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE68], Zeichenkette) Spalte: Ebene69 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE69], Zeichenkette) Spalte: Ebene70 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE70], Zeichenkette) Spalte: Ebene71 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE71], Zeichenkette) Spalte: Ebene72 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE72], Zeichenkette) Spalte: Ebene73 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE73], Zeichenkette) Spalte: Ebene74 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE74], Zeichenkette) Spalte: Ebene75 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE75], Zeichenkette) Spalte: Ebene76 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE76], Zeichenkette) Spalte: Ebene77 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE77], Zeichenkette) Spalte: Ebene78 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE78], Zeichenkette) Spalte: Ebene79 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE79], Zeichenkette) Spalte: Ebene80 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE80], Zeichenkette) Spalte: Ebene81 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE81], Zeichenkette) Spalte: Ebene82 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE82], Zeichenkette) Spalte: Ebene83 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE83], Zeichenkette) Spalte: Ebene84 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE84], Zeichenkette) Spalte: Ebene85 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE85], Zeichenkette) Spalte: Ebene86 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE86], Zeichenkette) Spalte: Ebene87 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE87], Zeichenkette) Spalte: Ebene88 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE88], Zeichenkette) Spalte: Ebene89 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE89], Zeichenkette) Spalte: Ebene90 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.EBENE90], Zeichenkette) Berechnung: Anzahl Stellen Konto Nr ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.Anzahl Stellen_Konto_Nr], Zahl) Spalte: Konto Art2 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_ART2], Zeichenkette) Spalte: Konto Art3 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_ART3], Zeichenkette) Spalte: Konto Nr2 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_NR2], Zeichenkette) Spalte: Konto ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.Konto], Zeichenkette) Spalte: Susa ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.Susa], Zeichenkette) Ordner: Ben Aw Order Number.ims Spalte: Order Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\ben_AW_Order_Number\.ims.order_number], Zahl) Spalte: Summe Duration Minutes ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\ben_AW_Order_Number\.ims.Summe_Duration_Minutes], Zahl) Ordner: Imvoice No Order No.ims Spalte: Order Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Imvoice_No_Order_No\.ims.order_number], Zahl) Spalte: Invoice Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Imvoice_No_Order_No\.ims.invoice_number], Zahl) Spalte: Invoice Type ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Imvoice_No_Order_No\.ims.invoice_type], Zahl) Berechnung: Invoice Number Nr.2 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Imvoice_No_Order_No\.ims.Invoice Number], Zeichenkette) Ordner: Invoices Gutschriften Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_number], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.subsidiary], Zahl) Spalte: Paying Customer ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.paying_customer], Zahl) Spalte: Order Customer ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.order_customer], Zahl) Spalte: Invoice Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_date], Datum) Spalte: Service Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.service_date], Datum) Spalte: Is Canceled ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.is_canceled], Zeichenkette) Spalte: Cancelation Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_number], Zahl) Spalte: Cancelation Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_date], Datum) Spalte: Cancelation Employee ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_employee], Zahl) Spalte: Is Own Vehicle ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.is_own_vehicle], Zeichenkette) Spalte: Is Credit ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.is_credit], Zeichenkette) Spalte: Credit Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.credit_invoice_type], Zahl) Spalte: Credit Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.credit_invoice_number], Zahl) Spalte: Odometer Reading ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.odometer_reading], Zahl) Spalte: Creating Employee ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.creating_employee], Zahl) Spalte: Internal Cost Account ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.internal_cost_account], Zahl) Spalte: Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.vehicle_number], Zahl) Spalte: Full Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_basevalue], Zahl) Spalte: Full Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_percentage], Zahl) Spalte: Full Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_value], Zahl) Spalte: Reduced Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_basevalue], Zahl) Spalte: Reduced Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_percentage], Zahl) Spalte: Reduced Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_value], Zahl) Spalte: Used Part Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.used_part_vat_value], Zahl) Spalte: Job Amount Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.job_amount_net], Zahl) Spalte: Job Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.job_amount_gross], Zahl) Spalte: Job Rebate ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.job_rebate], Zahl) Spalte: Part Amount Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.part_amount_net], Zahl) Spalte: Part Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.part_amount_gross], Zahl) Spalte: Part Rebate ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.part_rebate], Zahl) Spalte: Part Disposal ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.part_disposal], Zahl) Spalte: Total Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.total_gross], Zahl) Spalte: Total Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_Gutschriften.total_net], Zahl) Ordner: Skr Absatzkanal.ims Spalte: Ebene21 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE21], Zeichenkette) Spalte: Ebene22 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE22], Zeichenkette) Spalte: Ebene23 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE23], Zeichenkette) Spalte: Ebene24 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE24], Zeichenkette) Spalte: Ebene25 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE25], Zeichenkette) Spalte: Ebene26 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE26], Zeichenkette) Spalte: Ebene27 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE27], Zeichenkette) Spalte: Ebene28 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE28], Zeichenkette) Spalte: Ebene29 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE29], Zeichenkette) Spalte: Ebene30 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.EBENE30], Zeichenkette) Spalte: Absatzkanal ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.Absatzkanal], Zeichenkette) Ordner: Skr Kostenträger.ims Spalte: Ebene31 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE31], Zeichenkette) Spalte: Ebene32 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE32], Zeichenkette) Spalte: Ebene33 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE33], Zeichenkette) Spalte: Ebene34 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE34], Zeichenkette) Spalte: Ebene35 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE35], Zeichenkette) Spalte: Ebene36 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE36], Zeichenkette) Spalte: Ebene37 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE37], Zeichenkette) Spalte: Ebene38 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE38], Zeichenkette) Spalte: Ebene39 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE39], Zeichenkette) Spalte: Ebene40 ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.EBENE40], Zeichenkette) Spalte: Kostenträger Mit Bez ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.Kostenträger_mit_Bez], Zeichenkette) Spalte: Kostenträger ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.Kostenträger], Zeichenkette) Spalte: Ebene Marke ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Kostenträger\.ims.Ebene_Marke], Zeichenkette) Ordner: Customers Für Vehicle Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.customer_number], Zahl) Spalte: Is Supplier ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.is_supplier], Zeichenkette) Spalte: Is Natural Person ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.is_natural_person], Zeichenkette) Spalte: Is Dummy Customer ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.is_dummy_customer], Zeichenkette) Spalte: Salutation ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.salutation], Zeichenkette) Spalte: Name Prefix ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.name_prefix], Zeichenkette) Spalte: First Name ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.first_name], Zeichenkette) Spalte: Family Name ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.family_name], Zeichenkette) Spalte: Name Postfix ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.name_postfix], Zeichenkette) Spalte: Country Iso3166 Alpha2 ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.country_iso3166_alpha2], Zeichenkette) Spalte: Zip Code ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.zip_code], Zeichenkette) Spalte: Home City ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.home_city], Zeichenkette) Spalte: Home Street ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.home_street], Zeichenkette) Spalte: Parts Rebate Group Buy ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.parts_rebate_group_buy], Zahl) Spalte: Parts Rebate Group Sell ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.parts_rebate_group_sell], Zahl) Spalte: Rebate Labour Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.rebate_labour_percent], Zahl) Spalte: Rebate Material Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.rebate_material_percent], Zahl) Spalte: Rebate New Vehicles Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.rebate_new_vehicles_percent], Zahl) Spalte: Cash Discount Percent ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.cash_discount_percent], Zahl) Spalte: Vat Id Number ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.vat_id_number], Zeichenkette) Spalte: Birthday ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.birthday], Datum) Spalte: Last Contact ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.last_contact], Datum) Spalte: Created Date ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.created_date], Datum) Spalte: Created Employee No ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.created_employee_no], Zahl) Spalte: Updated Date ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.updated_date], Datum) Spalte: Updated Employee No ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.updated_employee_no], Zahl) Spalte: Name Updated Date ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.name_updated_date], Datum) Spalte: Name Updated Employee No ([Locosoft_GC.LOCOSOFT.dbo.customers_für_vehicle.name_updated_employee_no], Zahl) Ordner: Kontenrahmen Spalte: Konto Nr ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_Nr], Zeichenkette) Spalte: Konto Bezeichnung ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_Bezeichnung], Zeichenkette) Spalte: Konto Art ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_Art], Zeichenkette) Spalte: Kostenstelle ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Kostenstelle], Zeichenkette) Spalte: Stk ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.STK], Zeichenkette) Spalte: Konto 1 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_1], Zeichenkette) Spalte: Konto 2 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_2], Zeichenkette) Spalte: Konto 3 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_3], Zeichenkette) Spalte: Konto 4 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_4], Zeichenkette) Spalte: Konto 5 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_5], Zeichenkette) Spalte: Ebene1 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene1], Zeichenkette) Spalte: Ebene2 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene2], Zeichenkette) Spalte: Ebene3 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene3], Zeichenkette) Spalte: Ebene4 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene4], Zeichenkette) Spalte: Ebene5 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene5], Zeichenkette) Spalte: Ebene6 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene6], Zeichenkette) Spalte: Ebene7 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene7], Zeichenkette) Spalte: Ebene8 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene8], Zeichenkette) Spalte: Ebene9 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene9], Zeichenkette) Spalte: Ebene10 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene10], Zeichenkette) Spalte: Ebene11 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene11], Zeichenkette) Spalte: Ebene12 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene12], Zeichenkette) Spalte: Ebene13 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene13], Zeichenkette) Spalte: Ebene14 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene14], Zeichenkette) Spalte: Ebene15 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene15], Zeichenkette) Spalte: Ebene16 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene16], Zeichenkette) Spalte: Ebene17 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene17], Zeichenkette) Spalte: Ebene18 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene18], Zeichenkette) Spalte: Ebene19 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene19], Zeichenkette) Spalte: Ebene20 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene20], Zeichenkette) Spalte: Ebene21 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene21], Zeichenkette) Spalte: Ebene22 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene22], Zeichenkette) Spalte: Ebene23 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene23], Zeichenkette) Spalte: Ebene24 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene24], Zeichenkette) Spalte: Ebene25 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene25], Zeichenkette) Spalte: Ebene26 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene26], Zeichenkette) Spalte: Ebene27 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene27], Zeichenkette) Spalte: Ebene28 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene28], Zeichenkette) Spalte: Ebene29 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene29], Zeichenkette) Spalte: Ebene30 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene30], Zeichenkette) Spalte: Ebene31 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene31], Zeichenkette) Spalte: Ebene32 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene32], Zeichenkette) Spalte: Ebene33 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene33], Zeichenkette) Spalte: Ebene34 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene34], Zeichenkette) Spalte: Ebene35 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene35], Zeichenkette) Spalte: Ebene36 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene36], Zeichenkette) Spalte: Ebene37 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene37], Zeichenkette) Spalte: Ebene38 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene38], Zeichenkette) Spalte: Ebene39 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene39], Zeichenkette) Spalte: Ebene40 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene40], Zeichenkette) Spalte: Ebene41 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene41], Zeichenkette) Spalte: Ebene42 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene42], Zeichenkette) Spalte: Ebene43 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene43], Zeichenkette) Spalte: Ebene44 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene44], Zeichenkette) Spalte: Ebene45 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene45], Zeichenkette) Spalte: Ebene46 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene46], Zeichenkette) Spalte: Ebene47 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene47], Zeichenkette) Spalte: Ebene48 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene48], Zeichenkette) Spalte: Ebene49 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene49], Zeichenkette) Spalte: Ebene50 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene50], Zeichenkette) Spalte: Ebene51 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene51], Zeichenkette) Spalte: Ebene52 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene52], Zeichenkette) Spalte: Ebene53 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene53], Zeichenkette) Spalte: Ebene54 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene54], Zeichenkette) Spalte: Ebene55 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene55], Zeichenkette) Spalte: Ebene56 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene56], Zeichenkette) Spalte: Ebene57 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene57], Zeichenkette) Spalte: Ebene58 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene58], Zeichenkette) Spalte: Ebene59 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene59], Zeichenkette) Spalte: Ebene60 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene60], Zeichenkette) Spalte: Ebene61 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene61], Zeichenkette) Spalte: Ebene62 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene62], Zeichenkette) Spalte: Ebene63 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene63], Zeichenkette) Spalte: Ebene64 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene64], Zeichenkette) Spalte: Ebene65 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene65], Zeichenkette) Spalte: Ebene66 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene66], Zeichenkette) Spalte: Ebene67 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene67], Zeichenkette) Spalte: Ebene68 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene68], Zeichenkette) Spalte: Ebene69 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene69], Zeichenkette) Spalte: Ebene70 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene70], Zeichenkette) Spalte: Ebene71 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene71], Zeichenkette) Spalte: Ebene72 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene72], Zeichenkette) Spalte: Ebene73 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene73], Zeichenkette) Spalte: Ebene74 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene74], Zeichenkette) Spalte: Ebene75 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene75], Zeichenkette) Spalte: Ebene76 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene76], Zeichenkette) Spalte: Ebene77 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene77], Zeichenkette) Spalte: Ebene78 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene78], Zeichenkette) Spalte: Ebene79 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene79], Zeichenkette) Spalte: Ebene80 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene80], Zeichenkette) Spalte: Ebene81 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene81], Zeichenkette) Spalte: Ebene82 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene82], Zeichenkette) Spalte: Ebene83 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene83], Zeichenkette) Spalte: Ebene84 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene84], Zeichenkette) Spalte: Ebene85 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene85], Zeichenkette) Spalte: Ebene86 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene86], Zeichenkette) Spalte: Ebene87 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene87], Zeichenkette) Spalte: Ebene88 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene88], Zeichenkette) Spalte: Ebene89 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene89], Zeichenkette) Spalte: Ebene90 ([Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Ebene90], Zeichenkette) Ordner: Order Positions Fuer Serviceberater Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_number], Zahl) Spalte: Order Position ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_position], Zahl) Spalte: Labour Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.labour_type], Zeichenkette) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.subsidiary], Zahl) Spalte: Is Invoiced ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.is_invoiced], Zahl) Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.invoice_number], Zahl) Spalte: Order Date ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_date], Datum/Uhrzeit) Spalte: Estimated Inbound Time ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.estimated_inbound_time], Datum/Uhrzeit) Spalte: Estimated Outbound Time ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.estimated_outbound_time], Datum/Uhrzeit) Spalte: Order Print Date ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_print_date], Datum/Uhrzeit) Spalte: Order Taking Employee No ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_taking_employee_no], Zahl) Spalte: Order Delivery Employee No ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_delivery_employee_no], Zahl) Spalte: Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.vehicle_number], Zahl) Spalte: Order Mileage ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_mileage], Zahl) Spalte: Order Customer ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.order_customer], Zahl) Spalte: Paying Customer ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.paying_customer], Zahl) Spalte: Holder Number ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.holder_number], Zahl) Spalte: Parts Rebate Group Sell ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.parts_rebate_group_sell], Zahl) Spalte: Clearing Delay Type ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.clearing_delay_type], Zeichenkette) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.order_positions_fuer_Serviceberater.cdate], Datum/Uhrzeit) Ordner: Serviceberater Rechnung.ims Spalte: Invoice Type ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.invoice_type], Zahl) Spalte: Invoice Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.invoice_number], Zahl) Spalte: Order Taking Employee No ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.order_taking_employee_no], Zahl) Spalte: Order Delivery Employee No ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.order_delivery_employee_no], Zahl) Spalte: Invoice Type Invoice Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.invtype_invnr], Zeichenkette) Spalte: Employee Number ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.employee_number], Zahl) Spalte: Name ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.name], Zeichenkette) Spalte: Serviceberater ([C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.Serviceberater], Zeichenkette) Ordner: Order Positions Fuer Ben Aw Ordner: Employees Breaktimes Spalte: Is Latest Record ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.is_latest_record], Zahl) Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.employee_number], Zahl) Spalte: Validity Date ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.validity_date], Datum/Uhrzeit) Spalte: Dayofweek ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.dayofweek], Zahl) Spalte: Break Start ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.break_start], Zahl) Spalte: Break End ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.break_end], Zahl) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.cdate], Datum/Uhrzeit) Ordner: Employees Worktimes Spalte: Is Latest Record ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.is_latest_record], Zahl) Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.employee_number], Zahl) Spalte: Validity Date ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.validity_date], Datum/Uhrzeit) Spalte: Dayofweek ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.dayofweek], Zahl) Spalte: Work Duration ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.work_duration], Zahl) Spalte: Worktime Start ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.worktime_start], Zahl) Spalte: Worktime End ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.worktime_end], Zahl) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.cdate], Datum/Uhrzeit) Ordner: Times Für Lg Monteure Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.employee_number], Zahl) Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.order_number], Zahl) Spalte: Start Time ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.start_time], Datum/Uhrzeit) Spalte: Type ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.type], Zahl) Spalte: Order Positions ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.order_positions], Zeichenkette) Spalte: End Time ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.end_time], Datum/Uhrzeit) Spalte: Duration Minutes ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.duration_minutes], Zahl) Spalte: Exact Duration Seconds ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.exact_duration_seconds], Zahl) Spalte: Mdate ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.mdate], Datum/Uhrzeit) Spalte: Cdate ([Locosoft_GC.LOCOSOFT.dbo.times_für_LG_Monteure.cdate], Datum/Uhrzeit) Ordner: Invoices Neu Spalte: Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.invoice_type], Zahl) Spalte: Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.invoice_number], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.subsidiary], Zahl) Spalte: Order Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.order_number], Zahl) Spalte: Paying Customer ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.paying_customer], Zahl) Spalte: Order Customer ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.order_customer], Zahl) Spalte: Invoice Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.invoice_date], Datum/Uhrzeit) Spalte: Service Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.service_date], Datum/Uhrzeit) Spalte: Is Canceled ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.is_canceled], Zahl) Spalte: Cancelation Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.cancelation_number], Zahl) Spalte: Cancelation Date ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.cancelation_date], Datum/Uhrzeit) Spalte: Cancelation Employee ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.cancelation_employee], Zahl) Spalte: Is Own Vehicle ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.is_own_vehicle], Zahl) Spalte: Is Credit ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.is_credit], Zahl) Spalte: Credit Invoice Type ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.credit_invoice_type], Zahl) Spalte: Credit Invoice Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.credit_invoice_number], Zahl) Spalte: Odometer Reading ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.odometer_reading], Zahl) Spalte: Creating Employee ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.creating_employee], Zahl) Spalte: Internal Cost Account ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.internal_cost_account], Zahl) Spalte: Vehicle Number ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.vehicle_number], Zahl) Spalte: Full Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.full_vat_basevalue], Zahl) Spalte: Full Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.full_vat_percentage], Zahl) Spalte: Full Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.full_vat_value], Zahl) Spalte: Reduced Vat Basevalue ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.reduced_vat_basevalue], Zahl) Spalte: Reduced Vat Percentage ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.reduced_vat_percentage], Zahl) Spalte: Reduced Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.reduced_vat_value], Zahl) Spalte: Used Part Vat Value ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.used_part_vat_value], Zahl) Spalte: Job Amount Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.job_amount_net], Zahl) Spalte: Job Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.job_amount_gross], Zahl) Spalte: Job Rebate ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.job_rebate], Zahl) Spalte: Part Amount Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.part_amount_net], Zahl) Spalte: Part Amount Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.part_amount_gross], Zahl) Spalte: Part Rebate ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.part_rebate], Zahl) Spalte: Part Disposal ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.part_disposal], Zahl) Spalte: Total Gross ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.total_gross], Zahl) Spalte: Total Net ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.total_net], Zahl) Spalte: Invtype Invnr ([Locosoft_GC.LOCOSOFT.dbo.Invoices_neu.invtype_invnr], Zeichenkette) Ordner: Employees Fuer Serviceberater Spalte: Employee Number ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.employee_number], Zahl) Spalte: Validity Date ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.validity_date], Datum/Uhrzeit) Spalte: Is Latest Record ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.is_latest_record], Zahl) Spalte: Subsidiary ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.subsidiary], Zahl) Spalte: Has Constant Salary ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.has_constant_salary], Zahl) Spalte: Name ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.name], Zeichenkette) Spalte: Initials ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.initials], Zeichenkette) Spalte: Customer Number ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.customer_number], Zahl) Spalte: Mechanic Number ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.mechanic_number], Zahl) Spalte: Salesman Number ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.salesman_number], Zahl) Spalte: Is Business Executive ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.is_business_executive], Zahl) Spalte: Is Master Craftsman ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.is_master_craftsman], Zahl) Spalte: Employment Date ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.employment_date], Datum/Uhrzeit) Spalte: Termination Date ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.termination_date], Datum/Uhrzeit) Spalte: Leave Date ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.leave_date], Datum/Uhrzeit) Spalte: Is Flextime ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.is_flextime], Zahl) Spalte: Break Time Registration ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.break_time_registration], Zeichenkette) Spalte: Productivity Factor ([Locosoft_GC.LOCOSOFT.dbo.employees_fuer_serviceberater.productivity_factor], Zahl) Ordner: Offene Auftraege Ums Ben Aw Fuer Monteure.ims Spalte: Order Number ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile\\offene_Auftraege_Ums_ben_AW_fuer_Monteure\.ims.order_number], Zahl) Berechnung: Order Number Nr.2 ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile\\offene_Auftraege_Ums_ben_AW_fuer_Monteure\.ims.Order Number], Zeichenkette) Berechnung: Verk. Std. Aus O.a. ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile\\offene_Auftraege_Ums_ben_AW_fuer_Monteure\.ims.verk\. Std\. aus o\.A\.], Zahl) Ordner: Current Date Fuer Ims.ims Spalte: Bundeslaender Id ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.bundeslaender_id], Zeichenkette) Spalte: Datum ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.datum], Datum/Uhrzeit) Spalte: Wochentage Id ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.wochentage_id], Zeichenkette) Spalte: Arbeitstag Mofr ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.arbeitstag_mofr], Zahl) Spalte: Zaehler Mofr ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.zaehler_mofr], Zahl) Spalte: Summe Mofr ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.summe_mofr], Zahl) Spalte: Arbeitstag Mosa ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.arbeitstag_mosa], Zahl) Spalte: Zaehler Mosa ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.zaehler_mosa], Zahl) Spalte: Summe Mosa ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.summe_mosa], Zahl) Spalte: Feiertage Id ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.feiertage_id], Zahl) Spalte: Jahr ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.Jahr], Datum) Berechnung: Arbeitstag Nr Jahr ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.Arbeitstag Nr Jahr], Zahl) Berechnung: Gesamt Arbeitstage ([C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Belege\\current_date_fuer_ims\.ims.Gesamt Arbeitstage], Zahl) Tabellenverbindungen: nominal_accounts - journal_accountings: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.nominal_account_number] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.nominal_account_number] UND [Locosoft_GC.LOCOSOFT.dbo.nominal_accounts.subsidiary_to_company_ref] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref] order_positions - labour_types: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.labour_type] = [Locosoft_GC.LOCOSOFT.dbo.labour_types.code] order_positions - labours: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.order_number] = [Locosoft_GC.LOCOSOFT.dbo.labours.order_number] order_positions - parts: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.order_number] = [Locosoft_GC.LOCOSOFT.dbo.parts.order_number] parts - part_types: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.parts.parts_type] = [Locosoft_GC.LOCOSOFT.dbo.part_types.type] employees - times: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] = [Locosoft_GC.LOCOSOFT.dbo.times.employee_number] times - time_types: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.times.type] = [Locosoft_GC.LOCOSOFT.dbo.time_types.type] employees - absence_calendar: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] = [Locosoft_GC.LOCOSOFT.dbo.absence_calendar.employee_number] absence_calendar - absence_reasons: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.absence_calendar.reason] = [Locosoft_GC.LOCOSOFT.dbo.absence_reasons.id] absence_calendar - absence_types: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.absence_calendar.type] = [Locosoft_GC.LOCOSOFT.dbo.absence_types.type] labours - employees: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.labours.mechanic_no] = [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] labours - invoices: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.labours.invoice_number] = [Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_number] UND [Locosoft_GC.LOCOSOFT.dbo.labours.invoice_type] = [Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_type] invoice_types - invoices: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.invoice_types.type] = [Locosoft_GC.LOCOSOFT.dbo.invoices.invoice_type] invoices - journal_accountings: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.invoice_number] = [Locosoft_GC.LOCOSOFT.dbo.invoices.invtype_invnr] invoices - employees: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.invoices.creating_employee] = [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] customers_suppliers - invoices: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.customer_number] = [Locosoft_GC.LOCOSOFT.dbo.invoices.paying_customer] invoices - vehicles: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.invoices.vehicle_number] = [Locosoft_GC.LOCOSOFT.dbo.vehicles.internal_number] vehicles - makes: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.vehicles.make_number] = [Locosoft_GC.LOCOSOFT.dbo.makes.make_number] vehicles - models: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.vehicles.make_number] = [Locosoft_GC.LOCOSOFT.dbo.models.make_number] UND [Locosoft_GC.LOCOSOFT.dbo.vehicles.model_code] = [Locosoft_GC.LOCOSOFT.dbo.models.model_code] labours - times: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.labours.order_number] = [Locosoft_GC.LOCOSOFT.dbo.times.order_number] labours - C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Serv_Teile\ben_AW_Order_Number.ims: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.labours.order_number] = [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\ben_AW_Order_Number\.ims.order_number] journal_accountings - C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Serv_Teile\Imvoice_No_Order_No.ims: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.document_number] = ZEICHENKETTE-IN-ZAHL ( [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Imvoice_No_Order_No\.ims.Invoice Number] ) C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Belege\SKR_Absatzkanal.ims - journal_accountings: Rechte offene Verbindung ZEICHENKETTE-IN-ZAHL ( [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\SKR_Absatzkanal\.ims.Absatzkanal] ) = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel] customers_für_vehicle - vehicles: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.customers_suppliers.customer_number] = [Locosoft_GC.LOCOSOFT.dbo.vehicles.holder_number] journal_accountings - Kontenrahmen: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.nominal_account_number] = ZEICHENKETTE-IN-GANZZAHL ( [Locosoft_GC.LOCOSOFT.dbo.Kontenrahmen.Konto_Nr] ) order_positions_fuer_Serviceberater - employees: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.order_taking_employee_no] = [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] invoices - C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Serv_Teile\Serviceberater_Rechnung.ims: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.invoices.invtype_invnr] = [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Serv_Teile\\Serviceberater_Rechnung\.ims.invtype_invnr] employees - employees_breaktimes: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] = [Locosoft_GC.LOCOSOFT.dbo.employees_breaktimes.employee_number] employees - employees_worktimes: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] = [Locosoft_GC.LOCOSOFT.dbo.employees_worktimes.employee_number] labours - times_für_LG_Monteure: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.labours.order_number] = [Locosoft_GC.LOCOSOFT.dbo.times.order_number] UND [Locosoft_GC.LOCOSOFT.dbo.labours.mechanic_no] = [Locosoft_GC.LOCOSOFT.dbo.times.employee_number] times_für_LG_Monteure - employees: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.times.employee_number] = [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] accounts_characteristics - journal_accountings: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_branch] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_branch] UND [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_make] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_make] UND [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_cost_center] UND [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel] UND [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit] UND [Locosoft_GC.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref] = [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref] journal_accountings - C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Belege\Kontenrahmen_GC_Struct_SKR.ims: Geschlossene Verbindung [Locosoft_GC.LOCOSOFT.dbo.journal_accountings.nominal_account_number] = ZEICHENKETTE-IN-GANZZAHL ( [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_NR] ) charge_types - labours: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.charge_types.type] = [Locosoft_GC.LOCOSOFT.dbo.labours.charge_type] charge_type_descriptions - labours: Rechte offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.charge_type_descriptions.type] = [Locosoft_GC.LOCOSOFT.dbo.labours.charge_type] order_positions_fuer_Serviceberater - invoices: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.order_number] = [Locosoft_GC.LOCOSOFT.dbo.invoices.order_number] order_positions_fuer_Serviceberater - employees_fuer_serviceberater: Linke offene Verbindung [Locosoft_GC.LOCOSOFT.dbo.order_positions.order_taking_employee_no] = [Locosoft_GC.LOCOSOFT.dbo.employees.employee_number] C:\GlobalCube\System\LOCOSOFT\IQD\Serv_Teile\offene_Auftraege_Ums_ben_AW_fuer_Monteure.ims - times: Rechte offene Verbindung [C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile.C:\\GlobalCube\\System\\LOCOSOFT\\IQD\\Serv_Teile\\offene_Auftraege_Ums_ben_AW_fuer_Monteure\.ims.order_number] = [Locosoft_GC.LOCOSOFT.dbo.times.order_number] '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