| View Name: | MARIContainerLine |
| Based on table: | MPGebindeZeile |
| Group: | Group: Container |
| Description: | Container Lines to see the goods in the container |
| ClassID: | 1058. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContainerLineID | GebindeZeilenID INT Primary |
||
| ContainerDetailLineID | GebindeDetailZeilenID INT Primary |
||
| ContainerID | GebindeID INT Index |
MARIContainer.ContainerID | |
| Position | Position INT Index |
||
| LineType | ZeilenTyp SMALLINT Index |
||
| DetailType | DetailTyp INT |
||
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| ClassKey | Schluessel NVARCHAR (50) Index |
||
| ClassSubKey | SchluesselDetail NVARCHAR (20) |
||
| Matchcode | Matchcode NVARCHAR (200) Index |
||
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT Index |
MARIContractPositions.ContractPositionID | |
| PurchaseProcessID | EKVorgangsID INT Index |
MARIPurchaseProcess.PurchaseProcessID | |
| PurchaseProcessPositionID | EKVorgangsposition INT |
MARIPurchaseProcessPositions.PurchaseProcessPositionID | |
| BatchMode | SerienChargenMode SMALLINT |
||
| PosStatus | PosStatus INT |
MARISupportSettings.PosStatus (WHERE Setting=32) | |
| Quantity | Menge NUMERIC(19,6) |
||
| QuantityCount | MengeAnzahl NUMERIC(19,6) |
||
| QuantityCountText | MengeAnzahlText NVARCHAR (100) |
||
| Effect | Wirkung INT |
||
| MARIDocID | MPBelID INT Index |
MARIContractDocument.MARIDocID | |
| MARIDocPosID | MPBelPosID INT Index |
MARIContractDocumentPositions.MARIDocPosID | |
| DocumentDraftID | DocumentDraftID INT Index |
MARIDocumentDraftHead.DocumentDraftID | |
| DocumentDraftPosID | DocumentDraftPosID INT Index |
MARIDocumentDraftPosition.DocumentDraftPosID | |
| DocumentDraftPosLinkID | DocumentDraftPosLinkID INT Index |
MARIDocumentDraftPositionLink.DocumentDraftPosLinkID | |
| GrossWeight | BruttoGewicht NUMERIC(19,6) |
||
| Volume | Volumen NUMERIC(19,6) |
||
| NumberOfPakages | AnzahlPakete SMALLINT |
||
| Markings | Kennzeichen NVARCHAR (100) |
||
| MethodOfPacking | ArtVerpackung NVARCHAR (100) |
||
| NatureOfGoods | BezeichnungGut NVARCHAR (100) |
||
| IntrastatNumbers | StatistischeWarennummern NVARCHAR (100) |
||
| PrintMoe | DruckMode SMALLINT |
||
| PlanContainerCategory | PlanGebindeKategorie INT |
MARIContainerCategory.PlanContainerCategory | |
| PlanContainerID | PlanGebindeMenge SMALLINT |
MARIContainer.PlanContainerID | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIContainerBatchSN | Linked batches of serialnumbers for a line in the container |