TecDoc 2019Q2
Table of changes in the database schema
Table name | New table name | Column name | New column name | Reason for changes | Additional information |
---|---|---|---|---|---|
ART_LOOKUP_LINKS | — | — | — | Deleting a table | Data moved to table ART_LOOKUP |
ART_TRADE_NUMBERS | — | — | — | Deleting a table | Data moved to table ART_LOOKUP |
ART_OEM_NUMBERS | — | — | — | Deleting a table | Data moved to table ART_LOOKUP |
ART_EAN_NUMBERS | — | — | — | Deleting a table | Data moved to table ART_LOOKUP |
STR_FAMILY_TREE | — | — | — | Adding a table | The table contains information about all ancestors for non-root nodes of the category tree SEARCH_TREE. |
ART_LOOKUP | — | — | Adding column | The article number in the 7-Bit ASCII (with the exception of control characters and TAB) format. | |
— | — | Adding column | Index for the country restriction. Reference to the , if it is equal to 1 — then there is no country restriction. | ||
— | — | Adding column | Brand index, referenced to the table field, for more details click . | ||
— | — | Adding column | Brand name, referenced to the table field | ||
— | — | Adding column | A flag that is indicated to show the number on the search page or on the page with detailed information about the article. Only for trade numbers. | ||
— | — | Adding column | A key for the table with the Reference Information for the OEM number. Reference to the with the </code> = 270. | ||
— | — | Adding column | The flag that indicates whether this number (article) is used together with the article to which it refers.().
For example like repairing-sets (sealing kits) with the head gasket and etc. |
||
— | — | Deleting a column | — | ||
MANUFACTURERS | — | — | Adding column | Manufacturer ID, refers to the table field |
Other changes
From the table PASSENGER_CARS and LINK_LA_TYP all the passenger cars that are no longer part of the TecDoc data pool are deleted from the table. Such passenger cars did not have a list of countries for the field PASSENGER_CARS.PC_CTM in the table COUNTRY_RESTRICTIONS.CNTR_ID.
Removed duplicate text for table SEARCH_TREE.
In the table ART_MEDIA_INFO for the field ART_MEDIA_INFO.ART_MEDIA_HIPPERLINK added a full links to articles photos and pdf-documents (these links are relevant 1 quarter) on TecAlliance servers.
In the tables DES_TEXTS, TEXT_DESIGNATIONS, TEXT_MODULE_TEXTS added text information in Russian and Romanian from the TecDoc 2018Q2 database.
For the table field ART_LOOKUP.ARL_KIND changed data types for the article numbers:
-
- = 1 — Article Number;
- = 2 — Trade Number;
- = 3 — OE number;
- = 4 — Comparable Number;
- = 5 — EAN;
Описание TecDoc Catalogue
For the unlimited access, a valid license/ subscription is required (via in-app purchase or online: https://solutions.tecalliance.net/)Mobile spare part identification on a new level: Our completely new and modern mobile version of the TecDoc Catalogue 3.0 enables workshops, distributors, sellers and car owners worldwide to search & identify automotive spare parts more convenient and efficient than ever!No matter HOW you are searching…• Via Product – by simply scanning a barcode or entering a part number, an OE number or the EAN code• Via Vehicle – by scanning or entering the VIN or via search tree. A License plate search is available for certain regions as a third party service.… you will receive full article details including relevant pictures/ documents, parts criteria, linkages to other vehicles and manufacturer information — based on the comprehensive TecDoc Catalogue Database which includes the original manufacturer data of more than 700 aftermarket brands, 6.6 millions of article descriptions and product images.By subscription purchase you get unlimited access to our data and catalogue functions, which will be updated and enlarged via monthly updates by us.Subscription (including monthly data updates)• via in-app-purchase; Payment will be charged to your Store Account at confirmation of purchase• Your subscription automatically renews unless auto-renew is turned off at least 24 hours before the end of the current period; Account will be charged for renewal within 24-hours prior to the end of the current period, and identify the cost of the renewal; the counter-order of an existing subscription is excludedIn order to keep you well informed, the app contains links to all TecAlliance social media channels such as YouTube, Facebook, Xing, LinkedIn etc.
Показать больше
-
Категория
Автомобили и автомобили
-
Требования:
Android 4.1+
TecDoc Catalogue 1.8.18 APK для Android 4.1+
Версия | 1.8.18 для Android 4.1+ |
Обновить | 2022-05-25 |
Устанавливает | 10.000++ |
Размер файла | 23.501.881 bytes |
Разрешения | |
Какие новости | The following version contains the implementation of a new numberplate scanner for selected numberplate searches. |
История версий:
-
1. LATEST.
TecDoc Catalogue 1.8.18 APK
(2022-05-25, 22 MB)
-
2.
TecDoc Catalogue 1.7.95 APK
(2021-12-11, 22 MB)
-
3.
TecDoc Catalogue 1.7.76 APK
(2021-10-31, 22 MB)
-
4.
TecDoc Catalogue 1.7.67 APK
(2021-10-02, 22 MB)
-
5.
TecDoc Catalogue 1.7.16 APK
(2021-04-23, 25 MB)
-
6.
TecAlliance TecDoc Catalogue 1.7.8 APK
(2021-03-06, 25 MB)
-
7.
TecAlliance TecDoc Catalogue 1.6.11 APK
(2020-11-20, 25 MB)
-
8.
TecAlliance TecDoc Catalogue 1.6.7 APK
(2020-11-06, 25 MB)
-
9.
TecAlliance TecDoc Catalogue 1.6.5 APK
(2020-06-26, 17 MB)
Показать больше
TecDoc 2019Q1
Table of changes in the database schema
Table name | New table name | Column name | New column name | Reason for changes | Additional information |
---|---|---|---|---|---|
ART_META_INFO | — | — | Adding column | A flag indicating whether the article is a Service Exchange Part. | |
ARTICLES | — | — | Adding column | Supplier brand name for article, reference to the . | |
ART_MEDIA_INFO | — | — | Adding column | Image ordinal position. |
Other changes
- Duplicates were returned to the table TEXT_DESIGNATIONS for accurate text identification.
- Added missing image names for GIF files( = 3) in table ART_MEDIA_INFO.
- In the field of the table , the register of file names is given to the register of actual images file names. This should fix the problem on *nix systems, in which file names are case-sensitive (for example, «.jpg» ! = «.JPG»).
- Changes data type from to the for table fields:
TecDoc 2018Q4
Table of changes in the database schema
Table name | New table name | Column name | New column name | Reason for changes | Additional information |
---|---|---|---|---|---|
ARTICLES | — | — | Adding column | Field with product group name(PRODUCTS.PT_DES_ID). | |
ART_REP_NUM | — | — | — | Deleting a table | Replaced by table SUPERSEDED_ARTICLES |
TEXT_MODULES | — | — | — | Deleting a table | Table duplicated the features of the table TEXT_MODULE_TEXTS. |
ARTICLE_INFO | — | A column name changed | Now the field points to the field. | ||
LA_INFO | — | A column name changed | Now the field points to field. | ||
SUPERSEDED_ARTICLES | — | — | — | Adding a table | Table with outdated(superseded) articles that have been replaced by new ones. |
Other changes
In the table PRODUCTS left only records, that have links to articles(ARTICLES).
- Removed duplicates in the tables:
- TEXT_DESIGNATIONS
- ARTICLE_INFO
- LA_INFO
- TEXT_MODULE_TEXTS
In the table ART_COUNTRY_SPECIFICS deleted default records (ART_COUNTRY_SPECIFICS.ACS_COU_ID = 255), for articles intended only for certain countries.
Fixed the data type for the field LINK_LA_TYP.LAT_TYPE, from TINYINT to the SMALLINT. Field value of the LINK_LA_TYP.LAT_TYPE for the motorbikes MOTORBIKES changed from the 255 to 777.
TecDoc 2018Q2
Table of changes in the database schema
Table name | New table name | Column name | New column name | Reason for changes | Additional information |
---|---|---|---|---|---|
ART_OEM_NUMBERS | — | REF_KV_KT_ID | — | Deleting a column | This field has a static value of 270 (KT 270). |
ART_COUNTRY_SPECIFICS | — | ACS_STATUS_KV_KT_ID | — | Deleting a column | This field has a static value of 73(KT 073). |
Other changes
for articles images. In order to update articles images from TecDoc 2018Q1 to TecDoc 2018Q2 you do not need to download all the images for TecDoc 2018Q2 anymore. All customers who purchased articles images for TecDoc 2018Q1 will be provided only a relevent changes in the articles images for TecDoc 2018Q2 in comparison with TecDoc 2018Q1.
Fixed incorrect values for the ART_LOOKUP_LINKS.ALL_KIND field.
TecDoc 2018Q1.02
Table of changes in the database schema
Table name | New table name | Column name | New column name | Reason for changes | Additional information |
---|---|---|---|---|---|
ART_MEDIA_INFO | — | — | — | Adding a table | The table was returned due to the non-uniqueness of the graphics file ID in the TecDoc database, and because of that there is no way to build the binding of the graphic file through tables LINK_GRA_ART и GRAPHICS |
— | — | Adding column | Standardised graphic header, point to the field with the field that always equal to the 141(KT 141) | ||
— | — | Deleting a column | Descriptions of the type of graphic file can be obtained using the field | ||
ART_PL_PIC_DATA | — | A column name changed | Reference to | ||
SENSITIVE_COORDINATES | — | A column name changed | Reference to | ||
LINK_GRA_LA | — | A column name changed | Reference to | ||
LINK_GRA_ART | — | — | — | Deleting a table | All links between articles and graphic files again located in the table ART_MEDIA_INFO |
GRAPHICS | — | — | — | Deleting a table | All links between articles and graphic files again located in the table ART_MEDIA_INFO |
Other changes
Fixed problem with empty field ART_MEDIA_INFO.ART_MEDIA_HIPPERLINK for the URL-links.
Fixed problem with invalid field values ARTICLE_INFO.AIN_PT_ID.