Payment History Line

    API Details

    Property Value
    Endpoint /tablesFinance/paymentHistoryLines
    Table name Payment History Line
    Table id 11000002
    Table caption Payment History Line
    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
    runNo Run No. Code 20 * Payment History
    lineNo Line No. Integer 4 *
    accountType Account Type Option 4 Customer, Vendor, Employee
    accountNo Account No. Code 20
    date Date Date 4
    amount Amount Decimal 12
    bank Bank Code 20
    ourBank Our Bank Code 20 * Bank Account
    order Order Option 4 , Debit, Credit
    currencyCode Currency Code Code 10 Currency
    description1 Description 1 Text 32
    description2 Description 2 Text 32
    description3 Description 3 Text 32
    description4 Description 4 Text 32
    identification Identification Code 80
    bankAccountNo Bank Account No. Text 30
    transactionMode Transaction Mode Code 20
    status Status Option 4 New, Transmitted, Request for Cancellation, Rejected, Cancelled, Posted
    documentNo Document No. Code 20
    postingDate Posting Date Date 4
    paymentReceipt Payment/Receipt Option 4 Payment, Receipt
    amountPaymtInProcessLCY Amount Paymt. in Process (LCY) Decimal 12
    docket Docket Boolean 4
    accountHolderName Account Holder Name Text 100
    accountHolderAddress Account Holder Address Text 100
    accountHolderPostCode Account Holder Post Code Code 20 Post Code
    accountHolderCity Account Holder City Text 30 Post Code
    accHoldCountryRegionCode Acc. Hold. Country/Region Code Code 10 Country/Region
    nationalBankCode National Bank Code Code 10
    swiftCode SWIFT Code Code 20
    natureOfThePayment Nature of the Payment Option 4 , Goods, Transito Trade, Invisible- and Capital Transactions, Transfer to Own Account, Other Registrated BFI
    registrationNoDNB Registration No. DNB Text 8
    descriptionPayment Description Payment Text 30
    itemNo Item No. Text 2
    tradersNo Traders No. Text 4
    urgent Urgent Boolean 4
    bankName Bank Name Text 100
    bankAddress Bank Address Text 100
    bankCity Bank City Text 30 Post Code
    bankCountryRegion Bank Country/Region Code 10 Country/Region
    transferCostDomestic Transfer Cost Domestic Option 4 Principal, Balancing Account Holder
    transferCostForeign Transfer Cost Foreign Option 4 Principal, Balancing Account Holder
    abbrevNationalBankCode Abbrev. National Bank Code Code 3
    iban IBAN Code 50
    directDebitMandateID Direct Debit Mandate ID Code 35 SEPA Direct Debit Mandate
    directDebitMandateCounter Direct Debit Mandate Counter Integer 4
    sequenceType Sequence Type Option 4 , OOFF, FRST, RCUR, FNAL
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    foreignCurrency Foreign Currency Code 10
    foreignAmount Foreign Amount Decimal 12
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    omschrijving5 Omschrijving 5 Text 40
    omschrijving6 Omschrijving 6 Text 40
    betalingsregeling Betalingsregeling Code 20
    betalingsregelingregel Betalingsregelingregel Integer 4
    mandateCode Mandate Code Code 20
    unstructuredRemittanceInfo Unstructured Remittance Info Text 140
    recurringType Recurring Type Option 4 , FRST, RCUR, OOFF
    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