Table PLANDET
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PLANDET | PLADET | Plan detail | Common Data | NCS |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PLADET_0 | PLANID+LINENO | No | |
| PLADET_1 | PLANID+SORTSEQ | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTIONER | Actioner | AUS | [AUS]CODUSR=[PLADET]ACTIONER | Block | ||||
| ACTIONID | Action code | PLANACT | ||||||
| ACTTYP | Action type | ADI | [ADI]CODE=805;ACTTYP | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| COMMENT | Comment | A | 50 | |||||
| COMPLETEDATE | Complete by | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PLADET]CREUSR | Other | ||||
| ENDDATE | End date | D | ||||||
| LINENO | Line no. | C | 4 | |||||
| LINESTATUS | Status | M | 15 | 2040 | ||||
| LINTEX | Text | TXC | ||||||
| MFGNUM | Order no. | VCR | ||||||
| PLANID | Plan | PLANID | [PLAHDR]PLAHDR_0=[PLADET]PLANID | Block | ||||
| SORTSEQ | Sort sequence | C | 4 | |||||
| STARTDATE | Start date | D | ||||||
| TRANTYPE | Transaction type | ADI | [ADI]CODE=807;TRANTYPE | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PLADET]UPDUSR | Other |