View idempiere9.adempiere.c_dunning_header_v
Dunning Letter

 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
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_language varchar 6  √  null Language for this entity
c_dunningrun_id numeric 10  √  null Dunning Run
c_dunningrunentry_id numeric 10  √  null Dunning Run Entry
dunningdate timestamp 29,6  √  null Date of Dunning
printname varchar 60  √  null The label text to be printed on a document or correspondence.
documentnote varchar 2000  √  null Additional information for a Document
c_bpartner_id numeric 10  √  null Identifies a Business Partner
bpvalue varchar 40  √  null Business Partner Key Value
bptaxid varchar 20  √  null Tax ID of the Business Partner
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
duns varchar 11  √  null Dun & Bradstreet Number
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
salesrep_id numeric 10  √  null Sales Representative or Company Agent
salesrep_name varchar 2147483647  √  null Sales Representative
bpgreeting varchar 60  √  null Greeting for Business Partner
name varchar 120  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
bpcontactgreeting varchar 60  √  null Greeting for Business Partner Contact
title varchar 40  √  null Name this entity is referred to as
phone varchar 40  √  null Identifies a telephone number
contactname text 2147483647  √  null Business Partner Contact Name
c_location_id numeric 10  √  null Location or Address
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
postal text 2147483647  √  null Postal code
amt numeric 0  √  null Amount
qty numeric 0  √  null Quantity
note varchar 2000  √  null Optional additional user defined information
logo_id numeric 10  √  null Logo
c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_dunningrun_c_dunninglevel_id numeric 10  √  null c_dunningrun_c_dunninglevel_id
c_dunningrun_description varchar 255  √  null c_dunningrun_description
processed bpchar 1  √  null The document has been processed
processing bpchar 1  √  null Process Now
sendit bpchar 1  √  null Send
c_dunningrunentry_ad_org_id numeric 10  √  null c_dunningrunentry_ad_org_id
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_currency_id numeric 10  √  null The Currency for this record
c_dunrunentry_c_dunlevel_id numeric 10  √  null C_DunRunEntry_C_DunLevel_ID
c_dunningrunentry_created timestamp 29,6  √  null c_dunningrunentry_created
c_dunningrunentry_createdby numeric 10  √  null c_dunningrunentry_createdby
c_dunningrunentry_isactive bpchar 1  √  null c_dunningrunentry_isactive
c_dunningrunentry_processed bpchar 1  √  null c_dunningrunentry_processed
c_dunningrunentry_updated timestamp 29,6  √  null c_dunningrunentry_updated
c_dunningrunentry_updatedby numeric 10  √  null c_dunningrunentry_updatedby
c_dunninglevel_ad_org_id numeric 10  √  null c_dunninglevel_ad_org_id
c_dunninglevel_c_dunning_id numeric 10  √  null c_dunninglevel_c_dunning_id
chargefee bpchar 1  √  null Indicates if fees will be charged for overdue invoices
chargeinterest bpchar 1  √  null Indicates if interest will be charged on overdue invoices
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
daysafterdue numeric 10  √  null Days after due date to dun (if negative days until due)
daysbetweendunning numeric 10  √  null Days between sending dunning notices
c_dunninglevel_description varchar 255  √  null c_dunninglevel_description
dunning_printformat_id numeric 10  √  null Print Format for printing Dunning Letters
feeamt numeric 0  √  null Fee amount in invoice currency
interestpercent numeric 0  √  null Percentage interest to charge on overdue invoices
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_dunninglevel_isactive bpchar 1  √  null c_dunninglevel_isactive
issetcreditstop bpchar 1  √  null Set the business partner to credit stop
issetpaymentterm bpchar 1  √  null Set the payment term of the Business Partner
isshowalldue bpchar 1  √  null Show/print all due invoices
isshownotdue bpchar 1  √  null Show/print all invoices which are not due (yet).
isstatement bpchar 1  √  null Dunning Level is a definition of a statement
c_dunninglevel_name varchar 60  √  null c_dunninglevel_name
c_bpartner_acqusitioncost numeric 0  √  null c_bpartner_acqusitioncost
c_bpartner_actuallifetimevalue numeric 0  √  null c_bpartner_actuallifetimevalue
c_bpartner_ad_language varchar 6  √  null c_bpartner_ad_language
c_bpartner_ad_orgbp_id numeric 10  √  null C_BPartner_AD_OrgBP_ID
c_bpartner_ad_org_id numeric 10  √  null C_BPartner_AD_Org_ID
c_bpartner_bpartner_parent_id numeric 10  √  null C_BPartner_BPartner_Parent_ID
c_bpartner_c_bp_group_id numeric 10  √  null C_BPartner_C_BP_Group_ID
c_bpartner_c_greeting_id numeric 10  √  null C_BPartner_C_Greeting_ID
c_bpartner_invoiceschedule_id numeric 10  √  null C_BPartner_InvoiceSchedule_ID
c_bpartner_c_paymentterm_id numeric 10  √  null C_BPartner_C_PaymentTerm_ID
c_bpartner_created timestamp 29,6  √  null c_bpartner_created
c_bpartner_createdby numeric 10  √  null c_bpartner_createdby
c_bpartner_c_taxgroup_id numeric 10  √  null C_BPartner_C_TaxGroup_ID
c_bpartner_deliveryrule bpchar 1  √  null c_bpartner_deliveryrule
c_bpartner_deliveryviarule bpchar 1  √  null c_bpartner_deliveryviarule
c_bpartner_description varchar 255  √  null c_bpartner_description
c_bpartner_dunninggrace timestamp 29,6  √  null c_bpartner_dunninggrace
c_bpartner_firstsale timestamp 29,6  √  null c_bpartner_firstsale
c_bpartner_flatdiscount numeric 0  √  null c_bpartner_flatdiscount
c_bpartner_freightcostrule bpchar 1  √  null c_bpartner_freightcostrule
c_bpartner_invoicerule bpchar 1  √  null c_bpartner_invoicerule
c_bpartner_isactive bpchar 1  √  null c_bpartner_isactive
c_bpartner_iscustomer bpchar 1  √  null c_bpartner_iscustomer
c_bpartner_isdiscountprinted bpchar 1  √  null c_bpartner_isdiscountprinted
c_bpartner_isemployee bpchar 1  √  null c_bpartner_isemployee
c_bpartner_ismanufacturer bpchar 1  √  null c_bpartner_ismanufacturer
c_bpartner_isonetime bpchar 1  √  null c_bpartner_isonetime
c_bpartner_ispotaxexempt bpchar 1  √  null c_bpartner_ispotaxexempt
c_bpartner_isprospect bpchar 1  √  null c_bpartner_isprospect
c_bpartner_issalesrep bpchar 1  √  null c_bpartner_issalesrep
c_bpartner_issummary bpchar 1  √  null c_bpartner_issummary
c_bpartner_istaxexempt bpchar 1  √  null c_bpartner_istaxexempt
c_bpartner_isvendor bpchar 1  √  null c_bpartner_isvendor
c_bpartner_logo_id numeric 10  √  null C_BPartner_Logo_ID
c_bpartner_m_discountschema_id numeric 10  √  null C_BPartner_M_DiscountSchema_ID
c_bpartner_m_pricelist_id numeric 10  √  null C_BPartner_M_PriceList_ID
c_bpartner_naics varchar 6  √  null c_bpartner_naics
c_bpartner_numberemployees numeric 10  √  null c_bpartner_numberemployees
c_bpartner_paymentrule bpchar 1  √  null c_bpartner_paymentrule
c_bpartner_paymentrulepo bpchar 1  √  null c_bpartner_paymentrulepo
c_bpartnerpo_discountschema_id numeric 10  √  null C_BPartnerPO_DiscountSchema_ID
c_bpartner_po_paymentterm_id numeric 10  √  null c_bpartner_po_paymentterm_id
c_bpartner_po_pricelist_id numeric 10  √  null C_BPartner_PO_PriceList_ID
c_bpartner_poreference varchar 20  √  null c_bpartner_poreference
c_bpartner_potentiallifetimev numeric 0  √  null c_bpartner_potentiallifetimevalue
c_bpartner_rating bpchar 1  √  null c_bpartner_rating
c_bpartner_salesrep_id numeric 10  √  null C_BPartner_SalesRep_ID
c_bpartner_salesvolume numeric 10  √  null c_bpartner_salesvolume
c_bpartner_sendemail bpchar 1  √  null c_bpartner_sendemail
c_bpartner_shareofcustomer numeric 10  √  null c_bpartner_shareofcustomer
c_bpartner_shelflifeminpct numeric 10  √  null c_bpartner_shelflifeminpct
c_bpartner_so_creditlimit numeric 0  √  null c_bpartner_so_creditlimit
c_bpartner_socreditstatus bpchar 1  √  null c_bpartner_socreditstatus
c_bpartner_so_creditused numeric 0  √  null c_bpartner_so_creditused
c_bpartner_so_description varchar 255  √  null c_bpartner_so_description
c_bpartner_totalopenbalance numeric 0  √  null c_bpartner_totalopenbalance
c_bpartner_updated timestamp 29,6  √  null c_bpartner_updated
c_bpartner_updatedby numeric 10  √  null c_bpartner_updatedby
c_bpartner_url varchar 120  √  null c_bpartner_url
c_bpartner_greeting_ad_org_id numeric 10  √  null c_bpartner_greeting_ad_org_id
c_bpartner_greeting_isactive bpchar 1  √  null c_bpartner_greeting_isactive
c_bpartner_greeting_isfirstna bpchar 1  √  null c_bpartner_greeting_isfirstnameonly
c_bpartner_greeting_name varchar 60  √  null c_bpartner_greeting_name
c_bpartner_location_ad_org_id numeric 10  √  null C_BPartner_Location_AD_Org_ID
c_bpartner_location_created timestamp 29,6  √  null c_bpartner_location_created
c_bpartner_location_createdby numeric 10  √  null c_bpartner_location_createdby
c_salesregion_id numeric 10  √  null Sales coverage region
c_bpartner_location_fax varchar 40  √  null c_bpartner_location_fax
c_bpartner_location_isactive bpchar 1  √  null c_bpartner_location_isactive
isbillto bpchar 1  √  null Business Partner Invoice/Bill Address
isdn varchar 40  √  null ISDN or modem line
ispayfrom bpchar 1  √  null Business Partner pays from that address and we'll send dunning letters there
isremitto bpchar 1  √  null Business Partner payment address
isshipto bpchar 1  √  null Business Partner Shipment Address
c_bpartner_location_name varchar 60  √  null c_bpartner_location_name
c_bpartner_location_phone varchar 40  √  null c_bpartner_location_phone
c_bpartner_location_phone2 varchar 40  √  null c_bpartner_location_phone2
c_bpartner_location_updated timestamp 29,6  √  null c_bpartner_location_updated
c_bpartner_location_updatedby numeric 10  √  null c_bpartner_location_updatedby
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
address3 varchar 60  √  null Address Line 3 for the location
address4 varchar 60  √  null Address Line 4 for the location
c_location_ad_org_id numeric 10  √  null c_location_ad_org_id
c_city_id numeric 10  √  null City
c_country_id numeric 10  √  null Country
city varchar 60  √  null Identifies a City
c_location_created timestamp 29,6  √  null c_location_created
c_location_createdby numeric 10  √  null c_location_createdby
c_region_id numeric 10  √  null Identifies a geographical Region
c_location_isactive bpchar 1  √  null c_location_isactive
postal_add varchar 10  √  null Additional ZIP or Postal code
regionname varchar 40  √  null Name of the Region
c_location_updated timestamp 29,6  √  null c_location_updated
c_location_updatedby numeric 10  √  null c_location_updatedby
ad_user_ad_org_id numeric 10  √  null AD_User_AD_Org_ID
ad_user_ad_ad_orgtrx_id numeric 10  √  null
ad_user_ad_birthday timestamp 29,6  √  null ad_user_ad_birthday
ad_user_c_bpartner_id numeric 10  √  null AD_User_C_BPartner_ID
ad_user_c_bpartner_location_id numeric 10  √  null AD_User_C_BPartner_Location_ID
ad_user_c_greeting_id numeric 10  √  null AD_User_C_Greeting_ID
ad_user_comments varchar 2000  √  null ad_user_comments
ad_user_created timestamp 29,6  √  null ad_user_created
ad_user_createdby numeric 10  √  null ad_user_createdby
ad_user_description varchar 255  √  null ad_user_description
ad_user_email varchar 60  √  null ad_user_email
ad_user_fax varchar 40  √  null ad_user_fax
ad_user_isactive bpchar 1  √  null ad_user_isactive
ad_user_lastcontact timestamp 29,6  √  null ad_user_lastcontact
ad_user_lastresult varchar 255  √  null ad_user_lastresult
ad_user_name varchar 60  √  null ad_user_name
ad_user_phone2 varchar 40  √  null ad_user_phone2
ad_user_supervisor_id numeric 10  √  null AD_User_Supervisor_ID
ad_user_updated timestamp 29,6  √  null ad_user_updated
ad_user_updatedby numeric 10  √  null ad_user_updatedby
ad_user_value varchar 40  √  null ad_user_value
c_user_greeting_ad_org_id numeric 10  √  null c_user_greeting_ad_org_id
c_user_greeting_isactive bpchar 1  √  null c_user_greeting_isactive
c_user_greeting_isfirstnameon bpchar 1  √  null c_user_greeting_isfirstnameonly
c_user_greeting_name varchar 60  √  null c_user_greeting_name
ad_orginfo_ad_org_id numeric 10  √  null ad_orginfo_ad_org_id
ad_orgtype_id numeric 10  √  null Organization Type
c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_orginfo_created timestamp 29,6  √  null ad_orginfo_created
ad_orginfo_createdby numeric 10  √  null ad_orginfo_createdby
dropship_warehouse_id numeric 10  √  null The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_orginfo_duns varchar 11  √  null ad_orginfo_duns
ad_orginfo_email varchar 60  √  null ad_orginfo_email
ad_orginfo_fax varchar 40  √  null ad_orginfo_fax
ad_orginfo_isactive bpchar 1  √  null ad_orginfo_isactive
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
parent_org_id numeric 10  √  null Parent (superior) Organization
ad_orginfo_phone varchar 40  √  null ad_orginfo_phone
ad_orginfo_phone2 varchar 40  √  null ad_orginfo_phone2
receiptfootermsg varchar 1023  √  null This message will be displayed at the bottom of a receipt when doing a sales or purchase
supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_orginfo_updated timestamp 29,6  √  null ad_orginfo_updated
ad_orginfo_updatedby numeric 10  √  null ad_orginfo_updatedby
salesrep_ad_org_id numeric 10  √  null SalesRep_AD_Org_ID
salesrep_ad_ad_orgtrx_id numeric 10  √  null salesrep_ad_ad_orgtrx_id
salesrep_ad_birthday timestamp 29,6  √  null salesrep_ad_birthday
salesrep_c_bpartner_id numeric 10  √  null salesrep_c_bpartner_id
salesrep_c_bp_location_id numeric 10  √  null Sales Representative Location
salesrep_c_greeting_id numeric 10  √  null salesrep_c_greeting_id
salesrep_comments varchar 2000  √  null salesrep_comments
salesrep_created timestamp 29,6  √  null salesrep_created
salesrep_createdby numeric 10  √  null salesrep_createdby
salesrep_description varchar 255  √  null salesrep_description
salesrep_email varchar 60  √  null salesrep_email
salesrep_fax varchar 40  √  null salesrep_fax
salesrep_isactive bpchar 1  √  null salesrep_isactive
salesrep_lastcontact timestamp 29,6  √  null salesrep_lastcontact
salesrep_lastresult varchar 255  √  null salesrep_lastresult
salesrep_phone2 varchar 40  √  null salesrep_phone2
salesrep_supervisor_id numeric 10  √  null salesrep_supervisor_id
salesrep_updated timestamp 29,6  √  null salesrep_updated
salesrep_updatedby numeric 10  √  null salesrep_updatedby
salesrep_value varchar 40  √  null salesrep_value
salesrep_bpartner_acqusitionc numeric 0  √  null salesrep_bpartner_acqusitioncost
salesrep_bpartner_actuallifet numeric 0  √  null salesrep_bpartner_actuallifetimevalue
salesrep_bpartner_ad_language varchar 6  √  null salesrep_bpartner_ad_language
salesrep_bpartner_ad_orgbp_id numeric 10  √  null salesrep_bpartner_ad_orgbp_id
salesrep_bpartner_ad_org_id numeric 10  √  null salesrep_bpartner_ad_org_id
salesrep_bpartner_bp_parent_id numeric 10  √  null SalesRep_BPartner_BP_Parent_ID
salesrep_bp_c_bp_group_id numeric 10  √  null SalesRep_BP_C_BP_Group_ID
salesrep_bp_c_greeting_id numeric 10  √  null SalesRep_BP_C_Greeting_ID
salesrep_bp_invoiceschedule_id numeric 10  √  null SalesRep_BP_InvoiceSchedule_ID
salesrep_bp_c_paymentterm_id numeric 10  √  null SalesRep_BP_C_PaymentTerm_ID
salesrep_bpartner_created timestamp 29,6  √  null salesrep_bpartner_created
salesrep_bpartner_createdby numeric 10  √  null salesrep_bpartner_createdby
salesrep_bp_c_taxgroup_id numeric 10  √  null SalesRep_BP_C_TaxGroup_ID
salesrep_bpartner_deliveryrule bpchar 1  √  null salesrep_bpartner_deliveryrule
salesrep_bpartner_deliveryvia bpchar 1  √  null salesrep_bpartner_deliveryviarule
salesrep_bpartner_description varchar 255  √  null salesrep_bpartner_description
salesrep_bpartner_dunninggrace timestamp 29,6  √  null salesrep_bpartner_dunninggrace
salesrep_bpartner_firstsale timestamp 29,6  √  null salesrep_bpartner_firstsale
salesrep_bpartner_flatdiscount numeric 0  √  null salesrep_bpartner_flatdiscount
salesrep_bpartner_freightcost bpchar 1  √  null salesrep_bpartner_freightcostrule
salesrep_bpartner_invoicerule bpchar 1  √  null salesrep_bpartner_invoicerule
salesrep_bpartner_isactive bpchar 1  √  null salesrep_bpartner_isactive
salesrep_bpartner_iscustomer bpchar 1  √  null salesrep_bpartner_iscustomer
salesrep_bpartner_isdiscountp bpchar 1  √  null salesrep_bpartner_isdiscountprinted
salesrep_bpartner_isemployee bpchar 1  √  null salesrep_bpartner_isemployee
salesrep_bpartner_ismanufactu bpchar 1  √  null salesrep_bpartner_ismanufacturer
salesrep_bpartner_isonetime bpchar 1  √  null salesrep_bpartner_isonetime
salesrep_bpartner_ispotaxexem bpchar 1  √  null salesrep_bpartner_ispotaxexempt
salesrep_bpartner_isprospect bpchar 1  √  null salesrep_bpartner_isprospect
salesrep_bpartner_issalesrep bpchar 1  √  null salesrep_bpartner_issalesrep
salesrep_bpartner_issummary bpchar 1  √  null salesrep_bpartner_issummary
salesrep_bpartner_istaxexempt bpchar 1  √  null salesrep_bpartner_istaxexempt
salesrep_bpartner_isvendor bpchar 1  √  null salesrep_bpartner_isvendor
salesrep_bpartner_logo_id numeric 10  √  null salesrep_bpartner_logo_id
salesrep_bp_mdiscountschema_id numeric 10  √  null SalesRep_BP_MDiscountSchema_ID
salesrep_bp_m_pricelist_id numeric 10  √  null SalesRep_BP_M_PriceList_ID
salesrep_bpartner_naics varchar 6  √  null salesrep_bpartner_naics
salesrep_bpartner_numberemplo numeric 10  √  null salesrep_bpartner_numberemployees
salesrep_bpartner_paymentrule bpchar 1  √  null salesrep_bpartner_paymentrule
salesrep_bpartner_paymentrupo bpchar 1  √  null salesrep_bpartner_paymentrulepo
salesrep_bp_po_discountscm_id numeric 10  √  null SalesRep_BP_PO_DiscountScm_ID
salesrep_bp_po_paymentterm_id numeric 10  √  null SalesRep_BP_PO_PaymentTerm_ID
salesrep_bp_po_pricelist_id numeric 10  √  null SalesRep_BP_PO_PriceList_ID
salesrep_bpartner_poreference varchar 20  √  null salesrep_bpartner_poreference
salesrep_bpartner_potentialli numeric 0  √  null salesrep_bpartner_potentiallifetimevalue
salesrep_bpartner_rating bpchar 1  √  null salesrep_bpartner_rating
salesrep_bpartner_salesrep_id numeric 10  √  null salesrep_bpartner_salesrep_id
salesrep_bpartner_salesvolume numeric 10  √  null salesrep_bpartner_salesvolume
salesrep_bpartner_sendemail bpchar 1  √  null salesrep_bpartner_sendemail
salesrep_bpartner_shareofcust numeric 10  √  null salesrep_bpartner_shareofcustomer
salesrep_bpartner_shelflifemi numeric 10  √  null salesrep_bpartner_shelflifeminpct
salesrep_bpartner_so_creditli numeric 0  √  null salesrep_bpartner_so_creditlimit
salesrep_bpartner_socreditsta bpchar 1  √  null salesrep_bpartner_socreditstatus
salesrep_bpartner_so_creditus numeric 0  √  null salesrep_bpartner_so_creditused
salesrep_bpartner_so_descript varchar 255  √  null salesrep_bpartner_so_description
salesrep_bpartner_totalopenba numeric 0  √  null salesrep_bpartner_totalopenbalance
salesrep_bpartner_updated timestamp 29,6  √  null salesrep_bpartner_updated
salesrep_bpartner_updatedby numeric 10  √  null salesrep_bpartner_updatedby
salesrep_bpartner_url varchar 120  √  null salesrep_bpartner_url

Analyzed at 2021-12-25 14:53 +0100