Table CCMIMPFOD
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
CCMIMPFOD | CCMIFOD | Impact analysis-Forecasts | Common Data | CCM |
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 |