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

Table	Column	Type	Size	Nulls	Auto	Default
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
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
ad_wf_responsible	ad_role_id	numeric	10	√		null	Responsibility Role
ad_role_included	ad_role_included_uu	varchar	36	√		NULL::character varying	AD_Role_Included_UU
ad_role_orgaccess	ad_role_orgaccess_uu	varchar	36	√		NULL::character varying	AD_Role_OrgAccess_UU
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
ad_role	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_role	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_wf_responsible	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user_roles	ad_user_roles_uu	varchar	36	√		NULL::character varying	AD_User_Roles_UU
ad_user_substitute	ad_user_substitute_uu	varchar	36	√		NULL::character varying	AD_User_Substitute_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_wf_responsible	ad_wf_responsible_uu	varchar	36	√		NULL::character varying	AD_WF_Responsible_UU
ad_role	amtapproval	numeric	0	√		0	The approval amount limit for this role
ad_role	amtapprovalaccum	numeric	0	√		null	The approval amount limit for this role accumulated on a period
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
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
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
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_role	c_currency_id	numeric	10	√		null	The Currency for this record
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
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
ad_user	c_job_id	numeric	10	√		null	Job Position
c_job	c_job_uu	varchar	36	√		NULL::character varying	C_Job_UU
c_jobassignment	c_jobassignment_uu	varchar	36	√		NULL::character varying	C_JobAssignment_UU
c_jobcategory	c_jobcategory_uu	varchar	36	√		NULL::character varying	C_JobCategory_UU
c_jobremuneration	c_jobremuneration_uu	varchar	36	√		NULL::character varying	C_JobRemuneration_UU
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_orgassignment	c_orgassignment_uu	varchar	36	√		NULL::character varying	C_OrgAssignment_UU
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_remuneration	c_remuneration_uu	varchar	36	√		NULL::character varying	C_Remuneration_UU
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_userremuneration	c_userremuneration_uu	varchar	36	√		NULL::character varying	C_UserRemuneration_UU
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_role	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
ad_user	connectionprofile	bpchar	1	√		null	How a Java Tenant connects to the server(s)
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
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_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
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
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_role	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
ad_user_substitute	description	varchar	255	√		null	Optional short description of the record
ad_wf_responsible	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_job	description	varchar	255	√		null	Optional short description of the record
c_jobassignment	description	varchar	255	√		null	Optional short description of the record
c_jobcategory	description	varchar	255	√		null	Optional short description of the record
c_jobremuneration	description	varchar	255	√		null	Optional short description of the record
c_orgassignment	description	varchar	255	√		null	Optional short description of the record
c_remuneration	description	varchar	255	√		null	Optional short description of the record
c_userremuneration	description	varchar	255	√		null	Optional short description of the record
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
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_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
ad_user	fax	varchar	40	√		null	Facsimile 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_job	help	varchar	2000	√		null	Comment or Hint
c_jobcategory	help	varchar	2000	√		null	Comment or Hint
c_remuneration	help	varchar	2000	√		null	Comment or Hint
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
ad_role	isaccessadvanced	bpchar	1	√		'N'::bpchar	Access Advanced
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
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_orginfo	logo_id	numeric	10	√		NULL::numeric	Logo
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
ad_orginfo	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
ad_orginfo	phone	varchar	40	√		NULL::character varying	Identifies a telephone number
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_orginfo	phone2	varchar	40	√		NULL::character varying	Identifies an alternate telephone number.
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
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
ad_role	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_user	processing	bpchar	1	√		null	Process Now
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
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
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
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
ad_orginfo	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_role	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_orginfo	timezone	varchar	60	√		NULL::character varying	Time zone name
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
ad_orginfo	transferbank_id	numeric	0	√		null	Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo	transfercashbook_id	numeric	0	√		null	CashBook for transfers
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_role	userdiscount	numeric	22,2	√		null	User Discount
ad_user	userpin	varchar	20	√		null	User PIN
ad_user_substitute	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
ad_user_substitute	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_jobassignment	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_jobremuneration	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_userremuneration	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
ad_org	ad_client_id	numeric	10				Tenant for this installation.
ad_orginfo	ad_client_id	numeric	10				Tenant for this installation.
ad_role	ad_client_id	numeric	10				Tenant for this installation.
ad_role_included	ad_client_id	numeric	10				Tenant for this installation.
ad_role_orgaccess	ad_client_id	numeric	10				Tenant for this installation.
ad_user	ad_client_id	numeric	10				Tenant for this installation.
ad_user_roles	ad_client_id	numeric	10				Tenant for this installation.
ad_user_substitute	ad_client_id	numeric	10				Tenant for this installation.
ad_wf_responsible	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_job	ad_client_id	numeric	10				Tenant for this installation.
c_jobassignment	ad_client_id	numeric	10				Tenant for this installation.
c_jobcategory	ad_client_id	numeric	10				Tenant for this installation.
c_jobremuneration	ad_client_id	numeric	10				Tenant for this installation.
c_orgassignment	ad_client_id	numeric	10				Tenant for this installation.
c_remuneration	ad_client_id	numeric	10				Tenant for this installation.
c_userremuneration	ad_client_id	numeric	10				Tenant for this installation.
ad_org	ad_org_id	numeric	10				Organizational entity within tenant
ad_orginfo	ad_org_id	numeric	10				Organizational entity within tenant
ad_role	ad_org_id	numeric	10				Organizational entity within tenant
ad_role_included	ad_org_id	numeric	10				Organizational entity within tenant
ad_role_orgaccess	ad_org_id	numeric	10				Organizational entity within tenant
ad_user	ad_org_id	numeric	10				Organizational entity within tenant
ad_user_roles	ad_org_id	numeric	10				Organizational entity within tenant
ad_user_substitute	ad_org_id	numeric	10				Organizational entity within tenant
ad_wf_responsible	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_job	ad_org_id	numeric	10				Organizational entity within tenant
c_jobassignment	ad_org_id	numeric	10				Organizational entity within tenant
c_jobcategory	ad_org_id	numeric	10				Organizational entity within tenant
c_jobremuneration	ad_org_id	numeric	10				Organizational entity within tenant
c_orgassignment	ad_org_id	numeric	10				Organizational entity within tenant
c_remuneration	ad_org_id	numeric	10				Organizational entity within tenant
c_userremuneration	ad_org_id	numeric	10				Organizational entity within tenant
ad_role	ad_role_id	numeric	10				Responsibility Role
ad_role_included	ad_role_id	numeric	10				Responsibility Role
ad_role_orgaccess	ad_role_id	numeric	10				Responsibility Role
ad_user_roles	ad_role_id	numeric	10				Responsibility Role
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_roles	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_substitute	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_jobassignment	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_orgassignment	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_userremuneration	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_substitute	ad_user_substitute_id	numeric	10				Substitute of the user
ad_wf_responsible	ad_wf_responsible_id	numeric	10				Responsible for Workflow Execution
ad_role	allow_info_account	bpchar	1			'Y'::bpchar	Allow Info Account
ad_role	allow_info_asset	bpchar	1			'Y'::bpchar	Allow Info Asset
ad_role	allow_info_bpartner	bpchar	1			'Y'::bpchar	Allow Info BPartner
ad_role	allow_info_cashjournal	bpchar	1			'N'::bpchar	Allow Info Cash Journal
ad_role	allow_info_crp	bpchar	1			'N'::bpchar	Allow Info CRP
ad_role	allow_info_inout	bpchar	1			'Y'::bpchar	Allow Info InOut
ad_role	allow_info_invoice	bpchar	1			'Y'::bpchar	Allow Info Invoice
ad_role	allow_info_mrp	bpchar	1			'N'::bpchar	Allow Info MRP
ad_role	allow_info_order	bpchar	1			'Y'::bpchar	Allow Info Order
ad_role	allow_info_payment	bpchar	1			'Y'::bpchar	Allow Info Payment
ad_role	allow_info_product	bpchar	1			'Y'::bpchar	Allow Info Product
ad_role	allow_info_resource	bpchar	1			'Y'::bpchar	Allow Info Resource
ad_role	allow_info_schedule	bpchar	1			'Y'::bpchar	Allow Info Schedule
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_job	c_job_id	numeric	10				Job Position
c_jobassignment	c_job_id	numeric	10				Job Position
c_jobremuneration	c_job_id	numeric	10				Job Position
c_jobassignment	c_jobassignment_id	numeric	10				Assignment of Employee (User) to Job Position
c_job	c_jobcategory_id	numeric	10				Job Position Category
c_jobcategory	c_jobcategory_id	numeric	10				Job Position Category
c_jobremuneration	c_jobremuneration_id	numeric	10				Remuneration for the Position
c_orgassignment	c_orgassignment_id	numeric	10				Assignment to (transaction) Organization
c_jobremuneration	c_remuneration_id	numeric	10				Wage or Salary
c_remuneration	c_remuneration_id	numeric	10				Wage or Salary
c_userremuneration	c_remuneration_id	numeric	10				Wage or Salary
c_userremuneration	c_userremuneration_id	numeric	10				Employee Wage or Salary Overwrite
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_role_included	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_role_orgaccess	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_user_roles	created	timestamp	29,6			now()	Date this record was created
ad_user_substitute	created	timestamp	29,6			now()	Date this record was created
ad_wf_responsible	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_job	created	timestamp	29,6			now()	Date this record was created
c_jobassignment	created	timestamp	29,6			now()	Date this record was created
c_jobcategory	created	timestamp	29,6			now()	Date this record was created
c_jobremuneration	created	timestamp	29,6			now()	Date this record was created
c_orgassignment	created	timestamp	29,6			now()	Date this record was created
c_remuneration	created	timestamp	29,6			now()	Date this record was created
c_userremuneration	created	timestamp	29,6			now()	Date this record was created
ad_org	createdby	numeric	10				User who created this records
ad_orginfo	createdby	numeric	10				User who created this records
ad_role	createdby	numeric	10				User who created this records
ad_role_included	createdby	numeric	10				User who created this records
ad_role_orgaccess	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
ad_user_roles	createdby	numeric	10				User who created this records
ad_user_substitute	createdby	numeric	10				User who created this records
ad_wf_responsible	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_job	createdby	numeric	10				User who created this records
c_jobassignment	createdby	numeric	10				User who created this records
c_jobcategory	createdby	numeric	10				User who created this records
c_jobremuneration	createdby	numeric	10				User who created this records
c_orgassignment	createdby	numeric	10				User who created this records
c_remuneration	createdby	numeric	10				User who created this records
c_userremuneration	createdby	numeric	10				User who created this records
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
ad_wf_responsible	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
c_remuneration	grossramt	numeric	0			0	Gross Remuneration Amount
c_userremuneration	grossramt	numeric	0			0	Gross Remuneration Amount
c_remuneration	grossrcost	numeric	0			0	Gross Remuneration Costs
c_userremuneration	grossrcost	numeric	0			0	Gross Remuneration Costs
ad_role_included	included_role_id	numeric	10				Included Role
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_role	isaccessallorgs	bpchar	1			'N'::bpchar	Access all Organizations (no org access control) of the tenant
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orginfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role_included	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role_orgaccess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user_roles	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_user_substitute	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_responsible	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_job	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_jobassignment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_jobcategory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_jobremuneration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orgassignment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_remuneration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_userremuneration	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_role	iscanapproveowndoc	bpchar	1			'Y'::bpchar	Users with this role can approve their own documents
ad_role	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_role	isclientadministrator	bpchar	1			'N'::bpchar	This role is a tenant administrator
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	Is Discount Allowed On Total
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	Is Discount Up to Limit Price
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_job	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
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_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
ad_role	ismasterrole	bpchar	1			'N'::bpchar	A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role	ismenuautoexpand	bpchar	1			'N'::bpchar	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
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
ad_role	ispersonalaccess	bpchar	1			'N'::bpchar	Allow access to all personal records
ad_role	ispersonallock	bpchar	1			'N'::bpchar	Allow users with role to lock access to personal records
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
ad_role_orgaccess	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
ad_role	maxqueryrecords	numeric	10			0	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
ad_user_substitute	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_responsible	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_job	name	varchar	60				Alphanumeric identifier of the entity
c_jobcategory	name	varchar	60				Alphanumeric identifier of the entity
c_remuneration	name	varchar	60				Alphanumeric identifier of the entity
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_remuneration	overtimeamt	numeric	0			0	Hourly Overtime Rate
c_userremuneration	overtimeamt	numeric	0			0	Hourly Overtime Rate
c_remuneration	overtimecost	numeric	0			0	Hourly Overtime Cost
c_userremuneration	overtimecost	numeric	0			0	Hourly Overtime Cost
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
c_remuneration	remunerationtype	bpchar	1				Type of Remuneration
ad_wf_responsible	responsibletype	bpchar	1				Type of the Responsibility for a workflow
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
ad_role_included	seqno	numeric	10				Method of ordering records; lowest number comes first
c_remuneration	standardhours	numeric	10			0	Standard Work Hours based on Remuneration Type
ad_user_substitute	substitute_id	numeric	10				Entity which can be used in place of this entity
ad_orginfo	taxid	varchar	20				Tax Identification
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_role_included	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_role_orgaccess	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_user_roles	updated	timestamp	29,6			now()	Date this record was updated
ad_user_substitute	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_responsible	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_job	updated	timestamp	29,6			now()	Date this record was updated
c_jobassignment	updated	timestamp	29,6			now()	Date this record was updated
c_jobcategory	updated	timestamp	29,6			now()	Date this record was updated
c_jobremuneration	updated	timestamp	29,6			now()	Date this record was updated
c_orgassignment	updated	timestamp	29,6			now()	Date this record was updated
c_remuneration	updated	timestamp	29,6			now()	Date this record was updated
c_userremuneration	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updatedby	numeric	10				User who updated this records
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_role	updatedby	numeric	10				User who updated this records
ad_role_included	updatedby	numeric	10				User who updated this records
ad_role_orgaccess	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
ad_user_roles	updatedby	numeric	10				User who updated this records
ad_user_substitute	updatedby	numeric	10				User who updated this records
ad_wf_responsible	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_job	updatedby	numeric	10				User who updated this records
c_jobassignment	updatedby	numeric	10				User who updated this records
c_jobcategory	updatedby	numeric	10				User who updated this records
c_jobremuneration	updatedby	numeric	10				User who updated this records
c_orgassignment	updatedby	numeric	10				User who updated this records
c_remuneration	updatedby	numeric	10				User who updated this records
c_userremuneration	updatedby	numeric	10				User who updated this records
ad_role	userlevel	bpchar	3			' O'::bpchar	System Tenant Organization
c_jobassignment	validfrom	timestamp	29,6				Valid from including this date (first day)
c_jobremuneration	validfrom	timestamp	29,6				Valid from including this date (first day)
c_orgassignment	validfrom	timestamp	29,6				Valid from including this date (first day)
c_userremuneration	validfrom	timestamp	29,6				Valid from including this date (first day)
c_orgassignment	validto	timestamp	29,6				Valid to including this date (last day)
ad_org	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique