Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||
| expedition_id | VARCHAR | 36 | √ | null |
|
|
||||
| product_id | VARCHAR | 36 | √ | null |
|
|
||||
| borderoPosition | INT | 10 | null |
|
|
|||||
| sendungsPosition | INT | 10 | null |
|
|
|||||
| packstueckAnzahl | INT | 10 | null |
|
|
|||||
| verpackungsart | VARCHAR | 3 | √ | null |
|
|
||||
| packstueckAnzahlAufPalette | INT | 10 | null |
|
|
|||||
| verpackungsartAufPalette | VARCHAR | 3 | √ | null |
|
|
||||
| warenInhalt | VARCHAR | 35 | √ | null |
|
|
||||
| zeichenUndNummer | VARCHAR | 35 | √ | null |
|
|
||||
| gewicht | DECIMAL | 10,3 | √ | null |
|
|
||||
| frachtpflichtigesGewicht | DECIMAL | 10,3 | √ | null |
|
|
||||
| laengeInMeter | DECIMAL | 10,2 | √ | null |
|
|
||||
| breiteInMeter | DECIMAL | 10,2 | √ | null |
|
|
||||
| hoeheInMeter | DECIMAL | 10,2 | √ | null |
|
|
||||
| kubikMeter | DECIMAL | 10,3 | √ | null |
|
|
||||
| ladeMeter | DECIMAL | 10,3 | √ | null |
|
|
||||
| anzahlPalettenStellplatze | INT | 10 | √ | null |
|
|
||||
| barcode | VARCHAR | 35 | √ | null |
|
|
||||
| sendungsnummerVersandpartner | VARCHAR | 35 | √ | null |
|
|
||||
| sendungsBruttoGewicht | DECIMAL | 10,3 | √ | null |
|
|
||||
| frankatur | VARCHAR | 3 | √ | null |
|
|
||||
| direktzustellungsKz | BIT | 1 | null |
|
|
|||||
| abholdatum | DATETIME | 19 | √ | null |
|
|
||||
| logistikModell | VARCHAR | 6 | √ | null |
|
|
||||
| sendungsNummerEmpfangsPartner | VARCHAR | 35 | √ | null |
|
|
||||
| versenderIdOriginalBordero | VARCHAR | 35 | √ | null |
|
|
||||
| empfaengerIdOriginalBordero | VARCHAR | 35 | √ | null |
|
|
||||
| warengruppe | VARCHAR | 3 | √ | null |
|
|
||||
| warenwertWaehrung | VARCHAR | 3 | √ | null |
|
|
||||
| hinweistextschluessel1 | VARCHAR | 3 | √ | null |
|
|
||||
| hinweiszusatztext1 | VARCHAR | 35 | √ | null |
|
|
||||
| hinweistextschluessel2 | VARCHAR | 3 | √ | null |
|
|
||||
| hinweiszusatztext2 | VARCHAR | 35 | √ | null |
|
|
||||
| hinweistextschluessel3 | VARCHAR | 3 | √ | null |
|
|
||||
| hinweiszusatztext3 | VARCHAR | 35 | √ | null |
|
|
||||
| hinweistextschluessel4 | VARCHAR | 3 | √ | null |
|
|
||||
| hinweiszusatztext4 | VARCHAR | 35 | √ | null |
|
|
||||
| hinweistextschluessel5 | VARCHAR | 3 | √ | null |
|
|
||||
| hinweiszusatztext5 | VARCHAR | 35 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| IDX_C3FC07EC4584665A | Performance | Asc | product_id |
| IDX_C3FC07EC576EF81E | Performance | Asc | expedition_id |