| View Name: | MARIContainerCategory |
| Based on table: | MPGebindeKategorie |
| Group: | |
| Description: | Container Categtrory to manage special settings |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContainerCategory | GebindeKategorie INT Primary |
||
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| CategoryName | KategorieName NVARCHAR (100) |
||
| CategoryType | GebindeTyp SMALLINT |
||
| ContainerInContainer | GebindeInGebinde SMALLINT |
||
| SizeMode | GroessenMode SMALLINT |
||
| LifeTimeMode | LebensdauerMode SMALLINT |
||
| ProjectMode | ProjektMode SMALLINT |
||
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| Supplier | Lieferant NVARCHAR (20) |
OCRD.CardCode | |
| ReportID | ReportID INT Index |
MARISysReports.ReportID | |
| 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 |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| HidePageFlag | HidePageFlag BIGINT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIItemGroupProperties | Item Groups: Additional fields for maintenance and purchase order |
| MARIItemProperties | Item Master: Additional fields for maintenance and purchase order |
| MARIContainer | Definition of a container carrying other goods |
| MARIContainerAddress | Addtional information for trucks as container for shipping |