Table CCMIMPFOD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CCMIMPFOD | CCMIFOD | Impact analysis-Forecasts | Common Data | CCMNC |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CCMIFOD0 | CRID+LINENO | No | |
| CCMIFOD1 | CRID+SORTSEQ | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTIONER | Actioner | CCMAUS | [AUS]CODUSR=[CCMIFOD]ACTIONER | Block | ||||
| ACTIONID | Action ID | CCMACT | ||||||
| AUUID | Single identifier | AUUID | ||||||
| COMMENT | Comment | A | 240 | |||||
| COMPLETEDATE | Complete by | D | ||||||
| CREDATTIM | Created on | ADATIM | ||||||
| CREUSR | Created by | AUS | [AUS]CODUSR=[CCMIFOD]CREUSR | Other | ||||
| CRID | Request ID | CCMCRID | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | CCMEVL | ECC | |||||
| ENDDATE | End date | D | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[CCMIFOD]ITMREF | Block | ||||
| LINENO | Line no. | C | 4 | |||||
| LINESTATUS | Status | M | 15 | 2040 | ||||
| MONTHEND | End of month | D | ||||||
| MONTHNAME | Month (january, february, ...) | A | 10 | |||||
| MONTHSTART | Beginning of month | D | ||||||
| ORDSTATUS | Order status | A | 10 | |||||
| SITE | Site | FCY | [FCY]FCY0=[CCMIFOD]SITE | Block | ||||
| SORTSEQ | Sort sequence | C | 4 | |||||
| STARTDATE | Start date | D | ||||||
| TOTQTY | Monthly total | QTY | ||||||
| TRANTYPE | Transaction type | M | 15 | 2039 | ||||
| UPDDATTIM | Updated on | ADATIM | ||||||
| UPDUSR | Updated by | AUS | [AUS]CODUSR=[CCMIFOD]UPDUSR | Other | ||||
| WEEQTY1 | Qty week 1 | QTY | ||||||
| WEEQTY2 | Qty week 2 | QTY | ||||||
| WEEQTY3 | Qty week 3 | QTY | ||||||
| WEEQTY4 | Qty week 4 | QTY | ||||||
| WEEQTY5 | Qty week 5 | QTY | ||||||
| YEA | Year | A | 4 |