Table INTERVEN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| INTERVEN | ITN | Service response | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ITN0 | NUM | No | |
| ITN1 | DATX | Yes | |
| ITN2 | BPC | Yes | |
| ITN3 | CCN | Yes | |
| ITN4 | REP+DATX | Yes | |
| ITN5 | REP+DAT | Yes | |
| ITN6 | DAT | Yes | |
| ITN7 | ITNORI+ITNORIVCR+ITNORIVCRL | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | 3 | ADL | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPC | Customer | BPR | [BPR]BPR0=[ITN]BPC | Block | ||||
| CCN | Contact (relationship) | AIN | [AIN]AIN0=[ITN]CCN | Block | ||||
| CONNUM | Contract number | CON | [CON]CON0=[ITN]CONNUM | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREHOU | Creation time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[ITN]CRY | Block | ||||
| CTY | City | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[ITN]CUR | Block | ||||
| DAT | Start | D | ||||||
| DATEND | End | D | ||||||
| DATX | Week conversion | D | ||||||
| DON | Completed | M | 4 | 1 | ||||
| DTCKIL | Distance (miles) | L | 8 | |||||
| DUR | Duration | HMD | ||||||
| EML | Email address | MAI | ||||||
| FULDAY | Entire day | M | 4 | 1 | ||||
| HOU | Time | HM | ||||||
| HOUEND | End time | HM | ||||||
| HTOTTIMSPG | Time passed (hours) | L | 8 | |||||
| IFFADD | Indications | CLX | ||||||
| ITNCODADD | Address | ADR | ||||||
| ITNORI | Source | M | 15 | 2996 | ||||
| ITNORIVCR | Original document no. | VCR | ||||||
| ITNORIVCRL | Original line no. | L | 8 | |||||
| ITNRECADD | Recording | A | 15 | |||||
| ITNTYPADD | Type | M | 15 | 954 | ||||
| MAC | Base | MAC | [MAC]MAC0=[ITN]MAC | Block | ||||
| MACGRU | Base regroupment | MAC | [MAC]MAC0=[ITN]MACGRU | Block | ||||
| MANTIMFLG | Manual entry flag | C | 2 | |||||
| MOB | Mobile phone | TEL | ||||||
| MTOTTIMSPG | Time passed (min.) | C | 2 | |||||
| NUM | Sequence no. | VCR | ||||||
| NUMFULOBJ | Chrono txt file | CLC | ||||||
| NUMFULRPO | Report chrono | CLC | ||||||
| OBJ | Overview | CLX | ||||||
| OBJFLG | Flag text file | C | 2 | |||||
| ORDNUM | Order number | SOH | [SOH]SOH0=[ITN]ORDNUM | Block | ||||
| PBLSOL | Problem resolved | M | 4 | 1 | ||||
| REP | Provider | AUS | [AUS]CODUSR=[ITN]REP | Block | ||||
| RER | Reservations | 15 | RRS | [RRS]RRS0=[ITN]RER | Block | |||
| RPO | Overview | CLX | ||||||
| RPOFLG | Overview written | C | 2 | |||||
| SALFCY | Site | FCY | [FCY]FCY0=[ITN]SALFCY | Block | ||||
| SAT | County | SAT | ||||||
| SCO | Subcontracted | M | 4 | 1 | ||||
| SCOAMT | Negotiated amount | MD1 | ||||||
| SCONUM | Subcontractor | BPR | [BPR]BPR0=[ITN]SCONUM | Block | ||||
| SRVCONCOV | Coverage | M | 4 | 1 | ||||
| SRVDEMNUM | Serv. req. No. | SRE | [SRE]SRE0=[ITN]SRVDEMNUM | Block | ||||
| TEL | Telephone | TEL | ||||||
| TRITIM | Estimated travel time | C | 4 | |||||
| TYP | Category | ADI | [ADI]CODE=407;TYP | Block | ||||
| TYPFULOBJ | Type text file | CLT | ||||||
| TYPFULRPO | Report type | CLT | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WEE | Week | C | 4 | |||||
| ZIP | Postal code | POS |