Table MANDATE
| 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 |