Objects/Tables/Table 1230 SEPA Direct Debit Mandate
Table 1230 SEPA Direct Debit Mandate in 27
Jonas Paprotka, Base Application 27.5.46862.47359, checked
- App
- Base Application
- Namespace
- Microsoft.Bank.DirectDebit
Fields, 13Keys, 2Procedures, 5Events, 2
Versions171819202122232425262728latest
Source29
Fields, 13
| Id | Name | Type | Obsolete |
|---|
| 1 | ID | Code[35] | - |
| 2 | Customer No. | Code[20] | - |
| 3 | Customer Bank Account Code | Code[20] | - |
| 4 | Valid From | Date | - |
| 5 | Valid To | Date | - |
| 6 | Date of Signature | Date | - |
| 7 | Type of Payment | Option | - |
| 8 | Blocked | Boolean | - |
| 9 | Expected Number of Debits | Integer | - |
| 10 | Debit Counter | Integer | - |
| 11 | No. Series | Code[20] | - |
| 12 | Closed | Boolean | - |
| 13 | Ignore Exp. Number of Debits | Boolean | - |
Keys, 2
| Name | Fields | Obsolete |
|---|
| Key1, clustered | ID | - |
| Key2 | Customer No. | - |
Procedures, 5
| Name | Parameters | Returns | Access | Obsolete |
|---|
| IsMandateActive | (Date) | Boolean | public | - |
| GetDefaultMandate | (Code[20], Date) | Code[35] | public | - |
| UpdateCounter | () | | public | - |
| GetSequenceType | () | Integer | public | - |
| RollBackSequenceType | () | | public | - |
Events, 2
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeInsert | (var Boolean, var Record SEPA Direct Debit Mandate) | - |
| Integration event | OnBeforeModify | (var Boolean, var Record SEPA Direct Debit Mandate) | - |