Vendor Bank Account

    API Details

    Property Value
    Endpoint /tablesFinance/vendorBankAccounts
    Table name Vendor Bank Account
    Table id 288
    Table caption Vendor 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
    vendorNo Vendor No. Code 20 * Vendor
    code Code Code 20 *
    name Name Text 100
    name2 Name 2 Text 50
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    postCode Post Code Code 20
    contact Contact Text 100
    phoneNo Phone No. Text 30
    telexNo Telex No. Text 20
    bankBranchNo Bank Branch No. Text 20
    bankAccountNo Bank Account No. Text 30
    transitNo Transit No. Text 20
    currencyCode Currency Code Code 10 Currency
    countryRegionCode Country/Region Code Code 10 Country/Region
    county County Text 30
    faxNo Fax No. Text 30
    telexAnswerBack Telex Answer Back Text 20
    languageCode Language Code Code 10 Language
    eMail Email Text 80
    homePage Home Page Text 80
    iban IBAN Code 50
    swiftCode SWIFT Code Code 20 SWIFT Code
    bankClearingCode Bank Clearing Code Text 50
    bankClearingStandard Bank Clearing Standard Text 50 Bank Clearing Standard
    grekening B-Account Boolean 4
    standaardPctGrekening Standard % B-Account Decimal 12
    aanpassenAanContactadres Change to Contact Address Boolean 4
    localeBank Local Bank Boolean 4
    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
    nationalBankCode National Bank Code Code 10
    abbrevNationalBankCode Abbrev. National Bank Code Code 3
    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