SchemaSpy - View idempiere9.adempiere.c_dunning_header

C_Dunning_Header_vt

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	Default
ad_client_id	numeric	10	√	null
ad_org_id	numeric	10	√	null
isactive	bpchar	1	√	null
created	timestamp	29,6	√	null
createdby	numeric	10	√	null
updated	timestamp	29,6	√	null
updatedby	numeric	10	√	null
ad_language	varchar	6	√	null
c_dunningrun_id	numeric	10	√	null
c_dunningrunentry_id	numeric	10	√	null
dunningdate	timestamp	29,6	√	null
printname	varchar	60	√	null
documentnote	varchar	2000	√	null
c_bpartner_id	numeric	10	√	null
bpvalue	varchar	40	√	null
bptaxid	varchar	20	√	null
naics	varchar	6	√	null
duns	varchar	11	√	null
org_location_id	numeric	10	√	null
taxid	varchar	20	√	null
salesrep_id	numeric	10	√	null
salesrep_name	varchar	2147483647	√	null
bpgreeting	varchar	60	√	null
name	varchar	120	√	null
name2	varchar	60	√	null
bpcontactgreeting	varchar	60	√	null
title	varchar	40	√	null
phone	varchar	40	√	null
contactname	text	2147483647	√	null
c_location_id	numeric	10	√	null
referenceno	varchar	40	√	null
postal	text	2147483647	√	null
amt	numeric	0	√	null
qty	numeric	0	√	null
note	varchar	2000	√	null
logo_id	numeric	10	√	null
c_dunning_id	numeric	10	√	null
c_dunningrun_c_dunninglevel_id	numeric	10	√	null
c_dunningrun_description	varchar	255	√	null
processed	bpchar	1	√	null
processing	bpchar	1	√	null
sendit	bpchar	1	√	null
c_dunningrunentry_ad_org_id	numeric	10	√	null
ad_user_id	numeric	10	√	null
c_bpartner_location_id	numeric	10	√	null
c_currency_id	numeric	10	√	null
c_dunrunentry_c_dunlevel_id	numeric	10	√	null
c_dunningrunentry_created	timestamp	29,6	√	null
c_dunningrunentry_createdby	numeric	10	√	null
c_dunningrunentry_isactive	bpchar	1	√	null
c_dunningrunentry_processed	bpchar	1	√	null
c_dunningrunentry_updated	timestamp	29,6	√	null
c_dunningrunentry_updatedby	numeric	10	√	null
c_dunninglevel_ad_org_id	numeric	10	√	null
c_dunninglevel_c_dunning_id	numeric	10	√	null
chargefee	bpchar	1	√	null
chargeinterest	bpchar	1	√	null
c_paymentterm_id	numeric	10	√	null
daysafterdue	numeric	10	√	null
daysbetweendunning	numeric	10	√	null
c_dunninglevel_description	varchar	255	√	null
dunning_printformat_id	numeric	10	√	null
feeamt	numeric	0	√	null
interestpercent	numeric	0	√	null
invoicecollectiontype	bpchar	1	√	null
c_dunninglevel_isactive	bpchar	1	√	null
issetcreditstop	bpchar	1	√	null
issetpaymentterm	bpchar	1	√	null
isshowalldue	bpchar	1	√	null
isshownotdue	bpchar	1	√	null
isstatement	bpchar	1	√	null
c_dunninglevel_name	varchar	60	√	null
c_bpartner_acqusitioncost	numeric	0	√	null
c_bpartner_actuallifetimevalue	numeric	0	√	null
c_bpartner_ad_language	varchar	6	√	null
c_bpartner_ad_orgbp_id	numeric	10	√	null
c_bpartner_ad_org_id	numeric	10	√	null
c_bpartner_bpartner_parent_id	numeric	10	√	null
c_bpartner_c_bp_group_id	numeric	10	√	null
c_bpartner_c_greeting_id	numeric	10	√	null
c_bpartner_invoiceschedule_id	numeric	10	√	null
c_bpartner_c_paymentterm_id	numeric	10	√	null
c_bpartner_created	timestamp	29,6	√	null
c_bpartner_createdby	numeric	10	√	null
c_bpartner_c_taxgroup_id	numeric	10	√	null
c_bpartner_deliveryrule	bpchar	1	√	null
c_bpartner_deliveryviarule	bpchar	1	√	null
c_bpartner_description	varchar	255	√	null
c_bpartner_dunninggrace	timestamp	29,6	√	null
c_bpartner_firstsale	timestamp	29,6	√	null
c_bpartner_flatdiscount	numeric	0	√	null
c_bpartner_freightcostrule	bpchar	1	√	null
c_bpartner_invoicerule	bpchar	1	√	null
c_bpartner_isactive	bpchar	1	√	null
c_bpartner_iscustomer	bpchar	1	√	null
c_bpartner_isdiscountprinted	bpchar	1	√	null
c_bpartner_isemployee	bpchar	1	√	null
c_bpartner_ismanufacturer	bpchar	1	√	null
c_bpartner_isonetime	bpchar	1	√	null
c_bpartner_ispotaxexempt	bpchar	1	√	null
c_bpartner_isprospect	bpchar	1	√	null
c_bpartner_issalesrep	bpchar	1	√	null
c_bpartner_issummary	bpchar	1	√	null
c_bpartner_istaxexempt	bpchar	1	√	null
c_bpartner_isvendor	bpchar	1	√	null
c_bpartner_logo_id	numeric	10	√	null
c_bpartner_m_discountschema_id	numeric	10	√	null
c_bpartner_m_pricelist_id	numeric	10	√	null
c_bpartner_naics	varchar	6	√	null
c_bpartner_numberemployees	numeric	10	√	null
c_bpartner_paymentrule	bpchar	1	√	null
c_bpartner_paymentrulepo	bpchar	1	√	null
c_bpartnerpo_discountschema_id	numeric	10	√	null
c_bpartner_po_paymentterm_id	numeric	10	√	null
c_bpartner_po_pricelist_id	numeric	10	√	null
c_bpartner_poreference	varchar	20	√	null
c_bpartner_potentiallifetimev	numeric	0	√	null
c_bpartner_rating	bpchar	1	√	null
c_bpartner_salesrep_id	numeric	10	√	null
c_bpartner_salesvolume	numeric	10	√	null
c_bpartner_sendemail	bpchar	1	√	null
c_bpartner_shareofcustomer	numeric	10	√	null
c_bpartner_shelflifeminpct	numeric	10	√	null
c_bpartner_so_creditlimit	numeric	0	√	null
c_bpartner_socreditstatus	bpchar	1	√	null
c_bpartner_so_creditused	numeric	0	√	null
c_bpartner_so_description	varchar	255	√	null
c_bpartner_totalopenbalance	numeric	0	√	null
c_bpartner_updated	timestamp	29,6	√	null
c_bpartner_updatedby	numeric	10	√	null
c_bpartner_url	varchar	120	√	null
c_bpartner_greeting_ad_org_id	numeric	10	√	null
c_bpartner_greeting_isactive	bpchar	1	√	null
c_bpartner_greeting_isfirstna	bpchar	1	√	null
c_bpartner_greeting_name	varchar	60	√	null
c_bpartner_location_ad_org_id	numeric	10	√	null
c_bpartner_location_created	timestamp	29,6	√	null
c_bpartner_location_createdby	numeric	10	√	null
c_salesregion_id	numeric	10	√	null
c_bpartner_location_fax	varchar	40	√	null
c_bpartner_location_isactive	bpchar	1	√	null
isbillto	bpchar	1	√	null
isdn	varchar	40	√	null
ispayfrom	bpchar	1	√	null
isremitto	bpchar	1	√	null
isshipto	bpchar	1	√	null
c_bpartner_location_name	varchar	60	√	null
c_bpartner_location_phone	varchar	40	√	null
c_bpartner_location_phone2	varchar	40	√	null
c_bpartner_location_updated	timestamp	29,6	√	null
c_bpartner_location_updatedby	numeric	10	√	null
address1	varchar	60	√	null
address2	varchar	60	√	null
address3	varchar	60	√	null
address4	varchar	60	√	null
c_location_ad_org_id	numeric	10	√	null
c_city_id	numeric	10	√	null
c_country_id	numeric	10	√	null
city	varchar	60	√	null
c_location_created	timestamp	29,6	√	null
c_location_createdby	numeric	10	√	null
c_region_id	numeric	10	√	null
c_location_isactive	bpchar	1	√	null
postal_add	varchar	10	√	null
regionname	varchar	40	√	null
c_location_updated	timestamp	29,6	√	null
c_location_updatedby	numeric	10	√	null
ad_user_ad_org_id	numeric	10	√	null
ad_user_ad_ad_orgtrx_id	numeric	10	√	null
ad_user_ad_birthday	timestamp	29,6	√	null
ad_user_c_bpartner_id	numeric	10	√	null
ad_user_c_bpartner_location_id	numeric	10	√	null
ad_user_c_greeting_id	numeric	10	√	null
ad_user_comments	varchar	2000	√	null
ad_user_created	timestamp	29,6	√	null
ad_user_createdby	numeric	10	√	null
ad_user_description	varchar	255	√	null
ad_user_email	varchar	60	√	null
ad_user_fax	varchar	40	√	null
ad_user_isactive	bpchar	1	√	null
ad_user_lastcontact	timestamp	29,6	√	null
ad_user_lastresult	varchar	255	√	null
ad_user_name	varchar	60	√	null
ad_user_phone2	varchar	40	√	null
ad_user_supervisor_id	numeric	10	√	null
ad_user_updated	timestamp	29,6	√	null
ad_user_updatedby	numeric	10	√	null
ad_user_value	varchar	40	√	null
c_user_greeting_ad_org_id	numeric	10	√	null
c_user_greeting_isactive	bpchar	1	√	null
c_user_greeting_isfirstnameon	bpchar	1	√	null
c_user_greeting_name	varchar	60	√	null
ad_orginfo_ad_org_id	numeric	10	√	null
ad_orgtype_id	numeric	10	√	null
c_calendar_id	numeric	10	√	null
ad_orginfo_created	timestamp	29,6	√	null
ad_orginfo_createdby	numeric	10	√	null
dropship_warehouse_id	numeric	10	√	null
ad_orginfo_duns	varchar	11	√	null
ad_orginfo_email	varchar	60	√	null
ad_orginfo_fax	varchar	40	√	null
ad_orginfo_isactive	bpchar	1	√	null
m_warehouse_id	numeric	10	√	null
parent_org_id	numeric	10	√	null
ad_orginfo_phone	varchar	40	√	null
ad_orginfo_phone2	varchar	40	√	null
receiptfootermsg	varchar	1023	√	null
supervisor_id	numeric	10	√	null
ad_orginfo_updated	timestamp	29,6	√	null
ad_orginfo_updatedby	numeric	10	√	null
salesrep_ad_org_id	numeric	10	√	null
salesrep_ad_ad_orgtrx_id	numeric	10	√	null
salesrep_ad_birthday	timestamp	29,6	√	null
salesrep_c_bpartner_id	numeric	10	√	null
salesrep_c_bp_location_id	numeric	10	√	null
salesrep_c_greeting_id	numeric	10	√	null
salesrep_comments	varchar	2000	√	null
salesrep_created	timestamp	29,6	√	null
salesrep_createdby	numeric	10	√	null
salesrep_description	varchar	255	√	null
salesrep_email	varchar	60	√	null
salesrep_fax	varchar	40	√	null
salesrep_isactive	bpchar	1	√	null
salesrep_lastcontact	timestamp	29,6	√	null
salesrep_lastresult	varchar	255	√	null
salesrep_phone2	varchar	40	√	null
salesrep_supervisor_id	numeric	10	√	null
salesrep_updated	timestamp	29,6	√	null
salesrep_updatedby	numeric	10	√	null
salesrep_value	varchar	40	√	null
salesrep_bpartner_acqusitionc	numeric	0	√	null
salesrep_bpartner_actuallifet	numeric	0	√	null
salesrep_bpartner_ad_language	varchar	6	√	null
salesrep_bpartner_ad_orgbp_id	numeric	10	√	null
salesrep_bpartner_ad_org_id	numeric	10	√	null
salesrep_bpartner_bp_parent_id	numeric	10	√	null
salesrep_bp_c_bp_group_id	numeric	10	√	null
salesrep_bp_c_greeting_id	numeric	10	√	null
salesrep_bp_invoiceschedule_id	numeric	10	√	null
salesrep_bp_c_paymentterm_id	numeric	10	√	null
salesrep_bpartner_created	timestamp	29,6	√	null
salesrep_bpartner_createdby	numeric	10	√	null
salesrep_bp_c_taxgroup_id	numeric	10	√	null
salesrep_bpartner_deliveryrule	bpchar	1	√	null
salesrep_bpartner_deliveryvia	bpchar	1	√	null
salesrep_bpartner_description	varchar	255	√	null
salesrep_bpartner_dunninggrace	timestamp	29,6	√	null
salesrep_bpartner_firstsale	timestamp	29,6	√	null
salesrep_bpartner_flatdiscount	numeric	0	√	null
salesrep_bpartner_freightcost	bpchar	1	√	null
salesrep_bpartner_invoicerule	bpchar	1	√	null
salesrep_bpartner_isactive	bpchar	1	√	null
salesrep_bpartner_iscustomer	bpchar	1	√	null
salesrep_bpartner_isdiscountp	bpchar	1	√	null
salesrep_bpartner_isemployee	bpchar	1	√	null
salesrep_bpartner_ismanufactu	bpchar	1	√	null
salesrep_bpartner_isonetime	bpchar	1	√	null
salesrep_bpartner_ispotaxexem	bpchar	1	√	null
salesrep_bpartner_isprospect	bpchar	1	√	null
salesrep_bpartner_issalesrep	bpchar	1	√	null
salesrep_bpartner_issummary	bpchar	1	√	null
salesrep_bpartner_istaxexempt	bpchar	1	√	null
salesrep_bpartner_isvendor	bpchar	1	√	null
salesrep_bpartner_logo_id	numeric	10	√	null
salesrep_bp_mdiscountschema_id	numeric	10	√	null
salesrep_bp_m_pricelist_id	numeric	10	√	null
salesrep_bpartner_naics	varchar	6	√	null
salesrep_bpartner_numberemplo	numeric	10	√	null
salesrep_bpartner_paymentrule	bpchar	1	√	null
salesrep_bpartner_paymentrupo	bpchar	1	√	null
salesrep_bp_po_discountscm_id	numeric	10	√	null
salesrep_bp_po_paymentterm_id	numeric	10	√	null
salesrep_bp_po_pricelist_id	numeric	10	√	null
salesrep_bpartner_poreference	varchar	20	√	null
salesrep_bpartner_potentialli	numeric	0	√	null
salesrep_bpartner_rating	bpchar	1	√	null
salesrep_bpartner_salesrep_id	numeric	10	√	null
salesrep_bpartner_salesvolume	numeric	10	√	null
salesrep_bpartner_sendemail	bpchar	1	√	null
salesrep_bpartner_shareofcust	numeric	10	√	null
salesrep_bpartner_shelflifemi	numeric	10	√	null
salesrep_bpartner_so_creditli	numeric	0	√	null
salesrep_bpartner_socreditsta	bpchar	1	√	null
salesrep_bpartner_so_creditus	numeric	0	√	null
salesrep_bpartner_so_descript	varchar	255	√	null
salesrep_bpartner_totalopenba	numeric	0	√	null
salesrep_bpartner_updated	timestamp	29,6	√	null
salesrep_bpartner_updatedby	numeric	10	√	null
salesrep_bpartner_url	varchar	120	√	null

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