Objects/Tables/Table 1208 Direct Debit Collection Entry
Table 1208 Direct Debit Collection Entry in 22
Jonas Paprotka, Base Application 22.5.59966.64723, checked
- App
- Base Application
Fields, 23Keys, 2Procedures, 9Events, 9
Versions171819202122232425262728latest
Source29
Fields, 23
| Id | Name | Type | Obsolete |
|---|
| 1 | Direct Debit Collection No. | Integer | - |
| 2 | Entry No. | Integer | - |
| 3 | Customer No. | Code[20] | - |
| 4 | Applies-to Entry No. | Integer | - |
| 5 | Transfer Date | Date | - |
| 6 | Currency Code | Code[10] | - |
| 7 | Transfer Amount | Decimal | - |
| 8 | Transaction ID | Text[35] | - |
| 9 | Sequence Type | Option | - |
| 10 | Status | Option | - |
| 11 | Mandate ID | Code[35] | - |
| 12 | Mandate Type of Payment | Option | - |
| 13 | Customer Name | Text[100] | - |
| 14 | Applies-to Entry Document No. | Code[20] | - |
| 15 | Applies-to Entry Description | Text[100] | - |
| 16 | Applies-to Entry Posting Date | Date | - |
| 17 | Applies-to Entry Currency Code | Code[10] | - |
| 18 | Applies-to Entry Amount | Decimal | - |
| 19 | Applies-to Entry Rem. Amount | Decimal | - |
| 20 | Applies-to Entry Open | Boolean | - |
| 21 | Direct Debit Collection Status | Option | - |
| 22 | Payment Reference | Code[50] | - |
| 23 | Message to Recipient | Text[140] | - |
Keys, 2
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Direct Debit Collection No., Entry No. | - |
| Key2 | Applies-to Entry No., Status | - |
Procedures, 9
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CreateNew | (Integer, Record Cust. Ledger Entry) | | public | - |
| DeletePaymentFileErrors | () | | public | - |
| HasPaymentFileErrors | () | Boolean | public | - |
| ExportSEPA | () | | public | - |
| InsertPaymentFileError | (Text) | | public | - |
| InsertPaymentFileErrorWithDetails | (Text, Text) | | public | - |
| Reject | () | | public | - |
| SetTodayAsTransferDateForOverdueEnries | () | | public | - |
| GetAmountInActiveCollections | () | Decimal | public | - |
Events, 9
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeCheckSEPA | (var Record Direct Debit Collection Entry, var Boolean) | - |
| Integration event | OnBeforeDocTypeErr | (Record Cust. Ledger Entry, var Boolean) | - |
| Integration event | OnBeforeExportSEPA | (var Record Direct Debit Collection Entry, var Boolean) | - |
| Integration event | OnBeforeTransferPKToGenJnlLine | (var Record Direct Debit Collection Entry, var Record Gen. Journal Line, var Boolean) | - |
| Integration event | OnBeforeValidateTransferAmount | (var Record Direct Debit Collection Entry, var Boolean) | - |
| Integration event | OnBeforeCheckCustLedgerEntryAmountPositive | (var Record Cust. Ledger Entry, var Boolean) | - |
| Integration event | OnCreateNewOnBeforeInsert | (Record Cust. Ledger Entry, var Record Direct Debit Collection Entry) | - |
| Integration event | OnCreateNewOnAfterInsert | (Record Cust. Ledger Entry, var Record Direct Debit Collection Entry) | - |
| Integration event | OnValidateAppliesToEntryNoOnAfterTransferCustLedgerEntryFields | (var Record Direct Debit Collection Entry, Record Direct Debit Collection Entry, Record Cust. Ledger Entry) | - |