| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | SM74MDT | Internal Mandate Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | SM74MDTID | Mandate Identification | String | Generic Edit | 35 | 0 | Allow NULL? |
| 3 | SM74MDD | Mandate Date | Date | Generic Edit | 6 | 0 | |
| 4 | SM74MDCD | Mandate Cancelation Date | Date | Generic Edit | 6 | 0 | |
| 5 | SM74MSTY | Mandate Sequence Type | String | UDC (74 SQ) | 4 | 0 | Allow NULL? |
| 6 | SM74MSTS | Mandate Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | SM74MAD | Mandate Active Date | Date | Generic Edit | 6 | 0 | |
| 8 | SM74MVER | Mandate Version | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | SM74LCD | Last Collection Date | Date | Generic Edit | 6 | 0 | |
| 10 | SM74MTC | Mandate Transaction Counter | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | SM74DBTID | Debtor identification code | String | Generic Edit | 20 | 0 | Allow NULL? |
| 12 | SM74AIDD | Debtor Account Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | SM74AN8D | Debtor Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | SM74UAND | UKID Debtor Account Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | SM74AN8C | Creditor Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | SM74AIDC | Creditor Account Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | SM74UANC | UKID Creditor Account Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | SM74AN8UD | Ultimate Debtor Adress Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | SM74CDTID | Creditor Identification Code | String | Generic Edit | 35 | 0 | Allow NULL? |
| 20 | SM74CCC | Creditor Country Code | String | UDC (74 SA) | 2 | 0 | Allow NULL? |
| 21 | SM74CDV | Creditor Digit | String | Generic Edit | 2 | 0 | Allow NULL? |
| 22 | SM74CBC | Creditor Business Code | String | UDC (74 BC) | 3 | 0 | Allow NULL? |
| 23 | SM74CNI | Creditor National Identification | String | Generic Edit | 28 | 0 | Allow NULL? |
| 24 | SM74MAL | Mandate Amount Limit | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | SM74MTL | Mandate Transaction Limit | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 26 | SM74OMDT | Original Mandate Identification | String | Generic Edit | 35 | 0 | Allow NULL? |
| 27 | SM74OCDT | Original Creditor ID Code | String | Generic Edit | 35 | 0 | Allow NULL? |
| 28 | SM74OCDN | Original Creditor Name | String | Generic Edit | 40 | 0 | Allow NULL? |
| 29 | SM74ODBI | Original Debtor Account Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | SM74OUAD | Original UKI Debtor Account Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | SM74ODBB | Original Debtor Agent | String | Generic Edit | 15 | 0 | Allow NULL? |
| 32 | SM74ODIB | Original Debtor (IBAN) | String | Generic Edit | 34 | 0 | Allow NULL? |
| 33 | SMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | SMPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | SMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | SMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 37 | SMUPDJ | Date - Additional | Date | Generic Edit | 6 | 0 | |