Table CONTSERV
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CONTSERV | CON | Service contract | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CON0 | CONNUM | No | |
| CON1 | CONENDDAT | Yes | |
| CON2 | CONBPC | Yes | |
| CON3 | CONCCN | Yes | |
| CON4 | CONBPC+RSIFLG+FDDFLG | Yes | |
| CON5 | CONORI+CONORIVCR+CONORIVCRL | Yes |
| 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=[CON]CONBPC | Block | ||||
| CONBPCGRU | Group customer | BPR | [BPR]BPR0=[CON]CONBPCGRU | Block | ||||
| CONBPCINV | Bill-to customer | BPR | [BPR]BPR0=[CON]CONBPCINV | Block | ||||
| CONBPCPYR | Pay-by | BPR | [BPR]BPR0=[CON]CONBPCPYR | Block | ||||
| CONCAT | Category | M | 15 | 2976 | ||||
| CONCCN | Contact (relationship) | AIN | [AIN]AIN0=[CON]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 | Original document no. | VCR | ||||||
| CONORIVCRL | Source document line | L | 8 | |||||
| CONPJT | Project | PJT | [PIM]PIM0=[CON]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=[CON]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=[CON]CUR | Block | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[CON]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 | SFI | [SFI]SFI0=[CON]INVDTA | Block | 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=[CON]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 | ||||||
| MANCONENDDAT | End date | D | ||||||
| MANCONREW | Renewable | M | 4 | 1 | ||||
| MANCONSTRDAT | Start date | D | ||||||
| MANREWAMT | Renewal amount | MD1 | ||||||
| MANREWFLG | To renew | M | 4 | 1 | ||||
| MANREWFRY | Renew frequency | C | 4 | |||||
| MANREWFRYBAS | Basis | M | 15 | 976 | ||||
| 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=[CON]OINV | Other | ||||
| 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=[CON]ORDNUM | Block | ||||
| ORDUPDFLG | Order no. modification | M | 4 | 1 | ||||
| OREWINV | Invoice | SIH | [SIV]SIV0=[CON]OREWINV | Other | ||||
| ORVADAT | Revaluation date | D | ||||||
| ORVAINV | Invoice | SIH | [SIV]SIV0=[CON]ORVAINV | Other | ||||
| 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 | |||||
| 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=[CON]SALFCY | Block | ||||
| SALREP | Sales rep | REP | [REP]REP0=[CON]SALREP | Block | REC | |||
| SFISSTCOD | SST tax code | ADI | [ADI]CODE=203;SFISSTCOD | Block | SFI | |||
| SIUDAT | Subscription date | D | ||||||
| SOLLTIMAX | Max rsltn LT | C | 4 | |||||
| SOLLTIMAXX | Max rsltn LT | C | 4 | |||||
| SSTENTCOD | Entity/Use | ADI | [ADI]CODE=202;SSTENTCOD | Block | LTA | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |