Table CONTSERVX
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
CONTSERVX | COX | Service contract | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
COX0 | CONNUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACPDPTCOD | Litigation accepted | 25 | ADI | [ADI]CODE=315;ACPDPTCOD | Block | |||
AMTPLY | Penalty amount | MD1 | ||||||
AMTPLYX | Penalty amount | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BASEXXAMT | Expression database | M | 15 | 976 | ||||
BASEXXAMTX | Expression database | M | 15 | 976 | ||||
BASEXXITT | Expression database | M | 15 | 976 | ||||
BASEXXITTX | Expression database | M | 15 | 976 | ||||
BASEXXSOL | Expression database | M | 15 | 976 | ||||
BASEXXSOLX | Expression database | M | 15 | 976 | ||||
CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
CONAMT | Amount | MD1 | ||||||
CONBASFOR | Revaluation formula | ADI | [ADI]CODE=427;CONBASFOR | Block | ||||
CONBASIDX | Indexing database | ADI | [ADI]CODE=410;CONBASIDX | Block | ||||
CONBPC | Sold-to | BPR | [BPR]BPR0=[COX]CONBPC | Block | ||||
CONBPCGRU | Group customer | BPR | [BPR]BPR0=[COX]CONBPCGRU | Block | ||||
CONBPCINV | Bill-to customer | BPR | [BPR]BPR0=[COX]CONBPCINV | Block | ||||
CONBPCPYR | Pay-by | BPR | [BPR]BPR0=[COX]CONBPCPYR | Block | ||||
CONCAT | Category | M | 15 | 2976 | ||||
CONCCN | Contact (relationship) | AIN | [AIN]AIN0=[COX]CONCCN | Block | ||||
CONCHGTYP | Rate type | M | 15 | 202 | ||||
CONCOT | Contract template | VCR | ||||||
CONENDDAT | End date | D | ||||||
CONNAM | Description | A | 85 | |||||
CONNUM | Code | VCR | ||||||
CONORI | Source | M | 15 | 2977 | ||||
CONORIVCR | Document no. | VCR | ||||||
CONORIVCRL | Journal line | L | 8 | |||||
CONPJT | Project | OPP | [OPP]OPP0=[COX]CONPJT | Block | ||||
CONPRITYP | Price type | M | 6 | 243 | ||||
CONREW | Renewable | M | 4 | 1 | ||||
CONSTRDAT | Start date | D | ||||||
CONTYP | Statistical group | ADI | [ADI]CODE=indice+440;CONTYP(indice) | Block | STO | |||
CONTYPCLA | Category | DES | ||||||
CONVACBPR | Tax rule | TVB | [TVB]TVB0=CONVACBPR;[V]GSUPCLE | Block | ||||
CPY | Company | CPY | [CPY]CPY0=[COX]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CRSCOVSAM | Coverage viewed | M | 4 | 1 | ||||
CUR | Currency | CUR | [TCU]TCU0=[COX]CUR | Block | ||||
DIE | Dimension type code | DIE | [DIE]DIE0=[COX]DIE | Block | ANA | |||
DSYWND | Display left list | C | 2 | |||||
EVRMAC | All products | M | 4 | 1 | ||||
EVRPBL | All skills | M | 4 | 1 | ||||
FDDFLG | Archived | M | 4 | 1 | ||||
FDDUSR | Archived by | A | 5 | |||||
GUA | Warranty | M | 4 | 1 | ||||
INVDTA | Invoicing element | C | 2 | SFI | ||||
INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
INVDTATYP | Value type | M | 6 | 2227 | SFI | |||
INVFRY | Invoicing freq | C | 4 | |||||
INVFRYBAS | Basis | M | 15 | 976 | ||||
INVFRYCOE | Coefficient | DCB | 3.2 | |||||
INVLTI | Invoicing advance notice | C | 4 | |||||
INVLTIBAS | Basis | M | 15 | 976 | ||||
INVMET | Invoicing method | M | 15 | 2978 | ||||
ITMREF | Product code | ITM | [ITM]ITM0=[COX]ITMREF | Block | ||||
ITTDATEND | Intervention end | D | ||||||
ITTDATENDX | Intervention end | D | ||||||
ITTDUR | Duration | C | 4 | |||||
ITTDURBAS | Expression database | M | 15 | 976 | ||||
ITTDURBASX | Expression database | M | 15 | 976 | ||||
ITTDURX | B duration | C | 4 | |||||
ITTFCY | Intervention / site | M | 4 | 1 | ||||
ITTFCYX | Intervention / site | M | 4 | 1 | ||||
ITTLTIMAX | Max intrvn LT | C | 4 | |||||
ITTLTIMAXX | Max intrvn LT | C | 4 | |||||
LASIDXDAT | Last value date | D | ||||||
LASINVDAT | Last invoice | D | ||||||
LASVALIDX | Last index value | MD1 | ||||||
MANREWAMT | Renewal amount | MD1 | ||||||
MANREWFLG | To renew | M | 4 | 1 | ||||
NEXINVAMT | Next invoice amount | MD1 | ||||||
NEXINVDAT | Next invoice | D | ||||||
NEXSHIINV | Next invoice sending | D | ||||||
OCONAMT | Amount | MD1 | ||||||
OCONENDDAT | End date | D | ||||||
OCONSTRDAT | Start date | D | ||||||
ODSYWND | Old left list | C | 2 | |||||
OINV | Invoice | SIH | [SIV]SIV0=[COX]OINV | Block | ||||
OLASIDXDAT | Last value date | D | ||||||
OLASINVDAT | Prev last invoice | D | ||||||
OLASVALIDX | Last index value | MD1 | ||||||
ONEXINVAMT | Old amount | MD1 | ||||||
ONEXINVDAT | Former next invoice | D | ||||||
ONEXSHIINV | Former next mailing | D | ||||||
ORDLINNUM | Order line no. | L | 8 | |||||
ORDNUM | Order number | SOH | [SOH]SOH0=[COX]ORDNUM | Block | ||||
ORDUPDFLG | Order no. modification | M | 4 | 1 | ||||
OREWINV | Invoice | SIH | [SIV]SIV0=[COX]OREWINV | Block | ||||
ORVADAT | Revaluation date | D | ||||||
ORVAINV | Invoice | SIH | [SIV]SIV0=[COX]ORVAINV | Block | ||||
OTHCNI | Other constraints | CLX | ||||||
PITBLC | Remaining points | L | 8 | |||||
PITCDT | Points credit | L | 8 | |||||
PITCSM | Points consumed | L | 8 | |||||
PITRER | Points available | L | 8 | |||||
PITTOL | Points tolerance | C | 3 | |||||
PRONUM | Process number | L | 8 | |||||
PTE | Payment terms | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
REWFRY | Renew frequency | C | 4 | |||||
REWFRYBAS | Basis | M | 15 | 976 | ||||
RSIDAT | Termination date | D | ||||||
RSIFLG | Cancelled contract | M | 4 | 1 | ||||
RSILTI | Advance notice of cancellation | C | 4 | |||||
RSILTIBAS | Basis | M | 15 | 976 | ||||
RSIREN | Termination reason | ADI | [ADI]CODE=429;RSIREN | Block | ||||
RVADAT | Revaluation date | D | ||||||
RVAFRY | Revaluation freq | C | 4 | |||||
RVAFRYBAS | Basis | M | 15 | 976 | ||||
RVAMET | Revaluation method | M | 15 | 2979 | ||||
RVASSP | Revaluation support | M | 15 | 2974 | ||||
SALFCY | Sales site | FCY | [FCY]FCY0=[COX]SALFCY | Block | ||||
SALREP | Sales rep | REP | [REP]REP0=[COX]SALREP | Block | REC | |||
SIUDAT | Subscription date | D | ||||||
SOLLTIMAX | Max rsltn LT | C | 4 | |||||
SOLLTIMAXX | Max rsltn LT | C | 4 | |||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |