Direct Debit Mandate

    API Details

    Property Value
    Endpoint /tablesFinance/directDebitMandates
    Table name Direct Debit Mandate
    Table id 11151825
    Table caption Direct Debit Mandate
    Data per company True
    Group Finance

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    code Code Code 20 *
    recurring Recurring Boolean 4
    customerNo Customer No. Code 20
    dateSigned Date Signed Date 4
    iban IBAN Code 50
    directDebitReason Direct Debit Reason Code 20 Direct Debit Reason
    dateLastUsed Date Last Used Date 4
    dateFirstUsed Date First Used Date 4
    noSeries No. Series Code 10
    customerBankAccountCode Customer Bank Account Code Code 20
    creditorID Creditor ID Code 35
    bankAccountCode Our Bank Account Code 20 Bank Account
    createdFromWeb Created from Web Boolean 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8