Bank Account

    API Details

    Property Value
    Endpoint /tablesFinance/bankAccounts
    Table name Bank Account
    Table id 270
    Table caption Bank Account
    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
    no No. Code 20 *
    name Name Text 100
    searchName Search Name Code 100
    name2 Name 2 Text 50
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    contact Contact Text 100
    phoneNo Phone No. Text 30
    telexNo Telex No. Text 20
    bankAccountNo Bank Account No. Text 30
    transitNo Transit No. Text 20
    territoryCode Territory Code Code 10 Territory
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    chainName Chain Name Code 10
    minBalance Min. Balance Decimal 12
    bankAccPostingGroup Bank Acc. Posting Group Code 20 Bank Account Posting Group
    currencyCode Currency Code Code 10 Currency
    languageCode Language Code Code 10 Language
    formatRegion Format Region Text 80 Language Selection
    statisticsGroup Statistics Group Integer 4
    ourContactCode Our Contact Code Code 20
    countryRegionCode Country/Region Code Code 10 Country/Region
    amount Amount Decimal 12
    blocked Blocked Boolean 4
    lastStatementNo Last Statement No. Code 20
    lastPaymentStatementNo Last Payment Statement No. Code 20
    pmtRecNoSeries Payment Reconciliation No. Series Code 20 No. Series
    lastDateModified Last Date Modified Date 4
    useAsDefaultForCurrency Use as Default for Currency Boolean 4
    faxNo Fax No. Text 30
    telexAnswerBack Telex Answer Back Text 20
    postCode Post Code Code 20
    county County Text 30
    lastCheckNo Last Check No. Code 20
    balanceLastStatement Balance Last Statement Decimal 12
    bankBranchNo Bank Branch No. Text 20
    eMail Email Text 80
    homePage Home Page Text 80
    noSeries No. Series Code 20 No. Series
    checkReportID Check Report ID Integer 4
    iban IBAN Code 50
    swiftCode SWIFT Code Code 20 SWIFT Code
    bankStatementImportFormat Bank Statement Import Format Code 20
    creditTransferMsgNos Credit Transfer Msg. Nos. Code 20 No. Series
    directDebitMsgNos Direct Debit Msg. Nos. Code 20 No. Series
    sepaDirectDebitExpFormat SEPA Direct Debit Exp. Format Code 20
    bankStmtServiceRecordID Bank Stmt. Service Record ID RecordID 448
    transactionImportTimespan Transaction Import Timespan Integer 4
    automaticStmtImportEnabled Automatic Stmt. Import Enabled Boolean 4
    intercompanyEnable Enable for Intercompany transactions Boolean 4
    image Image Media 16
    creditorNo Creditor No. Code 35
    paymentExportFormat Payment Export Format Code 20
    bankClearingCode Bank Clearing Code Text 50
    bankClearingStandard Bank Clearing Standard Text 50 Bank Clearing Standard
    matchToleranceType Match Tolerance Type Option 4 Percentage, Amount
    matchToleranceValue Match Tolerance Value Decimal 12
    disableAutomaticPmtMatching Disable Automatic Payment Matching Boolean 4
    disableBankRecOptimization Disable Bank Reconciliation Optimization Boolean 4
    positivePayExportCode Positive Pay Export Code Code 20
    mobilePhoneNo Mobile Phone No. Text 30
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    accountHolderName Account Holder Name Text 100
    accountHolderAddress Account Holder Address Text 100
    accountHolderPostCode Account Holder Post Code Code 20
    accountHolderCity Account Holder City Text 30
    accHoldCountryRegionCode Acc. Hold. Country/Region Code Code 10 Country/Region
    creditorIdentifier Creditor Identifier Code 19
    creditorID Creditor ID Code 35
    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