Table DLVORDERL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DLVORDERL | DOL | DO lines | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DOL0 | FCY+DEP+DLONUM+DLOLIN | No | |
| DOL1 | FCY+DEP+DLONUM+DOLPTR | No | |
| DOL2 | FCY+DEP+CDKMGT+ITM+DLONUM+DLOLIN | No | |
| DOL3 | FCY+DEP+ITM+SKN+LOT+DOLSTA+DLONUM+DLOLIN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CDKCUQ | Cross Docking | QTA | ||||||
| CDKMGT | Cross dock management | M | 4 | 1 | ||||
| CONDATENA | Date contract activated | M | 4 | 1 | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTR | Container | ITC | [ITC]ITC0=FCY;DEP;ITM;CTR | Block | ||||
| CTRQTY | No containers | QTA | ||||||
| CUQ | Number of CU | QTA | ||||||
| CUQKIT | No. of kit CUs | QTA | ||||||
| DAT | Date created | D | ||||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLOLIN | Line no. | C | 4 | |||||
| DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Delete | ||||
| DOLPTR | Pointer | C | 4 | |||||
| DOLSTA | Status | M | 15 | 356 | ||||
| DSTMAXLVL | Max lev. disp. state | M | 15 | 311 | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| FIFDAT | FIFO date | D | ||||||
| FLCNUM | No flow | L | 8 | |||||
| GRUCOD | Group of parcel | A | 4 | |||||
| HISPTR | Archive | L | 8 | |||||
| IPSPRA | Parcel range | PRA | [PRA]PRA0=FCY;IPSPRA | Block | ||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Block | ||||
| KITDOLPTR | Kit pointer | C | 4 | |||||
| LINREF | Reference | A | 10 | |||||
| LNCCUQ | Launched | QTA | ||||||
| LNCDAT | Launch date | D | ||||||
| LNCTIM | Launch time | HM | ||||||
| LOT | Lot no. | A | 20 | |||||
| MVT | Mvt code | MVT | [MVT]MVT0=FCY;MVT | Block | ||||
| NEDEINRCP | EI under receipt | M | 4 | 1 | ||||
| NEDINPMVT | DI mvt not addressed | M | 4 | 1 | ||||
| NSHPIKCUQ | Voided | QTA | ||||||
| NTFCUQ | Not transferred | QTA | ||||||
| ORDNUM | Order number | A | 20 | |||||
| PIKCUQ | Prepared | QTA | ||||||
| REM | Comments | A | 240 | |||||
| REM2 | Notes | A | 240 | |||||
| REPCUQ | Postponed | QTA | ||||||
| RSA | Reservation no | A | 15 | |||||
| SHPCUQ | Shipped | QTA | ||||||
| SHPDAT | Shipment date | D | ||||||
| SHPTIM | Shipment time | HM | ||||||
| SHPWAIDAT | Waiting to ship | D | ||||||
| SHPWAITIM | Waiting to ship | HM | ||||||
| SKN | Stock Status | SKN | [SKN]SKN0=FCY;SKN | Block | ||||
| SNGLOT | Single lot | M | 4 | 1 | ||||
| SPT | Support no. | A | 15 | |||||
| SSHCUQ | Shortage | QTA | ||||||
| TOTSHP | Total shipped | QTA | ||||||
| TRFCUQ | Transferred | QTA | ||||||
| TYP | Line type | M | 15 | 357 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |