| Table Name: | MPGebindeKategorie |
| View Name: | MARIContainerCategory |
| Group: | Group: Container |
| 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) |
purchase of the container/box | OITM.ItemCode |
| Lieferant | Supplier NVARCHAR (20) |
standad supplier | OCRD.CardCode |
| ReportID | ReportID INT Index |
MPSysReports.UserReportID | |
| HinweisVerpackung | PackageHint NVARCHAR (100) |
Text for supplier | |
| 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 |
||
| GebindeGruppe1 | ContainerGroup1 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10703) | |
| GebindeGruppe2 | ContainerGroup2 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10702) | |
| GebindeGruppe3 | ContainerGroup3 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10705) | |
| 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 |
| MPGebindeZeile | Container Lines to see the goods in the container |