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 |