Debt Recovery Dossier

    API Details

    Property Value
    Endpoint /tablesFinance/debtRecoveryDossiers
    Table name Debt Recovery Dossier
    Table id 11024220
    Table caption Debt Recovery Dossier
    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 Dossier No. Code 20 *
    externalDossierNo External File No. Text 30
    startDate Start Date Date 4
    noSeries No. Series Code 20 No. Series
    customerNo Customer No. Code 20 Customer
    custName Customer Name Text 100
    custAddress Customer Address Text 100
    custAddress2 Customer Address 2 Text 50
    custPostCode Customer Post Code Code 20 Post Code
    custCity Customer City Text 30 Post Code
    custContact Customer Contact Text 100
    custPhoneNo Customer Phone No. Text 30
    debtMediation Debt Mediation Boolean 4
    closed Closed at Date 4
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    objectNo Object No. Code 20
    summoning Summoning Boolean 4
    dateDecisionWSNP Date Decision WSNP Date 4
    dateAgrRestrCost Date Agr. Restr. Cost Date 4
    dateAgrSettlement Date Agr. Settlement Date 4
    type Type Code 20 Debt Recovery Type
    status Status Option 4 , Pending WSNP, Pending Settlement, Pending Restructuring
    reasonClosure Reason Closure Code 20 Debt Recovery Reason Closure
    userID User ID Code 50 User Setup
    administratorNo Administrator No. Code 20 Contact
    admName Administrator Name Text 100
    admAddress Administrator Address Text 100
    admAddress2 Administrator Address 2 Text 50
    admPostCode Administrator Post Code Code 20 Post Code
    admCity Administrator City Text 30 Post Code
    admContact Administrator Contact Text 50
    admPhoneNo Administrator Phone No. Text 30
    paymentAmount Payment Amount Decimal 12
    paymentPct Payment % Decimal 12
    deductable Deductable Decimal 12
    dateDeducted Date Deducted Date 4
    dateGranted Date Granted Date 4
    dossierStatus Dossier Status Option 4 , AmtPosted, TotPosted, PmtReversed, TotReversed
    entryNoDeduction Entry No. Deduction Integer 4 Cust. Ledger Entry
    applyingStatus Applying Status Option 4 , Applied, Unapplied
    deductPaymentAmount Deduct Payment Amount Boolean 4
    applyingStatusPmt Applying Status Pmt. Option 4 , Applied, Unapplied
    entryNoDeductionPmt Entry No. Deduction Payment Integer 4 Cust. Ledger Entry
    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