Table idempiere9.adempiere.c_dunninglevel
Dunning Level

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_dunninglevel_id numeric 10
c_dunningrun.c_dunninglevel_id cdunninglevel_cdunningrun R
c_dunningrunentry.c_dunninglevel_id cdunninglevel_cdunningrunentry R
c_invoice.c_dunninglevel_id cdunninglevel_cinvoice R
Dunning Level
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
c_dunning_id numeric 10
c_dunning.c_dunning_id cdunning_cdunninglevel R
Dunning Rules for overdue invoices
printname varchar 60 The label text to be printed on a document or correspondence.
daysafterdue numeric 10 Days after due date to dun (if negative days until due)
daysbetweendunning numeric 10 Days between sending dunning notices
note varchar 2000  √  null Optional additional user defined information
chargeinterest bpchar 1 'Y'::bpchar Indicates if interest will be charged on overdue invoices
interestpercent numeric 0  √  0 Percentage interest to charge on overdue invoices
chargefee bpchar 1 'Y'::bpchar Indicates if fees will be charged for overdue invoices
feeamt numeric 0  √  0 Fee amount in invoice currency
dunning_printformat_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformat_cdunninglevel R
Print Format for printing Dunning Letters
name varchar 60 'x'::character varying Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
isshowalldue bpchar 1 'N'::bpchar Show/print all due invoices
isshownotdue bpchar 1 'N'::bpchar Show/print all invoices which are not due (yet).
issetcreditstop bpchar 1 'N'::bpchar Set the business partner to credit stop
issetpaymentterm bpchar 1 'N'::bpchar Set the payment term of the Business Partner
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
invoicecollectiontype bpchar 1  √  NULL::bpchar Invoice Collection Status
isstatement bpchar 1 'N'::bpchar Dunning Level is a definition of a statement
c_dunninglevel_uu varchar 36  √  NULL::character varying C_DunningLevel_UU

Table contained 2 rows at 2021-12-25 14:51 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_dunninglevel_id Primary key Asc c_dunninglevel_pkey
c_dunninglevel_uu Must be unique Asc c_dunninglevel_uu_idx

Close relationships  within of separation: