Table Abbreviation Description Module Activity code
MANDATE MDT Mandates Common Data SDD

Key Description Duplicates Activity code
MDT0 CPY+UMRNUM No  
MDT1 CPY+BPCNUM+UMRNUM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACS Access code   ACS     [ACS]ACS0=[MDT]ACS RTZ  
AMDFLG Amendment flag   M 4 1      
AUUID Single identifier   AUUID          
BICCOD BIC code   A 11       VII
BIDCRY Bank acct. country   CRY     [TCY]TCY0=[MDT]BIDCRY Block  
BIDNUM Bank acct. number   BID          
BPCADD Customer address code   ADR          
BPCNUM Customer code   BPR     [BPR]BPR0=[MDT]BPCNUM Delete  
CPY Company   CPY     [CPY]CPY0=[MDT]CPY Delete  
CPYADD Company address code   ADR          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   AUS     [AUS]CODUSR=[MDT]CREUSR Other  
DES Description   DES          
ENDDAT Mandate end date   D          
FNLDBT Final debtor   A 35        
FNLFLG Final   M 4 1      
IBACOD IBAN code   A 34        
IBAN IBAN pref   A 4        
MAIMDTFLG Main mandate   M 4 1      
MDTCOP Copy of the mandate   AC0 1        
MIGFLG Migration   M 4 1      
NBRSDDPAY Number of payments   C 4        
NDAIMPFLG SMNDA or IBAN   M 4 1      
NTLMIGIDT Migration national ID   A 28        
PAYNBR No. of direct debits   C 4        
PAYTYP Payment type   M 15 3630      
SIGCTY Signature place   CTY          
SIGDAT Signature date   D          
SITFNC Signatory function   A 35        
SITNAM Signatory name   A 35        
STA Status   M 1 3631      
TOTSDDPAY Total direct debits   MD1          
TYP Type   M 15 3629      
UDLCON Underlying contract   A 35        
UMRNUM Mandate reference   MDT     [MDT]MDT0=CPY;UMRNUM Delete  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[MDT]UPDUSR Other  
WIOFIRSEQ Without first seq   M 4 1