Table CCMIMPSQD
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
CCMIMPSQD | CCMISQD | Impact analysis-Sales quotes | Common Data | CCM |
Key | Description | Duplicates | Activity code |
---|---|---|---|
CCMSQD0 | CRID+LINENO | No | |
CCMSQD1 | CRID+SORTSEQ | No | |
CCMSQD2 | CRID+BPCORD+SQHNUM | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACTIONER | Actioner | CCMAUS | [AUS]CODUSR=[CCMISQD]ACTIONER | Block | ||||
ACTIONID | Action ID | CCMACT | ||||||
AUUID | Single identifier | AUUID | ||||||
BPCORD | Sold-to | BPC | [BPC]BPC0=[CCMISQD]BPCORD | Block | ||||
COMMENT | Comment | A | 50 | |||||
COMPLETEDATE | Complete by | D | ||||||
CONAMNT | Base calculation | MD8 | ||||||
CREDATTIM | Created on | ADATIM | ||||||
CREUSR | Created by | AUS | [AUS]CODUSR=[CCMISQD]CREUSR | Other | ||||
CRID | Request ID | CCMCRID | ||||||
ECCVALMAJ | Major version | CCMECS | ECC | |||||
ECCVALMIN | Minor version | CCMEVL | ECC | |||||
ENDDATE | End date | D | ||||||
FOLDCUR | Currency | CUR | [TCU]TCU0=[CCMISQD]FOLDCUR | Block | ||||
ITMREF | Product | ITM | [ITM]ITM0=[CCMISQD]ITMREF | Block | ||||
LINENO | No. | C | 4 | |||||
LINESTATUS | Status | M | 15 | 2040 | ||||
NETPRIATI | Amount + tax | MD8 | ||||||
NETPRINOT | Amount - tax | MD8 | ||||||
QTY | Quote quantity | QTY | ||||||
SALFCY | Sales site | FCY | [FCY]FCY0=[CCMISQD]SALFCY | Block | ||||
SORTSEQ | Sort sequence | C | 4 | |||||
SQDLIN | Quote line | L | 8 | |||||
SQHCUR | Currency | CUR | [TCU]TCU0=[CCMISQD]SQHCUR | Block | ||||
SQHNUM | Quote no. | VCR | ||||||
STARTDATE | Start date | D | ||||||
TRANTYPE | Transaction type | M | 15 | 2039 | ||||
UPDDATTIM | Updated on | ADATIM | ||||||
UPDUSR | Updated by | AUS | [AUS]CODUSR=[CCMISQD]UPDUSR | Other | ||||
VLYDAT | Validity date | D |