Table AUTILIS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| AUTILIS | AUS | Users | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CODUSR | USR | No | |
| LOGIN | LOGIN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=[V]GCACAUS;ACCCOD;[V]GSUPCLE | Other | CPT | |||
| ACSUSR | Access | ACS | [ACS]ACS0=[AUS]ACSUSR | Block | ||||
| ADDEML | Email address | MAI | ||||||
| ADDNAM | AD reference | A | 250 | |||||
| ALLACS | All access codes | M | 4 | 1 | ||||
| ARCPRF | Profile code | ARU | [ARU]ARU0=[AUS]ARCPRF | Block | ||||
| ARVHOU | Arrival time | 7 | HM | |||||
| AUSDAY | Days | 7 | M | 15 | 742 | |||
| AUUID | Single identifier | AUUID | ||||||
| AUZDSCDEM | Dispatching | M | 4 | 1 | ||||
| BIDNUM | Bank acct. number | BID | ||||||
| BPAADD | Default address | ADR | ||||||
| BPRNUM | BP | A | 10 | |||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CHEF | Supervisors | 20 | AUS | [AUS]CODUSR=[AUS]CHEF | RTZ | |||
| CHGDAT | Date change | M | 4 | 1 | ||||
| CODADRDFT | Default address | ADR | ||||||
| CODMET | Profession code | AME | [AME]AME0=[AUS]CODMET | Block | ||||
| CODRIBDFT | Default bank details | BID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[AUS]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[AUS]CUR | Block | ||||
| DATCONN | Connection date | D | ||||||
| DECTIME | Time-out | L | 5 | |||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[AUS]DIE | Block | ANA | |||
| DIFIMP | Deferred prints | M | 4 | 1 | ||||
| DPEHOU | Leaving time | 7 | HM | |||||
| ENAFLG | Active | M | 4 | 1 | ||||
| ESCSTRDAT | Escalation start date | D | ||||||
| FAX | Default fax | TEL | ||||||
| FLGPASPRV | Provisional | M | 4 | 1 | ||||
| FNC | Function | M | 15 | 977 | ||||
| FNCCOD | Functions | 8 | AFC | [AFC]CODINT=[AUS]FNCCOD | Block | |||
| FNCPAR | Parameters | 8 | A | 10 | ||||
| FULTIM | Full time | M | 4 | 1 | ||||
| HDKREP | Help-desk | M | 4 | 1 | ||||
| INTUSR | Name | AX3 | ||||||
| KILRAT | Kilometer rate | DCB | 9.2 | |||||
| LOGIN | Login | ALO | ||||||
| MNA | Supervisor | M | 15 | 50 | ||||
| MSNEND | End of the mission | D | ||||||
| MSNSTR | Task start | D | ||||||
| NBDAY | Number of days | C | 4 | |||||
| NBFNC | No. | C | 4 | |||||
| NBRCON | Number of connections | C | 4 | |||||
| NBRESC | No. of escalations | C | 4 | |||||
| NEWPAS | New password | A | 24 | |||||
| NOMUSR | Name | DES | ||||||
| PASSDAT | Validity date | D | ||||||
| PASSE | Password | A | 10 | |||||
| PRFFCT | Function profile | AFT | [AFT]AFT0=[AUS]PRFFCT | Block | ||||
| PRFMEN | Menu profile | APM | [APF]CODPRF=0;PRFMEN | Block | ||||
| PRFXTD | Safe X3 WAS profile | A | 10 | AYT | ||||
| PRTDEF | Destination | 10 | AIM | [AIM]AIM0=[AUS]PRTDEF | Block | |||
| PWDBI | BI password | A | 24 | ABI | ||||
| REPNUM | Sales rep code | A | 10 | |||||
| RPCREP | Sales rep | C | 4 | |||||
| STA | Status | M | 15 | 978 | ||||
| TELEP | Default telephone | TEL | ||||||
| TIMCONN | Connection time | A | 10 | |||||
| TIT | Title bar | AFR | 250 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[AUS]UPDUSR | Other | ||||
| USR | Code | AUS | [AUS]CODUSR=[AUS]USR | Delete | ||||
| USRBI | BI user | AIU | [AIU]AIU0=[AUS]USRBI | Block | ABI | |||
| USRCONNECT | X3 connection | M | 4 | 1 | ||||
| USRCONXTD | Web services connect. | M | 4 | 1 | ||||
| USREXT | External user | M | 4 | 1 | ||||
| USRPRT | User model | AUS | [AUS]CODUSR=[AUS]USRPRT | Block | ||||
| WITHOUTLDAP | Without LDAP | M | 4 | 1 | ||||
| WRH | Warehouse | WRH | [WRH]WRH0=[AUS]WRH | Block | WRH |