Table TRANSPORT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TRANSPORT | TRNP | Transport | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TRNP0 | TRNNUM | No | |
| TRNP1 | ARVEXPDAT+TRNNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ARVDAT | Arrival date | D | ||||||
| ARVEXPDAT | Exp. arrival date | D | ||||||
| ARVTPC | Transit - arrival | TPC | [TPC]TPC0=[TRNP]ARVTPC | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| AWB | Air waybill | A | 15 | |||||
| BPRNUM | BP code | BPR | [BPR]BPR0=[TRNP]BPRNUM | Block | ||||
| BPTNUM | Carrier | BPT | [BPT]BPT0=[TRNP]BPTNUM | Block | ||||
| CIM | CIM/CIV waybill | A | 15 | |||||
| CMR | CMR waybill | A | 15 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TRNP]CREUSR | Other | ||||
| CTBL | Combined transp. doc. | A | 15 | |||||
| DESAXX | Description | AX3 | ||||||
| DPEDAT | Departure date | D | ||||||
| DPETPC | Transit - start | TPC | [TPC]TPC0=[TRNP]DPETPC | Block | ||||
| FLINUM | Flight number | A | 15 | |||||
| FLYNAM | Company | A | 30 | |||||
| HAWB | HAWB | A | 15 | |||||
| HBOL | Bill of lading | A | 15 | |||||
| MBOL | Master Bill | A | 15 | |||||
| REGNUM | Registration | A | 30 | |||||
| ROANAM | Name | A | 30 | |||||
| SHIPLAG | Date shift | C | 4 | |||||
| TRANUM | Train number | A | 30 | |||||
| TRNMOD | Transport mode | M | 15 | 2027 | ||||
| TRNNUM | Transport no. | VCR | ||||||
| TRNSTA | Status | M | 30 | 591 | ||||
| TRNUID | Transport ID | A | 15 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TRNP]UPDUSR | Other | ||||
| VESNAM | Company | A | 30 | |||||
| VESSEL | Vessel name | A | 30 | |||||
| VOYNUM | Voyage number | A | 30 | |||||
| WAGNAM | Company | A | 30 | |||||
| WAGNUM | Wagon | A | 15 |