idempiere11.adempiere contains 341 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
ad_printformat	ad_client_id	numeric	10				Tenant for this installation.
ad_printformat	ad_org_id	numeric	10				Organizational entity within tenant
ad_printformat	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printformat	ad_printfont_id	numeric	10				Maintain Print Font
ad_printformat	ad_printformat_id	numeric	10				Data Print Format
ad_printformat	ad_printformat_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_UU
ad_printformat	ad_printheaderfooter_id	numeric	10	√		NULL::numeric	Print Header/Footer
ad_printformat	ad_printpaper_id	numeric	10				Printer paper definition
ad_printformat	ad_printtableformat_id	numeric	10	√		null	Table Format in Reports
ad_printformat	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_printformat	ad_table_id	numeric	10				Database Table information
ad_printformat	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
ad_printformat	args	varchar	510	√		null	Args
ad_printformat	classname	varchar	240	√		null	Java Classname
ad_printformat	createcopy	bpchar	1	√		null	Create Copy
ad_printformat	created	timestamp	29,6			now()	Date this record was created
ad_printformat	createdby	numeric	10				User who created this records
ad_printformat	description	varchar	255	√		null	Optional short description of the record
ad_printformat	filenamepattern	varchar	255	√		null	File Name Pattern
ad_printformat	footermargin	numeric	10				Margin of the Footer in 1/72 of an inch
ad_printformat	headermargin	numeric	10				Margin of the Header in 1/72 of an inch
ad_printformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printformat	isbreakpageperrecord	bpchar	1			'Y'::bpchar	Page Break after each record
ad_printformat	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printformat	isform	bpchar	1			'N'::bpchar	If Selected, a Form is printed, if not selected a columnar List report
ad_printformat	isstandardheaderfooter	bpchar	1			'Y'::bpchar	The standard Header and Footer is used
ad_printformat	istablebased	bpchar	1			'Y'::bpchar	Table based List Reporting
ad_printformat	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the print engine if any process defined
ad_printformat	name	varchar	60				Alphanumeric identifier of the entity
ad_printformat	printername	varchar	40	√		null	Name of the Printer
ad_printformat	updated	timestamp	29,6			now()	Date this record was updated
ad_printformat	updatedby	numeric	10				User who updated this records
ad_user	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	authenticationtype	varchar	10	√		NULL::character varying	Authentication Type
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_user	createdby	numeric	10				User who created this records
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
ad_user	description	varchar	255	√		null	Optional short description of the record
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
ad_user	processing	bpchar	1	√		null	Process Now
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updatedby	numeric	10				User who updated this records
ad_user	userpin	varchar	20	√		null	User PIN
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
c_bp_group	ad_client_id	numeric	10				Tenant for this installation.
c_bp_group	ad_org_id	numeric	10				Organizational entity within tenant
c_bp_group	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_bp_group	c_bp_group_id	numeric	10				Business Partner Group
c_bp_group	c_bp_group_uu	varchar	36	√		NULL::character varying	C_BP_Group_UU
c_bp_group	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bp_group	created	timestamp	29,6			now()	Date this record was created
c_bp_group	createdby	numeric	10				User who created this records
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bp_group	description	varchar	255	√		null	Optional short description of the record
c_bp_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
c_bp_group	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bp_group	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bp_group	name	varchar	60				Alphanumeric identifier of the entity
c_bp_group	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bp_group	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
c_bp_group	updated	timestamp	29,6			now()	Date this record was updated
c_bp_group	updatedby	numeric	10				User who updated this records
c_bp_group	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner_location	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner_location	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_location	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_bpartner_location	c_bpartner_location_uu	varchar	36	√		NULL::character varying	C_BPartner_Location_UU
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_bpartner_location	created	timestamp	29,6			now()	Date this record was created
c_bpartner_location	createdby	numeric	10				User who created this records
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_bpartner_location	fax	varchar	40	√		null	Facsimile number
c_bpartner_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner_location	isbillto	bpchar	1			'Y'::bpchar	Business Partner Invoice/Bill Address
c_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
c_bpartner_location	ispayfrom	bpchar	1			'Y'::bpchar	Business Partner pays from that address and we'll send dunning letters there
c_bpartner_location	ispreservecustomname	bpchar	1			'N'::bpchar	Preserve custom name
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
c_bpartner_location	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_bpartner_location	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_location	updatedby	numeric	10				User who updated this records
c_currency	ad_client_id	numeric	10				Tenant for this installation.
c_currency	ad_org_id	numeric	10				Organizational entity within tenant
c_currency	c_currency_id	numeric	10				The Currency for this record
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_currency	created	timestamp	29,6			now()	Date this record was created
c_currency	createdby	numeric	10				User who created this records
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_currency	description	varchar	255				Optional short description of the record
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_currency	updatedby	numeric	10				User who updated this records
c_dunning	ad_client_id	numeric	10				Tenant for this installation.
c_dunning	ad_org_id	numeric	10				Organizational entity within tenant
c_dunning	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunning	c_dunning_uu	varchar	36	√		NULL::character varying	C_Dunning_UU
c_dunning	created	timestamp	29,6			now()	Date this record was created
c_dunning	createdby	numeric	10				User who created this records
c_dunning	createlevelssequentially	bpchar	1			'N'::bpchar	Create Dunning Letter by level sequentially
c_dunning	description	varchar	255	√		null	Optional short description of the record
c_dunning	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunning	isdefault	bpchar	1			'N'::bpchar	Default value
c_dunning	name	varchar	60				Alphanumeric identifier of the entity
c_dunning	senddunningletter	bpchar	1			'Y'::bpchar	Indicates if dunning letters will be sent
c_dunning	updated	timestamp	29,6			now()	Date this record was updated
c_dunning	updatedby	numeric	10				User who updated this records
c_dunninglevel	ad_client_id	numeric	10				Tenant for this installation.
c_dunninglevel	ad_org_id	numeric	10				Organizational entity within tenant
c_dunninglevel	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunninglevel	c_dunninglevel_id	numeric	10				Dunning Level
c_dunninglevel	c_dunninglevel_uu	varchar	36	√		NULL::character varying	C_DunningLevel_UU
c_dunninglevel	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_dunninglevel	chargefee	bpchar	1			'Y'::bpchar	Indicates if fees will be charged for overdue invoices
c_dunninglevel	chargeinterest	bpchar	1			'Y'::bpchar	Indicates if interest will be charged on overdue invoices
c_dunninglevel	created	timestamp	29,6			now()	Date this record was created
c_dunninglevel	createdby	numeric	10				User who created this records
c_dunninglevel	daysafterdue	numeric	10				Days after due date to dun (if negative days until due)
c_dunninglevel	daysbetweendunning	numeric	10				Days between sending dunning notices
c_dunninglevel	description	varchar	255	√		null	Optional short description of the record
c_dunninglevel	dunning_printformat_id	numeric	10	√		null	Print Format for printing Dunning Letters
c_dunninglevel	feeamt	numeric	0	√		0	Fee amount in invoice currency
c_dunninglevel	interestpercent	numeric	0	√		0	Percentage interest to charge on overdue invoices
c_dunninglevel	invoicecollectiontype	bpchar	1	√		NULL::bpchar	Invoice Collection Status
c_dunninglevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunninglevel	issetcreditstop	bpchar	1			'N'::bpchar	Set the business partner to credit stop
c_dunninglevel	issetpaymentterm	bpchar	1			'N'::bpchar	Set the payment term of the Business Partner
c_dunninglevel	isshowalldue	bpchar	1			'N'::bpchar	Show/print all due invoices
c_dunninglevel	isshownotdue	bpchar	1			'N'::bpchar	Show/print all invoices which are not due (yet).
c_dunninglevel	isstatement	bpchar	1			'N'::bpchar	Dunning Level is a definition of a statement
c_dunninglevel	name	varchar	60			'x'::character varying	Alphanumeric identifier of the entity
c_dunninglevel	note	varchar	2000	√		null	Optional additional user defined information
c_dunninglevel	printname	varchar	60				The label text to be printed on a document or correspondence.
c_dunninglevel	updated	timestamp	29,6			now()	Date this record was updated
c_dunninglevel	updatedby	numeric	10				User who updated this records
c_dunningrun	ad_client_id	numeric	10				Tenant for this installation.
c_dunningrun	ad_org_id	numeric	10				Organizational entity within tenant
c_dunningrun	c_dunning_id	numeric	10			NULL::numeric	Dunning Rules for overdue invoices
c_dunningrun	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_dunningrun	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrun	c_dunningrun_uu	varchar	36	√		NULL::character varying	C_DunningRun_UU
c_dunningrun	created	timestamp	29,6			now()	Date this record was created
c_dunningrun	createdby	numeric	10				User who created this records
c_dunningrun	description	varchar	255	√		null	Optional short description of the record
c_dunningrun	dunningdate	timestamp	29,6				Date of Dunning
c_dunningrun	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrun	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrun	processing	bpchar	1	√		null	Process Now
c_dunningrun	sendit	bpchar	1	√		null	Send
c_dunningrun	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrun	updatedby	numeric	10				User who updated this records
c_dunningrunentry	ad_client_id	numeric	10				Tenant for this installation.
c_dunningrunentry	ad_org_id	numeric	10				Organizational entity within tenant
c_dunningrunentry	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_dunningrunentry	amt	numeric	0			0	Amount
c_dunningrunentry	c_bpartner_id	numeric	10				Identifies a Business Partner
c_dunningrunentry	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_dunningrunentry	c_currency_id	numeric	10				The Currency for this record
c_dunningrunentry	c_dunninglevel_id	numeric	10			NULL::numeric	Dunning Level
c_dunningrunentry	c_dunningrun_id	numeric	10				Dunning Run
c_dunningrunentry	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunentry	c_dunningrunentry_uu	varchar	36	√		NULL::character varying	C_DunningRunEntry_UU
c_dunningrunentry	created	timestamp	29,6			now()	Date this record was created
c_dunningrunentry	createdby	numeric	10				User who created this records
c_dunningrunentry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunentry	note	varchar	2000	√		null	Optional additional user defined information
c_dunningrunentry	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunentry	qty	numeric	0			0	Quantity
c_dunningrunentry	salesrep_id	numeric	10				Sales Representative or Company Agent
c_dunningrunentry	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunentry	updatedby	numeric	10				User who updated this records
c_dunningrunline	ad_client_id	numeric	10				Tenant for this installation.
c_dunningrunline	ad_org_id	numeric	10				Organizational entity within tenant
c_dunningrunline	amt	numeric	0			0	Amount
c_dunningrunline	c_dunningrunentry_id	numeric	10				Dunning Run Entry
c_dunningrunline	c_dunningrunline_id	numeric	10				Dunning Run Line
c_dunningrunline	c_dunningrunline_uu	varchar	36	√		NULL::character varying	C_DunningRunLine_UU
c_dunningrunline	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_dunningrunline	c_invoicepayschedule_id	numeric	10	√		null	Invoice Payment Schedule
c_dunningrunline	c_payment_id	numeric	10	√		null	Payment identifier
c_dunningrunline	convertedamt	numeric	0			0	Converted Amount
c_dunningrunline	created	timestamp	29,6			now()	Date this record was created
c_dunningrunline	createdby	numeric	10				User who created this records
c_dunningrunline	daysdue	numeric	10			0	Number of days due (negative: due in number of days)
c_dunningrunline	feeamt	numeric	0			0	Fee amount in invoice currency
c_dunningrunline	interestamt	numeric	0			0	Interest Amount
c_dunningrunline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunningrunline	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_dunningrunline	openamt	numeric	0				Open item amount
c_dunningrunline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_dunningrunline	timesdunned	numeric	10			0	Number of times dunned previously
c_dunningrunline	totalamt	numeric	0			0	Total Amount
c_dunningrunline	updated	timestamp	29,6			now()	Date this record was updated
c_dunningrunline	updatedby	numeric	10				User who updated this records