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 |