Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Comment:
auto sync 2024-02-09T15:55:43+00:00
Name
EXPOS Merkmale (exmlntab)Tabellen-Typ / -Klasse
EXPOS / AllgemeinHaupt-Pflegedialog / -Liste
keineModul(e)
Bitte Module pflegen (Entwickler/TB11)!Beschreibung
Bitte Beschreibung pflegen (Entwickler/TB11)!Felder
Feld | Typ | Bezeichnung | Beschreibung |
---|---|---|---|
finr | INTEGER(4) | Mandant | Syslog verwaltet bis zu 999 Mandanten und trennt deren Datenbestände über die Mandanten-Nr. Diese wird in allen Datenbank-Tabellen als erstes Feld geführt. Beim Login entscheidet sich der Sachbearbeiter für einen einzigen Mandanten, in dem gearbeitet wird. |
artnr | CHAR(20) | Artikel-Nr. | Eindeutiger Ident eines Artikels. Innerhalb der Stückliste bezeichnet dieses Feld die Baugruppe. |
klasse | CHAR(20) | Merkmalsklasse | |
prklasse | CHAR(20) | Produktklasse | EXPOS - Produktklasse Zeichenkette darf nur aus Buchstaben von A-Z, a-z sowie Zahlen bestehen, wobei das erste Zeichen keine Zahl sein darf. |
mk001 | CHAR(20) | mk001 | |
mk002 | CHAR(20) | mk002 | |
mk003 | CHAR(20) | mk003 | |
mk004 | CHAR(20) | mk004 | |
mk005 | CHAR(20) | mk005 | |
mk006 | CHAR(20) | mk006 | |
mk007 | CHAR(20) | mk007 | |
mk008 | CHAR(20) | mk008 | |
mk009 | CHAR(20) | mk009 | |
mk010 | CHAR(20) | mk010 | |
mk011 | CHAR(20) | mk011 | |
mk012 | CHAR(20) | mk012 | |
mk013 | CHAR(20) | mk013 | |
mk014 | CHAR(20) | mk014 | |
mk015 | CHAR(20) | mk015 | |
mk016 | CHAR(20) | mk016 | |
mk017 | CHAR(20) | mk017 | |
mk018 | CHAR(20) | mk018 | |
mk019 | CHAR(20) | mk019 | |
mk020 | CHAR(20) | mk020 | |
mk021 | CHAR(20) | mk021 | |
mk022 | CHAR(20) | mk022 | |
mk023 | CHAR(20) | mk023 | |
mk024 | CHAR(20) | mk024 | |
mk025 | CHAR(20) | mk025 | |
mk026 | CHAR(20) | mk026 | |
mk027 | CHAR(20) | mk027 | |
mk028 | CHAR(20) | mk028 | |
mk029 | CHAR(20) | mk029 | |
mk030 | CHAR(20) | mk030 | |
mk031 | CHAR(20) | mk031 | |
mk032 | CHAR(20) | mk032 | |
mk033 | CHAR(20) | mk033 | |
mk034 | CHAR(20) | mk034 | |
mk035 | CHAR(20) | mk035 | |
mk036 | CHAR(20) | mk036 | |
mk037 | CHAR(20) | mk037 | |
mk038 | CHAR(20) | mk038 | |
mk039 | CHAR(20) | mk039 | |
mk040 | CHAR(20) | mk040 | |
mk041 | CHAR(20) | mk041 | |
mk042 | CHAR(20) | mk042 | |
mk043 | CHAR(20) | mk043 | |
mk044 | CHAR(20) | mk044 | |
mk045 | CHAR(20) | mk045 | |
mk046 | CHAR(20) | mk046 | |
mk047 | CHAR(20) | mk047 | |
mk048 | CHAR(20) | mk048 | |
mk049 | CHAR(20) | mk049 | |
mk050 | CHAR(20) | mk050 | |
mk051 | CHAR(20) | mk051 | |
mk052 | CHAR(20) | mk052 | |
mk053 | CHAR(20) | mk053 | |
mk054 | CHAR(20) | mk054 | |
mk055 | CHAR(20) | mk055 | |
mk056 | CHAR(20) | mk056 | |
mk057 | CHAR(20) | mk057 | |
mk058 | CHAR(20) | mk058 | |
mk059 | CHAR(20) | mk059 | |
mk060 | CHAR(20) | mk060 | |
mk061 | CHAR(20) | mk061 | |
mk062 | CHAR(20) | mk062 | |
mk063 | CHAR(20) | mk063 | |
mk064 | CHAR(20) | mk064 | |
mk065 | CHAR(20) | mk065 | |
mk066 | CHAR(20) | mk066 | |
mk067 | CHAR(20) | mk067 | |
mk068 | CHAR(20) | mk068 | |
mk069 | CHAR(20) | mk069 | |
mk070 | CHAR(20) | mk070 | |
mk071 | CHAR(20) | mk071 | |
mk072 | CHAR(20) | mk072 | |
mk073 | CHAR(20) | mk073 | |
mk074 | CHAR(20) | mk074 | |
mk075 | CHAR(20) | mk075 | |
mk076 | CHAR(20) | mk076 | |
mk077 | CHAR(20) | mk077 | |
mk078 | CHAR(20) | mk078 | |
mk079 | CHAR(20) | mk079 | |
mk080 | CHAR(20) | mk080 | |
mk081 | CHAR(20) | mk081 | |
mk082 | CHAR(20) | mk082 | |
mk083 | CHAR(20) | mk083 | |
mk084 | CHAR(20) | mk084 | |
mk085 | CHAR(20) | mk085 | |
mk086 | CHAR(20) | mk086 | |
mk087 | CHAR(20) | mk087 | |
mk088 | CHAR(20) | mk088 | |
mk089 | CHAR(20) | mk089 | |
mk090 | CHAR(20) | mk090 | |
mk091 | CHAR(20) | mk091 | |
mk092 | CHAR(20) | mk092 | |
mk093 | CHAR(20) | mk093 | |
mk094 | CHAR(20) | mk094 | |
mk095 | CHAR(20) | mk095 | |
mk096 | CHAR(20) | mk096 | |
mk097 | CHAR(20) | mk097 | |
mk098 | CHAR(20) | mk098 | |
mk099 | CHAR(20) | mk099 | |
mk100 | CHAR(20) | mk100 | |
mkd001 | FLOAT(8) | mkd001 | |
mkd002 | FLOAT(8) | mkd002 | |
mkd003 | FLOAT(8) | mkd003 | |
mkd004 | FLOAT(8) | mkd004 | |
mkd005 | FLOAT(8) | mkd005 | |
mkd006 | FLOAT(8) | mkd006 | |
mkd007 | FLOAT(8) | mkd007 | |
mkd008 | FLOAT(8) | mkd008 | |
mkd009 | FLOAT(8) | mkd009 | |
mkd010 | FLOAT(8) | mkd010 | |
mkd011 | FLOAT(8) | mkd011 | |
mkd012 | FLOAT(8) | mkd012 | |
mkd013 | FLOAT(8) | mkd013 | |
mkd014 | FLOAT(8) | mkd014 | |
mkd015 | FLOAT(8) | mkd015 | |
mkd016 | FLOAT(8) | mkd016 | |
mkd017 | FLOAT(8) | mkd017 | |
mkd018 | FLOAT(8) | mkd018 | |
mkd019 | FLOAT(8) | mkd019 | |
mkd020 | FLOAT(8) | mkd020 | |
mkd021 | FLOAT(8) | mkd021 | |
mkd022 | FLOAT(8) | mkd022 | |
mkd023 | FLOAT(8) | mkd023 | |
mkd024 | FLOAT(8) | mkd024 | |
mkd025 | FLOAT(8) | mkd025 | |
mkd026 | FLOAT(8) | mkd026 | |
mkd027 | FLOAT(8) | mkd027 | |
mkd028 | FLOAT(8) | mkd028 | |
mkd029 | FLOAT(8) | mkd029 | |
mkd030 | FLOAT(8) | ||
mkd031 | FLOAT(8) | mkd031 | |
mkd032 | FLOAT(8) | mkd032 | |
mkd033 | FLOAT(8) | mkd033 | |
mkd034 | FLOAT(8) | mkd034 | |
mkd035 | FLOAT(8) | mkd035 | |
mkd036 | FLOAT(8) | mkd036 | |
mkd037 | FLOAT(8) | mkd037 | |
mkd038 | FLOAT(8) | mkd038 | |
mkd039 | FLOAT(8) | mkd039 | |
mkd040 | FLOAT(8) | mkd040 | |
mkd041 | FLOAT(8) | mkd041 | |
mkd042 | FLOAT(8) | mkd042 | |
mkd043 | FLOAT(8) | mkd043 | |
mkd044 | FLOAT(8) | mkd044 | |
mkd045 | FLOAT(8) | mkd045 | |
mkd046 | FLOAT(8) | mkd046 | |
mkd047 | FLOAT(8) | mkd047 | |
mkd048 | FLOAT(8) | mkd048 | |
mkd049 | FLOAT(8) | mkd049 | |
mkd050 | FLOAT(8) | mkd050 | |
mkd051 | FLOAT(8) | mkd051 | |
mkd052 | FLOAT(8) | mkd052 | |
mkd053 | FLOAT(8) | mkd053 | |
mkd054 | FLOAT(8) | mkd054 | |
mkd055 | FLOAT(8) | mkd055 | |
mkd056 | FLOAT(8) | mkd056 | |
mkd057 | FLOAT(8) | mkd057 | |
mkd058 | FLOAT(8) | mkd058 | |
mkd059 | FLOAT(8) | mkd059 | |
mkd060 | FLOAT(8) | mkd060 | |
mkd061 | FLOAT(8) | mkd061 | |
mkd062 | FLOAT(8) | mkd062 | |
mkd063 | FLOAT(8) | mkd063 | |
mkd064 | FLOAT(8) | mkd064 | |
mkd065 | FLOAT(8) | mkd065 | |
mkd066 | FLOAT(8) | mkd066 | |
mkd067 | FLOAT(8) | mkd067 | |
mkd068 | FLOAT(8) | mkd068 | |
mkd069 | FLOAT(8) | mkd069 | |
mkd070 | FLOAT(8) | mkd070 | |
mkd071 | FLOAT(8) | mkd071 | |
mkd072 | FLOAT(8) | mkd072 | |
mkd073 | FLOAT(8) | mkd073 | |
mkd074 | FLOAT(8) | mkd074 | |
mkd075 | FLOAT(8) | mkd075 | |
mkd076 | FLOAT(8) | mkd076 | |
mkd077 | FLOAT(8) | mkd077 | |
mkd078 | FLOAT(8) | mkd078 | |
mkd079 | FLOAT(8) | mkd079 | |
mkd080 | FLOAT(8) | mkd080 | |
mkd081 | FLOAT(8) | mkd081 | |
mkd082 | FLOAT(8) | mkd082 | |
mkd083 | FLOAT(8) | mkd083 | |
mkd084 | FLOAT(8) | mkd084 | |
mkd085 | FLOAT(8) | mkd085 | |
mkd086 | FLOAT(8) | mkd086 | |
mkd087 | FLOAT(8) | mkd087 | |
mkd088 | FLOAT(8) | mkd088 | |
mkd089 | FLOAT(8) | mkd089 | |
mkd090 | FLOAT(8) | mkd090 | |
mkd091 | FLOAT(8) | mkd091 | |
mkd092 | FLOAT(8) | mkd092 | |
mkd093 | FLOAT(8) | mkd093 | |
mkd094 | FLOAT(8) | mkd094 | |
mkd095 | FLOAT(8) | mkd095 | |
mkd096 | FLOAT(8) | mkd096 | |
mkd097 | FLOAT(8) | mkd097 | |
mkd098 | FLOAT(8) | mkd098 | |
mkd099 | FLOAT(8) | mkd099 | |
mkd100 | FLOAT(8) | mkd100 |