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