Payment Scheme

    API Details

    Property Value
    Endpoint /tablesFinance/paymentSchemes
    Table name Payment Scheme
    Table id 11024036
    Table caption Payment Scheme
    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
    customerNo Customer No. Code 20 Customer
    name Name Text 100
    code Code Code 20 *
    noSeries No. Series Code 10
    letterTemplate Letter Template Code 30
    paymentSchemeTemplateCode Payment Scheme Template Code Code 20 Payment Scheme Template
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    postCode Post Code Code 20 Post Code
    phoneNo Phone No. Text 30
    contact Contact Text 100
    status Status Option 4 Created, Activated, Closed
    lastDateModified Last Date Modified Date 4
    objectNo Realty Object No. Code 20
    redesign Redesign Boolean 4
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    factuurtype Invoice Type Option 4 Geen, Factuur, Factuur + OLA, OLA
    terminationCode Termination Code Code 20 Termination Code Paymnt.Scheme
    terminate Terminate Boolean 4
    postingDate Posting Date Date 4
    documentDate Document Date Date 4
    recurringFrequency Recurring Frequency DateFormula 32
    paymentTermsCode Payment Terms Code Code 10 Payment Terms
    contactNo Contact No. Code 20
    openTerms Open Terms Boolean 4
    overdue Overdue Boolean 4
    remainingAmtLCY Remaining Amount (LCY) Decimal 12
    overdueAmtLCY Overdue Amount (LCY) Decimal 12
    transactionModeCode Transaction Mode Code Code 20
    bankAccountCode Bank Account Code Code 20
    mandateCode Mandate Code Code 20
    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