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

Table	Column	Type	Size	Nulls	Auto	Default
r_request	a_asset_id	numeric	10	√		null	Asset used internally or by customers
r_request_v	a_asset_id	numeric	10	√		null
r_requestaction	a_asset_id	numeric	10	√		null	Asset used internally or by customers
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
r_mailtext	ad_client_id	numeric	10				Client/Tenant for this installation.
r_request	ad_client_id	numeric	10				Client/Tenant for this installation.
r_request_v	ad_client_id	numeric	10	√		null
r_requestaction	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessor_route	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requesttype	ad_client_id	numeric	10				Client/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 client
r_mailtext	ad_org_id	numeric	10				Organizational entity within client
r_request	ad_org_id	numeric	10				Organizational entity within client
r_request_v	ad_org_id	numeric	10	√		null
r_requestaction	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessor	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessor_route	ad_org_id	numeric	10				Organizational entity within client
r_requesttype	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
r_request	ad_role_id	numeric	10	√		null	Responsibility Role
r_request_v	ad_role_id	numeric	10	√		null
r_requestaction	ad_role_id	numeric	10	√		null	Responsibility Role
r_requestprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
r_request	ad_table_id	numeric	10	√		null	Database Table information
r_request_v	ad_table_id	numeric	10	√		null
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_request	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_request_v	ad_user_id	numeric	10	√		null
r_requestaction	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_requestprocessor_route	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
r_requesttype	autoduedatedays	numeric	10	√		null	Automatic Due Date Days
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
r_request	c_activity_id	numeric	10	√		null	Business Activity
r_request_v	c_activity_id	numeric	10	√		null
r_requestaction	c_activity_id	numeric	10	√		null	Business Activity
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
r_request	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
r_request_v	c_bpartner_id	numeric	10	√		null
r_requestaction	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
r_request	c_campaign_id	numeric	10	√		null	Marketing Campaign
r_request_v	c_campaign_id	numeric	10	√		null
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
r_request	c_invoice_id	numeric	10	√		null	Invoice Identifier
r_request_v	c_invoice_id	numeric	10	√		null
r_requestaction	c_invoice_id	numeric	10	√		null	Invoice Identifier
r_request	c_invoicerequest_id	numeric	10	√		null	The generated invoice for this request
r_request_v	c_invoicerequest_id	numeric	10	√		null
ad_user	c_job_id	numeric	10	√		null	Job Position
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
r_request	c_order_id	numeric	10	√		null	Order
r_request_v	c_order_id	numeric	10	√		null
r_requestaction	c_order_id	numeric	10	√		null	Order
r_request	c_payment_id	numeric	10	√		null	Payment identifier
r_request_v	c_payment_id	numeric	10	√		null
r_requestaction	c_payment_id	numeric	10	√		null	Payment identifier
r_request	c_project_id	numeric	10	√		null	Financial Project
r_request_v	c_project_id	numeric	10	√		null
r_requestaction	c_project_id	numeric	10	√		null	Financial Project
r_request	closedate	timestamp	29,6	√		null	Close Date
r_request_v	closedate	timestamp	29,6	√		null
ad_user	comments	varchar	2000	√		null	Comments or additional information
r_request	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
r_request_v	confidentialtype	bpchar	1	√		null
r_requestaction	confidentialtype	bpchar	1	√		null	Type of Confidentiality
r_requesttype	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
r_request	confidentialtypeentry	bpchar	1				Confidentiality of the individual entry
r_request_v	confidentialtypeentry	bpchar	1	√		null
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
r_requesttype	contentcolor	varchar	7	√		NULL::character varying	Content color of calendar dashlet
ad_user	created	timestamp	29,6			now()	Date this record was created
r_mailtext	created	timestamp	29,6			now()	Date this record was created
r_request	created	timestamp	29,6			now()	Date this record was created
r_request_v	created	timestamp	29,6	√		null
r_requestaction	created	timestamp	29,6			now()	Date this record was created
r_requestprocessor	created	timestamp	29,6			now()	Date this record was created
r_requestprocessor_route	created	timestamp	29,6			now()	Date this record was created
r_requesttype	created	timestamp	29,6			now()	Date this record was created
ad_user	createdby	numeric	10				User who created this records
r_mailtext	createdby	numeric	10				User who created this records
r_request	createdby	numeric	10				User who created this records
r_request_v	createdby	numeric	10	√		null
r_requestaction	createdby	numeric	10				User who created this records
r_requestprocessor	createdby	numeric	10				User who created this records
r_requestprocessor_route	createdby	numeric	10				User who created this records
r_requesttype	createdby	numeric	10				User who created this records
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
r_request	datecompleteplan	timestamp	29,6	√		null	Planned Completion Date
r_request_v	datecompleteplan	timestamp	29,6	√		null
r_requestaction	datecompleteplan	timestamp	29,6	√		null	Planned Completion Date
r_request	datelastaction	timestamp	29,6	√		null	Date this request was last acted on
r_request_v	datelastaction	timestamp	29,6	√		null
r_request	datelastalert	timestamp	29,6	√		null	Date when last alert were sent
r_request_v	datelastalert	timestamp	29,6	√		null
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
r_requestprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
r_request	datenextaction	timestamp	29,6	√		null	Date that this request should be acted on
r_request_v	datenextaction	timestamp	29,6	√		null
r_requestaction	datenextaction	timestamp	29,6	√		null	Date that this request should be acted on
r_requestprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
r_request	datestartplan	timestamp	29,6	√		null	Planned Start Date
r_request_v	datestartplan	timestamp	29,6	√		null
r_requestaction	datestartplan	timestamp	29,6	√		null	Planned Start Date
ad_user	description	varchar	255	√		null	Optional short description of the record
r_requestprocessor	description	varchar	255	√		null	Optional short description of the record
r_requesttype	description	varchar	255	√		null	Optional short description of the record
r_request	documentno	varchar	30				Document sequence number of the document
r_request_v	documentno	varchar	30	√		null
r_requesttype	duedatetolerance	numeric	10			7	Tolerance in days between the Date Next Action and the date the request is regarded as overdue
r_request	duetype	bpchar	1				Status of the next action for this Request
r_request_v	duetype	bpchar	1	√		null
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
r_requestaction	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
r_request	endtime	timestamp	29,6	√		null	End of the time span
r_request_v	endtime	timestamp	29,6	√		null
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_user	fax	varchar	40	√		null	Facsimile number
r_requestprocessor	frequency	numeric	10	√		(1)::numeric	Frequency of events
r_requestprocessor	frequencytype	bpchar	1	√		null	Frequency of event
r_requesttype	headercolor	varchar	7	√		NULL::character varying	Header color of calendar dashlet
r_requestprocessor	inactivityalertdays	numeric	10			0	Send Alert when there is no activity after days (0= no alert)
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_mailtext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_request	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_request_v	isactive	bpchar	1	√		null
r_requestaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessor_route	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requesttype	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
r_requesttype	isautochangerequest	bpchar	1			'N'::bpchar	Automatically create BOM (Engineering) Change Request
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
r_requesttype	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
r_requesttype	isdefault	bpchar	1			'N'::bpchar	Default value
r_requesttype	isemailwhendue	bpchar	1			'N'::bpchar	Send EMail when Request becomes due
r_requesttype	isemailwhenoverdue	bpchar	1			'N'::bpchar	Send EMail when Request becomes overdue
r_request	isescalated	bpchar	1			'N'::bpchar	This request has been escalated
r_request_v	isescalated	bpchar	1	√		null
r_requestaction	isescalated	bpchar	1	√		null	This request has been escalated
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
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
r_requesttype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
r_request	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
r_request_v	isinvoiced	bpchar	1	√		null
r_requestaction	isinvoiced	bpchar	1	√		null	Is this invoiced?
r_requesttype	isinvoiced	bpchar	1	√		null	Is this invoiced?
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
r_request	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_request_v	isselfservice	bpchar	1	√		null
r_requestaction	isselfservice	bpchar	1	√		null	This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
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
r_requestprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
r_requestprocessor_route	keyword	varchar	60	√		null	Case insensitive keyword
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
r_request	lastresult	varchar	2000	√		null	Result of last contact
r_request_v	lastresult	varchar	2000	√		null
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
r_request	m_changerequest_id	numeric	10	√		null	BOM (Engineering) Change Request
r_request_v	m_changerequest_id	numeric	10	√		null
r_request	m_fixchangenotice_id	numeric	10	√		null	Fixed in Change Notice
r_request_v	m_fixchangenotice_id	numeric	10	√		null
r_request	m_inout_id	numeric	10	√		null	Material Shipment Document
r_request_v	m_inout_id	numeric	10	√		null
r_requestaction	m_inout_id	numeric	10	√		null	Material Shipment Document
r_request	m_product_id	numeric	10	√		null	Product, Service, Item
r_request_v	m_product_id	numeric	10	√		null
r_requestaction	m_product_id	numeric	10	√		null	Product, Service, Item
r_request	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
r_request_v	m_productspent_id	numeric	10	√		null
r_requestaction	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
r_request	m_rma_id	numeric	10	√		null	Return Material Authorization
r_request_v	m_rma_id	numeric	10	√		null
r_requestaction	m_rma_id	numeric	10	√		null	Return Material Authorization
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
r_mailtext	mailtext	text	2147483647				Text used for Mail message
r_mailtext	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
ad_user	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
r_requestprocessor	name	varchar	60				Alphanumeric identifier of the entity
r_requesttype	name	varchar	60				Alphanumeric identifier of the entity
r_request	nextaction	bpchar	1	√		null	Next Action to be taken
r_request_v	nextaction	bpchar	1	√		null
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
r_requestaction	nullcolumns	varchar	255	√		null	Columns with NULL value
r_requestprocessor	overduealertdays	numeric	10				Send email alert after number of days due (0=no alerts)
r_requestprocessor	overdueassigndays	numeric	10				Escalation to superior after number of due days (0 = no)
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.
r_request	priority	bpchar	1				Indicates if this request is of a high, medium or low priority.
r_request_v	priority	bpchar	1	√		null
r_requestaction	priority	bpchar	1	√		null	Indicates if this request is of a high, medium or low priority.
r_request	priorityuser	bpchar	1	√		null	Priority of the issue for the User
r_request_v	priorityuser	bpchar	1	√		null
r_requestaction	priorityuser	bpchar	1	√		null	Priority of the issue for the User
r_request	processed	bpchar	1			'N'::bpchar	The document has been processed
r_request_v	processed	bpchar	1	√		null
ad_user	processing	bpchar	1	√		null	Process Now
r_requestprocessor	processing	bpchar	1	√		null	Process Now
r_request	qtyinvoiced	numeric	0	√		0	Invoiced Quantity
r_request_v	qtyinvoiced	numeric	0	√		null
r_requestaction	qtyinvoiced	numeric	0	√		null	Invoiced Quantity
r_request	qtyplan	numeric	0	√		null	Planned Quantity
r_request_v	qtyplan	numeric	0	√		null
r_requestaction	qtyplan	numeric	0	√		null	Planned Quantity
r_request	qtyspent	numeric	0	√		0	Quantity used for this event
r_request_v	qtyspent	numeric	0	√		null
r_requestaction	qtyspent	numeric	0	√		null	Quantity used for this event
r_request	r_category_id	numeric	10	√		null	Request Category
r_request_v	r_category_id	numeric	10	√		null
r_requestaction	r_category_id	numeric	10	√		null	Request Category
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
r_request	r_group_id	numeric	10	√		null	Request Group
r_request_v	r_group_id	numeric	10	√		null
r_requestaction	r_group_id	numeric	10	√		null	Request Group
r_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
r_request	r_mailtext_id	numeric	10	√		null	Text templates for mailings
r_request_v	r_mailtext_id	numeric	10	√		null
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
r_request	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_request_v	r_request_id	numeric	10	√		null
r_requestaction	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_request	r_request_uu	varchar	36	√		NULL::character varying	R_Request_UU
r_requestaction	r_requestaction_id	numeric	10				Request has been changed
r_requestaction	r_requestaction_uu	varchar	36	√		NULL::character varying	R_RequestAction_UU
r_requestprocessor	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessor_route	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessor_route	r_requestprocessor_route_id	numeric	10				Automatic routing of requests
r_requestprocessor_route	r_requestprocessor_route_uu	varchar	36	√		NULL::character varying	R_RequestProcessor_Route_UU
r_requestprocessor	r_requestprocessor_uu	varchar	36	√		NULL::character varying	R_RequestProcessor_UU
r_request	r_requestrelated_id	numeric	10	√		null	Related Request (Master Issue, ..)
r_request_v	r_requestrelated_id	numeric	10	√		null
r_request	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_request_v	r_requesttype_id	numeric	10	√		null
r_requestaction	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor_route	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_uu	varchar	36	√		NULL::character varying	R_RequestType_UU
r_request	r_resolution_id	numeric	10	√		null	Request Resolution
r_request_v	r_resolution_id	numeric	10	√		null
r_requestaction	r_resolution_id	numeric	10	√		null	Request Resolution
r_request	r_standardresponse_id	numeric	10	√		null	Request Standard Response
r_request_v	r_standardresponse_id	numeric	10	√		null
r_request	r_status_id	numeric	10	√		null	Request Status
r_request_v	r_status_id	numeric	10	√		null
r_requestaction	r_status_id	numeric	10	√		null	Request Status
r_requesttype	r_statuscategory_id	numeric	10				Request Status Category
r_request	record_id	numeric	10	√		null	Direct internal record ID
r_request_v	record_id	numeric	10	√		null
r_requestprocessor	reminddays	numeric	10			7	Days between sending Reminder Emails for a due or inactive Document
r_request	requestamt	numeric	0			0	Amount associated with this request
r_request_v	requestamt	numeric	0	√		null
r_request	result	varchar	2000	√		null	Result of the action taken
r_request_v	result	varchar	2000	√		null
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
r_request	salesrep_id	numeric	10				Sales Representative or Company Agent
r_request_v	salesrep_id	numeric	10	√		null
r_requestaction	salesrep_id	numeric	10	√		null	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
r_requestprocessor_route	seqno	numeric	10				Method of ordering records; lowest number comes first
r_request	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_request_v	startdate	timestamp	29,6	√		null
r_requestaction	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_request	starttime	timestamp	29,6	√		null	Time started
r_request_v	starttime	timestamp	29,6	√		null
r_request	summary	varchar	2000				Textual summary of this request
r_request_v	summary	varchar	2000	√		null
r_requestaction	summary	varchar	2000	√		null	Textual summary of this request
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
r_requestprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
r_request	taskstatus	bpchar	1	√		null	Status of the Task
r_request_v	taskstatus	bpchar	1	√		null
r_requestaction	taskstatus	bpchar	1	√		null	Status of the Task
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
r_mailtext	updated	timestamp	29,6			now()	Date this record was updated
r_request	updated	timestamp	29,6			now()	Date this record was updated
r_request_v	updated	timestamp	29,6	√		null
r_requestaction	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessor	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessor_route	updated	timestamp	29,6			now()	Date this record was updated
r_requesttype	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updatedby	numeric	10				User who updated this records
r_mailtext	updatedby	numeric	10				User who updated this records
r_request	updatedby	numeric	10				User who updated this records
r_request_v	updatedby	numeric	10	√		null
r_requestaction	updatedby	numeric	10				User who updated this records
r_requestprocessor	updatedby	numeric	10				User who updated this records
r_requestprocessor_route	updatedby	numeric	10				User who updated this records
r_requesttype	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