Table MACHINES
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MACHINES | MAC | Installed base | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MAC0 | MACNUM | No | |
| MAC1 | BPCNUM+CCNNUM | Yes | |
| MAC2 | BPCNUM | Yes | |
| MAC3 | CCNNUM | Yes | |
| MAC5 | MACPDTCOD+MACSERNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPCNUM | BP code | BPR | [BPR]BPR0=[MAC]BPCNUM | Block | ||||
| CCNNUM | Contact (rel.) code | AIN | [AIN]AIN0=[MAC]CCNNUM | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Sales currency | CUR | [TCU]TCU0=[MAC]CUR | Block | ||||
| FCYITN | Installation site | ADR | ||||||
| MACBPCCUR | Purchase currency | CUR | [TCU]TCU0=[MAC]MACBPCCUR | Block | ||||
| MACBPCDAT | Purchase date | D | ||||||
| MACBPCPRI | Purchase price | MD1 | ||||||
| MACBRA | Brand | ADI | [ADI]CODE=408;MACBRA | Block | ||||
| MACBRACLA | Mark clearly | DES | ||||||
| MACCUTBPC | End user | BPR | [BPR]BPR0=[MAC]MACCUTBPC | Block | ||||
| MACDES | Description | DES | ||||||
| MACITNDAT | Installation date | D | ||||||
| MACITNLND | Installed as a loan | M | 4 | 1 | ||||
| MACITNTYP | Installation type | M | 15 | 2972 | ||||
| MACITSDAT | In service date | D | ||||||
| MACNUM | Sequence no. | VCR | ||||||
| MACORI | Source | M | 15 | 2971 | ||||
| MACORIVCR | Original document no. | VCR | ||||||
| MACORIVCRL | Source document line | L | 8 | |||||
| MACPDTCOD | Product code | ITM | [ITM]ITM0=[MAC]MACPDTCOD | Block | ||||
| MACPURDAT | Sales date | D | ||||||
| MACQTY | Quantity | L | 8 | |||||
| MACRSL | Reseller | BPR | [BPR]BPR0=[MAC]MACRSL | Block | ||||
| MACSALPRI | Sale price | MD1 | ||||||
| MACSERNUM | Serial number | SE1 | ||||||
| PLE | Location | CLX | ||||||
| PREORI | Source | M | 15 | 2971 | ||||
| PREORIVCR | Original document no. | VCR | ||||||
| PREORIVCRL | Source document line | L | 8 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[MAC]SALFCY | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |