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 |