| Table Name: | MPGebindeKategorie |
| View Name: | MARIContainerCategory |
| Group: | |
| Description: | Container Categtrory to manage special settings |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GebindeKategorie | ContainerCategory INT Primary |
||
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| KategorieName | CategoryName NVARCHAR (100) |
||
| GebindeTyp | CategoryType SMALLINT |
||
| GebindeInGebinde | ContainerInContainer SMALLINT |
||
| GroessenMode | SizeMode SMALLINT |
||
| LebensdauerMode | LifeTimeMode SMALLINT |
||
| ProjektMode | ProjectMode SMALLINT |
||
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| Lieferant | Supplier NVARCHAR (20) |
OCRD.CardCode | |
| ReportID | ReportID INT Index |
MPSysReports.UserReportID | |
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| Height2 | Height2 NUMERIC(19,6) |
||
| Hght2Unit | Hght2Unit SMALLINT |
||
| Width2 | Width2 NUMERIC(19,6) |
||
| Wdth2Unit | Wdth2Unit SMALLINT |
||
| Length2 | Length2 NUMERIC(19,6) |
||
| Len2Unit | Len2Unit SMALLINT |
||
| Volume2 | Volume2 NUMERIC(19,6) |
||
| Vol2Unit | Vol2Unit SMALLINT |
||
| Weight2 | Weight2 NUMERIC(19,6) |
||
| Wght2Unit | Wght2Unit SMALLINT |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| HidePageFlag | HidePageFlag BIGINT |
||
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPArtikelGruppenKennzeichen | Item Groups: Additional fields for maintenance and purchase order |
| MPArtikelKennzeichen | Item Master: Additional fields for maintenance and purchase order |
| MPGebinde | Definition of a container carrying other goods |
| MPGebindeAdresse | Addtional information for trucks as container for shipping |