123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305 |
- Kataloginformationen
- Katalog-Dateiname: C:\GlobalCube\System\LOCOSOFT\Catalogs\Locosoft_operativ_NW_GW_VK.cat
- Beschreibung:
- Datenbankinformationen
- Datenbankname: GC_LOCOSOFT
- Verbindungszeichenkette: DSN=GC_LOCOSOFT;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=
- Datenbankstruktur
- Table: accounts_characteristics
- Spalte: skr51_branch (longint)
- Spalte: skr51_make (longint)
- Spalte: skr51_cost_center (longint)
- Spalte: skr51_sales_channel (longint)
- Spalte: skr51_cost_unit (longint)
- Spalte: skr51_brach_name (varchar)
- Spalte: skr51_make_description (varchar)
- Spalte: skr51_cost_center_name (varchar)
- Spalte: skr51_sales_channel_name (varchar)
- Spalte: skr51_cost_unit_name (varchar)
- 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)
- 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)
- 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)
- 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: 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)
- 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: time_units (decimal)
- Spalte: net_price_in_order (decimal)
- Spalte: rebate_percent (decimal)
- Spalte: goodwill_percent (decimal)
- Spalte: charge_type (int)
- Spalte: text_line (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)
- 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)
- 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)
- 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: employees_Salesmen
- 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)
- Katalogordner
- Ordner: Accounts Characteristics
- Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch], Zahl)
- Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make], Zahl)
- Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center], Zahl)
- Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel], Zahl)
- Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit], Zahl)
- Spalte: Skr51 Brach Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_brach_name], Zeichenkette)
- Spalte: Skr51 Make Description ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make_description], Zeichenkette)
- Spalte: Skr51 Cost Center Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center_name], Zeichenkette)
- Spalte: Skr51 Sales Channel Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel_name], Zeichenkette)
- Spalte: Skr51 Cost Unit Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit_name], Zeichenkette)
- Ordner: Customers Suppliers
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number], Zahl)
- Spalte: Is Supplier ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_supplier], Zeichenkette)
- Spalte: Is Natural Person ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_natural_person], Zeichenkette)
- Spalte: Name Prefix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_prefix], Zeichenkette)
- Spalte: First Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.first_name], Zeichenkette)
- Spalte: Family Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.family_name], Zeichenkette)
- Spalte: Name Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_postfix], Zeichenkette)
- Spalte: Country Iso3166 Alpha2 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.country_iso3166_alpha2], Zeichenkette)
- Spalte: Zip Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.zip_code], Zeichenkette)
- Spalte: Home City ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.home_city], Zeichenkette)
- Spalte: Parts Rebate Group Buy ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_buy], Zahl)
- Spalte: Parts Rebate Group Sell ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_sell], Zahl)
- Spalte: Rebate Labour Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_labour_percent], Zahl)
- Spalte: Rebate Material Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_material_percent], Zahl)
- Spalte: Rebate New Vehicles Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_new_vehicles_percent], Zahl)
- Spalte: Cash Discount Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.cash_discount_percent], Zahl)
- Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.vat_id_number], Zeichenkette)
- Ordner: Document Types
- Spalte: Document Type In Journal ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_in_journal], Zeichenkette)
- Spalte: Document Type Description ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_description], Zeichenkette)
- Ordner: Journal Accountings
- Spalte: Accounting Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.accounting_date], Datum)
- Spalte: Document Type ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_type], Zeichenkette)
- Spalte: Document Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_number], Zahl)
- Spalte: Position In Document ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.position_in_document], Zahl)
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_number], Zahl)
- Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number], Zahl)
- Spalte: Is Balanced ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.is_balanced], Zeichenkette)
- Spalte: Clearing Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.clearing_number], Zahl)
- Spalte: Document Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_date], Datum)
- Spalte: Posted Value ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_value], Zahl)
- Spalte: Debit Or Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.debit_or_credit], Zeichenkette)
- Spalte: Posted Count ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_count], Zahl)
- Spalte: Branch Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.branch_number], Zahl)
- Spalte: Customer Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_contra_account], Zahl)
- Spalte: Nominal Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_contra_account], Zahl)
- Spalte: Contra Account Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.contra_account_text], Zeichenkette)
- Spalte: Account Form Page Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_number], Zahl)
- Spalte: Account Form Page Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_line], Zahl)
- Spalte: Serial Number Each Month ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.serial_number_each_month], Zahl)
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.employee_number], Zahl)
- Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_date], Datum)
- Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_number], Zeichenkette)
- Spalte: Dunning Level ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.dunning_level], Zeichenkette)
- Spalte: Last Dunning Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.last_dunning_date], Datum)
- Spalte: Journal Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_page], Zahl)
- Spalte: Journal Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_line], Zahl)
- Spalte: Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.cash_discount], Zahl)
- Spalte: Term Of Payment ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.term_of_payment], Zahl)
- Spalte: Posting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posting_text], Zeichenkette)
- Spalte: Vehicle Reference ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vehicle_reference], Zeichenkette)
- Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_id_number], Zeichenkette)
- Spalte: Account Statement Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_number], Zahl)
- Spalte: Account Statement Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_page], Zahl)
- Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_key], Zeichenkette)
- Spalte: Days For Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.days_for_cash_discount], Zahl)
- Spalte: Day Of Actual Accounting ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.day_of_actual_accounting], Datum)
- Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch], Zahl)
- Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make], Zahl)
- Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center], Zahl)
- Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel], Zahl)
- Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit], Zahl)
- Spalte: Previously Used Account No ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.previously_used_account_no], Zeichenkette)
- Spalte: Free Form Accounting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_accounting_text], Zeichenkette)
- Spalte: Free Form Document Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_document_text], Zeichenkette)
- Ordner: Nominal Accounts
- Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number], Zahl)
- Spalte: Account Description ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.account_description], Zeichenkette)
- Spalte: Is Profit Loss Account ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.is_profit_loss_account], Zeichenkette)
- Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.vat_key], Zeichenkette)
- Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_date], Datum)
- Spalte: Create Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_employee_number], Zahl)
- Spalte: Oldest Accountable Month ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.oldest_accountable_month], Datum)
- Ordner: Parts Rebate Groups Buy
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.code], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.description], Zeichenkette)
- Ordner: Parts Rebate Groups Sell
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.code], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.description], Zeichenkette)
- Ordner: Vat Keys
- Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_key], Zeichenkette)
- Spalte: Key Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.key_validity_date], Datum)
- Spalte: Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.branch], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.description], Zeichenkette)
- Spalte: Vat Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_rate], Zahl)
- Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.create_date], Datum)
- Spalte: Vat Account ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_account], Zahl)
- Spalte: Advanced Turnover Tax Pos ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.advanced_turnover_tax_pos], Zahl)
- Ordner: Employees
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.employee_number], Zahl)
- Spalte: Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.validity_date], Datum)
- Spalte: Is Latest Record ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.is_latest_record], Zeichenkette)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.subsidiary], Zahl)
- Spalte: Has Constant Salary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.has_constant_salary], Zeichenkette)
- Spalte: Name ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.name], Zeichenkette)
- Spalte: Initials ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.initials], Zeichenkette)
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.customer_number], Zahl)
- Spalte: Mechanic Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.mechanic_number], Zahl)
- Spalte: Salesman Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.salesman_number], Zahl)
- Spalte: Is Business Executive ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.is_business_executive], Zeichenkette)
- Spalte: Is Master Craftsman ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.is_master_craftsman], Zeichenkette)
- Spalte: Employment Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.employment_date], Datum)
- Spalte: Termination Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.termination_date], Datum)
- Spalte: Leave Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees.leave_date], Datum)
- Ordner: Vehicles
- Spalte: Internal Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.internal_number], Zahl)
- Spalte: Vin ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.vin], Zeichenkette)
- Spalte: License Plate ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.license_plate], Zeichenkette)
- Spalte: License Plate Country ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.license_plate_country], Zeichenkette)
- Spalte: License Plate Season ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.license_plate_season], Zeichenkette)
- Spalte: Make Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.make_number], Zahl)
- Spalte: Free Form Make Text ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.free_form_make_text], Zeichenkette)
- Spalte: Model Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.model_code], Zeichenkette)
- Spalte: Free Form Model Text ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.free_form_model_text], Zeichenkette)
- Spalte: Is Roadworthy ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.is_roadworthy], Zeichenkette)
- Spalte: Is Customer Vehicle ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.is_customer_vehicle], Zeichenkette)
- Spalte: Dealer Vehicle Type ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.dealer_vehicle_type], Zeichenkette)
- Spalte: Dealer Vehicle Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.dealer_vehicle_number], Zahl)
- Spalte: First Registration Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.first_registration_date], Datum)
- Spalte: Readmission Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.readmission_date], Datum)
- Spalte: Next Service Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_service_date], Datum)
- Spalte: Next Service Km ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_service_km], Zahl)
- Spalte: Next Service Miles ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_service_miles], Zahl)
- Spalte: Production Year ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.production_year], Zahl)
- Spalte: Owner Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.owner_number], Zahl)
- Spalte: Holder Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.holder_number], Zahl)
- Spalte: Previous Owner Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.previous_owner_number], Zahl)
- Spalte: Previous Owner Counter ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.previous_owner_counter], Zahl)
- Spalte: Last Holder Change Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.last_holder_change_date], Datum)
- Spalte: German Kba Hsn ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.german_kba_hsn], Zeichenkette)
- Spalte: German Kba Tsn ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.german_kba_tsn], Zeichenkette)
- Spalte: Austria Nat Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.austria_nat_code], Zeichenkette)
- Spalte: Is Prefer Km ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.is_prefer_km], Zeichenkette)
- Spalte: Mileage Km ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.mileage_km], Zahl)
- Spalte: Mileage Miles ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.mileage_miles], Zahl)
- Spalte: Odometer Reading Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.odometer_reading_date], Datum)
- Spalte: Engine Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.engine_number], Zeichenkette)
- Spalte: Gear Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.gear_number], Zeichenkette)
- Spalte: Unloaded Weight ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.unloaded_weight], Zahl)
- Spalte: Gross Vehicle Weight ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.gross_vehicle_weight], Zahl)
- Spalte: Power Kw ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.power_kw], Zahl)
- Spalte: Cubic Capacity ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.cubic_capacity], Zahl)
- Spalte: Is All Accidents Repaired ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.is_all_accidents_repaired], Zeichenkette)
- Spalte: Accidents Counter ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.accidents_counter], Zahl)
- Spalte: Has Tyre Pressure Sensor ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.has_tyre_pressure_sensor], Zeichenkette)
- Spalte: Carkey Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.carkey_number], Zeichenkette)
- Spalte: Internal Source Flag ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.internal_source_flag], Zeichenkette)
- Spalte: Emission Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.emission_code], Zeichenkette)
- Spalte: First Sold Country ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.first_sold_country], Zeichenkette)
- Spalte: First Sold Dealer Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.first_sold_dealer_code], Zahl)
- Spalte: Body Paint Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.body_paint_code], Zeichenkette)
- Spalte: Body Paint Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.body_paint_description], Zeichenkette)
- Spalte: Is Body Paint Metallic ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.is_body_paint_metallic], Zeichenkette)
- Spalte: Interior Paint Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.interior_paint_code], Zeichenkette)
- Spalte: Interior Paint Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.interior_paint_description], Zeichenkette)
- Spalte: Trim Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.trim_code], Zeichenkette)
- Spalte: Trim Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.trim_description], Zeichenkette)
- Spalte: Fine Dust Label ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.fine_dust_label], Zeichenkette)
- Spalte: Internal Assignment ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.internal_assignment], Zeichenkette)
- Spalte: Ricambi Free Input ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.ricambi_free_input], Zeichenkette)
- Spalte: Document Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.document_number], Zeichenkette)
- Spalte: Salesman Number ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.salesman_number], Zahl)
- Spalte: Sale Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.sale_date], Datum)
- Spalte: Next Emission Test Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_emission_test_date], Datum)
- Spalte: Next General Inspection Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_general_inspection_date], Datum)
- Spalte: Next Rust Inspection Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_rust_inspection_date], Datum)
- Spalte: Next Exceptional Inspection Da ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.next_exceptional_inspection_da], Datum)
- Spalte: Last Change Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.last_change_date], Datum)
- Spalte: Last Change Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.last_change_employee_no], Zahl)
- Spalte: Created Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.created_date], Datum)
- Spalte: Created Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.created_employee_no], Zahl)
- Spalte: Last Change Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.last_change_subsidiary], Zahl)
- Ordner: Absence Calendar
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.employee_number], Zahl)
- Spalte: Date ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.date], Datum)
- Spalte: Unique Dummy ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.unique_dummy], Zahl)
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.type], Zeichenkette)
- Spalte: Is Payed ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.is_payed], Zeichenkette)
- Spalte: Day Contingent ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.day_contingent], Zahl)
- Spalte: Reason ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.reason], Zeichenkette)
- Spalte: Booking Flag ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.booking_flag], Zeichenkette)
- Ordner: Absence Reasons
- Spalte: Id ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_reasons.id], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_reasons.description], Zeichenkette)
- Spalte: Is Annual Vacation ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_reasons.is_annual_vacation], Zeichenkette)
- Ordner: Absence Types
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_types.type], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.absence_types.description], Zeichenkette)
- Ordner: Charge Type Descriptions
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_type_descriptions.type], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_type_descriptions.description], Zeichenkette)
- Ordner: Charge Types
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_types.type], Zahl)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_types.subsidiary], Zahl)
- Spalte: Timeunit Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_types.timeunit_rate], Zahl)
- Spalte: Department ([GC_LOCOSOFT.LOCOSOFT.dbo.charge_types.department], Zahl)
- Ordner: Com Number Types
- Spalte: Typ ([GC_LOCOSOFT.LOCOSOFT.dbo.com_number_types.typ], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.com_number_types.description], Zeichenkette)
- Spalte: Is Office Number ([GC_LOCOSOFT.LOCOSOFT.dbo.com_number_types.is_office_number], Zeichenkette)
- Ordner: Customer Codes
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_codes.code], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_codes.description], Zeichenkette)
- Ordner: Customer Com Numbers
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.customer_number], Zahl)
- Spalte: Counter ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.counter], Zahl)
- Spalte: Com Type ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.com_type], Zeichenkette)
- Spalte: Is Reference ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.is_reference], Zeichenkette)
- Spalte: Is From 1st Tab ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.is_from_1st_tab], Zeichenkette)
- Spalte: Address ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.address], Zeichenkette)
- Spalte: Has Contact Person Fields ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.has_contact_person_fields], Zeichenkette)
- Spalte: Contact Salutation ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.contact_salutation], Zeichenkette)
- Spalte: Contact Firstname ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.contact_firstname], Zeichenkette)
- Spalte: Contact Lastname ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.contact_lastname], Zeichenkette)
- Spalte: Contact Description ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.contact_description], Zeichenkette)
- Spalte: Note ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_com_numbers.note], Zeichenkette)
- Ordner: Customer To Customercodes
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_to_customercodes.customer_number], Zahl)
- Spalte: Customer Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customer_to_customercodes.customer_code], Zahl)
- Ordner: Employees History
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.employee_number], Zahl)
- Spalte: Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.validity_date], Datum)
- Spalte: Is Latest Record ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.is_latest_record], Zeichenkette)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.subsidiary], Zahl)
- Spalte: Has Constant Salary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.has_constant_salary], Zeichenkette)
- Spalte: Name ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.name], Zeichenkette)
- Spalte: Initials ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.initials], Zeichenkette)
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.customer_number], Zahl)
- Spalte: Mechanic Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.mechanic_number], Zahl)
- Spalte: Salesman Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.salesman_number], Zahl)
- Spalte: Is Business Executive ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.is_business_executive], Zeichenkette)
- Spalte: Is Master Craftsman ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.is_master_craftsman], Zeichenkette)
- Spalte: Employment Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.employment_date], Datum)
- Spalte: Termination Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.termination_date], Datum)
- Spalte: Leave Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_history.leave_date], Datum)
- Ordner: Fuels
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.fuels.code], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.fuels.description], Zeichenkette)
- Ordner: Invoice Types
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.invoice_types.type], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.invoice_types.description], Zeichenkette)
- Ordner: Invoices
- Spalte: Invoice Type ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_type], Zahl)
- Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_number], Zahl)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.subsidiary], Zahl)
- Spalte: Paying Customer ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.paying_customer], Zahl)
- Spalte: Order Customer ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.order_customer], Zahl)
- Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_date], Datum)
- Spalte: Service Date ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.service_date], Datum)
- Spalte: Is Canceled ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.is_canceled], Zeichenkette)
- Spalte: Cancelation Number ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.cancelation_number], Zahl)
- Spalte: Cancelation Date ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.cancelation_date], Datum)
- Spalte: Cancelation Employee ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.cancelation_employee], Zahl)
- Spalte: Is Own Vehicle ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.is_own_vehicle], Zeichenkette)
- Spalte: Is Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.is_credit], Zeichenkette)
- Spalte: Credit Invoice Type ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.credit_invoice_type], Zahl)
- Spalte: Credit Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.credit_invoice_number], Zahl)
- Spalte: Odometer Reading ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.odometer_reading], Zahl)
- Spalte: Creating Employee ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.creating_employee], Zahl)
- Spalte: Internal Cost Account ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.internal_cost_account], Zahl)
- Spalte: Vehicle Number ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.vehicle_number], Zahl)
- Spalte: Full Vat Basevalue ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.full_vat_basevalue], Zahl)
- Spalte: Full Vat Percentage ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.full_vat_percentage], Zahl)
- Spalte: Full Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.full_vat_value], Zahl)
- Spalte: Reduced Vat Basevalue ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.reduced_vat_basevalue], Zahl)
- Spalte: Reduced Vat Percentage ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.reduced_vat_percentage], Zahl)
- Spalte: Reduced Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.reduced_vat_value], Zahl)
- Spalte: Used Part Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.used_part_vat_value], Zahl)
- Spalte: Job Amount Net ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.job_amount_net], Zahl)
- Spalte: Job Amount Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.job_amount_gross], Zahl)
- Spalte: Job Rebate ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.job_rebate], Zahl)
- Spalte: Part Amount Net ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.part_amount_net], Zahl)
- Spalte: Part Amount Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.part_amount_gross], Zahl)
- Spalte: Part Rebate ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.part_rebate], Zahl)
- Spalte: Part Disposal ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.part_disposal], Zahl)
- Spalte: Total Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.total_gross], Zahl)
- Spalte: Total Net ([GC_LOCOSOFT.LOCOSOFT.dbo.invoices.total_net], Zahl)
- Ordner: Labour Types
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.labour_types.code], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.labour_types.description], Zeichenkette)
- Ordner: Labours
- Spalte: Order Number ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_number], Zahl)
- Spalte: Order Position ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_position], Zahl)
- Spalte: Order Position Line ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_position_line], Zahl)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.subsidiary], Zahl)
- Spalte: Is Invoiced ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.is_invoiced], Zeichenkette)
- Spalte: Invoice Type ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.invoice_type], Zahl)
- Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.invoice_number], Zahl)
- Spalte: Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.employee_no], Zahl)
- Spalte: Mechanic No ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.mechanic_no], Zahl)
- Spalte: Labour Operation Id ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.labour_operation_id], Zeichenkette)
- Spalte: Is Nominal ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.is_nominal], Zeichenkette)
- Spalte: Time Units ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.time_units], Zahl)
- Spalte: Net Price In Order ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.net_price_in_order], Zahl)
- Spalte: Rebate Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.rebate_percent], Zahl)
- Spalte: Goodwill Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.goodwill_percent], Zahl)
- Spalte: Charge Type ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.charge_type], Zahl)
- Spalte: Text Line ([GC_LOCOSOFT.LOCOSOFT.dbo.labours.text_line], Zeichenkette)
- Ordner: Makes
- Spalte: Make Number ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.make_number], Zahl)
- Spalte: Is Actual Make ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_actual_make], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.description], Zeichenkette)
- Spalte: Group Name ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.group_name], Zeichenkette)
- Spalte: Make Id In Group ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.make_id_in_group], Zeichenkette)
- Spalte: Internal Labour Group ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.internal_labour_group], Zahl)
- Spalte: Is Production Year Visible ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_production_year_visible], Zeichenkette)
- Spalte: Is Transmission No Visible ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_transmission_no_visible], Zeichenkette)
- Spalte: Is Engine No Visible ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_engine_no_visible], Zeichenkette)
- Spalte: Is Ricambi No Visible ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_ricambi_no_visible], Zeichenkette)
- Spalte: Ricambi Label ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.ricambi_label], Zeichenkette)
- Spalte: Is Preset Finance Stock Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.is_preset_finance_stock_rate], Zeichenkette)
- Spalte: Rate Free Days New Vehicle ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.rate_free_days_new_vehicle], Zahl)
- Spalte: Rate Free Days Demo Vehicle ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.rate_free_days_demo_vehicle], Zahl)
- Spalte: Special Service 2 Interval ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.special_service_2_interval], Zahl)
- Spalte: Special Service 3 Interval ([GC_LOCOSOFT.LOCOSOFT.dbo.makes.special_service_3_interval], Zahl)
- Ordner: Model To Fuels
- Spalte: Make Number ([GC_LOCOSOFT.LOCOSOFT.dbo.model_to_fuels.make_number], Zahl)
- Spalte: Model Code ([GC_LOCOSOFT.LOCOSOFT.dbo.model_to_fuels.model_code], Zeichenkette)
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.model_to_fuels.code], Zeichenkette)
- Ordner: Models
- Spalte: Make Number ([GC_LOCOSOFT.LOCOSOFT.dbo.models.make_number], Zahl)
- Spalte: Model Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.model_code], Zeichenkette)
- Spalte: Is Actual Model ([GC_LOCOSOFT.LOCOSOFT.dbo.models.is_actual_model], Zeichenkette)
- Spalte: Model Currently Available ([GC_LOCOSOFT.LOCOSOFT.dbo.models.model_currently_available], Zeichenkette)
- Spalte: Replacing Model Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.replacing_model_code], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.models.description], Zeichenkette)
- Spalte: Gear Count ([GC_LOCOSOFT.LOCOSOFT.dbo.models.gear_count], Zahl)
- Spalte: Seat Count ([GC_LOCOSOFT.LOCOSOFT.dbo.models.seat_count], Zahl)
- Spalte: Door Count ([GC_LOCOSOFT.LOCOSOFT.dbo.models.door_count], Zahl)
- Spalte: Cylinder Count ([GC_LOCOSOFT.LOCOSOFT.dbo.models.cylinder_count], Zahl)
- Spalte: Vehicle Body ([GC_LOCOSOFT.LOCOSOFT.dbo.models.vehicle_body], Zeichenkette)
- Spalte: Model Labour Group ([GC_LOCOSOFT.LOCOSOFT.dbo.models.model_labour_group], Zeichenkette)
- Spalte: Has Hour Meter ([GC_LOCOSOFT.LOCOSOFT.dbo.models.has_hour_meter], Zeichenkette)
- Spalte: Source Extern ([GC_LOCOSOFT.LOCOSOFT.dbo.models.source_extern], Zeichenkette)
- Spalte: Free Form Vehicle Class ([GC_LOCOSOFT.LOCOSOFT.dbo.models.free_form_vehicle_class], Zeichenkette)
- Spalte: Vin Begin ([GC_LOCOSOFT.LOCOSOFT.dbo.models.vin_begin], Zeichenkette)
- Spalte: Vehicle Pool Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.vehicle_pool_code], Zeichenkette)
- Spalte: Vehicle Pool Engine Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.vehicle_pool_engine_code], Zeichenkette)
- Spalte: Is Manual Transmission ([GC_LOCOSOFT.LOCOSOFT.dbo.models.is_manual_transmission], Zeichenkette)
- Spalte: Is All Wheel Drive ([GC_LOCOSOFT.LOCOSOFT.dbo.models.is_all_wheel_drive], Zeichenkette)
- Spalte: Is Plugin Hybride ([GC_LOCOSOFT.LOCOSOFT.dbo.models.is_plugin_hybride], Zeichenkette)
- Spalte: Unloaded Weight ([GC_LOCOSOFT.LOCOSOFT.dbo.models.unloaded_weight], Zahl)
- Spalte: Gross Vehicle Weight ([GC_LOCOSOFT.LOCOSOFT.dbo.models.gross_vehicle_weight], Zahl)
- Spalte: Power Kw ([GC_LOCOSOFT.LOCOSOFT.dbo.models.power_kw], Zahl)
- Spalte: Power Kw At Rotation ([GC_LOCOSOFT.LOCOSOFT.dbo.models.power_kw_at_rotation], Zahl)
- Spalte: Cubic Capacity ([GC_LOCOSOFT.LOCOSOFT.dbo.models.cubic_capacity], Zahl)
- Spalte: German Kba Hsn ([GC_LOCOSOFT.LOCOSOFT.dbo.models.german_kba_hsn], Zeichenkette)
- Spalte: German Kba Tsn ([GC_LOCOSOFT.LOCOSOFT.dbo.models.german_kba_tsn], Zeichenkette)
- Spalte: Annual Tax ([GC_LOCOSOFT.LOCOSOFT.dbo.models.annual_tax], Zahl)
- Spalte: Model Year ([GC_LOCOSOFT.LOCOSOFT.dbo.models.model_year], Zahl)
- Spalte: Model Year Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.models.model_year_postfix], Zeichenkette)
- Spalte: Suggested Net Retail Price ([GC_LOCOSOFT.LOCOSOFT.dbo.models.suggested_net_retail_price], Zahl)
- Spalte: Suggested Net Shipping Cost ([GC_LOCOSOFT.LOCOSOFT.dbo.models.suggested_net_shipping_cost], Zahl)
- Spalte: European Pollutant Class ([GC_LOCOSOFT.LOCOSOFT.dbo.models.european_pollutant_class], Zeichenkette)
- Spalte: Efficiency Class ([GC_LOCOSOFT.LOCOSOFT.dbo.models.efficiency_class], Zeichenkette)
- Spalte: Emission Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.emission_code], Zeichenkette)
- Spalte: Carbondioxid Emission ([GC_LOCOSOFT.LOCOSOFT.dbo.models.carbondioxid_emission], Zahl)
- Spalte: Nox Exhoust ([GC_LOCOSOFT.LOCOSOFT.dbo.models.nox_exhoust], Zahl)
- Spalte: Particle Exhoust ([GC_LOCOSOFT.LOCOSOFT.dbo.models.particle_exhoust], Zahl)
- Spalte: External Schwacke Code ([GC_LOCOSOFT.LOCOSOFT.dbo.models.external_schwacke_code], Zeichenkette)
- Spalte: Skr Carrier Flag ([GC_LOCOSOFT.LOCOSOFT.dbo.models.skr_carrier_flag], Zahl)
- Spalte: Free Form Model Specification ([GC_LOCOSOFT.LOCOSOFT.dbo.models.free_form_model_specification], Zeichenkette)
- Spalte: External Technical Type ([GC_LOCOSOFT.LOCOSOFT.dbo.models.external_technical_type], Zeichenkette)
- Spalte: European Fuel Consumption Over ([GC_LOCOSOFT.LOCOSOFT.dbo.models.european_fuel_consumption_over], Zahl)
- Spalte: European Fuel Consumption Coun ([GC_LOCOSOFT.LOCOSOFT.dbo.models.european_fuel_consumption_coun], Zahl)
- Spalte: European Fuel Consumption City ([GC_LOCOSOFT.LOCOSOFT.dbo.models.european_fuel_consumption_city], Zahl)
- Spalte: Energy Consumption ([GC_LOCOSOFT.LOCOSOFT.dbo.models.energy_consumption], Zahl)
- Spalte: Insurance Class Liability ([GC_LOCOSOFT.LOCOSOFT.dbo.models.insurance_class_liability], Zahl)
- Spalte: Insurance Class Part Comprehen ([GC_LOCOSOFT.LOCOSOFT.dbo.models.insurance_class_part_comprehen], Zahl)
- Spalte: Insurance Class Full Comprehen ([GC_LOCOSOFT.LOCOSOFT.dbo.models.insurance_class_full_comprehen], Zahl)
- Ordner: Order Positions
- Spalte: Order Number ([GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_number], Zahl)
- Spalte: Order Position ([GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_position], Zahl)
- Spalte: Labour Type ([GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.labour_type], Zeichenkette)
- Ordner: Part Types
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.part_types.type], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.part_types.description], Zeichenkette)
- Ordner: Parts
- Spalte: Order Number ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.order_number], Zahl)
- Spalte: Order Position ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.order_position], Zahl)
- Spalte: Order Position Line ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.order_position_line], Zahl)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.subsidiary], Zahl)
- Spalte: Is Invoiced ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.is_invoiced], Zeichenkette)
- Spalte: Invoice Type ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.invoice_type], Zahl)
- Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.invoice_number], Zahl)
- Spalte: Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.employee_no], Zahl)
- Spalte: Mechanic No ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.mechanic_no], Zahl)
- Spalte: Part Number ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.part_number], Zeichenkette)
- Spalte: Stock No ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.stock_no], Zahl)
- Spalte: Stock Removal Date ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.stock_removal_date], Datum)
- Spalte: Amount ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.amount], Zahl)
- Spalte: Sum ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.sum], Zahl)
- Spalte: Rebate Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.rebate_percent], Zahl)
- Spalte: Goodwill Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.goodwill_percent], Zahl)
- Spalte: Parts Type ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.parts_type], Zahl)
- Spalte: Text Line ([GC_LOCOSOFT.LOCOSOFT.dbo.parts.text_line], Zeichenkette)
- Ordner: Time Types
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.time_types.type], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.time_types.description], Zeichenkette)
- Ordner: Times
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.times.employee_number], Zahl)
- Spalte: Order Number ([GC_LOCOSOFT.LOCOSOFT.dbo.times.order_number], Zahl)
- Spalte: Start Time ([GC_LOCOSOFT.LOCOSOFT.dbo.times.start_time], Datum/Uhrzeit)
- Spalte: Type ([GC_LOCOSOFT.LOCOSOFT.dbo.times.type], Zahl)
- Spalte: Order Positions ([GC_LOCOSOFT.LOCOSOFT.dbo.times.order_positions], Zeichenkette)
- Spalte: End Time ([GC_LOCOSOFT.LOCOSOFT.dbo.times.end_time], Datum/Uhrzeit)
- Spalte: Duration Minutes ([GC_LOCOSOFT.LOCOSOFT.dbo.times.duration_minutes], Zahl)
- Ordner: Vehicle Bodys
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicle_bodys.code], Zeichenkette)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vehicle_bodys.description], Zeichenkette)
- Ordner: Year Calendar
- Spalte: Calendar Id ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.calendar_id], Zahl)
- Spalte: Date ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.date], Datum)
- Spalte: Day Off Declaration ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.day_off_declaration], Zahl)
- Spalte: Is School Holid ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.is_school_holid], Zeichenkette)
- Spalte: Is Public Holid ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.is_public_holid], Zeichenkette)
- Spalte: Day Note ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar.day_note], Zeichenkette)
- Ordner: Year Calendar Day Off Codes
- Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar_day_off_codes.code], Zahl)
- Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar_day_off_codes.description], Zeichenkette)
- Ordner: Year Calendar Subsidiary Mapping
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar_subsidiary_mapping.subsidiary], Zahl)
- Spalte: Year ([GC_LOCOSOFT.LOCOSOFT.dbo.year_calendar_subsidiary_mapping.year], Zahl)
- Spalte: Calendar Id ([GC_LOCOSOFT.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 ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_type], Zahl)
- Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_number], Zahl)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.subsidiary], Zahl)
- Spalte: Paying Customer ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.paying_customer], Zahl)
- Spalte: Order Customer ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.order_customer], Zahl)
- Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.invoice_date], Datum)
- Spalte: Service Date ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.service_date], Datum)
- Spalte: Is Canceled ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.is_canceled], Zeichenkette)
- Spalte: Cancelation Number ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_number], Zahl)
- Spalte: Cancelation Date ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_date], Datum)
- Spalte: Cancelation Employee ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.cancelation_employee], Zahl)
- Spalte: Is Own Vehicle ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.is_own_vehicle], Zeichenkette)
- Spalte: Is Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.is_credit], Zeichenkette)
- Spalte: Credit Invoice Type ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.credit_invoice_type], Zahl)
- Spalte: Credit Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.credit_invoice_number], Zahl)
- Spalte: Odometer Reading ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.odometer_reading], Zahl)
- Spalte: Creating Employee ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.creating_employee], Zahl)
- Spalte: Internal Cost Account ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.internal_cost_account], Zahl)
- Spalte: Vehicle Number ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.vehicle_number], Zahl)
- Spalte: Full Vat Basevalue ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_basevalue], Zahl)
- Spalte: Full Vat Percentage ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_percentage], Zahl)
- Spalte: Full Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.full_vat_value], Zahl)
- Spalte: Reduced Vat Basevalue ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_basevalue], Zahl)
- Spalte: Reduced Vat Percentage ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_percentage], Zahl)
- Spalte: Reduced Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.reduced_vat_value], Zahl)
- Spalte: Used Part Vat Value ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.used_part_vat_value], Zahl)
- Spalte: Job Amount Net ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.job_amount_net], Zahl)
- Spalte: Job Amount Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.job_amount_gross], Zahl)
- Spalte: Job Rebate ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.job_rebate], Zahl)
- Spalte: Part Amount Net ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.part_amount_net], Zahl)
- Spalte: Part Amount Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.part_amount_gross], Zahl)
- Spalte: Part Rebate ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.part_rebate], Zahl)
- Spalte: Part Disposal ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.part_disposal], Zahl)
- Spalte: Total Gross ([GC_LOCOSOFT.LOCOSOFT.dbo.Invoices_Gutschriften.total_gross], Zahl)
- Spalte: Total Net ([GC_LOCOSOFT.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 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.customer_number], Zahl)
- Spalte: Is Supplier ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.is_supplier], Zeichenkette)
- Spalte: Is Natural Person ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.is_natural_person], Zeichenkette)
- Spalte: Is Dummy Customer ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.is_dummy_customer], Zeichenkette)
- Spalte: Salutation ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.salutation], Zeichenkette)
- Spalte: Name Prefix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.name_prefix], Zeichenkette)
- Spalte: First Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.first_name], Zeichenkette)
- Spalte: Family Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.family_name], Zeichenkette)
- Spalte: Name Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.name_postfix], Zeichenkette)
- Spalte: Country Iso3166 Alpha2 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.country_iso3166_alpha2], Zeichenkette)
- Spalte: Zip Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.zip_code], Zeichenkette)
- Spalte: Home City ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.home_city], Zeichenkette)
- Spalte: Home Street ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.home_street], Zeichenkette)
- Spalte: Parts Rebate Group Buy ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.parts_rebate_group_buy], Zahl)
- Spalte: Parts Rebate Group Sell ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.parts_rebate_group_sell], Zahl)
- Spalte: Rebate Labour Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.rebate_labour_percent], Zahl)
- Spalte: Rebate Material Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.rebate_material_percent], Zahl)
- Spalte: Rebate New Vehicles Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.rebate_new_vehicles_percent], Zahl)
- Spalte: Cash Discount Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.cash_discount_percent], Zahl)
- Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.vat_id_number], Zeichenkette)
- Spalte: Birthday ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.birthday], Datum)
- Spalte: Last Contact ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.last_contact], Datum)
- Spalte: Created Date ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.created_date], Datum)
- Spalte: Created Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.created_employee_no], Zahl)
- Spalte: Updated Date ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.updated_date], Datum)
- Spalte: Updated Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.updated_employee_no], Zahl)
- Spalte: Name Updated Date ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.name_updated_date], Datum)
- Spalte: Name Updated Employee No ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_für_vehicle.name_updated_employee_no], Zahl)
- Ordner: Employees Salesmen
- Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.employee_number], Zahl)
- Spalte: Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.validity_date], Datum)
- Spalte: Is Latest Record ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.is_latest_record], Zeichenkette)
- Spalte: Subsidiary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.subsidiary], Zahl)
- Spalte: Has Constant Salary ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.has_constant_salary], Zeichenkette)
- Spalte: Name ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.name], Zeichenkette)
- Spalte: Initials ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.initials], Zeichenkette)
- Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.customer_number], Zahl)
- Spalte: Mechanic Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.mechanic_number], Zahl)
- Spalte: Salesman Number ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.salesman_number], Zahl)
- Spalte: Is Business Executive ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.is_business_executive], Zeichenkette)
- Spalte: Is Master Craftsman ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.is_master_craftsman], Zeichenkette)
- Spalte: Employment Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.employment_date], Datum)
- Spalte: Termination Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.termination_date], Datum)
- Spalte: Leave Date ([GC_LOCOSOFT.LOCOSOFT.dbo.employees_Salesmen.leave_date], Datum)
- Ordner: Vehicles Test
- Ordner: Nominal Accounts Test
- Tabellenverbindungen:
- nominal_accounts - journal_accountings: Geschlossene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number]
- order_positions - labour_types: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.labour_type] = [GC_LOCOSOFT.LOCOSOFT.dbo.labour_types.code]
- order_positions - labours: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_position] = [GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_position]
- order_positions - parts: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.parts.order_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.order_positions.order_position] = [GC_LOCOSOFT.LOCOSOFT.dbo.parts.order_position]
- parts - part_types: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.parts.parts_type] = [GC_LOCOSOFT.LOCOSOFT.dbo.part_types.type]
- employees - times: Geschlossene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.employees.employee_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.times.employee_number]
- times - time_types: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.times.type] = [GC_LOCOSOFT.LOCOSOFT.dbo.time_types.type]
- employees - absence_calendar: Geschlossene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.employees.employee_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.employee_number]
- absence_calendar - absence_reasons: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.reason] = [GC_LOCOSOFT.LOCOSOFT.dbo.absence_reasons.id]
- absence_calendar - absence_types: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.absence_calendar.type] = [GC_LOCOSOFT.LOCOSOFT.dbo.absence_types.type]
- labours - employees: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.labours.mechanic_no] = [GC_LOCOSOFT.LOCOSOFT.dbo.employees.employee_number]
- labours - invoices: Rechte offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.labours.invoice_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.labours.invoice_type] = [GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_type]
- invoice_types - invoices: Rechte offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.invoice_types.type] = [GC_LOCOSOFT.LOCOSOFT.dbo.invoices.invoice_type]
- C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Belege\Kontenrahmen_GC_Struct_SKR.ims - journal_accountings: Rechte offene Verbindung
- ZEICHENKETTE-IN-ZAHL ( [C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege.C:\\GlobalCube\\System\\LOCOSOFT\\Catalogs\\\.\.\\IQD\\Belege\\Kontenrahmen_GC_Struct_SKR\.ims.KONTO_NR] ) = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number]
- invoices - employees: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.invoices.creating_employee] = [GC_LOCOSOFT.LOCOSOFT.dbo.employees.employee_number]
- customers_suppliers - invoices: Rechte offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.invoices.paying_customer]
- vehicles - makes: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.make_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.makes.make_number]
- vehicles - models: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.make_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.models.make_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.model_code] = [GC_LOCOSOFT.LOCOSOFT.dbo.models.model_code]
- labours - times: Geschlossene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.labours.order_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.times.order_number]
- labours - C:\GlobalCube\System\LOCOSOFT\Catalogs\..\IQD\Serv_Teile\ben_AW_Order_Number.ims: Geschlossene Verbindung
- [GC_LOCOSOFT.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]
- 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] ) = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel]
- customers_für_vehicle - vehicles: Rechte offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.holder_number]
- vehicles - journal_accountings: Geschlossene Verbindung
- LINKS ( [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vehicle_reference]; 8 ) = [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.dealer_vehicle_type] + ZAHL-IN-ZEICHENKETTE ( [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.dealer_vehicle_number] )
- vehicles - employees_Salesmen: Linke offene Verbindung
- [GC_LOCOSOFT.LOCOSOFT.dbo.vehicles.salesman_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.employees.salesman_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
|