idempiere9.adempiere contains 304 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
c_salesdashboard	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
c_salesdashboard	ad_org_id	numeric	10	√		null	Organizational entity within client
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_contactactivity	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
c_opportunity	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_salesdashboard	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_location_id	numeric	10	√		null	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_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_opportunity	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
c_campaign	c_channel_id	numeric	10	√		null	Sales Channel
c_contactactivity	c_contactactivity_uu	varchar	36	√		NULL::character varying	C_ContactActivity_UU
c_cycle	c_cycle_uu	varchar	36	√		NULL::character varying	C_Cycle_UU
c_cyclestep	c_cyclestep_uu	varchar	36	√		NULL::character varying	C_CycleStep_UU
c_bpartner_location	c_location_id	numeric	10	√		null	Location or Address
c_contactactivity	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_opportunity	c_opportunity_uu	varchar	36	√		NULL::character varying	C_Opportunity_UU
c_opportunity	c_order_id	numeric	10	√		NULL::numeric	Order
c_projectline	c_order_id	numeric	10	√		null	Order
c_projectline	c_orderpo_id	numeric	10	√		null	Purchase Order
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_phase	c_phase_uu	varchar	36	√		NULL::character varying	C_Phase_UU
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_projectline	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
c_projectline	c_projectline_uu	varchar	36	√		NULL::character varying	C_ProjectLine_UU
c_projectline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_projectline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_bpartner_location	c_salesregion_id	numeric	10	√		null	Sales coverage region
c_salesstage	c_salesstage_uu	varchar	36	√		NULL::character varying	C_SalesStage_UU
c_opportunity	closedate	timestamp	29,6	√		null	Close Date
c_contactactivity	comments	text	2147483647	√		null	Comments or additional information
c_opportunity	comments	text	2147483647	√		null	Comments or additional information
m_bp_price	comments	varchar	2000	√		NULL::character varying	Comments or additional information
c_projectline	committedamt	numeric	0	√		0	The (legal) commitment amount
c_projectline	committedqty	numeric	0	√		0	The (legal) commitment Quantity
c_project	copyfrom	bpchar	1	√		null	Copy From Record
c_opportunity	cost	numeric	0	√		null	Cost information
c_salesdashboard	created	timestamp	29,6	√		null	Date this record was created
c_salesdashboard	createdby	numeric	10	√		null	User who created this records
c_bpartner_location	customeraddressid	varchar	60	√		NULL::character varying	Customer Address ID
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_campaign	description	varchar	255	√		null	Optional short description of the record
c_cycle	description	varchar	255	√		null	Optional short description of the record
c_opportunity	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_phase	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_projectline	description	varchar	255	√		null	Optional short description of the record
c_salesstage	description	varchar	255	√		NULL::character varying	Optional short description of the record
r_interestarea	description	varchar	255	√		null	Optional short description of the record
m_bp_price	discount	numeric	0	√		null	Discount in percent
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
c_projectline	dopricing	bpchar	1	√		'Y'::bpchar	Pricing
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_contactactivity	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_bpartner_location	fax	varchar	40	√		null	Facsimile number
c_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
c_project	generateto	bpchar	1	√		null	Generate To
c_phase	help	varchar	2000	√		null	Comment or Hint
c_salesdashboard	isactive	bpchar	1	√		null	The record is active in the system
c_contactactivity	iscomplete	bpchar	1	√		NULL::bpchar	It is complete
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_bpartner_location	isdn	varchar	40	√		null	ISDN or modem line
m_bp_price	isnetprice	bpchar	1	√		NULL::bpchar	Net Price including all discounts
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
c_salesstage	iswon	bpchar	1	√		NULL::bpchar	The opportunity was won
m_bp_price	m_bp_price_uu	varchar	36	√		NULL::character varying	M_BP_Price_UU
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
c_projectline	m_product_category_id	numeric	10	√		null	Category of a Product
c_phase	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectline	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectline	m_production_id	numeric	10	√		NULL::numeric	Plan for producing a product
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_salesdashboard	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_project	note	varchar	2000	√		null	Optional additional user defined information
r_contactinterest	optoutdate	timestamp	29,6	√		null	Date the contact opted out
c_bpartner_location	phone	varchar	40	√		null	Identifies a telephone number
c_bpartner_location	phone2	varchar	40	√		null	Identifies an alternate telephone number.
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_bp_price	priceoverridetype	bpchar	1	√		NULL::bpchar	Type of price override, fixed price or discount off list
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
r_contactinterest	r_contactinterest_uu	varchar	36	√		NULL::character varying	R_ContactInterest_UU
r_interestarea	r_interestarea_uu	varchar	36	√		NULL::character varying	R_InterestArea_UU
c_salesdashboard	salespipeline	int4	10	√		null	Sales Pipeline
c_contactactivity	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_opportunity	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_campaign	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_contactinterest	subscribedate	timestamp	29,6	√		null	Date the contact actively subscribed
c_salesdashboard	updated	timestamp	29,6	√		null	Date this record was updated
c_salesdashboard	updatedby	numeric	10	√		null	User who updated this records
m_bp_price	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
m_bp_price	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_bpartner_location	ad_client_id	numeric	10				Client/Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Client/Tenant for this installation.
c_contactactivity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cycle	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cyclestep	ad_client_id	numeric	10				Client/Tenant for this installation.
c_opportunity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_phase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesstage	ad_client_id	numeric	10				Client/Tenant for this installation.
m_bp_price	ad_client_id	numeric	10				Client/Tenant for this installation.
r_contactinterest	ad_client_id	numeric	10				Client/Tenant for this installation.
r_interestarea	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner_location	ad_org_id	numeric	10				Organizational entity within client
c_campaign	ad_org_id	numeric	10				Organizational entity within client
c_contactactivity	ad_org_id	numeric	10				Organizational entity within client
c_cycle	ad_org_id	numeric	10				Organizational entity within client
c_cyclestep	ad_org_id	numeric	10				Organizational entity within client
c_opportunity	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
c_phase	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_projectline	ad_org_id	numeric	10				Organizational entity within client
c_salesstage	ad_org_id	numeric	10				Organizational entity within client
m_bp_price	ad_org_id	numeric	10				Organizational entity within client
r_contactinterest	ad_org_id	numeric	10				Organizational entity within client
r_interestarea	ad_org_id	numeric	10				Organizational entity within client
r_contactinterest	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
m_bp_price	breakvalue	numeric	0				Low Value of trade discount break level
c_bpartner_location	c_bpartner_id	numeric	10				Identifies a Business Partner
c_opportunity	c_bpartner_id	numeric	10				Identifies a Business Partner
m_bp_price	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_campaign	c_campaign_id	numeric	10				Marketing Campaign
c_contactactivity	c_contactactivity_id	numeric	10				Events, tasks, communications related to a contact
c_cycle	c_currency_id	numeric	10				The Currency for this record
c_opportunity	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
m_bp_price	c_currency_id	numeric	10				The Currency for this record
c_cycle	c_cycle_id	numeric	10				Identifier for this Project Reporting Cycle
c_cyclestep	c_cycle_id	numeric	10				Identifier for this Project Reporting Cycle
c_cyclestep	c_cyclestep_id	numeric	10				The step for this Cycle
c_opportunity	c_opportunity_id	numeric	10				Sales Opportunity
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_phase	c_phase_id	numeric	10				Standard Phase of the Project Type
c_project	c_project_id	numeric	10				Financial Project
c_projectline	c_project_id	numeric	10				Financial Project
c_projectline	c_projectline_id	numeric	10				Task or step in a project
c_phase	c_projecttype_id	numeric	10				Type of the project
c_opportunity	c_salesstage_id	numeric	10				Stages of the sales process
c_salesstage	c_salesstage_id	numeric	10				Stages of the sales process
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_contactactivity	contactactivitytype	varchar	10				Type of activity, e.g. task, email, phone call
c_campaign	costs	numeric	0			0	Costs in accounting currency
c_bpartner_location	created	timestamp	29,6			now()	Date this record was created
c_campaign	created	timestamp	29,6			now()	Date this record was created
c_contactactivity	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_cycle	created	timestamp	29,6			now()	Date this record was created
c_cyclestep	created	timestamp	29,6			now()	Date this record was created
c_opportunity	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_phase	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_projectline	created	timestamp	29,6			now()	Date this record was created
c_salesstage	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_bp_price	created	timestamp	29,6			statement_timestamp()	Date this record was created
r_contactinterest	created	timestamp	29,6			now()	Date this record was created
r_interestarea	created	timestamp	29,6			now()	Date this record was created
c_bpartner_location	createdby	numeric	10				User who created this records
c_campaign	createdby	numeric	10				User who created this records
c_contactactivity	createdby	numeric	10				User who created this records
c_cycle	createdby	numeric	10				User who created this records
c_cyclestep	createdby	numeric	10				User who created this records
c_opportunity	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_phase	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_projectline	createdby	numeric	10				User who created this records
c_salesstage	createdby	numeric	10				User who created this records
m_bp_price	createdby	numeric	10				User who created this records
r_contactinterest	createdby	numeric	10				User who created this records
r_interestarea	createdby	numeric	10				User who created this records
c_contactactivity	description	varchar	255				Optional short description of the record
c_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
c_opportunity	documentno	varchar	60				Document sequence number of the document
c_opportunity	expectedclosedate	timestamp	29,6				Expected Close Date
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_projectline	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_projectline	invoicedqty	numeric	0			0	The quantity invoiced
c_bpartner_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_campaign	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_contactactivity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cycle	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cyclestep	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_opportunity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentterm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_phase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projectline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesstage	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_bp_price	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_contactinterest	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_interestarea	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_salesstage	isclosed	bpchar	1			'N'::bpchar	The status is closed
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
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_projectline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
c_bpartner_location	isremitto	bpchar	1			'Y'::bpchar	Business Partner payment address
r_interestarea	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_bpartner_location	isshipto	bpchar	1			'Y'::bpchar	Business Partner Shipment Address
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_projectline	line	numeric	10				Unique line for this document
m_bp_price	m_bp_price_id	numeric	10				Business Partner Price
m_bp_price	m_product_id	numeric	10				Product, Service, Item
c_bpartner_location	name	varchar	60				Alphanumeric identifier of the entity
c_campaign	name	varchar	60				Alphanumeric identifier of the entity
c_cycle	name	varchar	60				Alphanumeric identifier of the entity
c_cyclestep	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_phase	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_salesstage	name	varchar	60				Alphanumeric identifier of the entity
r_interestarea	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
c_opportunity	opportunityamt	numeric	0				The estimated value of this opportunity.
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_projectline	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_projectline	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_projectline	plannedprice	numeric	0			0	Planned price for this project line
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_projectline	plannedqty	numeric	0			0	Planned quantity for this project
m_bp_price	pricelimit	numeric	0				Lowest price for a product
m_bp_price	pricelist	numeric	0				List Price
m_bp_price	pricestd	numeric	0				Standard Price
c_opportunity	probability	numeric	0				Probability
c_salesstage	probability	numeric	0				Probability
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
r_contactinterest	r_interestarea_id	numeric	10				Interest Area or Topic
r_interestarea	r_interestarea_id	numeric	10				Interest Area or Topic
c_cyclestep	relativeweight	numeric	0				Relative weight of this step (0 = ignored)
c_cyclestep	seqno	numeric	10				Method of ordering records; lowest number comes first
c_phase	seqno	numeric	10				Method of ordering records; lowest number comes first
c_phase	standardqty	numeric	0			0	Standard Quantity
c_contactactivity	startdate	timestamp	29,6				First effective day (inclusive)
c_bpartner_location	updated	timestamp	29,6			now()	Date this record was updated
c_campaign	updated	timestamp	29,6			now()	Date this record was updated
c_contactactivity	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_cycle	updated	timestamp	29,6			now()	Date this record was updated
c_cyclestep	updated	timestamp	29,6			now()	Date this record was updated
c_opportunity	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_phase	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_projectline	updated	timestamp	29,6			now()	Date this record was updated
c_salesstage	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_bp_price	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
r_contactinterest	updated	timestamp	29,6			now()	Date this record was updated
r_interestarea	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_location	updatedby	numeric	10				User who updated this records
c_campaign	updatedby	numeric	10				User who updated this records
c_contactactivity	updatedby	numeric	10				User who updated this records
c_cycle	updatedby	numeric	10				User who updated this records
c_cyclestep	updatedby	numeric	10				User who updated this records
c_opportunity	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_phase	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_projectline	updatedby	numeric	10				User who updated this records
c_salesstage	updatedby	numeric	10				User who updated this records
m_bp_price	updatedby	numeric	10				User who updated this records
r_contactinterest	updatedby	numeric	10				User who updated this records
r_interestarea	updatedby	numeric	10				User who updated this records
c_campaign	value	varchar	40				Search key for the record in the format required - must be unique
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
c_salesstage	value	varchar	60				Search key for the record in the format required - must be unique
r_interestarea	value	varchar	40				Search key for the record in the format required - must be unique