Dunning Level

C_DunningLevel

Overview

Table NameC_DunningLevel
Access LevelClient Only
Entity TypeD
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableDunning_PrintFormat
WikiView on iDempiere Wiki

Columns (28)

Column Type Required Default Description
Description String(255) No - Optional short description of the record
Dunning_PrintFormat_ID Table(22) No - Print Format for printing Dunning Letters
InvoiceCollectionType List(1) No - Invoice Collection Status
IsStatement Yes-No(1) Yes N Dunning Level is a definition of a statement
PrintName String(60) Yes - The label text to be printed on a document or correspondence.
Name String(60) Yes - Alphanumeric identifier of the entity
AD_Client_ID Table Direct(22) Yes @AD_Client_ID@ Tenant for this installation.
AD_Org_ID Table Direct(22) Yes @AD_Org_ID@ Organizational entity within tenant
C_Dunning_ID Table Direct(22) Yes - Dunning Rules for overdue invoices
C_DunningLevel_ID ID(22) Yes - -
C_DunningLevel_UU String(36) No - -
ChargeFee Yes-No(1) Yes - Indicates if fees will be charged for overdue invoices
ChargeInterest Yes-No(1) Yes - Indicates if interest will be charged on overdue invoices
C_PaymentTerm_ID Table Direct(10) No - The terms of Payment (timing, discount)
Created Date+Time(7) Yes SYSDATE Date this record was created
CreatedBy Search(22) Yes - User who created this records
DaysAfterDue Number(22) Yes - Days after due date to dun (if negative days until due)
DaysBetweenDunning Integer(22) Yes - Days between sending dunning notices
FeeAmt Amount(22) No - Fee amount in invoice currency
InterestPercent Number(22) No - Percentage interest to charge on overdue invoices
IsActive Yes-No(1) Yes Y The record is active in the system
IsSetCreditStop Yes-No(1) Yes - Set the business partner to credit stop
IsSetPaymentTerm Yes-No(1) Yes - Set the payment term of the Business Partner
IsShowAllDue Yes-No(1) Yes - Show/print all due invoices
IsShowNotDue Yes-No(1) Yes - Show/print all invoices which are not due (yet).
Note Text(2000) No - Optional additional user defined information
Updated Date+Time(7) Yes SYSDATE Date this record was updated
UpdatedBy Search(22) Yes - User who updated this records

Foreign Keys

Column References Description
Dunning_PrintFormat_ID Dunning_PrintFormat.Dunning_PrintFormat_ID Print Format for printing Dunning Letters
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
C_Dunning_ID C_Dunning.C_Dunning_ID Dunning Rules for overdue invoices
C_PaymentTerm_ID C_PaymentTerm.C_PaymentTerm_ID The terms of Payment (timing, discount)

Generated on 2026-05-03T16:39:15.802492358Z