Table DELIVERY
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DELIVERY | DLN | Delivery note | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DLN0 | FCY+DEP+DLNNUM | No | |
| DLN1 | FCY+DEP+WAVNUM+DLONUM+DLNNUM | No | |
| DLN2 | SHPFCY+NTRNUM+FCY+DEP+DLNNUM | No | EDC |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CGT | Transport type | CGT | [CGT]CGT0=SHPFCY;CGT | Block | ||||
| CLTORDREF | Customer reference | A | 15 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRGAMT | Freight Charge | MD1 | ||||||
| CRR | Carrier | CRR | [CRR]CRR0=SHPFCY;CRR | Block | ||||
| CRRMOD | Transportation method | CRM | [CRM]CRM0=SHPFCY;CRRMOD | Block | ||||
| CRRREF | Carriage reference | A | 15 | |||||
| CUR | Currency | CUR | [TCU]TCU0=CUR | Block | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Block | ||||
| DLNDAT | Shipment date | D | ||||||
| DLNEDT | Report | ARP | [ARP]ARP0=DLNEDT | Block | ||||
| DLNNUM | Delivery note | DLN | [DLN]DLN0=FCY;DEP;DLNNUM | Delete | ||||
| DLNSTA | Final DN | M | 4 | 1 | ||||
| DLNTIM | Shipment time | HM | ||||||
| DLONUM | DO number | DLO | [DOH]DOH0=FCY;DEP;DLONUM | Block | ||||
| DLVADD | Address | 3 | ADL | |||||
| DLVARE | Delivery area | A | 3 | |||||
| DLVCLT | Ship to | CLT | [CLT]CLT0=FCY;DLVCLT | Block | ||||
| DLVCRY | Country | CRY | [TCY]TCY0=DLVCRY | Block | ||||
| DLVCRYNAM | Country name | NCY | ||||||
| DLVCTY | City | CTY | ||||||
| DLVFAX | Fax | TEL | ||||||
| DLVNAM | Company name | 2 | NAM | |||||
| DLVPOS | Postal code | POS | ||||||
| DLVREM | Notes | A | 240 | |||||
| DLVSAT | Region (county, state, ..) | SAT | ||||||
| DLVTEL | Telephone | TEL | ||||||
| DRNPST | Round position | C | 3 | |||||
| EDHNUM | Number | EDH | [EDH]EDH0=SHPFCY;EDHNUM | RTZ | ||||
| EDISTA | EDI management status | M | 20 | 376 | ||||
| EDTLAN | Print language | LAN | [TLA]TLA0=EDTLAN | Block | ||||
| EXPDLVDAT | Delivery date | D | ||||||
| EXPDLVTIM | Delivery time | HM | ||||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| GDR | Generic round | GDR | [GDR]GDR0=SHPFCY;GDR | Block | ||||
| HISPTR | Archive | L | 8 | |||||
| INVADD | Address | 3 | ADL | |||||
| INVCLT | Bill-to customer | CLT | [CLT]CLT0=FCY;INVCLT | Block | ||||
| INVCRY | Country | CRY | [TCY]TCY0=INVCRY | Block | ||||
| INVCRYNAM | Country name | NCY | ||||||
| INVCTY | City | CTY | ||||||
| INVFAX | Fax | TEL | ||||||
| INVNAM | Company name | 2 | NAM | |||||
| INVPOS | Postal code | POS | ||||||
| INVREM | Notes | A | 240 | |||||
| INVSAT | Region (county, state, ..) | SAT | ||||||
| INVTEL | Telephone | TEL | ||||||
| LMT | Linear meters | QTY | ||||||
| MVT | Mvt code | MVT | [MVT]MVT0=FCY;MVT | Block | ||||
| NBREXP | Dispatchable parcels | C | 4 | CTR | ||||
| NBRLIG | Number of lines | C | 4 | |||||
| NBRPRC | No. of parcels | C | 4 | |||||
| NBRPRCEDI | Nr parcel w/o msg | C | 4 | |||||
| NBRSHP | No SU | C | 4 | |||||
| NTRNUM | Carriage Receipt | NTR | [NTR]NTR0=SHPFCY;NTRNUM | Block | ||||
| NUMREQ | Query no. | L | 8 | |||||
| ORDCLT | Sold to | A | 15 | |||||
| ORDDAT | Order date | D | ||||||
| ORDNUM | Order number | A | 20 | |||||
| ORDREF | Order reference | A | 20 | |||||
| PKZ | Preparation area | PKZ | [PKZ]PKZ0=FCY;PKZ | Block | ||||
| PMD | Picking mode | PMD | [PMD]PMD0=FCY;DEP;PMD | Block | ||||
| PTLPIK | Partial delivery | M | 15 | 338 | ||||
| QYMNUM | Round no. | DRN | [QYM]QYM0=SHPFCY;2;QYMNUM | RTZ | ||||
| REF | Reference | REF | ||||||
| SHPDAT | Shipment date | D | ||||||
| SHPFCY | Shipment site | FCY | [FCY]FCY0=[DLN]SHPFCY | Block | ||||
| SHPTIM | Shipment time | HM | ||||||
| TDNADD | Address | 3 | ADL | |||||
| TDNARE | Delivery area | A | 3 | |||||
| TDNCGT | Transport type | CGT | [CGT]CGT0=SHPFCY;TDNCGT | Other | ||||
| TDNCLT | Ship to | CLT | [CLT]CLT0=FCY;TDNCLT | Other | ||||
| TDNCRR | Carrier | CRR | [CRR]CRR0=SHPFCY;TDNCRR | Other | ||||
| TDNCRRMOD | Transportation method | CRM | [CRM]CRM0=SHPFCY;TDNCRRMOD | Other | ||||
| TDNCRY | Country | CRY | [TCY]TCY0=TDNCRY | Other | ||||
| TDNCRYNAM | Country name | NCY | ||||||
| TDNCTY | City | CTY | ||||||
| TDNGDR | Generic round | GDR | [GDR]GDR0=SHPFCY;TDNGDR | Other | ||||
| TDNNAM | Company name | 2 | NAM | |||||
| TDNPOS | Postal code | POS | ||||||
| TDNQYMNUM | Round no. | DRN | [QYM]QYM0=SHPFCY;2;TDNQYMNUM | Other | ||||
| TDNSAT | Region (county, state, ..) | SAT | ||||||
| TDNSTA | Upd DN | M | 4 | 1 | ||||
| TYPEDI | EDI management level | M | 10 | 364 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VOL | Volume | QTY | ||||||
| WAVNUM | Wave no | VAC | [VAC]VAC0=FCY;DEP;WAVNUM | Block | ||||
| WCRGAMT | Freight Charge | MD1 | ||||||
| WEI | Weight | QTY |