I_CustomerSEPAMandate

Customer SEPA Mandate | view: ICUSTSEPAMANDATE | Extraction: Not supported | Component: Business Partners
Tables used: SEPA_MANDATE
Column Name Description
Customer SEPA Mandate: Sender ID
SEPAMandate Unique Reference to Mandate for each Payee
SEPAMandateSenderIBAN IBAN (International Bank Account Number)
SEPAMandateVersion SEPA Mandate: Version of Mandate (0 = Current Version)
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate SEPA: Validity Date of Mandate (From)
ValidityEndDate SEPA: Validity Date of Mandate (To)
SEPAMandateFirstUseDate SEPA Mandate: Date of First Use
SEPAMandateLastUseDate SEPA Mandate: Date of Last Use
Column Name Description
SEPAPaymentType SEPA: Payment Type Show values
SEPAMandateStatus SEPA: Mandate Status Show values
SEPAMandateIsB2BMandate SEPA-Mandate: B2B Mandate Show values
Column Name Description Domain name
SEPAMandateSenderBankSWIFTCode SWIFT/BIC for International Payments SWIFT
SEPAMandateUUID SEPA Mandate: GUID of Mandate
OriginalSEPAMandateCreditor SEPA Mandate: Original Creditor ID of Mandate ID035
OriginalSEPAMandate SEPA Mandate: Original Mandate of Mandate ID035
SEPAMandateReferenceType SEPA Mandate: Reference Type OJ_NAME
SEPAMandateReference SEPA Mandate: Reference ID SWO_TYPEID
SEPAMandateSenderType SEPA Mandate: Sender Type OJ_NAME
SEPAMandateRecipientType SEPA Mandate: Recipient Type OJ_NAME
SEPAMandateRecipient SEPA Mandate: Recipient ID SWO_TYPEID
SEPAMandateCreditor Creditor Identification Number ID035
SEPAMandateFirstUseObjTypeCode SEPA Mandate: Type of First Usage OJ_NAME
SEPAMandateFirstUsePaymentDoc SEPA Mandate: ID of First Usage SWO_TYPEID
SEPAMandateLastUseObjTypeCode SEPA Mandate: Type of Last Usage OJ_NAME
SEPAMandateLastUsePaymentDoc SEPA Mandate: ID of Last Usage SWO_TYPEID
SEPAMandateFirstUsePaymentRun SEPA Mandate: ID of Payment Run of First Use CHAR16